by ehermouet » Thu Jun 19, 2014 9:47 am
6.25') and (last_local_call_time < "2014-06-19 04:05:06") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2014-06-19 03:50:06") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2014-06-19 03:35:06") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2014-06-19 03:20:06") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2014-06-19 03:05:06") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2014-06-19 02:50:06") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2014-06-19 02:35:06") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2014-06-19 02:20:06") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2014-06-19 02:05:06") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2014-06-19 01:50:06") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2014-06-19 01:35:06") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2014-06-19 01:20:06") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2014-06-19 01:05:06") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2014-06-19 00:50:06") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2014-06-19 00:35:06") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2014-06-19 00:20:06") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2014-06-19 00:05:06") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2014-06-18 23:50:06") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2014-06-18 23:35:06") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2014-06-18 23:20:06") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2014-06-18 23:05:06") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2014-06-18 22:50:06") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2014-06-18 22:35:06") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2014-06-18 22:20:06") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2014-06-18 22:05:06") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2014-06-18 21:50:06") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2014-06-18 21:35:06") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2014-06-18 21:20:06") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2014-06-18 21:05:06") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2014-06-18 20:50:06") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2014-06-18 20:35:06") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2014-06-18 20:20:06") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2014-06-18 20:05:06") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2014-06-18 19:50:06") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2014-06-18 19:35:06") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2014-06-18 19:20:06") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2014-06-18 19:05:06") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2014-06-18 18:50:06") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2014-06-18 18:35:06") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2014-06-18 18:20:06") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2014-06-18 18:05:06") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2014-06-18 17:50:06") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2014-06-18 17:35:06") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2014-06-18 17:20:06") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2014-06-18 17:05:06") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2014-06-18 16:50:06") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2014-06-18 16:35:06") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2014-06-18 16:20:06") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2014-06-18 16:05:06") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2014-06-18 15:50:06") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2014-06-18 15:35:06") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2014-06-18 15:20:06") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2014-06-18 15:05:06") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2014-06-18 14:50:06") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2014-06-18 14:35:06") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2014-06-18 14:20:06") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2014-06-18 14:05:06") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2014-06-18 13:50:06") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2014-06-18 13:35:06") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2014-06-18 13:20:06") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2014-06-18 13:05:06") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2014-06-18 12:50:06") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2014-06-18 12:35:06") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2014-06-18 12:20:06") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2014-06-18 12:05:06") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2014-06-18 11:50:06") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2014-06-18 11:35:06") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2014-06-18 11:20:06") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2014-06-18 11:05:06") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2014-06-18 10:50:06") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2014-06-18 10:35:06") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2014-06-18 10:20:06") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2014-06-18 10:05:06") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2014-06-18 09:50:06") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2014-06-18 09:35:06") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2014-06-18 09:20:06") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2014-06-18 09:05:06") ) ) ) ) and list_id IN('997') and lead_id NOT IN('0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 50;|
RECYCLE leads to call count: 0
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where ( ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='B') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2014-06-19 10:50:06") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2014-06-19 10:35:06") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2014-06-19 10:20:06") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2014-06-19 10:05:06") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2014-06-19 09:50:06") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2014-06-19 09:35:06") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2014-06-19 09:20:06") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2014-06-19 09:05:06") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2014-06-19 08:50:06") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2014-06-19 08:35:06") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2014-06-19 08:20:06") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2014-06-19 08:05:06") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2014-06-19 07:50:06") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2014-06-19 07:35:06") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2014-06-19 07:20:06") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2014-06-19 07:05:06") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2014-06-19 06:50:06") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2014-06-19 06:35:06") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2014-06-19 06:20:06") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2014-06-19 06:05:06") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2014-06-19 05:50:06") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2014-06-19 05:35:06") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2014-06-19 05:20:06") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2014-06-19 05:05:06") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2014-06-19 04:50:06") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2014-06-19 04:35:06") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2014-06-19 04:20:06") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2014-06-19 04:05:06") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2014-06-19 03:50:06") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2014-06-19 03:35:06") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2014-06-19 03:20:06") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2014-06-19 03:05:06") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2014-06-19 02:50:06") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2014-06-19 02:35:06") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2014-06-19 02:20:06") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2014-06-19 02:05:06") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2014-06-19 01:50:06") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2014-06-19 01:35:06") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2014-06-19 01:20:06") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2014-06-19 01:05:06") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2014-06-19 00:50:06") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2014-06-19 00:35:06") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2014-06-19 00:20:06") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2014-06-19 00:05:06") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2014-06-18 23:50:06") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2014-06-18 23:35:06") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2014-06-18 23:20:06") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2014-06-18 23:05:06") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2014-06-18 22:50:06") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2014-06-18 22:35:06") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2014-06-18 22:20:06") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2014-06-18 22:05:06") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2014-06-18 21:50:06") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2014-06-18 21:35:06") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2014-06-18 21:20:06") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2014-06-18 21:05:06") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2014-06-18 20:50:06") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2014-06-18 20:35:06") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2014-06-18 20:20:06") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2014-06-18 20:05:06") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2014-06-18 19:50:06") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2014-06-18 19:35:06") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2014-06-18 19:20:06") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2014-06-18 19:05:06") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2014-06-18 18:50:06") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2014-06-18 18:35:06") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2014-06-18 18:20:06") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2014-06-18 18:05:06") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2014-06-18 17:50:06") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2014-06-18 17:35:06") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2014-06-18 17:20:06") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2014-06-18 17:05:06") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2014-06-18 16:50:06") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2014-06-18 16:35:06") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2014-06-18 16:20:06") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2014-06-18 16:05:06") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2014-06-18 15:50:06") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2014-06-18 15:35:06") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2014-06-18 15:20:06") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2014-06-18 15:05:06") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2014-06-18 14:50:06") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2014-06-18 14:35:06") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2014-06-18 14:20:06") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2014-06-18 14:05:06") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2014-06-18 13:50:06") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2014-06-18 13:35:06") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2014-06-18 13:20:06") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2014-06-18 13:05:06") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2014-06-18 12:50:06") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2014-06-18 12:35:06") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2014-06-18 12:20:06") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2014-06-18 12:05:06") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2014-06-18 11:50:06") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2014-06-18 11:35:06") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2014-06-18 11:20:06") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2014-06-18 11:05:06") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2014-06-18 10:50:06") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2014-06-18 10:35:06") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2014-06-18 10:20:06") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2014-06-18 10:05:06") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2014-06-18 09:50:06") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2014-06-18 09:35:06") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2014-06-18 09:20:06") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2014-06-18 09:05:06") ) ) ) ) and list_id IN('997') and lead_id NOT IN('0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 50;|
Adding to hopper: 0
DONE with this campaign
SUMMARY: 3 campaigns
TESTCAMP 27 5 5
Relances 25 1 1
110 0 50 0
DONE. Script execution time in seconds: 0