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 = 154 ORDER BY award_rank ASC, image_score_overall DESC