instruction: The longest post that don't contain awesome newlines.. For some people, the enter key seems to be broken...
response: SELECT ph1.PostId AS "post_link", LENGTH(ph1.Text) FROM PostHistory AS ph1 WHERE NOT REPLACE(REPLACE(ph1.Text, CHAR(13), 'AWESOMENEWLINE'), CHAR(10), 'AWESOMENEWLINE') LIKE '%AWESOMENEWLINE%' AND NOT EXISTS(SELECT ph2.Id FROM PostHistory AS ph2 WHERE ph2.PostId = ph1.PostId AND ph2.CreationDate > ph1.CreationDate) ORDER BY LENGTH(Text) DESC LIMIT 100