Lead Recycle issue

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Lead Recycle issue

Postby urmi.l » Thu May 12, 2016 3:05 am

Hello,

VERSION: 2.4-364a BUILD: 120409-1136 © 2012 ViciDial Group

We have outbound process working very well with PRI lines. We have setup Lead recycle in all the campaigns. My issue is the lead recycle is not working the way it should be.

Below is my lead recycle settings :

STATUS | ATTEMPT DELAY | ATTEMPT MAXIMUM
N | 18000 | 10
B | 18000 | 10
CD | 18000 | 10

Now, if any call disposed as N, B or CD then it should be called after 18000 seconds i.e after 5 hours. But right now its directly coming to hopper and hence the next call is dialed within few minutes only.

Actually it should not come to hopper till attempt delay time and even should not dialed out. Can anyone help me out here ?
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India

Re: Lead Recycle issue

Postby MJCoate » Thu May 12, 2016 8:36 am

Hello,

I've never seen this before but you might consider upgrading as you're running a version of VICIdial that's over 6 years old.
Mike Coate | VICIdial Technical Support Staff
MJCoate
 
Posts: 82
Joined: Wed Mar 25, 2015 1:57 pm

Re: Lead Recycle issue

Postby williamconley » Thu May 12, 2016 1:19 pm

Lead recycle is designed to call a "busy" or similar status up to 5 MINUTES later (not hours).

If you're trying to call 5 hours later, just call all the leads in the list and reset the list. You should not be using lead recycle for this, turn it off and reset the list instead.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Lead Recycle issue

Postby urmi.l » Fri May 13, 2016 5:59 am

Thank you for your reply.

We need to call the NA,B etc dispositions at every 5 hours that is business logic.

This was working fine since last 3 years. And even working fine in other replica server. Can you please help me out in this ?
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India

Re: Lead Recycle issue

Postby williamconley » Fri May 13, 2016 11:05 am

If it's been working for 5 years ... what changed?

Someone posted a fix for one of the sql queries in lead recycle a couple weeks ago. Not sure if it's related at all to your issue, since I have no idea what your issue is (ie: if it works for 5 years and stops working suddenly ... why?)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Lead Recycle issue

Postby urmi.l » Tue May 17, 2016 5:24 am

No change and still lead recycle stopped working. Even the same is working in other replica server.

Someone posted a fix for one of the sql queries in lead recycle a couple weeks ago.

Will you please do let me know what was this change or will you please do let me know the link ?
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India

Re: Lead Recycle issue

Postby williamconley » Tue May 17, 2016 4:40 pm

If I had the link handy, I'd have posted it before. But as I recall, there was a slight change to the sql query. Whether or not that's related to the issue you're having is another matter. LOL
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Lead Recycle issue

Postby urmi.l » Mon May 23, 2016 3:35 pm

I found some issues with last_local_call_time. I m not sure but it may be related to Lead recycling. I have below settings for my cluster :

2 asterisk servers and 1 web / DB server. We are working accordingly Asia/calcutta timezone : GMT +5.5
Asterisk1== 192.168.1.30
Asterisk2== 192.168.1.33

DB == 192.168.1.32


I have below entries in my admin==>Server Settings :
asterisk1 192.168.1.30 5.50
asterisk2 192.168.1.33 5.50
vicidial 192.168.1.32 0.0

Now, when we did few calls and check, its not setting the correct last_local_call_time in vicidial_list table against any lead and hence its creating issue in recycling the leads. The lead recycling is calculating the interval based on the last_local_call_time.

We found that the vdc_db_query.php file is setting the last_local_call_time in MANUAL call but can any one do let me know from where this last_local_call_time is being set in auto dialing ? Also why its taking wrong last_local_call_time ?

What should be my GMT setting in all my servers ? Also what should be the gmt_offset_now for each lead ? Right now we are setting it to 5.50.

Need help.
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India

Re: Lead Recycle issue

Postby urmi.l » Mon May 23, 2016 4:18 pm

Below is my hopper debug.

[root@test]# perl /usr/share/astguiclient/AST_VDhopper.pl --campaign=OTP_TEST --debugX

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: 0.00|0.00|0| GMT: 02:28
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists: 384
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('998','10666','10999','10995','10164','10526','10527','10345','10521','41000','10145','10992','10991','10988','10987','10986','10985','10144','10984','10983','10980','10978','10959','10977','10976','10971','10968','10967','10966','10962','10961','10956','10955','10948','10947','10942','10940','10933','10935','10930','10929','10425','10424','10139','10918','10417','10133','10131','10129','2200','10127','2222','2223','2224','1112','2226','2227','3334','3335','10126','10408','10111','4444','4446','200001','200002','10325','4449','11000000','501','2228','10332','10116','10142','81044','10103','10303','10119','10321','10928','81035','81036','10667','10668','10669','10670','10671','10926','10969','10525','5555','501010','1113','38000011','3900001','38000012','38000013','40106','81049','38000015','444101','10122','123456','401010','40112','10993','10125','20201','1313','10994','10147','1414','10148','10149','1314','10426','720001','81037','10156','81051','10157','10158','10159','10416','10421','10160','10161','10134','10132','10135','10927','10137','10140','10141','10163','1114','1415','10166','72755512','10167','10200','10168','10169','1416','10170','1115','10173','10174','10175','600','601','602','603','604','605','606','10176','10177','10178','1116','10179','10180','2206','10183','10184','10185','10187','10191','10192','10193','10194','1417','10195','1117','10196','10197','10204','10205','123','10427','10209','10210','10213','10215','10214','10216','20150405','10218','20150706','20150508','41001','10220','4451','10221','20150512','10224','10225','20150521','20203','2230','10230','10231','1315','1500','1600','1502','10235','10236','10238','10243','10244','10245','502','510','654321','15062015','10248','503','511','10249','10251','10253','512','10254','10255','513','700','516','517','10259','10258','10260','10264','10265','10266','10268','10269','10270','10271','10275','10280','10281','10282','10283','10284','10274','519','521','310','10295','10296','10300','5453','312','313','10304','701','702','10305','10306','10307','10308','607','608','609','610','10309','10311','999','526','527','528','529','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','10316','10320','10323','10324','621','10326','10327','565','10331','10975','567','611','566','569','570','750','751','10334','10337','10338','752','10339','124','572','10342','10343','753','755','756','758','10347','10349','996','995','994','997','12345','579','10352','993','401','10357','402','10358','10359','10120','10361','10939','403','405','406','580','581','582','404','300','54321','780','781','407','10378','10380','408','10385','10387','411','412','416','419','5003','5004','421','10391','11564','430','431','438');|
CALLBACK HOLD: 1277|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2016-05-24 02:28:44' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0
VLC Dup Check Live Calls: 0|0|0
''|

