SELECT archimedercitems.id as id,archimedercitems.category as category, archimedercitemsDetail.itemTitle as itemTitle,archimedercimages.file FROM
archimedercitems LEFT JOIN
archimedercitemsDetail ON (archimedercitemsDetail.item = archimedercitems.id) LEFT JOIN
archimedercimages ON (archimedercitemsDetail.id = archimedercimages.item)
WHERE archimedercimages.del = 0
AND archimedercimages.active = 1
AND archimedercitems.del = 0
AND archimedercitemsDetail.active = 1
AND lang = '1'
AND archimedercitemsDetail.del = 0
AND category = 66 GROUP BY archimedercitems.id