From Wikipedia, the free encyclopedia
num_wikis = number of wikis that the link was added on in the last 24 hours.
s_domain = indexed domain, this is just the domain flipped around. This is done for mysql optimization purposes.
u_c = Number of users that added the listed link. A single IP registers as one user. (one IP spamming 5 wikis will show up as 1 in this field)
user = Last user that added the link, in the case that there is only 1 user, this is the user that did it.
timestamp = Time of last link addition.
l = total number of links added
d_l = total number of *distinct* links added. If someone is just adding "foo.com" to 10 pages, this shows up as 1.
If the link is different as in "foo.com/1" "foo.com/2" etc, the number of different links will be counted and shown here.
fullurl = last full url added.
+-----------+------------------------------+-----+----------------+---------------------+----+-----+--------------------------------------------------------------------------+
| num_wikis | s_domain | u_c | user | timestamp | l | d_l | fullurl |
+-----------+------------------------------+-----+----------------+---------------------+----+-----+--------------------------------------------------------------------------+
| 27 | com.radhavallabh.www. | 4 | ClueBot | 2008-03-22 00:04:38 | 30 | 3 | http://www.radhavallabh.com/Holi |
| 9 | com.bubbleart.www. | 1 | Claus Ableiter | 2008-03-21 12:53:27 | 9 | 1 | http://www.bubbleart.com/ |
| 9 | com.keithmichaeljohnson.www. | 1 | Claus Ableiter | 2008-03-21 12:49:23 | 9 | 1 | http://www.keithmichaeljohnson.com/ |
| 9 | com.tangenttoy.www. | 1 | Claus Ableiter | 2008-03-21 12:54:59 | 9 | 1 | http://www.tangenttoy.com/bubbleman/ |
| 9 | com.tomnoddy.www. | 1 | Claus Ableiter | 2008-03-21 12:41:29 | 9 | 1 | http://www.tomnoddy.com/ |
| 9 | com.worldslargestbubble. | 1 | Claus Ableiter | 2008-03-21 13:30:55 | 9 | 1 | http://worldslargestbubble.com/gwr.html |
| 9 | com.xtremebubbles.www. | 1 | Claus Ableiter | 2008-03-21 13:35:46 | 9 | 1 | http://www.xtremebubbles.com/media_press.html |
| 9 | de.rinaldo.www. | 1 | Claus Ableiter | 2008-03-21 12:58:17 | 9 | 1 | http://www.rinaldo.de/seifenblasen-show.php |
| 8 | br.com.terra.paginas. | 2 | 189.25.152.74 | 2008-03-21 18:40:58 | 11 | 5 | http://paginas.terra.com.br/esporte/rsssfbrasil/miscellaneous/flutit.htm |
| 7 | com.deniztube.www. | 1 | 85.99.214.79 | 2008-03-21 21:15:23 | 54 | 1 | http://www.deniztube.com |
| 7 | com.tangsudo.www. | 1 | 88.149.245.138 | 2008-03-22 02:37:34 | 7 | 1 | http://www.tangsudo.com |
| 5 | com.worldmapfinder.www. | 2 | 64.60.43.52 | 2008-03-21 20:34:12 | 13 | 12 | http://www.worldmapfinder.com/country/kr_kazakhstan.html |
| 5 | net.3monkeyz.www. | 1 | 220.86.141.234 | 2008-03-21 21:34:06 | 5 | 3 | http://www.3monkeyz.net/index_No.htm |
| 5 | net.risk-online.www. | 1 | 84.58.35.23 | 2008-03-21 15:57:07 | 5 | 1 | http://www.risk-online.net |
| 5 | nl.airbornekerkhof.www. | 4 | 81.70.33.154 | 2008-03-21 15:36:36 | 7 | 1 | http://www.airbornekerkhof.nl/ |
| 4 | com.arnold-chiari.www. | 2 | Jacasfru | 2008-03-21 10:52:30 | 9 | 1 | http://www.arnold-chiari.com/ |
| 4 | com.israelinphotos. | 1 | 85.250.132.235 | 2008-03-22 09:03:09 | 4 | 1 | http://israelinphotos.com/gallery8-Holon.htm |
| 4 | de.rodurago.www. | 1 | 85.178.228.99 | 2008-03-21 09:45:02 | 5 | 3 | http://www.rodurago.de/en/index.php?site=details&link=0 |
| 4 | ru.narod.rfc-of-oeb. | 1 | 78.37.31.50 | 2008-03-21 12:02:13 | 5 | 2 | http://rfc-of-oeb.narod.ru/mainpage.html |
| 3 | com.chesshistory.www. | 2 | ZucchiniMann | 2008-03-21 10:20:33 | 3 | 2 | http://www.chesshistory.com/winter/extra/corzo.html |
| 3 | com.parkerpen.www. | 1 | 198.176.19.40 | 2008-03-21 13:34:42 | 3 | 3 | http://www.parkerpen.com/nl/ |
| 3 | com.productosdegalicia.www. | 2 | Xaviugt | 2008-03-21 17:12:12 | 3 | 1 | http://www.productosdegalicia.com |
| 3 | com.proyectoventiworld.www. | 2 | 190.31.61.114 | 2008-03-21 23:07:59 | 5 | 2 | http://www.proyectoventiworld.com |
| 3 | com.speedskating-online.www. | 1 | 32peet74 | 2008-03-21 13:44:36 | 3 | 1 | http://www.speedskating-online.com/morrisonmarch2008.htm |
| 3 | com.webcindario.ivetlalova. | 2 | 81.41.114.226 | 2008-03-21 14:18:11 | 4 | 2 | http://ivetlalova.webcindario.com/carolinakluft.htm |
| 3 | ru.msu.sai.www. | 1 | Yakudza | 2008-03-21 11:50:41 | 3 | 1 | http://www.sai.msu.ru/news/2007/01/20/chernyh.html |
| 3 | ua.biz.catalogue.www. | 2 | Droba | 2008-03-22 08:41:35 | 4 | 4 | http://www.catalogue.biz.ua/rus/guides/guide_index/1/1/ |
+-----------+------------------------------+-----+----------------+---------------------+----+-----+--------------------------------------------------------------------------+
27 rows in set (12.92 sec)
