Your Romantic Queries

Sunday, July 17, 2005 | 11:41 pm

SELECT COUNT(*), a.id, a.title, c.user, MAX(b.timestamp) FROM logentries a, comments b, authent c WHERE a.id = b.entryid AND a.user_id = c.id GROUP BY 2 ORDER BY 5 DESC LIMIT $index_display_number;

This query kind of turns me on.

Tags: , ,

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

2 Responses to "Your Romantic Queries"

  1. Charles R says:
    July 18th, 2005 at 4:41 am

    “So, your blog or mine?”

  2. cari says:
    July 18th, 2005 at 7:12 am

    Yours!

    oh.