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
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