[eg0master]

select id,subject,date,isnull(in_reply_to,id) AS irt 
from blog_comments 
WHERE blog_id = 1 
ORDER BY irt, date;

Borde lösa det. Notera att isnull kan heta ifnull eller coalesce (sic) beroende på databas.