All Awards : Press and Photojournalism
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 = 129 ORDER BY award_rank ASC, image_score_overall DESC
Michael McLaughlin
Highly Commended