http://cre.ations.net/ A haven for creators and makers, cre.ations.net is the place to quickly publish anything you've created. Free and easy! en-us Copyright 2006, cre.ations.net Sun, 20 May 2012 17:36:41 -0500 Sun, 20 May 2012 17:36:41 -0500 custom http://blogs.law.harvard.edu/tech/rssSELECT comments.*, UNIX_TIMESTAMP(comments.added) AS added_unix, DATE_FORMAT(comments.added, '%d-%b-%Y %H:%i:%S') AS prettytime, blogentries.minidesc, blogentries.id AS creation_id, (SELECT username AS creator_name FROM creators WHERE creators.id=comments.posted_by) AS poster_name FROM blogentries, comments WHERE blogentries.id='17' AND comments.blog_id=blogentries.id ORDER BY comments.added DESC