SELECT name, milestone, challenge_entry.challenger_id, title, notes, datetime, cgtalk_postid, cgtalk_threadid, cgtalk_username, image_small, score, max(entry_id) as entry_id, milestone FROM challenger, challenge_entry WHERE (challenge_entry.challenge_id IN (22,23)) AND challenger.challenger_id=challenge_entry.challenger_id AND (milestone='Final Image' OR milestone='Finished Trailer' OR milestone='Final Render' OR milestone='Finished Video') GROUP BY challenger_id
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||