Visualizza:
djjeck
spiders
escludi visitatori normali
giorni
mesi
admin page

March
2008		 April
2008		 May
2008
SELECT datetime, coalesce(idalias.alias,visita.id), contatore, ip, useragent FROM visita LEFT JOIN idalias ON visita.id = idalias.id WHERE datetime > '2008-05-14 00:00:00' ORDER BY datetime DESC
admindataIDcontatoreIPuser agent
2008-05-16
elimina2008-05-16 06:14:1912109112595118762.129.253.19
elimina2008-05-16 05:50:5412109098545118692.112.82.230Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
elimina2008-05-16 04:50:26121090622651185201.38.159.195Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-16 04:50:01121090620151184200.219.152.6Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-16 04:49:29121090616951183201.34.32.44Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-16 04:49:2312109061635118274.50.117.14
elimina2008-05-16 02:17:29121089704951181200.62.149.14Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-16 02:16:5212108970125118072.21.34.26
elimina2008-05-16 01:44:2612108950665117989.149.254.93Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040815 Firefox/0.8 (MOOX M3)
elimina2008-05-16 01:08:10121089289051178203.162.2.133Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-16 01:08:06121089288651177216.32.81.66
elimina2008-05-16 00:57:0612108922265117669.136.140.161Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)
elimina2008-05-16 00:13:5212108896325117587.50.11.169Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)
elimina2008-05-16 00:12:0112108895215117478.156.217.30Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
2008-05-15
elimina2008-05-15 23:43:3012108878105117361.247.221.45Yeti/1.0 (+http://help.naver.com/robots/)
elimina2008-05-15 23:27:2512108868455117283.93.76.230Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
elimina2008-05-15 23:01:5512108853155117167.86.236.146Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040707 Firefox/0.9.2 StumbleUpon/1.998
elimina2008-05-15 22:18:5412108827345117081.169.154.94Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
elimina2008-05-15 22:08:25121088210551169202.179.180.42Mozilla/4.0 (compatible; NaverBot/1.0; http://help.naver.com/delete_main.asp)
elimina2008-05-15 21:21:1712108792775116887.104.65.191Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)
elimina2008-05-15 21:04:5512108782955116761.132.27.68Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 21:04:4712108782875116672.21.34.26
elimina2008-05-15 20:27:3512108760555116587.118.112.43Mozilla/5.0 (Windows; U; WinNT4.0; en-CA; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
elimina2008-05-15 18:52:3912108703595116479.42.90.176Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
elimina2008-05-15 18:06:16121086757651163202.179.180.45Mozilla/4.0 (compatible; NaverBot/1.0; http://help.naver.com/delete_main.asp)
elimina2008-05-15 18:01:2412108672845116289.149.254.93Mozilla/4.5 [en]C-CCK-MCD {TLC;RETAIL} (Win95; U)
elimina2008-05-15 16:18:37121086111751161206.225.84.223
elimina2008-05-15 16:04:0912108602495116085.91.81.188Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 15:15:58121085735851158151.96.3.241Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
elimina2008-05-15 14:34:4412108548845115780.191.83.5Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 14:34:35121085487551156200.199.5.43Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 14:34:3212108548725115564.92.164.106
elimina2008-05-15 13:52:1612108523365115466.212.28.29Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 13:52:08121085232851153200.208.127.130Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 13:51:5112108523115115258.248.44.155Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 13:51:4112108523015115174.50.117.14
elimina2008-05-15 13:35:09121085130951150200.165.133.73Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 13:05:15121084951551149204.185.11.48Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 13:05:0312108495035114872.233.58.23
elimina2008-05-15 12:42:2812108481485114789.78.226.43Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 12:42:2712108481475114689.149.227.166
elimina2008-05-15 12:41:24121084808451145151.67.11.178Mozilla/5.0 (Macintosh; U; Intel Mac OS X; it; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
elimina2008-05-15 11:29:55121084379551144200.133.8.2Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 11:29:4212108437825114372.21.34.26
elimina2008-05-15 10:54:59121084169951142125.64.94.209Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20060319 Firefox/2.0a1
elimina2008-05-15 10:31:4812108403085114190.156.9.75Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 10:31:4712108403075114089.149.227.166
elimina2008-05-15 10:25:41121083994151139200.160.125.20Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 10:25:32121083993251138216.32.81.66
elimina2008-05-15 09:17:4012108358605113789.113.17.122Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 09:17:3912108358595113689.149.227.166
elimina2008-05-15 08:21:47121083250751135201.66.22.129Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 08:21:3512108324955113472.21.34.82
elimina2008-05-15 06:45:1412108267145113392.43.64.81Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 06:24:5712108254975113289.77.201.229Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 06:06:16121082437651130125.243.145.2Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 06:06:0912108243695112972.21.34.26
elimina2008-05-15 06:00:2312108240235112885.214.51.251Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 06:00:22121082402251127200.140.171.24Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 06:00:1912108240195112664.92.166.42
elimina2008-05-15 04:35:0912108189095112572.233.58.23
elimina2008-05-15 03:51:10121081627051124220.88.184.231Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)
elimina2008-05-15 03:38:3412108155145112385.89.181.147Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 03:09:4712108137875112285.8.13.217Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 02:56:34121081299451120156.26.118.51Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.6) Gecko/20050224 Firefox/1.0.2
elimina2008-05-15 00:59:25121080596551119201.6.248.113Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 00:59:2112108059615111872.21.34.26
elimina2008-05-15 00:22:1312108037335111789.78.226.43Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 00:04:45121080268551116203.162.2.135Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 00:04:43121080268351115200.3.225.251Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 00:04:4212108026825111474.50.117.14
elimina2008-05-15 00:03:2512108026055111380.191.83.5Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-15 00:03:2112108026015111264.92.164.106
2008-05-14
elimina2008-05-14 23:56:1112108021715111187.236.233.52Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 23:56:0912108021695111089.149.227.166
elimina2008-05-14 22:56:37121079859751109201.234.80.3Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 22:56:33121079859351108216.32.81.66
elimina2008-05-14 21:35:11121079371151107202.179.180.42Mozilla/4.0 (compatible; NaverBot/1.0; http://help.naver.com/delete_main.asp)
elimina2008-05-14 21:12:3212107923525110689.147.0.209Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 21:12:3112107923515110589.149.227.166
elimina2008-05-14 19:58:5412107879345110487.118.112.43Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 19:14:11121078525151103151.20.39.56Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
elimina2008-05-14 18:48:4912107837295110290.133.22.59Mozilla/5.0 (Macintosh; U; Intel Mac OS X; it; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
elimina2008-05-14 17:47:0212107800225110198.75.131.245Mozilla/4.0+(compatible;)
elimina2008-05-14 17:18:3512107783155110088.55.112.19Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 17:18:3012107783105109988.208.233.228Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 17:18:2212107783025109889.149.227.166
elimina2008-05-14 15:59:27121077356751097208.80.193.30Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; {A698DE5F-353B-54DF-F3C7-1033B6FB6D93}; ADVPLUGIN|K114|04|S-1133534006|dialno; snprtz|dialno)
elimina2008-05-14 15:49:26121077296651096189.20.64.106Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 15:49:2112107729615109572.21.34.82
elimina2008-05-14 14:12:02121076712251094221.174.22.7Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20050512 Netscape/8.0
elimina2008-05-14 13:51:39121076589951093201.30.204.2Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 13:51:3312107658935109272.21.34.26
elimina2008-05-14 13:37:3612107650565109187.252.185.98Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 13:37:2712107650475109089.149.227.166
elimina2008-05-14 12:54:04121076244451089221.0.94.67Mozilla/4.0 (compatible; MSIE 6.0; AOL 9.0; Windows NT 5.1)
elimina2008-05-14 11:09:05121075614551088207.38.4.12Opera/9.00 (Windows NT 5.1; U; en)
elimina2008-05-14 11:07:0412107560245108782.55.106.199Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)
elimina2008-05-14 11:05:5312106265195108679.13.106.22Mozilla/5.0 (X11; U; Linux x86_64; it; rv:1.9b5) Gecko/2008050509 Firefox/3.0b5
elimina2008-05-14 10:50:5612107550565108577.222.142.33Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 10:48:1812107548985108492.43.64.81Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 10:48:08121075488851083216.32.81.66
elimina2008-05-14 10:47:27121075484751082200.129.43.168Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 10:25:14121075351451081201.38.159.195Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 10:25:0512107535055108072.233.58.23
elimina2008-05-14 10:05:2512107523255107986.133.40.32Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 08:55:3712107481375107789.149.254.93Mozilla/4.0 (compatible; MSIE 5.0; Windows 2000) Opera 6.0 [en]
elimina2008-05-14 08:26:2612107463865107685.91.81.188Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 08:26:2412107463845107572.21.34.26
elimina2008-05-14 04:40:00121073280051074208.80.193.45Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312467)
elimina2008-05-14 03:43:30121072941051073201.66.22.129Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 03:43:2312107294035107272.21.34.26
elimina2008-05-14 01:49:19121072255951071203.162.2.133Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 01:49:1612107225565107092.43.64.81Opera/9.0 (Windows NT 5.1; U; en)
elimina2008-05-14 01:49:1412107225545106964.92.166.42
elimina2008-05-14 01:30:3612107214365106879.22.4.4Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
elimina2008-05-14 00:23:1412107173945106781.208.31.223Mozilla/4.0 (compatible; MSIE 5.00; Windows 98)

connect: Resource id #6
select db: 1