|GMT-DAY-HOUR| |13.00-2-1528||12.75-2-1513||12.50-2-1458||12.25-2-1443||12.00-2-1428||11.75-2-1413||11.50-2-1358||11.25-2-1343||11.00-2-1328||10.75-2-1313||10.50-2-1258||10.25-2-1243||10.00-2-1228||9.75-2-1213||9.50-2-1158||9.25-2-1143||9.00-2-1128||8.75-2-1113||8.50-2-1058||8.25-2-1043||8.00-2-1028||7.75-2-1013||7.50-2-958||7.25-2-943||7.00-2-928||6.75-2-913||6.50-2-858||6.25-2-843||6.00-2-828||5.75-2-813||5.50-2-758||5.25-2-743||5.00-2-728||4.75-2-713||4.50-2-658||4.25-2-643||4.00-2-628||3.75-2-613||3.50-2-558||3.25-2-543||3.00-2-528||2.75-2-513||2.50-2-458||2.25-2-443||2.00-2-428||1.75-2-413||1.50-2-358||1.25-2-343||1.00-2-328||0.75-2-313||0.50-2-258||0.25-2-243||0.00-2-228||-0.25-2-213||-0.50-2-158||-0.75-2-143||-1.00-2-128||-1.25-2-113||-1.50-2-58||-1.75-2-43||-2.00-2-28||-2.25-2-13||-2.50-1-2358||-2.75-1-2343||-3.00-1-2328||-3.25-1-2313||-3.50-1-2258||-3.75-1-2243||-4.00-1-2228||-4.25-1-2213||-4.50-1-2158||-4.75-1-2143||-5.00-1-2128||-5.25-1-2113||-5.50-1-2058||-5.75-1-2043||-6.00-1-2028||-6.25-1-2013||-6.50-1-1958||-6.75-1-1943||-7.00-1-1928||-7.25-1-1913||-7.50-1-1858||-7.75-1-1843||-8.00-1-1828||-8.25-1-1813||-8.50-1-1758||-8.75-1-1743||-9.00-1-1728||-9.25-1-1713||-9.50-1-1658||-9.75-1-1643||-10.00-1-1628||-10.25-1-1613||-10.50-1-1558||-10.75-1-1543||-11.00-1-1528||-11.25-1-1513||-11.50-1-1458||-11.75-1-1443||-12.00-1-1428||-12.25-1-1413||-12.50-1-1358||-12.75-1-1343|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
RECYCLE: |OTP_TEST|B|300|10|2016-05-23 13:38:44|
RECYCLE SQL: |( ( (called_since_last_reset IN('','Y','N','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='B') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2016-05-24 15:23:44") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2016-05-24 15:08:44") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2016-05-24 14:53:44") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2016-05-24 14:38:44") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2016-05-24 14:23:44") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2016-05-24 14:08:44") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2016-05-24 13:53:44") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2016-05-24 13:38:44") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2016-05-24 13:23:44") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2016-05-24 13:08:44") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2016-05-24 12:53:44") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2016-05-24 12:38:44") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2016-05-24 12:23:44") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2016-05-24 12:08:44") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2016-05-24 11:53:44") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2016-05-24 11:38:44") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2016-05-24 11:23:44") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2016-05-24 11:08:44") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2016-05-24 10:53:44") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2016-05-24 10:38:44") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2016-05-24 10:23:44") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2016-05-24 10:08:44") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2016-05-24 09:53:44") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2016-05-24 09:38:44") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2016-05-24 09:23:44") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2016-05-24 09:08:44") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2016-05-24 08:53:44") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2016-05-24 08:38:44") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2016-05-24 08:23:44") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2016-05-24 08:08:44") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2016-05-24 07:53:44") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2016-05-24 07:38:44") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2016-05-24 07:23:44") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2016-05-24 07:08:44") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2016-05-24 06:53:44") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2016-05-24 06:38:44") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2016-05-24 06:23:44") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2016-05-24 06:08:44") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2016-05-24 05:53:44") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2016-05-24 05:38:44") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2016-05-24 05:23:44") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2016-05-24 05:08:44") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2016-05-24 04:53:44") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2016-05-24 04:38:44") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2016-05-24 04:23:44") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2016-05-24 04:08:44") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2016-05-24 03:53:44") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2016-05-24 03:38:44") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2016-05-24 03:23:44") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2016-05-24 03:08:44") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2016-05-24 02:53:44") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2016-05-24 02:38:44") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2016-05-24 02:23:44") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2016-05-24 02:08:44") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2016-05-24 01:53:44") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2016-05-24 01:38:44") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2016-05-24 01:23:44") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2016-05-24 01:08:44") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2016-05-24 00:53:44") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2016-05-24 00:38:44") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2016-05-24 00:23:44") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2016-05-24 00:08:44") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2016-05-23 23:53:44") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2016-05-23 23:38:44") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2016-05-23 23:23:44") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2016-05-23 23:08:44") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2016-05-23 22:53:44") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2016-05-23 22:38:44") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2016-05-23 22:23:44") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2016-05-23 22:08:44") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2016-05-23 21:53:44") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2016-05-23 21:38:44") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2016-05-23 21:23:44") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2016-05-23 21:08:44") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2016-05-23 20:53:44") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2016-05-23 20:38:44") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2016-05-23 20:23:44") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2016-05-23 20:08:44") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2016-05-23 19:53:44") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2016-05-23 19:38:44") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2016-05-23 19:23:44") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2016-05-23 19:08:44") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2016-05-23 18:53:44") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2016-05-23 18:38:44") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2016-05-23 18:23:44") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2016-05-23 18:08:44") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2016-05-23 17:53:44") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2016-05-23 17:38:44") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2016-05-23 17:23:44") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2016-05-23 17:08:44") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2016-05-23 16:53:44") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2016-05-23 16:38:44") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2016-05-23 16:23:44") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2016-05-23 16:08:44") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2016-05-23 15:53:44") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2016-05-23 15:38:44") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2016-05-23 15:23:44") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2016-05-23 15:08:44") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2016-05-23 14:53:44") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2016-05-23 14:38:44") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2016-05-23 14:23:44") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2016-05-23 14:08:44") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2016-05-23 13:53:44") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2016-05-23 13:38:44") ) ) ) )|
Starting hopper run for OTP_TEST campaign- GMT: 24hours HOPPER: 1000 ORDER: DOWN LAST CALL TIME|N|LEAD_DESCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='OTP_TEST' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='OTP_TEST' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 4
|SELECT count(*) from vicidial_hopper where campaign_id='OTP_TEST' and status='READY';|
campaign lists count: 1 | '199999'
|SELECT list_id FROM vicidial_lists where campaign_id='OTP_TEST' and active='Y';|
lead filter 3ATTMPT defined for OTP_TEST
|and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now()|
|SELECT count(*) FROM vicidial_list where status IN('NEW') and list_id IN('199999') 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') ) ) and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now() ;|
leads to call count: 4
|SELECT count(*) FROM vicidial_list where status IN('NEW') and list_id IN('199999') 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') ) ) and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now() ;|
|SELECT count(*) FROM vicidial_list where ( ( (called_since_last_reset IN('','Y','N','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='B') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2016-05-24 15:23:44") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2016-05-24 15:08:44") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2016-05-24 14:53:44") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2016-05-24 14:38:44") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2016-05-24 14:23:44") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2016-05-24 14:08:44") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2016-05-24 13:53:44") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2016-05-24 13:38:44") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2016-05-24 13:23:44") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2016-05-24 13:08:44") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2016-05-24 12:53:44") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2016-05-24 12:38:44") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2016-05-24 12:23:44") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2016-05-24 12:08:44") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2016-05-24 11:53:44") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2016-05-24 11:38:44") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2016-05-24 11:23:44") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2016-05-24 11:08:44") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2016-05-24 10:53:44") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2016-05-24 10:38:44") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2016-05-24 10:23:44") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2016-05-24 10:08:44") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2016-05-24 09:53:44") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2016-05-24 09:38:44") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2016-05-24 09:23:44") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2016-05-24 09:08:44") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2016-05-24 08:53:44") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2016-05-24 08:38:44") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2016-05-24 08:23:44") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2016-05-24 08:08:44") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2016-05-24 07:53:44") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2016-05-24 07:38:44") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2016-05-24 07:23:44") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2016-05-24 07:08:44") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2016-05-24 06:53:44") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2016-05-24 06:38:44") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2016-05-24 06:23:44") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2016-05-24 06:08:44") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2016-05-24 05:53:44") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2016-05-24 05:38:44") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2016-05-24 05:23:44") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2016-05-24 05:08:44") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2016-05-24 04:53:44") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2016-05-24 04:38:44") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2016-05-24 04:23:44") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2016-05-24 04:08:44") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2016-05-24 03:53:44") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2016-05-24 03:38:44") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2016-05-24 03:23:44") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2016-05-24 03:08:44") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2016-05-24 02:53:44") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2016-05-24 02:38:44") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2016-05-24 02:23:44") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2016-05-24 02:08:44") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2016-05-24 01:53:44") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2016-05-24 01:38:44") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2016-05-24 01:23:44") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2016-05-24 01:08:44") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2016-05-24 00:53:44") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2016-05-24 00:38:44") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2016-05-24 00:23:44") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2016-05-24 00:08:44") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2016-05-23 23:53:44") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2016-05-23 23:38:44") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2016-05-23 23:23:44") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2016-05-23 23:08:44") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2016-05-23 22:53:44") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2016-05-23 22:38:44") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2016-05-23 22:23:44") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2016-05-23 22:08:44") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2016-05-23 21:53:44") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2016-05-23 21:38:44") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2016-05-23 21:23:44") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2016-05-23 21:08:44") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2016-05-23 20:53:44") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2016-05-23 20:38:44") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2016-05-23 20:23:44") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2016-05-23 20:08:44") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2016-05-23 19:53:44") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2016-05-23 19:38:44") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2016-05-23 19:23:44") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2016-05-23 19:08:44") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2016-05-23 18:53:44") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2016-05-23 18:38:44") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2016-05-23 18:23:44") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2016-05-23 18:08:44") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2016-05-23 17:53:44") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2016-05-23 17:38:44") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2016-05-23 17:23:44") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2016-05-23 17:08:44") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2016-05-23 16:53:44") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2016-05-23 16:38:44") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2016-05-23 16:23:44") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2016-05-23 16:08:44") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2016-05-23 15:53:44") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2016-05-23 15:38:44") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2016-05-23 15:23:44") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2016-05-23 15:08:44") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2016-05-23 14:53:44") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2016-05-23 14:38:44") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2016-05-23 14:23:44") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2016-05-23 14:08:44") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2016-05-23 13:53:44") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2016-05-23 13:38:44") ) ) ) ) and list_id IN('199999') 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') ) ) and entry_date>'2016-02-24 2:28:44' and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now()|
Recycle leads to call count: 4
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','N','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='B') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2016-05-24 15:23:44") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2016-05-24 15:08:44") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2016-05-24 14:53:44") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2016-05-24 14:38:44") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2016-05-24 14:23:44") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2016-05-24 14:08:44") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2016-05-24 13:53:44") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2016-05-24 13:38:44") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2016-05-24 13:23:44") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2016-05-24 13:08:44") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2016-05-24 12:53:44") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2016-05-24 12:38:44") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2016-05-24 12:23:44") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2016-05-24 12:08:44") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2016-05-24 11:53:44") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2016-05-24 11:38:44") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2016-05-24 11:23:44") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2016-05-24 11:08:44") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2016-05-24 10:53:44") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2016-05-24 10:38:44") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2016-05-24 10:23:44") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2016-05-24 10:08:44") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2016-05-24 09:53:44") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2016-05-24 09:38:44") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2016-05-24 09:23:44") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2016-05-24 09:08:44") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2016-05-24 08:53:44") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2016-05-24 08:38:44") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2016-05-24 08:23:44") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2016-05-24 08:08:44") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2016-05-24 07:53:44") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2016-05-24 07:38:44") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2016-05-24 07:23:44") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2016-05-24 07:08:44") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2016-05-24 06:53:44") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2016-05-24 06:38:44") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2016-05-24 06:23:44") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2016-05-24 06:08:44") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2016-05-24 05:53:44") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2016-05-24 05:38:44") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2016-05-24 05:23:44") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2016-05-24 05:08:44") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2016-05-24 04:53:44") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2016-05-24 04:38:44") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2016-05-24 04:23:44") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2016-05-24 04:08:44") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2016-05-24 03:53:44") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2016-05-24 03:38:44") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2016-05-24 03:23:44") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2016-05-24 03:08:44") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2016-05-24 02:53:44") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2016-05-24 02:38:44") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2016-05-24 02:23:44") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2016-05-24 02:08:44") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2016-05-24 01:53:44") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2016-05-24 01:38:44") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2016-05-24 01:23:44") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2016-05-24 01:08:44") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2016-05-24 00:53:44") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2016-05-24 00:38:44") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2016-05-24 00:23:44") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2016-05-24 00:08:44") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2016-05-23 23:53:44") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2016-05-23 23:38:44") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2016-05-23 23:23:44") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2016-05-23 23:08:44") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2016-05-23 22:53:44") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2016-05-23 22:38:44") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2016-05-23 22:23:44") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2016-05-23 22:08:44") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2016-05-23 21:53:44") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2016-05-23 21:38:44") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2016-05-23 21:23:44") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2016-05-23 21:08:44") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2016-05-23 20:53:44") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2016-05-23 20:38:44") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2016-05-23 20:23:44") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2016-05-23 20:08:44") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2016-05-23 19:53:44") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2016-05-23 19:38:44") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2016-05-23 19:23:44") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2016-05-23 19:08:44") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2016-05-23 18:53:44") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2016-05-23 18:38:44") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2016-05-23 18:23:44") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2016-05-23 18:08:44") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2016-05-23 17:53:44") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2016-05-23 17:38:44") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2016-05-23 17:23:44") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2016-05-23 17:08:44") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2016-05-23 16:53:44") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2016-05-23 16:38:44") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2016-05-23 16:23:44") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2016-05-23 16:08:44") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2016-05-23 15:53:44") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2016-05-23 15:38:44") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2016-05-23 15:23:44") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2016-05-23 15:08:44") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2016-05-23 14:53:44") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2016-05-23 14:38:44") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2016-05-23 14:23:44") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2016-05-23 14:08:44") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2016-05-23 13:53:44") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2016-05-23 13:38:44") ) ) ) ) and list_id IN('199999') and lead_id NOT IN('24314378','24314379','24314380','24314382','0') and vendor_lead_code NOT IN('--99999999987654321--') 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') ) ) and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now() order by last_local_call_time, lead_id desc limit 1000;|
lead call order: order by last_local_call_time, lead_id desc
|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='N' and status IN('NEW') and list_id IN('199999') and lead_id NOT IN('24314378','24314379','24314380','24314382','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') ) ) and called_count < 3 and entry_date BETWEEN DATE_SUB(now(), INTERVAL 2 MONTH) AND now() order by last_local_call_time, lead_id desc limit 1000;|
Adding to hopper: 1
DONE with this campaign

SUMMARY: 1 campaigns
OTP_TEST 4 1000 4
DONE. Script execution time in seconds: 0
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India

Re: Lead Recycle issue

Postby urmi.l » Wed May 25, 2016 4:20 am

Any help please.
urmi.l
 
Posts: 108
Joined: Mon Jun 04, 2012 4:04 am
Location: India


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 126 guests