Skip to content

Instantly share code, notes, and snippets.

@zuriby

zuriby/gist:812715

Created February 5, 2011 19:40
Show Gist options
  • Save zuriby/812715 to your computer and use it in GitHub Desktop.
Save zuriby/812715 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select count(job_rowid) from results_links group by job_rowid;
+------------------+
| count(job_rowid) |
+------------------+
| 342 |
| 9267 |
| 211 |
| 10054 |
| 9811 |
| 281 |
+------------------+
6 rows in set (0.07 sec)
mysql> select count(*) from results_links;
+----------+
| count(*) |
+----------+
| 29966 |
+----------+
1 row in set (0.00 sec)
mysql> select * from results_links limit 100;
+-----------+-------------+-----------+------------------------------------+
| job_rowid | provider_id | direction | link |
+-----------+-------------+-----------+------------------------------------+
| 1 | 1 | -1 | http://twitter.com/tzury |
| 1 | 1 | 1 | http://twitter.com/tzury |
| 1 | 1 | -1 | http://twitter.com/stevecase |
| 1 | 1 | -1 | http://twitter.com/jessamyn |
| 1 | 1 | -1 | http://twitter.com/saadventures |
| 1 | 1 | -1 | http://twitter.com/shitmydadsays |
| 1 | 1 | -1 | http://twitter.com/adriangrenier |
| 1 | 1 | -1 | http://twitter.com/dropbox |
| 1 | 1 | -1 | http://twitter.com/mcandrew |
| 1 | 1 | -1 | http://twitter.com/posterous |
| 1 | 1 | -1 | http://twitter.com/gmc |
| 1 | 1 | -1 | http://twitter.com/al3x |
| 1 | 1 | -1 | http://twitter.com/yahooza |
| 1 | 1 | -1 | http://twitter.com/adamdangelo |
| 1 | 1 | -1 | http://twitter.com/davidkirkpatric |
| 1 | 1 | -1 | http://twitter.com/zackbogue |
| 1 | 1 | -1 | http://twitter.com/simonw |
| 1 | 1 | -1 | http://twitter.com/asenkut |
| 1 | 1 | -1 | http://twitter.com/enterprisey |
| 1 | 1 | -1 | http://twitter.com/iamcal |
| 1 | 1 | -1 | http://twitter.com/jkraus |
| 1 | 1 | -1 | http://twitter.com/arrington |
| 1 | 1 | -1 | http://twitter.com/ar3te |
| 1 | 1 | -1 | http://twitter.com/dburka |
| 1 | 1 | -1 | http://twitter.com/ev |
| 1 | 1 | -1 | http://twitter.com/aaronkoblin |
| 1 | 1 | -1 | http://twitter.com/veen |
| 1 | 1 | -1 | http://twitter.com/davemorin |
| 1 | 1 | -1 | http://twitter.com/chaddickerson |
| 1 | 1 | -1 | http://twitter.com/joshk |
| 1 | 1 | -1 | http://twitter.com/foodgenome |
| 1 | 1 | -1 | http://twitter.com/zhanna |
| 1 | 1 | -1 | http://twitter.com/threatwatch |
| 1 | 1 | -1 | http://twitter.com/gladwell |
| 1 | 1 | -1 | http://twitter.com/vyatta |
| 1 | 1 | -1 | http://twitter.com/laughingsquid |
| 1 | 1 | -1 | http://twitter.com/jenny8lee |
| 1 | 1 | -1 | http://twitter.com/rtomayko |
| 1 | 1 | -1 | http://twitter.com/vrt_sourcefire |
| 1 | 1 | -1 | http://twitter.com/dottedlinegirl |
| 1 | 1 | -1 | http://twitter.com/markpinc |
| 1 | 1 | -1 | http://twitter.com/k |
| 1 | 1 | -1 | http://twitter.com/billgates |
| 1 | 1 | -1 | http://twitter.com/marissamayer |
| 1 | 1 | -1 | http://twitter.com/photomatt |
| 1 | 1 | -1 | http://twitter.com/yetanotherjosh |
| 1 | 1 | -1 | http://twitter.com/2000f |
| 1 | 1 | -1 | http://twitter.com/adamlashinsky |
| 1 | 1 | -1 | http://twitter.com/adamlazzarato |
| 1 | 1 | -1 | http://twitter.com/timoreilly |
| 1 | 1 | -1 | http://twitter.com/gideonyu |
| 1 | 1 | -1 | http://twitter.com/freeswitch_wire |
| 1 | 1 | -1 | http://twitter.com/kubla |
| 1 | 1 | -1 | http://twitter.com/lessig |
| 1 | 1 | -1 | http://twitter.com/pierre |
| 1 | 1 | -1 | http://twitter.com/artypapers |
| 1 | 1 | -1 | http://twitter.com/zefrank |
| 1 | 1 | -1 | http://twitter.com/paulg |
| 1 | 1 | -1 | http://twitter.com/dsifry |
| 1 | 1 | -1 | http://twitter.com/joshu |
| 1 | 1 | -1 | http://twitter.com/fakesacca |
| 1 | 1 | -1 | http://twitter.com/ycombinator |
| 1 | 1 | -1 | http://twitter.com/bruces |
| 1 | 1 | -1 | http://twitter.com/techcrunch |
| 1 | 1 | -1 | http://twitter.com/jess |
| 1 | 1 | -1 | http://twitter.com/chad_hurley |
| 1 | 1 | -1 | http://twitter.com/daniel_freebsd |
| 1 | 1 | -1 | http://twitter.com/nikonrumors |
| 1 | 1 | -1 | http://twitter.com/postgresql |
| 1 | 1 | -1 | http://twitter.com/synfinatic |
| 1 | 1 | -1 | http://twitter.com/davidhornik |
| 1 | 1 | -1 | http://twitter.com/mlevchin |
| 1 | 1 | -1 | http://twitter.com/loic |
| 1 | 1 | -1 | http://twitter.com/nicknotned |
| 1 | 1 | -1 | http://twitter.com/square |
| 1 | 1 | -1 | http://twitter.com/gavinnewsom |
| 1 | 1 | -1 | http://twitter.com/randizuckerberg |
| 1 | 1 | -1 | http://twitter.com/whitehouse |
| 1 | 1 | -1 | http://twitter.com/conanobrien |
| 1 | 1 | -1 | http://twitter.com/ezmobius |
| 1 | 1 | -1 | http://twitter.com/buzz |
| 1 | 1 | -1 | http://twitter.com/duckduckgo |
| 1 | 1 | -1 | http://twitter.com/sacca |
| 1 | 1 | -1 | http://twitter.com/marshallk |
| 1 | 1 | -1 | http://twitter.com/nelson |
| 1 | 1 | -1 | http://twitter.com/dochugo |
| 1 | 1 | -1 | http://twitter.com/mizmoose |
| 1 | 1 | -1 | http://twitter.com/anildash |
| 1 | 1 | -1 | http://twitter.com/ccg |
| 1 | 1 | -1 | http://twitter.com/paulsmith |
| 1 | 1 | -1 | http://twitter.com/peterb |
| 1 | 1 | -1 | http://twitter.com/damienkatz |
| 1 | 1 | -1 | http://twitter.com/cameo |
| 1 | 1 | -1 | http://twitter.com/dickc |
| 1 | 1 | -1 | http://twitter.com/snort |
| 1 | 1 | -1 | http://twitter.com/codinghorror |
| 1 | 1 | -1 | http://twitter.com/padday |
| 1 | 1 | -1 | http://twitter.com/doughellmann |
| 1 | 1 | -1 | http://twitter.com/dakonkydong |
| 1 | 1 | -1 | http://twitter.com/loosewire |
+-----------+-------------+-----------+------------------------------------+
100 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment