Не грабятся тумбы
Posted: Sat May 24, 2014 3:58 am
Привет.При импорт тумбы остаются в To Grab .
Версия 50.Build 201402240856
В Home все чисто.В error.log вот такое
07.40 select * from settings:: :
07.40 select * from rot_settings:: :
07.40 SELECT `data` FROM `admin_sessions` WHERE `id` = '9e9b37a13d72817658051fcad68e3e85' LIMIT 1:: :
07.40 select ip from admin_access_log where date > '2014-05-18 00:00:00' order by date desc:: :
07.40 insert into admin_access_log (ip, date) values ('2996713719', '2014-05-18 07:40:02'):: :
07.40 select * from ga_categories order by name desc:: :
07.40 select count(*) from script_messages where msg_new = 1:: :
07.40 SELECT td FROM traders WHERE system_trade IN (2,3):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388828' and hour <= 388851 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388828' and hour <= 388851 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
07.40 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select value from settings where name = 'last_update_number':: :
07.40 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
07.40 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
07.40 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
07.40 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
07.40 select sum(num) as total_clicks from bookmarks :: :
07.40 show fields from trader_groups:: :
07.40 select * from trader_groups order by group_name:: :
07.40 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('9e9b37a13d72817658051fcad68e3e85', ''):: :
01.23 select * from settings:: :
01.23 select * from rot_settings:: :
01.23 SELECT `data` FROM `admin_sessions` WHERE `id` = 'e37ba5c4093b46eda792acf9614f1e2c' LIMIT 1:: :
01.23 select ip from admin_access_log where date > '2014-05-19 00:00:00' order by date desc:: :
01.23 insert into admin_access_log (ip, date) values ('1389328439', '2014-05-19 01:23:36'):: :
01.23 select * from ga_categories order by name desc:: :
01.23 select count(*) from script_messages where msg_new = 1:: :
01.23 SELECT td FROM traders WHERE system_trade IN (2,3):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader = 'SE':: :
01.23 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select value from settings where name = 'last_update_number':: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
01.23 select sum(num) as total_clicks from bookmarks :: :
01.23 show fields from trader_groups:: :
01.23 select * from trader_groups order by group_name:: :
01.23 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('e37ba5c4093b46eda792acf9614f1e2c', ''):: :
01.23 select * from settings:: :
01.23 select * from rot_settings:: :
01.23 SELECT `data` FROM `admin_sessions` WHERE `id` = 'ba021e0102c9b428242e9163fd094423' LIMIT 1:: :
01.23 select ip from admin_access_log where date > '2014-05-19 00:00:00' order by date desc:: :
01.23 insert into admin_access_log (ip, date) values ('1389328439', '2014-05-19 01:23:40'):: :
01.23 select * from ga_categories order by name desc:: :
01.23 select count(*) from script_messages where msg_new = 1:: :
01.23 SELECT td FROM traders WHERE system_trade IN (2,3):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader = 'SE':: :
01.23 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select value from settings where name = 'last_update_number':: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
01.23 select sum(num) as total_clicks from bookmarks :: :
01.23 show fields from trader_groups:: :
01.23 select * from trader_groups order by group_name:: :
01.23 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('ba021e0102c9b428242e9163fd094423', ''):: :
11.40 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
11.40 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
11.42 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
11.42 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
12.20 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
12.20 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
Админы говорят что кроны работают.
помогите советом.
Версия 50.Build 201402240856
В Home все чисто.В error.log вот такое
07.40 select * from settings:: :
07.40 select * from rot_settings:: :
07.40 SELECT `data` FROM `admin_sessions` WHERE `id` = '9e9b37a13d72817658051fcad68e3e85' LIMIT 1:: :
07.40 select ip from admin_access_log where date > '2014-05-18 00:00:00' order by date desc:: :
07.40 insert into admin_access_log (ip, date) values ('2996713719', '2014-05-18 07:40:02'):: :
07.40 select * from ga_categories order by name desc:: :
07.40 select count(*) from script_messages where msg_new = 1:: :
07.40 SELECT td FROM traders WHERE system_trade IN (2,3):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388828' and hour <= 388851 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388828' and hour <= 388851 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
07.40 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
07.40 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
07.40 select value from settings where name = 'last_update_number':: :
07.40 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
07.40 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
07.40 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
07.40 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
07.40 select sum(num) as total_clicks from bookmarks :: :
07.40 show fields from trader_groups:: :
07.40 select * from trader_groups order by group_name:: :
07.40 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('9e9b37a13d72817658051fcad68e3e85', ''):: :
01.23 select * from settings:: :
01.23 select * from rot_settings:: :
01.23 SELECT `data` FROM `admin_sessions` WHERE `id` = 'e37ba5c4093b46eda792acf9614f1e2c' LIMIT 1:: :
01.23 select ip from admin_access_log where date > '2014-05-19 00:00:00' order by date desc:: :
01.23 insert into admin_access_log (ip, date) values ('1389328439', '2014-05-19 01:23:36'):: :
01.23 select * from ga_categories order by name desc:: :
01.23 select count(*) from script_messages where msg_new = 1:: :
01.23 SELECT td FROM traders WHERE system_trade IN (2,3):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader = 'SE':: :
01.23 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select value from settings where name = 'last_update_number':: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
01.23 select sum(num) as total_clicks from bookmarks :: :
01.23 show fields from trader_groups:: :
01.23 select * from trader_groups order by group_name:: :
01.23 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('e37ba5c4093b46eda792acf9614f1e2c', ''):: :
01.23 select * from settings:: :
01.23 select * from rot_settings:: :
01.23 SELECT `data` FROM `admin_sessions` WHERE `id` = 'ba021e0102c9b428242e9163fd094423' LIMIT 1:: :
01.23 select ip from admin_access_log where date > '2014-05-19 00:00:00' order by date desc:: :
01.23 insert into admin_access_log (ip, date) values ('1389328439', '2014-05-19 01:23:40'):: :
01.23 select * from ga_categories order by name desc:: :
01.23 select count(*) from script_messages where msg_new = 1:: :
01.23 SELECT td FROM traders WHERE system_trade IN (2,3):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388852' and hour <= 388875 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388876' and hour <= 388899 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388900' and hour <= 388923 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388924' and hour <= 388947 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388948' and hour <= 388971 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388972' and hour <= 388995 and trader = 'SE':: :
01.23 select sum(row), sum(uni), sum(`out`), sum(click_trade), sum(click_url)
from history where hour >= '388996' and hour <= 389019 and trader = 'SE':: :
01.23 SELECT
sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as ud,
sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as rd,
sum(ho0 + ho1 + ho2 + ho3 + ho4 + ho5 + ho6 + ho7 + ho8 + ho9 + ho10 + ho11 + ho12 + ho13 + ho14 + ho15 + ho16 + ho17 + ho18 + ho19 + ho20 + ho21 + ho22 + ho23) as od,
sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7 + hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15 + hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as ctd,
sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6 + hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15 + hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23) as cud
FROM day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select * from day WHERE 1 = 1 and h NOT IN ('blocked_ref', 'mobile', 'spiders' ):: :
01.23 select value from settings where name = 'last_update_number':: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'SE' :: :
01.23 select sum(hu0 + hu1 + hu2 + hu3 + hu4 + hu5 + hu6 + hu7 + hu8 + hu9 + hu10 + hu11 + hu12 + hu13 + hu14 + hu15 + hu16 + hu17 + hu18 + hu19 + hu20 + hu21 + hu22 + hu23) as total_hits from day where h = 'noref' :: :
01.23 select sum(hr0 + hr1 + hr2 + hr3 + hr4 + hr5 + hr6 + hr7 + hr8 + hr9 + hr10 + hr11 + hr12 + hr13 + hr14 + hr15 + hr16 + hr17 + hr18 + hr19 + hr20 + hr21 + hr22 + hr23) as total_hits from day where h = 'noref' :: :
01.23 select sum(num) as total_clicks from bookmarks :: :
01.23 show fields from trader_groups:: :
01.23 select * from trader_groups order by group_name:: :
01.23 REPLACE INTO `admin_sessions` (`id`, `data`) VALUES ('ba021e0102c9b428242e9163fd094423', ''):: :
11.40 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
11.40 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
11.42 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
11.42 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
12.20 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
12.20 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
Админы говорят что кроны работают.
помогите советом.