FAIL

result error or no results.
SELECT works.id, collections.name as collection, titles.title, agents.name, descriptions.description, images.thumb_href, images.refid, images.image_href, images.supplied_title, images.description as image_desc, inscriptions.text FROM works LEFT JOIN works_work_types ON works.id = works_work_types.work_id LEFT JOIN work_types ON work_types.id = works_work_types.work_type_id LEFT JOIN works_techniques ON works.id = works_techniques.work_id LEFT JOIN techniques ON techniques.id = works_techniques.technique_id LEFT JOIN works_agents ON works.id = works_agents.work_id LEFT JOIN agents ON agents.id = works_agents.agent_id LEFT JOIN titles ON titles.work_id = works.id LEFT JOIN inscriptions ON inscriptions.work_id = works.id LEFT JOIN descriptions ON descriptions.work_id = works.id LEFT JOIN collections ON collections.id = works.collection_id LEFT JOIN works_images_relations ON works.id = works_images_relations.work_id LEFT JOIN images ON images.id = works_images_relations.image_id WHERE GROUP BY works.id ORDER BY collections.name, agents.name, titles.title, images.supplied_title LIMIT 0, 25