Москва 8-926-233-52-54
arrowСтатистика сайта Spidometrs.ru
 
  корректировка спидометра коррекция скрутить смотать отмотать
Главная Контакт Новости Форум Магазин Авторынок
 
 
Страницы
Посещаемость сайта Глубина просмотра Переходы с поисковых систем История переходов
География
Языки Города и страны Страны
Разное
Сейчас на сайте Настройки
Переходы с поисковых систем
Отчет за период с 15.02.2018 00:00:00 до 15.02.2018 23:59:59

A fatal MySQL error occured:

Table 'cns_log' is marked as crashed and should be repaired

SELECT IF(LOCATE('http://www.punto.ru',referer)!=0,'Punto', IF(LOCATE('http://search.lycos',referer)!=0,'Lycos [Search]', IF(LOCATE('http://poisk.lycos.ru',referer)!=0,'Lycos [Search]', IF(LOCATE('http://www.hotbot.com',referer)!=0,'HotBot', IF(LOCATE('http://hotbot.com',referer)!=0,'HotBot', IF(LOCATE('http://www.alltheweb.com',referer)!=0,'AllTheWeb.com', IF(LOCATE('http://auto.search.msn',referer)!=0,'Microsoft Network', IF(LOCATE('http://aolsearch.aol.com',referer)!=0,'AOL Search', IF(LOCATE('http://search.netscape.com',referer)!=0,'Netscape Netcenter', IF(LOCATE('http://search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('http://altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('http://search.altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('uk.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.yupimsn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.xtramsn.co.nz',referer)!=0,'Microsoft Network', IF(LOCATE('search.tw.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.t1msn.com.mx',referer)!=0,'Microsoft Network', IF(LOCATE('search.no.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.nl.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.ninemsn.com.au',referer)!=0,'Microsoft Network', IF(LOCATE('search.latam.yupimsn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.latam.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.fr.msn.ch',referer)!=0,'Microsoft Network', IF(LOCATE('search.fr.msn.be',referer)!=0,'Microsoft Network', IF(LOCATE('partners.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('go.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('fr.ca.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('ca.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('auto.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('http://search.msn',referer)!=0,'Microsoft Network', IF(LOCATE('http://www.translate.google.com',referer)!=0,'Google', IF(LOCATE('http://www.toolbar.google.com',referer)!=0,'Google', IF(LOCATE('http://www.images.google',referer)!=0,'Google', IF(LOCATE('http://www.google',referer)!=0,'Google', IF(LOCATE('http://translate.google.com',referer)!=0,'Google', IF(LOCATE('http://toolbar.google.com',referer)!=0,'Google', IF(LOCATE('http://images.google',referer)!=0,'Google', IF(LOCATE('http://google.co',referer)!=0,'Google', IF(LOCATE('http://sm2.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://ec.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://an.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://sm.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://www-windows-1251.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://www-utf8.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://www-koi-8r.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://ie4.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://ie5.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://search.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://images.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://hghltd.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://bar.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://blogs.yandex.ru',referer)!=0,'Yandex.Blogs', IF(LOCATE('http://www.ya.ru',referer)!=0,'Yandex', IF(LOCATE('http://ya.ru',referer)!=0,'Yandex', IF(LOCATE('http://yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://www.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://www.excite.co.uk',referer)!=0,'Excite', IF(LOCATE('http://www.looksmart.com',referer)!=0,'LookSmart', IF(LOCATE('http://www.excite.com',referer)!=0,'Excite', IF(LOCATE('http://www.uk.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.search.yahoo',referer)!=0,'Yahoo', IF(LOCATE('http://www.mx.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.images.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.de.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.ar.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://uk.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://search.yahoo',referer)!=0,'Yahoo', IF(LOCATE('http://mx.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://images.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://de.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://ar.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://search.novgorod.ru',referer)!=0,'Search.Novgorod.Ru', IF(LOCATE('http://punto.ru',referer)!=0,'Punto', IF(LOCATE('http://go.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search1.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search3.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search.kvasir.no',referer)!=0,'Kvasir.no', 'Остальные ссылки'))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))),count(referer) FROM cns_log WHERE type=1 AND date>'2018-02-15 00:00:00' AND date<'2018-02-15 23:59:59' AND referer LIKE 'http%' GROUP BY IF(LOCATE('http://www.punto.ru',referer)!=0,'Punto', IF(LOCATE('http://search.lycos',referer)!=0,'Lycos [Search]', IF(LOCATE('http://poisk.lycos.ru',referer)!=0,'Lycos [Search]', IF(LOCATE('http://www.hotbot.com',referer)!=0,'HotBot', IF(LOCATE('http://hotbot.com',referer)!=0,'HotBot', IF(LOCATE('http://www.alltheweb.com',referer)!=0,'AllTheWeb.com', IF(LOCATE('http://auto.search.msn',referer)!=0,'Microsoft Network', IF(LOCATE('http://aolsearch.aol.com',referer)!=0,'AOL Search', IF(LOCATE('http://search.netscape.com',referer)!=0,'Netscape Netcenter', IF(LOCATE('http://search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('http://altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('http://search.altavista.com',referer)!=0,'Alta Vista', IF(LOCATE('uk.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.yupimsn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.xtramsn.co.nz',referer)!=0,'Microsoft Network', IF(LOCATE('search.tw.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.t1msn.com.mx',referer)!=0,'Microsoft Network', IF(LOCATE('search.no.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.nl.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.ninemsn.com.au',referer)!=0,'Microsoft Network', IF(LOCATE('search.latam.yupimsn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.latam.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('search.fr.msn.ch',referer)!=0,'Microsoft Network', IF(LOCATE('search.fr.msn.be',referer)!=0,'Microsoft Network', IF(LOCATE('partners.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('go.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('fr.ca.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('ca.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('auto.search.msn.com',referer)!=0,'Microsoft Network', IF(LOCATE('http://search.msn',referer)!=0,'Microsoft Network', IF(LOCATE('http://www.translate.google.com',referer)!=0,'Google', IF(LOCATE('http://www.toolbar.google.com',referer)!=0,'Google', IF(LOCATE('http://www.images.google',referer)!=0,'Google', IF(LOCATE('http://www.google',referer)!=0,'Google', IF(LOCATE('http://translate.google.com',referer)!=0,'Google', IF(LOCATE('http://toolbar.google.com',referer)!=0,'Google', IF(LOCATE('http://images.google',referer)!=0,'Google', IF(LOCATE('http://google.co',referer)!=0,'Google', IF(LOCATE('http://sm2.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://ec.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://an.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://sm.aport.ru',referer)!=0,'Aport', IF(LOCATE('http://www-windows-1251.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://www-utf8.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://www-koi-8r.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://ie4.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://ie5.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://search.rambler.ru',referer)!=0,'Rambler', IF(LOCATE('http://images.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://hghltd.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://bar.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://blogs.yandex.ru',referer)!=0,'Yandex.Blogs', IF(LOCATE('http://www.ya.ru',referer)!=0,'Yandex', IF(LOCATE('http://ya.ru',referer)!=0,'Yandex', IF(LOCATE('http://yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://www.yandex.ru',referer)!=0,'Yandex', IF(LOCATE('http://www.excite.co.uk',referer)!=0,'Excite', IF(LOCATE('http://www.looksmart.com',referer)!=0,'LookSmart', IF(LOCATE('http://www.excite.com',referer)!=0,'Excite', IF(LOCATE('http://www.uk.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.search.yahoo',referer)!=0,'Yahoo', IF(LOCATE('http://www.mx.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.images.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.de.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://www.ar.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://uk.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://search.yahoo',referer)!=0,'Yahoo', IF(LOCATE('http://mx.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://images.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://de.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://ar.search.yahoo.com',referer)!=0,'Yahoo', IF(LOCATE('http://search.novgorod.ru',referer)!=0,'Search.Novgorod.Ru', IF(LOCATE('http://punto.ru',referer)!=0,'Punto', IF(LOCATE('http://go.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search1.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search3.mail.ru',referer)!=0,'Mail.Ru', IF(LOCATE('http://search.kvasir.no',referer)!=0,'Kvasir.no', 'Остальные ссылки'))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) ORDER BY 2 desc;