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 > 1337427351
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:35:51' limit 10000
Tag Swarm results for laptop Try Searching Instead
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120519 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120518 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120517 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120516 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120515 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120514 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120513 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120512 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120511 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25
Query Trouble : SELECT urlindex,url,bksitetitle,bksiteurl,bksiteid,bksitedesc,bkuser,submitted,gathered,slug,title FROM urls_20120510 WHERE bksitecount < 2 AND bksitetitle != '' AND (tags like '%laptop%' OR bksitetags like '%laptop%') ORDER BY gathered DESC LIMIT 25