All Awards : Pictorial and Travel
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 = 128 ORDER BY award_rank ASC, image_score_overall DESC
Michael McLaughlin
Award of Excellence
Michael McLaughlin
Merit