SELECT F.*, C.* , GREATEST(C.updated, C.created) AS sortfield, COALESCE(C.nickname, "Unknown") AS nickname, F.description AS original_description FROM comments AS C LEFT JOIN upload_games AS F ON F.id = C.flash_id WHERE 1 ORDER BY sortfield DESC LIMIT 100