Example of visits (database) from 2022-02-25 16:03 to 2022-02-26 07:47
83 visits during 15h44 (average [2022] : 1 visit every 11,37 seconds)
mysql> select * from Robots;
+-----------------------+---------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ws | dat | ip | ua |
+-----------------------+---------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| www.fauque.fr | 2022-02-25 16:03:04 | 207.46.13.235 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.edulinux.fr | 2022-02-25 16:08:43 | 66.249.64.206 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.fauque.fr | 2022-02-25 16:09:27 | 54.36.148.147 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.qcmclass.fr | 2022-02-25 16:22:22 | 54.36.149.0 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.qcmclass.fr | 2022-02-25 16:23:50 | 185.191.171.23 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.edulinux.fr | 2022-02-25 16:40:36 | 157.55.39.23 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 16:43:44 | 159.138.102.98 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-25 16:45:29 | 91.242.162.27 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.fauque.fr | 2022-02-25 16:47:24 | 185.191.171.2 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.qcmclass.fr | 2022-02-25 16:50:11 | 40.77.167.98 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 16:55:47 | 91.242.162.27 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.qcmclass.fr | 2022-02-25 17:07:12 | 91.242.162.27 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.156rdfp.fr | 2022-02-25 17:11:37 | 207.46.13.230 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.qcmclass.fr | 2022-02-25 17:33:15 | 77.88.5.208 | Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) |
| www.156rdfp.fr | 2022-02-25 17:38:48 | 40.77.167.104 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.156rdfp.fr | 2022-02-25 17:38:49 | 40.77.167.104 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.qcmclass.fr | 2022-02-25 17:47:02 | 51.222.253.16 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.edulinux.fr | 2022-02-25 17:48:58 | 185.191.171.34 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-25 17:50:03 | 40.77.167.103 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 17:50:59 | 162.210.196.129 | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) |
| www.fauque.fr | 2022-02-25 17:59:31 | 66.249.64.166 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.fauque.fr | 2022-02-25 18:09:30 | 185.191.171.11 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.156rdfp.fr | 2022-02-25 18:22:19 | 114.119.150.101 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.qcmclass.fr | 2022-02-25 19:00:40 | 114.119.141.77 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.hdjpneumotenon.fr | 2022-02-25 19:10:27 | 66.249.70.142 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.qcmclass.fr | 2022-02-25 19:40:53 | 207.46.13.234 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.hdjpneumotenon.fr | 2022-02-25 19:45:33 | 207.46.13.233 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 19:50:27 | 66.249.70.146 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.fauque.fr | 2022-02-25 19:54:56 | 91.242.162.3 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.156rdfp.fr | 2022-02-25 20:03:39 | 207.46.13.230 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.qcmclass.fr | 2022-02-25 20:11:55 | 91.242.162.3 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.hdjpneumotenon.fr | 2022-02-25 20:15:14 | 66.249.70.120 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.qcmclass.fr | 2022-02-25 20:18:07 | 207.46.13.234 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.qcmclass.fr | 2022-02-25 20:19:15 | 51.222.253.12 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.fauque.fr | 2022-02-25 20:35:59 | 91.242.162.3 | Mozilla/5.0 (compatible; Qwantify/2.4w; +https://www.qwant.com/) |
| www.fauque.fr | 2022-02-25 20:55:22 | 185.191.171.2 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.edulinux.fr | 2022-02-25 21:27:22 | 54.36.148.63 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.hdjpneumotenon.fr | 2022-02-25 21:49:12 | 207.46.13.233 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 22:04:26 | 185.191.171.41 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-25 22:29:17 | 85.208.98.51 | Mozilla/5.0 (compatible; SemrushBot-BM/1.0; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-25 22:30:42 | 40.77.167.103 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.hdjpneumotenon.fr | 2022-02-25 22:49:09 | 207.46.13.236 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-25 23:07:56 | 17.121.113.188 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot) |
| www.hdjpneumotenon.fr | 2022-02-25 23:20:44 | 54.36.148.190 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.fauque.fr | 2022-02-25 23:51:04 | 185.191.171.15 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.qcmclass.fr | 2022-02-25 23:55:42 | 40.77.167.98 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-26 00:00:34 | 114.119.149.89 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.edulinux.fr | 2022-02-26 00:05:39 | 114.119.130.109 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 00:24:15 | 114.119.143.133 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.qcmclass.fr | 2022-02-26 00:35:47 | 93.158.161.38 | Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) |
| www.fauque.fr | 2022-02-26 00:53:14 | 114.119.133.166 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 00:56:07 | 5.188.62.21 | Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2226.0 Safari/537.36 |
| www.fauque.fr | 2022-02-26 01:03:22 | 114.119.138.127 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 01:32:20 | 66.249.64.28 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.qcmclass.fr | 2022-02-26 01:41:56 | 185.191.171.10 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.qcmclass.fr | 2022-02-26 01:46:07 | 85.208.98.51 | Mozilla/5.0 (compatible; SemrushBot-BM/1.0; +http://www.semrush.com/bot.html) |
| www.edulinux.fr | 2022-02-26 01:51:24 | 167.114.101.143 | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) |
| www.fauque.fr | 2022-02-26 02:31:07 | 35.210.5.38 | Go-http-client/1.1 |
| www.qcmclass.fr | 2022-02-26 02:35:12 | 5.188.62.21 | Mozilla/5.0 (Windows NT 6.2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2227.1 Safari/537.36 |
| www.fauque.fr | 2022-02-26 02:41:37 | 185.191.171.4 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-26 02:42:07 | 114.119.142.93 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 02:44:02 | 93.158.161.38 | Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) |
| www.156rdfp.fr | 2022-02-26 03:03:54 | 40.77.167.104 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-26 03:12:51 | 17.121.113.30 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot) |
| www.qcmclass.fr | 2022-02-26 03:17:32 | 54.36.149.96 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.edulinux.fr | 2022-02-26 03:47:44 | 114.119.130.61 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 04:20:22 | 35.210.24.3 | Go-http-client/1.1 |
| www.fauque.fr | 2022-02-26 04:41:11 | 114.119.129.229 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 05:04:57 | 185.191.171.38 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-26 05:05:00 | 216.244.66.199 | Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com) |
| www.156rdfp.fr | 2022-02-26 05:17:17 | 40.77.167.104 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.edulinux.fr | 2022-02-26 05:36:48 | 5.188.62.140 | Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2227.1 Safari/537.36 |
| www.fauque.fr | 2022-02-26 05:41:39 | 17.121.115.155 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot) |
| www.fauque.fr | 2022-02-26 05:43:35 | 114.119.130.125 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.fauque.fr | 2022-02-26 05:54:01 | 216.244.66.199 | Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com) |
| www.fauque.fr | 2022-02-26 06:14:48 | 51.222.253.15 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.fauque.fr | 2022-02-26 06:58:12 | 93.158.161.38 | Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) |
| www.edulinux.fr | 2022-02-26 07:09:07 | 185.191.171.8 | Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) |
| www.fauque.fr | 2022-02-26 07:18:35 | 54.36.149.34 | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) |
| www.qcmclass.fr | 2022-02-26 07:32:20 | 66.249.64.55 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
| www.156rdfp.fr | 2022-02-26 07:32:46 | 114.119.129.81 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
| www.156rdfp.fr | 2022-02-26 07:37:20 | 207.46.13.230 | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) |
| www.fauque.fr | 2022-02-26 07:47:00 | 114.119.140.217 | Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot) |
+-----------------------+---------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
83 rows in set (0.00 sec)
mysql> select ws,count(ws) as nbvisits from Robots group by ws;
+-----------------------+----------+
| ws | nbvisits |
+-----------------------+----------+
| www.156rdfp.fr | 9 |
| www.edulinux.fr | 9 |
| www.fauque.fr | 41 |
| www.hdjpneumotenon.fr | 6 |
| www.qcmclass.fr | 18 |
+-----------------------+----------+
5 rows in set (0.00 sec)
mysql> select date(dat) as date,count(dat) as nbvisit from Robots group by date(dat);
+------------+---------+
| date | nbvisit |
+------------+---------+
| 2022-02-25 | 46 |
| 2022-02-26 | 37 |
+------------+---------+
2 rows in set (0.00 sec)
mysql> notee;
|
Download
