SELECT * FROM com_awards LEFT JOIN com_images on award_image_id = image_id LEFT JOIN com_entries on image_entry_id = entry_id LEFT JOIN wp_users on id = entry_user_id WHERE image_category_id = 124 ORDER BY award_rank ASC, image_score_overall DESC

Michael Hayes

Merit

Brendan Lyon

Merit

Michael Hayes

Highly Commended

Brendan Lyon

Highly Commended