Query Trouble : SELECT count(*) as fivemin FROM urls_20120519 WHERE gathered > '2012-05-19 19:29:38'

Hive Spy


Keeping an eye on the collective...
...one submission at a time      

what's hot now in wikipedia edits
Query Trouble : SELECT count(distinct(b.editor)) as theCount,b.editor,a.Title,a.URL FROM wikipages a, top100edits b WHERE a.wikipageid = b.wikipageid AND date > 1337427278 GROUP BY b.wikipageid ORDER BY theCount DESC LIMIT 0,25

This site collects the latest new submissions to Social Bookmarking Portals such as Digg.Com, Netscape.Com, and Del.icio.us. If you are not seeing the websites scrolling from the top, then check that you have Javascript turned on. If you are still having troubles or you have any suggestions, comments, complaints .. Send me feedback.

Query Trouble : SELECT tags,bksitetags FROM urls_20120519 WHERE (tags != '' OR bksitetags != '') AND gathered > '2012-05-19 16:34:38' limit 10000

Search Hive Spy


Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120519 WHERE bksitecount < 2 AND bksitetitle != '' AND gathered < '2012-05-19 19:31:38' ORDER BY gathered DESC LIMIT 25