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