SELECT ParentID, LENGTH(Body) AS length, Body, LastEditDate FROM posts WHERE PostTypeId = 2 AND OwnerUserId = 6309 AND LENGTH(Body) > 5000 AND Body LIKE '%http://stackoverflow.com%' ORDER BY length DESC LIMIT 200

SELECT ParentID, LENGTH(Body) AS length, Body, LastEditDate FROM posts WHERE PostTypeId = 2 AND OwnerUserId = 6309 AND LENGTH(Body) > 5000 AND Body NOT LIKE '%http://stackoverflow.com%' ORDER BY length DESC LIMIT 200

SELECT COUNT(*) FROM posts WHERE PostTypeId = 2 AND LENGTH(Body) > 5000 AND Body LIKE '%http://stackoverflow.com%'

SELECT ParentID, LENGTH(Body) AS length, Body, LastEditDate FROM posts WHERE PostTypeId = 2 AND LENGTH(Body) > 5000 AND Body LIKE '%http://stackoverflow.com%' ORDER BY length DESC LIMIT 300

SELECT OwnerUserId,COUNT(*) AS n FROM posts WHERE PostTypeId = 2 AND LENGTH(Body) > 5000 AND Body LIKE '%http://stackoverflow.com%' GROUP BY OwnerUserId ORDER BY n DESC

SELECT
    ParentID, CHAR_LENGTH(Body) AS length, Body, LastEditDate, CreationDate
FROM posts
WHERE PostTypeId = 2 AND CHAR_LENGTH(Body) > 4500 AND Body LIKE '%http://stackoverflow.com%'
AND LastEditDate < '2009-08-08'  AND CreationDate  < cast('2009-08-08' as datetime)
 ORDER BY length DESC LIMIT 200