And The Winners Are

Bibliofuture, slashgirl and Bob Cox are the big winners of the "Lipstick Librarian T-Shirts" If you didn't win, there's plenty more at the "Lipstick Librarian Store"!

Don't forget, everyone who suggests a story this week could win a personalized copy of "What Would Dewey Do?", the latest book from Overdue Media home of Unshelved and next week we'll have a couple subscriptions to BookMarks Magazine.To select the names I did:
SELECT *
FROM submissions
WHERE time > '2004-12-01'
ORDER BY rand( )
LIMIT 2
It actually took a few tries, Anonymous Patron won more than once!
To get the winning author I did:
SELECT *
FROM `slash_users`
WHERE author =1
ORDER BY RAND( )
LIMIT 1
And luckily a current author came up first.

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Lipstick Librarian...

At the annual Cristmas party we have a Yankee swap. This year I brought a LL mug with an LL thong stuffed in it. Big hit!

How about

SELECT *FROM submissionsWHERE time > '2004-12-01'AND NOT name IS NULLORDER BY rand( )LIMIT 2

or whatever it is that distinguishes APs?

Syndicate content