New Released Feature: Call Count Limit

[dspaan]

In the SVN trunk codebase there is a new feature called Call Count Limit. But the instruction/help info about how this feature works is very short. Can someone explain how it works?

Here are some pictures of the configurations options:

Call Count Limit - This enforces a limit on the number of call attempts for the leads dialed in this campaign. A lead may go over this limit slightly if Lead Recycling or Auto-Alt-Dialing is enabled. Default is 0 for no limit.

Call Count Target - This option is only used for reporting purposes and has no effect on leads dialed. Default is 3.

The limit setting is clear. But what exactly does the target setting do?



A new flag has appeared in the campaign statuses screen; completed. What does this flag do?



New columns added to the campaign and list screens; Dialable and Penetration.

Dialable seems clear. But what is penetration? Is it related to the Completed flag or call count target?

Furthermore, is it possible to give records which have reached the limit a new status? So when you use export leads report or any of the other reports it's clear which numbers have reached the limit. Or is that what the Completed flag is for? What happens if i give multiple statuses this flag?

PS: @Matt - I took the liberty of registering vicidial.org here in your name so pictures from imageshack show up properly:
http://stream.imageshack.us/content.php ... ter_domain
I hope you don't mind, i used the sales at vici e-mail address to register.

[mflorell]

You pretty much guessed the first few, called count target and completed status flag are used in thee new penetration column.

No it is not possible to change the status after a lead is penetrated, that would require significantly more programming and more settings.

You can give multiple statuses the completed flag, it is really only used in reporting.

[dspaan]

Hi Matt,

I have currently a campaign which has a call count limit of 5 and call count target of 5.

When i look in the column PENETRATION i see percentages. Do this figures represent the percentage of leads which have reached the current status within 5 calls or less? So 14% penetration with status code 'not interested' would mean that it took 5 or less calls in 14% of the cases to get that status?

And the column DIALABLE, how come it shows numbers there for statuses that should not be dialed again (they are not dialstatuses)?

And i still don't understand what the COMPLETED flag does??

[dspaan]

Bumping my last post and also reporting a possible bug with this feature.

It seems that when you use list order DOWN 2nd NEW that there are still leads inserted into the hopper that have exceeded the call count limit. See screenshots below.

[mflorell]

Clear the hopper then run the AST_VDhopper.pl script with the --debugX flag when you see this happen, then post the output for the affected campaign.

[dspaan]

Alright i ran the hopper script and this is the output, i'm not sure i copy/pasted it right. Is there a log file this ends up in? PS: I see now leads in the hopper which have been called 33 times??

TIME DEBUG: -3.00|-3.00|0| GMT: 17:58
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists: 16
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','997','996','994','121','991','139','140','148','149','150','154','155','157','161');|
CALLBACK HOLD: 1|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2012-03-13 14:58:55' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-3-658||12.75-3-643||12.50-3-628||12.25-3-613||12.00-3-558||11.75-3-543||11.50-3-528||11.25-3-513||11.00-3-458||10.75-3-443||10.50-3-428||10.25-3-413||10.00-3-358||9.75-3-343||9.50-3-328||9.25-3-313||9.00-3-258||8.75-3-243||8.50-3-228||8.25-3-213||8.00-3-158||7.75-3-143||7.50-3-128||7.25-3-113||7.00-3-58||6.75-3-43||6.50-3-28||6.25-3-13||6.00-2-2358||5.75-2-2343||5.50-2-2328||5.25-2-2313||5.00-2-2258||4.75-2-2243||4.50-2-2228||4.25-2-2213||4.00-2-2158||3.75-2-2143||3.50-2-2128||3.25-2-2113||3.00-2-2058||2.75-2-2043||2.50-2-2028||2.25-2-2013||2.00-2-1958||1.75-2-1943||1.50-2-1928||1.25-2-1913||1.00-2-1858||0.75-2-1843||0.50-2-1828||0.25-2-1813||0.00-2-1758||-0.25-2-1743||-0.50-2-1728||-0.75-2-1713||-1.00-2-1658||-1.25-2-1643||-1.50-2-1628||-1.75-2-1613||-2.00-2-1558||-2.25-2-1543||-2.50-2-1528||-2.75-2-1513||-3.00-2-1458||-3.25-2-1443||-3.50-2-1428||-3.75-2-1413||-4.00-2-1358||-4.25-2-1343||-4.50-2-1328||-4.75-2-1313||-5.00-2-1258||-5.25-2-1243||-5.50-2-1228||-5.75-2-1213||-6.00-2-1158||-6.25-2-1143||-6.50-2-1128||-6.75-2-1113||-7.00-2-1058||-7.25-2-1043||-7.50-2-1028||-7.75-2-1013||-8.00-2-958||-8.25-2-943||-8.50-2-928||-8.75-2-913||-9.00-2-858||-9.25-2-843||-9.50-2-828||-9.75-2-813||-10.00-2-758||-10.25-2-743||-10.50-2-728||-10.75-2-713||-11.00-2-658||-11.25-2-643||-11.50-2-628||-11.75-2-613||-12.00-2-558||-12.25-2-543||-12.50-2-528||-12.75-2-513|
|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: |Hotelgrp|STOR|300|10|2012-03-13 05:08:55|
RECYCLE: |Hotelgrp|B|300|10|2012-03-13 05:08:55|
RECYCLE: |Hotelgrp|AB|300|10|2012-03-13 05:08:55|
RECYCLE: |Hotelgrp|ERI|120|10|2012-03-13 05:11:55|
RECYCLE: |Hotelgrp|BELNU|120|10|2012-03-13 05:11:55|
RECYCLE SQL: |( ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='STOR') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 06:53:55") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 06:38:55") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 06:23:55") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 06:08:55") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 05:53:55") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 05:38:55") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 05:23:55") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 05:08:55") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 04:53:55") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 04:38:55") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 04:23:55") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 04:08:55") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 03:53:55") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 03:38:55") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 03:23:55") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 03:08:55") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 02:53:55") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 02:38:55") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 02:23:55") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 02:08:55") ) or ( (gmt_offset_now ='8.00') and (last_local_call_time < "2012-03-14 01:53:55") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 01:38:55") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 01:23:55") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 01:08:55") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 00:53:55") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 00:38:55") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 00:23:55") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 00:08:55") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-13 23:53:55") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-13 23:38:55") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-13 23:23:55") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-13 23:08:55") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-13 22:53:55") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-13 22:38:55") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-13 22:23:55") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-13 22:08:55") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-13 21:53:55") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-13 21:38:55") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-13 21:23:55") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-13 21:08:55") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-13 20:53:55") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-13 20:38:55") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-13 20:23:55") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-13 20:08:55") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-13 19:53:55") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-13 19:38:55") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-13 19:23:55") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-13 19:08:55") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-13 18:53:55") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-13 18:38:55") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-13 18:23:55") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-13 18:08:55") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-13 17:53:55") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-13 17:38:55") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-13 17:23:55") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-13 17:08:55") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-13 16:53:55") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-13 16:38:55") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-13 16:23:55") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-13 16:08:55") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 15:53:55") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 15:38:55") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 15:23:55") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 15:08:55") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 14:53:55") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 14:38:55") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 14:23:55") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 14:08:55") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 13:53:55") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 13:38:55") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 13:23:55") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 13:08:55") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 12:53:55") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 12:38:55") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 12:23:55") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 12:08:55") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 11:53:55") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 11:38:55") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 11:23:55") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 11:08:55") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 10:53:55") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 10:38:55") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 10:23:55") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 10:08:55") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 09:53:55") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 09:38:55") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 09:23:55") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 09:08:55") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 08:53:55") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 08:38:55") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 08:23:55") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 08:08:55") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 07:53:55") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 07:38:55") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 07:23:55") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 07:08:55") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 06:53:55") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 06:38:55") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 06:23:55") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 06:08:55") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 05:53:55") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 05:38:55") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 05:23:55") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 05:08:55") ) ) ) or ( (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 < "2012-03-14 06:53:55") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 06:38:55") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 06:23:55") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 06:08:55") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 05:53:55") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 05:38:55") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 05:23:55") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 05:08:55") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 04:53:55") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 04:38:55") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 04:23:55") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 04:08:55") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 03:53:55") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 03:38:55") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 03:23:55") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 03:08:55") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 02:53:55") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 02:38:55") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 02:23:55") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 02:08:55") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 01:53:55") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 01:38:55") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 01:23:55") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 01:08:55") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 00:53:55") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 00:38:55") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 00:23:55") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 00:08:55") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-13 23:53:55") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-13 23:38:55") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-13 23:23:55") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-13 23:08:55") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-13 22:53:55") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-13 22:38:55") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-13 22:23:55") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-13 22:08:55") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-13 21:53:55") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-13 21:38:55") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-13 21:23:55") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-13 21:08:55") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-13 20:53:55") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-13 20:38:55") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-13 20:23:55") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-13 20:08:55") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-13 19:53:55") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-13 19:38:55") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-13 19:23:55") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-13 19:08:55") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-13 18:53:55") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-13 18:38:55") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-13 18:23:55") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-13 18:08:55") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-13 17:53:55") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-13 17:38:55") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-13 17:23:55") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-13 17:08:55") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-13 16:53:55") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-13 16:38:55") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-13 16:23:55") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-13 16:08:55") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 15:53:55") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 15:38:55") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 15:23:55") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 15:08:55") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 14:53:55") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 14:38:55") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 14:23:55") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 14:08:55") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 13:53:55") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 13:38:55") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 13:23:55") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 13:08:55") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 12:53:55") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 12:38:55") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 12:23:55") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 12:08:55") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 11:53:55") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 11:38:55") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 11:23:55") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 11:08:55") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 10:53:55") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 10:38:55") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 10:23:55") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 10:08:55") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 09:53:55") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 09:38:55") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 09:23:55") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 09:08:55") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 08:53:55") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 08:38:55") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 08:23:55") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 08:08:55") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 07:53:55") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 07:38:55") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 07:23:55") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 07:08:55") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 06:53:55") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 06:38:55") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 06:23:55") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 06:08:55") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 05:53:55") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 05:38:55") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 05:23:55") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 05:08:55") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='AB') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 06:53:55") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 06:38:55") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 06:23:55") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 06:08:55") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 05:53:55") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 05:38:55") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 05:23:55") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 05:08:55") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 04:53:55") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 04:38:55") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 04:23:55") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 04:08:55") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 03:53:55") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 03:38:55") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 03:23:55") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 03:08:55") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 02:53:55") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 02:38:55") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 02:23:55") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 02:08:55") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 01:53:55") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 01:38:55") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 01:23:55") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 01:08:55") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 00:53:55") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 00:38:55") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 00:23:55") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 00:08:55") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-13 23:53:55") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-13 23:38:55") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-13 23:23:55") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-13 23:08:55") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-13 22:53:55") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-13 22:38:55") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-13 22:23:55") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-13 22:08:55") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-13 21:53:55") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-13 21:38:55") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-13 21:23:55") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-13 21:08:55") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-13 20:53:55") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-13 20:38:55") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-13 20:23:55") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-13 20:08:55") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-13 19:53:55") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-13 19:38:55") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-13 19:23:55") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-13 19:08:55") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-13 18:53:55") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-13 18:38:55") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-13 18:23:55") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-13 18:08:55") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-13 17:53:55") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-13 17:38:55") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-13 17:23:55") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-13 17:08:55") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-13 16:53:55") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-13 16:38:55") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-13 16:23:55") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-13 16:08:55") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 15:53:55") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 15:38:55") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 15:23:55") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 15:08:55") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 14:53:55") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 14:38:55") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 14:23:55") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 14:08:55") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 13:53:55") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 13:38:55") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 13:23:55") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 13:08:55") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 12:53:55") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 12:38:55") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 12:23:55") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 12:08:55") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 11:53:55") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 11:38:55") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 11:23:55") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 11:08:55") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 10:53:55") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 10:38:55") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 10:23:55") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 10:08:55") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 09:53:55") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 09:38:55") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 09:23:55") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 09:08:55") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 08:53:55") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 08:38:55") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 08:23:55") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 08:08:55") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 07:53:55") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 07:38:55") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 07:23:55") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 07:08:55") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 06:53:55") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 06:38:55") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 06:23:55") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 06:08:55") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 05:53:55") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 05:38:55") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 05:23:55") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 05:08:55") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='ERI') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 06:56:55") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 06:41:55") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 06:26:55") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 06:11:55") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 05:56:55") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 05:41:55") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 05:26:55") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 05:11:55") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 04:56:55") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 04:41:55") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 04:26:55") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 04:11:55") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 03:56:55") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 03:41:55") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 03:26:55") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 03:11:55") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 02:56:55") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 02:41:55") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 02:26:55") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 02:11:55") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 01:56:55") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 01:41:55") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 01:26:55") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 01:11:55") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 00:56:55") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 00:41:55") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 00:26:55") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 00:11:55") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-13 23:56:55") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-13 23:41:55") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-13 23:26:55") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-13 23:11:55") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-13 22:56:55") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-13 22:41:55") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-13 22:26:55") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-13 22:11:55") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-13 21:56:55") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-13 21:41:55") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-13 21:26:55") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-13 21:11:55") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-13 20:56:55") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-13 20:41:55") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-13 20:26:55") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-13 20:11:55") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-13 19:56:55") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-13 19:41:55") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-13 19:26:55") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-13 19:11:55") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-13 18:56:55") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-13 18:41:55") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-13 18:26:55") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-13 18:11:55") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-13 17:56:55") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-13 17:41:55") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-13 17:26:55") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-13 17:11:55") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-13 16:56:55") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-13 16:41:55") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-13 16:26:55") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-13 16:11:55") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 15:56:55") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 15:41:55") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 15:26:55") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 15:11:55") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 14:56:55") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 14:41:55") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 14:26:55") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 14:11:55") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 13:56:55") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 13:41:55") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 13:26:55") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 13:11:55") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 12:56:55") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 12:41:55") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 12:26:55") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 12:11:55") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 11:56:55") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 11:41:55") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 11:26:55") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 11:11:55") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 10:56:55") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 10:41:55") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 10:26:55") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 10:11:55") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 09:56:55") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 09:41:55") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 09:26:55") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 09:11:55") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 08:56:55") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 08:41:55") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 08:26:55") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 08:11:55") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 07:56:55") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 07:41:55") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 07:26:55") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 07:11:55") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 06:56:55") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 06:41:55") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 06:26:55") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 06:11:55") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 05:56:55") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 05:41:55") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 05:26:55") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 05:11:55") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='BELNU') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 06:56:55") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 06:41:55") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 06:26:55") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 06:11:55") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 05:56:55") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 05:41:55") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 05:26:55") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 05:11:55") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 04:56:55") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 04:41:55") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 04:26:55") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 04:11:55") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 03:56:55") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 03:41:55") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 03:26:55") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 03:11:55") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 02:56:55") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 02:41:55") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 02:26:55") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 02:11:55") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 01:56:55") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 01:41:55") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 01:26:55") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 01:11:55") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 00:56:55") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 00:41:55") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 00:26:55") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 00:11:55") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-13 23:56:55") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-13 23:41:55") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-13 23:26:55") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-13 23:11:55") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-13 22:56:55") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-13 22:41:55") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-13 22:26:55") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-13 22:11:55") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-13 21:56:55") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-13 21:41:55") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-13 21:26:55") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-13 21:11:55") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-13 20:56:55") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-13 20:41:55") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-13 20:26:55") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-13 20:11:55") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-13 19:56:55") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-13 19:41:55") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-13 19:26:55") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-13 19:11:55") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-13 18:56:55") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-13 18:41:55") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-13 18:26:55") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-13 18:11:55") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-13 17:56:55") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-13 17:41:55") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-13 17:26:55") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-13 17:11:55") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-13 16:56:55") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-13 16:41:55") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-13 16:26:55") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-13 16:11:55") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 15:56:55") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 15:41:55") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 15:26:55") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 15:11:55") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 14:56:55") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 14:41:55") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 14:26:55") ) or ( (gmt_offset_now='-3.75') and (last_local_call_

Seems the forum code tag can only handle a certain length and then cuts off. Here is the rest i still had in my screen:

looking for 50 NEW leads mixed in with 50 other leads
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('156','167') 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;|
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and status IN('NEW','CALLBK','NA','DROP','PDROP','N','AA','A') and list_id IN('156','167') 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: 100
Doing CAMP DNC Check: 636574214 - Y
LEAD INSERTED: 1|449562|
Doing CAMP DNC Check: 622962938 - Y
LEAD INSERTED: 1|419511|
Doing CAMP DNC Check: 521371391 - Y
LEAD INSERTED: 1|449563|
Doing CAMP DNC Check: 641314569 - Y
LEAD INSERTED: 1|419512|
Doing CAMP DNC Check: 624996998 - Y
LEAD INSERTED: 1|449564|
Doing CAMP DNC Check: 2012345678 - Y
LEAD INSERTED: 1|419513|
Doing CAMP DNC Check: 434501816 - Y
LEAD INSERTED: 1|449565|
Doing CAMP DNC Check: 627525319 - Y
LEAD INSERTED: 1|419516|
Doing CAMP DNC Check: 778513425 - Y
LEAD INSERTED: 1|449566|
Doing CAMP DNC Check: 674564477 - Y
LEAD INSERTED: 1|419521|
Doing CAMP DNC Check: 742555678 - Y
LEAD INSERTED: 1|449567|
Doing CAMP DNC Check: 630336369 - Y
LEAD INSERTED: 1|419576|
Doing CAMP DNC Check: 627185977 - Y
LEAD INSERTED: 1|449568|
Doing CAMP DNC Check: 623586129 - Y
LEAD INSERTED: 1|419669|
Doing CAMP DNC Check: 655187886 - Y
LEAD INSERTED: 1|449569|
Doing CAMP DNC Check: 648048723 - Y
LEAD INSERTED: 1|419703|
Doing CAMP DNC Check: 644173665 - Y
LEAD INSERTED: 1|449570|
Doing CAMP DNC Check: 31658935277 - Y
LEAD INSERTED: 1|419711|
Doing CAMP DNC Check: 650814410 - Y
LEAD INSERTED: 1|449571|
Doing CAMP DNC Check: 615975328 - Y
LEAD INSERTED: 1|419713|
Doing CAMP DNC Check: 464852892 - Y
LEAD INSERTED: 1|449572|
Doing CAMP DNC Check: 626236456 - Y
LEAD INSERTED: 1|419728|
Doing CAMP DNC Check: 658988158 - Y
LEAD INSERTED: 1|449573|
Doing CAMP DNC Check: 31316787996 - Y
LEAD INSERTED: 1|419737|
Doing CAMP DNC Check: 571291674 - Y
LEAD INSERTED: 1|449574|
Doing CAMP DNC Check: 433255209 - Y
LEAD INSERTED: 1|419760|
Doing CAMP DNC Check: 650894476 - Y
LEAD INSERTED: 1|449575|
Doing CAMP DNC Check: 648033075 - Y
LEAD INSERTED: 1|419767|
Doing CAMP DNC Check: 570517360 - Y
LEAD INSERTED: 1|449576|
Doing CAMP DNC Check: 625037534 - Y
LEAD INSERTED: 1|419772|
Doing CAMP DNC Check: 632051234 - Y
LEAD INSERTED: 1|449577|
Doing CAMP DNC Check: 4976642665 - Y
LEAD INSERTED: 1|419773|
Doing CAMP DNC Check: 651851858 - Y
LEAD INSERTED: 1|449578|
Doing CAMP DNC Check: 2631680101 - Y
LEAD INSERTED: 1|419780|
Doing CAMP DNC Check: 648965024 - Y
LEAD INSERTED: 1|449579|
Doing CAMP DNC Check: 207384659 - Y
LEAD INSERTED: 1|419784|
Doing CAMP DNC Check: 614598683 - Y
LEAD INSERTED: 1|449580|
Doing CAMP DNC Check: 356115617 - Y
LEAD INSERTED: 1|419786|
Doing CAMP DNC Check: 647123044 - Y
LEAD INSERTED: 1|449581|
Doing CAMP DNC Check: 616574043 - Y
LEAD INSERTED: 1|419792|
Doing CAMP DNC Check: 631947011 - Y
LEAD INSERTED: 1|449582|
Doing CAMP DNC Check: 793425585 - Y
LEAD INSERTED: 1|419794|
Doing CAMP DNC Check: 235333595 - Y
LEAD INSERTED: 1|449583|
Doing CAMP DNC Check: 641239745 - Y
LEAD INSERTED: 1|419801|
Doing CAMP DNC Check: 628825333 - Y
LEAD INSERTED: 1|449584|
Doing CAMP DNC Check: 613274106 - Y
LEAD INSERTED: 1|419807|
Doing CAMP DNC Check: 622936200 - Y
LEAD INSERTED: 1|449585|
Doing CAMP DNC Check: 635160028 - Y
LEAD INSERTED: 1|419814|
Doing CAMP DNC Check: 626993362 - Y
LEAD INSERTED: 1|449586|
Doing CAMP DNC Check: 657814253 - Y
LEAD INSERTED: 1|419820|
Doing CAMP DNC Check: 627588655 - Y
LEAD INSERTED: 1|449587|
Doing CAMP DNC Check: 650847903 - Y
LEAD INSERTED: 1|419831|
Doing CAMP DNC Check: 627283900 - Y
LEAD INSERTED: 1|449588|
Doing CAMP DNC Check: 405371755 - Y
LEAD INSERTED: 1|419844|
Doing CAMP DNC Check: 777504514 - Y
LEAD INSERTED: 1|449589|
Doing CAMP DNC Check: 623526585 - Y
LEAD INSERTED: 1|419863|
Doing CAMP DNC Check: 102160251 - Y
LEAD INSERTED: 1|449590|
Doing CAMP DNC Check: 359680085 - Y
LEAD INSERTED: 1|419868|
Doing CAMP DNC Check: 575471946 - Y
LEAD INSERTED: 1|449591|
Doing CAMP DNC Check: 647845654 - Y
LEAD INSERTED: 1|419869|
Doing CAMP DNC Check: 630439677 - Y
LEAD INSERTED: 1|449592|
Doing CAMP DNC Check: 405123456 - Y
LEAD INSERTED: 1|420833|
Doing CAMP DNC Check: 683722123 - Y
LEAD INSERTED: 1|449593|
Doing CAMP DNC Check: 624549673 - Y
LEAD INSERTED: 1|420836|
Doing CAMP DNC Check: 223759067 - Y
LEAD INSERTED: 1|449594|
Doing CAMP DNC Check: 654554900 - Y
LEAD INSERTED: 1|420841|
Doing CAMP DNC Check: 623272747 - Y
LEAD INSERTED: 1|449595|
Doing CAMP DNC Check: 787007741 - Y
LEAD INSERTED: 1|420847|
Doing CAMP DNC Check: 612834545 - Y
LEAD INSERTED: 1|449596|
Doing CAMP DNC Check: 172411089 - Y
LEAD INSERTED: 1|420859|
Doing CAMP DNC Check: 612345098 - Y
LEAD INSERTED: 1|449597|
Doing CAMP DNC Check: 627218943 - Y
LEAD INSERTED: 1|420860|
Doing CAMP DNC Check: 703863738 - Y
LEAD INSERTED: 1|449598|
Doing CAMP DNC Check: 654770580 - Y
LEAD INSERTED: 1|420864|
Doing CAMP DNC Check: 651871552 - Y
LEAD INSERTED: 1|449599|
Doing CAMP DNC Check: 646159887 - Y
LEAD INSERTED: 1|420904|
Doing CAMP DNC Check: 646255908 - Y
LEAD INSERTED: 1|449600|
Doing CAMP DNC Check: 131562761 - Y
LEAD INSERTED: 1|420908|
Doing CAMP DNC Check: 718904326 - Y
LEAD INSERTED: 1|449601|
Doing CAMP DNC Check: 611167118 - Y
LEAD INSERTED: 1|420910|
Doing CAMP DNC Check: 613850819 - Y
LEAD INSERTED: 1|449602|
Doing CAMP DNC Check: 621210999 - Y
LEAD INSERTED: 1|420912|
Doing CAMP DNC Check: 631531489 - Y
LEAD INSERTED: 1|449603|
Doing CAMP DNC Check: 657987423 - Y
LEAD INSERTED: 1|420917|
Doing CAMP DNC Check: 493479713 - Y
LEAD INSERTED: 1|449604|
Doing CAMP DNC Check: 622623849 - Y
LEAD INSERTED: 1|420920|
Doing CAMP DNC Check: 708897844 - Y
LEAD INSERTED: 1|449605|
Doing CAMP DNC Check: 106376304 - Y
LEAD INSERTED: 1|420923|
Doing CAMP DNC Check: 650895964 - Y
LEAD INSERTED: 1|449606|
Doing CAMP DNC Check: 623811704 - Y
LEAD INSERTED: 1|420930|
Doing CAMP DNC Check: 634174278 - Y
LEAD INSERTED: 1|449607|
Doing CAMP DNC Check: 686148808 - Y
LEAD INSERTED: 1|420943|
Doing CAMP DNC Check: 627080008 - Y
LEAD INSERTED: 1|449608|
Doing CAMP DNC Check: 622019073 - Y
LEAD INSERTED: 1|420947|
Doing CAMP DNC Check: 229212223 - Y
LEAD INSERTED: 1|449609|
Doing CAMP DNC Check: 685525175 - Y
LEAD INSERTED: 1|420948|
Doing CAMP DNC Check: 646114338 - Y
LEAD INSERTED: 1|449610|
Doing CAMP DNC Check: 657751213 - Y
LEAD INSERTED: 1|420962|
Doing CAMP DNC Check: 634616751 - Y
LEAD INSERTED: 1|449611|
Doing CAMP DNC Check: 4925773693 - Y
LEAD INSERTED: 1|420963|
DONE with this campaign

SUMMARY: 1 campaigns
Hotelgrp 3301 100 0
DONE. Script execution time in seconds: 9

[mflorell]

Go into your AST_VDhopper.pl script and paste the last line in the CHANGELOG section at the top.

[dspaan]

# 120109-1510 - Fixed list mix bug

Oh and i forgot to provide SVN info (the info in my signature concerns the other servers):

Path: .
URL: svn://svn.eflo.net:3690/agc_2-X/trunk
Repository Root: svn://svn.eflo.net:3690
Repository UUID: 3d104415-ff17-0410-8863-d5cf3c621b8a
Revision: 1772
Node Kind: directory
Schedule: normal
Last Changed Author: mattf
Last Changed Rev: 1772
Last Changed Date: 2012-01-09 17:26:38 -0300 (Mon, 09 Jan 2012)

[mflorell]

For some reason it isn't outputting this line, meaning that it doesn't see the call count limit set above 0 for that campaign:

call count limit $call_count_limit[$i] defined for $campaign_id[$i]

Not sure why that is happening, since I cannot duplicate this issue on my development server.

[dspaan]

I think i missed it while copy/pasting because when i just ran the script it definitely is there:

call count limit 5 defined for Hotelgrp
|and (called_count < 5)|

I just checked on another server and i also see that line in the output of running the hopper script:

call count limit 10 defined for HTLGRP
|and (called_count < 10)|

But still when i look in the hopper screen via the campaign modify page i see leads in the hopper with 12 and 14 call counts.

So this problem occurs on two servers. This other server has svn info:

Path: /usr/src/astguiclient/trunk
URL: svn://svn.eflo.net:3690/agc_2-X/trunk
Repository Root: svn://svn.eflo.net:3690
Repository UUID: 3d104415-ff17-0410-8863-d5cf3c621b8a
Revision: 1792
Node Kind: directory
Schedule: normal
Last Changed Author: mattf
Last Changed Rev: 1792
Last Changed Date: 2012-02-28 02:22:10 +0100 (Tue, 28 Feb 2012)

And last line in the hopper changelog is:

# 120109-1510 - Fixed list mix bug
# 120210-1735 - Added vendor_lead_code duplication check per campaign option

Is there a way to capture the full output of the --debugX flag command in a file?

[mflorell]

just send the output to a file: " > /file/path/here.txt"

I didn't see the called_count as a part of the SQL that you had posted, and I can't duplicate it on our development server.

[dspaan]

Here is the entire output of the script:


[quote]----- DEBUG -----


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

TIME DEBUG: 1.00|1.00|0| GMT: 02:01
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists: 13
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','802','805','901','902','997','903','904','905','906','907','908');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2012-03-14 03:01:47' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For HG900---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 5
Auto Hopper Level Adjustment = 0
Final Hopper Level = 5

---------------Auto Trim Hopper Enabled For HG900---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 5

---------------Auto Hopper Level Enabled For test05---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 5
Auto Hopper Level Adjustment = 0
Final Hopper Level = 5

---------------Auto Trim Hopper Enabled For test05---------------------
Leads in Hopper for this Campaign = 5
Hopper Level for this Campaign = 5

---------------Auto Trim Hopper Enabled For HTLGRP---------------------
Leads in Hopper for this Campaign = 113
Hopper Level for this Campaign = 100

---------------Auto Hopper Level Enabled For HTLGRP-T---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1.0
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 100
Auto Hopper Level Adjustment = 0
Final Hopper Level = 100

---------------Auto Trim Hopper Enabled For HTLGRP-T---------------------
Leads in Hopper for this Campaign = 198
Hopper Level for this Campaign = 100

CAMPAIGNS TO PROCESSES HOPPER FOR: 4|3

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
Starting hopper run for HG900 campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HG900' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HG900' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='HG900' and status='READY';|
campaign lists count: 0 | '999876543210'
|SELECT list_id FROM vicidial_lists where campaign_id='HG900' and active='Y';|
no lead filter defined for campaign: HG900
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|5) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
Starting hopper run for test05 campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='test05' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='test05' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 5
|SELECT count(*) from vicidial_hopper where campaign_id='test05' and status='READY';|
campaign lists count: 1 | '801'
|SELECT list_id FROM vicidial_lists where campaign_id='test05' and active='Y';|
no lead filter defined for campaign: test05
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('B','NEW') and list_id IN('801') 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') ) ) ;|
leads to call count: 972
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('B','NEW') and list_id IN('801') 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') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
RECYCLE: |HTLGRP|B|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP|STOR|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP|ERI|300|10|2012-03-13 13:11:47|
RECYCLE SQL: |( ( (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 < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='STOR') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='ERI') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) )|
Starting hopper run for HTLGRP campaign- GMT: 24hours HOPPER: 100 ORDER: DOWN 2nd NEW|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 116
|SELECT count(*) from vicidial_hopper where campaign_id='HTLGRP' and status='READY';|
campaign lists count: 1 | '909'
|SELECT list_id FROM vicidial_lists where campaign_id='HTLGRP' and active='Y';|
no lead filter defined for campaign: HTLGRP
|NONE|
call count limit 10 defined for HTLGRP
|and (called_count < 10)|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
leads to call count: 7283
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
NEW leads to call count: 316
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('909') 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') ) ) ;|

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
RECYCLE: |HTLGRP-T|B|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP-T|STOR|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP-T|ERI|300|10|2012-03-13 13:11:47|
RECYCLE SQL: |( ( (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 < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='STOR') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset

[quote:

[dspaan]

Here is the entire output of the script:

----- DEBUG -----


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

TIME DEBUG: 1.00|1.00|0| GMT: 02:01
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists: 13
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','802','805','901','902','997','903','904','905','906','907','908');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2012-03-14 03:01:47' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For HG900---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 5
Auto Hopper Level Adjustment = 0
Final Hopper Level = 5

---------------Auto Trim Hopper Enabled For HG900---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 5

---------------Auto Hopper Level Enabled For test05---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 5
Auto Hopper Level Adjustment = 0
Final Hopper Level = 5

---------------Auto Trim Hopper Enabled For test05---------------------
Leads in Hopper for this Campaign = 5
Hopper Level for this Campaign = 5

---------------Auto Trim Hopper Enabled For HTLGRP---------------------
Leads in Hopper for this Campaign = 113
Hopper Level for this Campaign = 100

---------------Auto Hopper Level Enabled For HTLGRP-T---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1.0
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 100
Auto Hopper Level Adjustment = 0
Final Hopper Level = 100

---------------Auto Trim Hopper Enabled For HTLGRP-T---------------------
Leads in Hopper for this Campaign = 198
Hopper Level for this Campaign = 100

CAMPAIGNS TO PROCESSES HOPPER FOR: 4|3

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
Starting hopper run for HG900 campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HG900' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HG900' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='HG900' and status='READY';|
campaign lists count: 0 | '999876543210'
|SELECT list_id FROM vicidial_lists where campaign_id='HG900' and active='Y';|
no lead filter defined for campaign: HG900
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|5) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
Starting hopper run for test05 campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='test05' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='test05' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 5
|SELECT count(*) from vicidial_hopper where campaign_id='test05' and status='READY';|
campaign lists count: 1 | '801'
|SELECT list_id FROM vicidial_lists where campaign_id='test05' and active='Y';|
no lead filter defined for campaign: test05
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('B','NEW') and list_id IN('801') 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') ) ) ;|
leads to call count: 972
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('B','NEW') and list_id IN('801') 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') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
RECYCLE: |HTLGRP|B|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP|STOR|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP|ERI|300|10|2012-03-13 13:11:47|
RECYCLE SQL: |( ( (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 < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='STOR') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9')) and (status='ERI') and (( (gmt_offset_now='13.00') and (last_local_call_time < "2012-03-14 14:56:47") ) or ( (gmt_offset_now='12.75') and (last_local_call_time < "2012-03-14 14:41:47") ) or ( (gmt_offset_now='12.50') and (last_local_call_time < "2012-03-14 14:26:47") ) or ( (gmt_offset_now='12.25') and (last_local_call_time < "2012-03-14 14:11:47") ) or ( (gmt_offset_now='12.00') and (last_local_call_time < "2012-03-14 13:56:47") ) or ( (gmt_offset_now='11.75') and (last_local_call_time < "2012-03-14 13:41:47") ) or ( (gmt_offset_now='11.50') and (last_local_call_time < "2012-03-14 13:26:47") ) or ( (gmt_offset_now='11.25') and (last_local_call_time < "2012-03-14 13:11:47") ) or ( (gmt_offset_now='11.00') and (last_local_call_time < "2012-03-14 12:56:47") ) or ( (gmt_offset_now='10.75') and (last_local_call_time < "2012-03-14 12:41:47") ) or ( (gmt_offset_now='10.50') and (last_local_call_time < "2012-03-14 12:26:47") ) or ( (gmt_offset_now='10.25') and (last_local_call_time < "2012-03-14 12:11:47") ) or ( (gmt_offset_now='10.00') and (last_local_call_time < "2012-03-14 11:56:47") ) or ( (gmt_offset_now='9.75') and (last_local_call_time < "2012-03-14 11:41:47") ) or ( (gmt_offset_now='9.50') and (last_local_call_time < "2012-03-14 11:26:47") ) or ( (gmt_offset_now='9.25') and (last_local_call_time < "2012-03-14 11:11:47") ) or ( (gmt_offset_now='9.00') and (last_local_call_time < "2012-03-14 10:56:47") ) or ( (gmt_offset_now='8.75') and (last_local_call_time < "2012-03-14 10:41:47") ) or ( (gmt_offset_now='8.50') and (last_local_call_time < "2012-03-14 10:26:47") ) or ( (gmt_offset_now='8.25') and (last_local_call_time < "2012-03-14 10:11:47") ) or ( (gmt_offset_now='8.00') and (last_local_call_time < "2012-03-14 09:56:47") ) or ( (gmt_offset_now='7.75') and (last_local_call_time < "2012-03-14 09:41:47") ) or ( (gmt_offset_now='7.50') and (last_local_call_time < "2012-03-14 09:26:47") ) or ( (gmt_offset_now='7.25') and (last_local_call_time < "2012-03-14 09:11:47") ) or ( (gmt_offset_now='7.00') and (last_local_call_time < "2012-03-14 08:56:47") ) or ( (gmt_offset_now='6.75') and (last_local_call_time < "2012-03-14 08:41:47") ) or ( (gmt_offset_now='6.50') and (last_local_call_time < "2012-03-14 08:26:47") ) or ( (gmt_offset_now='6.25') and (last_local_call_time < "2012-03-14 08:11:47") ) or ( (gmt_offset_now='6.00') and (last_local_call_time < "2012-03-14 07:56:47") ) or ( (gmt_offset_now='5.75') and (last_local_call_time < "2012-03-14 07:41:47") ) or ( (gmt_offset_now='5.50') and (last_local_call_time < "2012-03-14 07:26:47") ) or ( (gmt_offset_now='5.25') and (last_local_call_time < "2012-03-14 07:11:47") ) or ( (gmt_offset_now='5.00') and (last_local_call_time < "2012-03-14 06:56:47") ) or ( (gmt_offset_now='4.75') and (last_local_call_time < "2012-03-14 06:41:47") ) or ( (gmt_offset_now='4.50') and (last_local_call_time < "2012-03-14 06:26:47") ) or ( (gmt_offset_now='4.25') and (last_local_call_time < "2012-03-14 06:11:47") ) or ( (gmt_offset_now='4.00') and (last_local_call_time < "2012-03-14 05:56:47") ) or ( (gmt_offset_now='3.75') and (last_local_call_time < "2012-03-14 05:41:47") ) or ( (gmt_offset_now='3.50') and (last_local_call_time < "2012-03-14 05:26:47") ) or ( (gmt_offset_now='3.25') and (last_local_call_time < "2012-03-14 05:11:47") ) or ( (gmt_offset_now='3.00') and (last_local_call_time < "2012-03-14 04:56:47") ) or ( (gmt_offset_now='2.75') and (last_local_call_time < "2012-03-14 04:41:47") ) or ( (gmt_offset_now='2.50') and (last_local_call_time < "2012-03-14 04:26:47") ) or ( (gmt_offset_now='2.25') and (last_local_call_time < "2012-03-14 04:11:47") ) or ( (gmt_offset_now='2.00') and (last_local_call_time < "2012-03-14 03:56:47") ) or ( (gmt_offset_now='1.75') and (last_local_call_time < "2012-03-14 03:41:47") ) or ( (gmt_offset_now='1.50') and (last_local_call_time < "2012-03-14 03:26:47") ) or ( (gmt_offset_now='1.25') and (last_local_call_time < "2012-03-14 03:11:47") ) or ( (gmt_offset_now='1.00') and (last_local_call_time < "2012-03-14 02:56:47") ) or ( (gmt_offset_now='0.75') and (last_local_call_time < "2012-03-14 02:41:47") ) or ( (gmt_offset_now='0.50') and (last_local_call_time < "2012-03-14 02:26:47") ) or ( (gmt_offset_now='0.25') and (last_local_call_time < "2012-03-14 02:11:47") ) or ( (gmt_offset_now='0.00') and (last_local_call_time < "2012-03-14 01:56:47") ) or ( (gmt_offset_now='-0.25') and (last_local_call_time < "2012-03-14 01:41:47") ) or ( (gmt_offset_now='-0.50') and (last_local_call_time < "2012-03-14 01:26:47") ) or ( (gmt_offset_now='-0.75') and (last_local_call_time < "2012-03-14 01:11:47") ) or ( (gmt_offset_now='-1.00') and (last_local_call_time < "2012-03-14 00:56:47") ) or ( (gmt_offset_now='-1.25') and (last_local_call_time < "2012-03-14 00:41:47") ) or ( (gmt_offset_now='-1.50') and (last_local_call_time < "2012-03-14 00:26:47") ) or ( (gmt_offset_now='-1.75') and (last_local_call_time < "2012-03-14 00:11:47") ) or ( (gmt_offset_now='-2.00') and (last_local_call_time < "2012-03-13 23:56:47") ) or ( (gmt_offset_now='-2.25') and (last_local_call_time < "2012-03-13 23:41:47") ) or ( (gmt_offset_now='-2.50') and (last_local_call_time < "2012-03-13 23:26:47") ) or ( (gmt_offset_now='-2.75') and (last_local_call_time < "2012-03-13 23:11:47") ) or ( (gmt_offset_now='-3.00') and (last_local_call_time < "2012-03-13 22:56:47") ) or ( (gmt_offset_now='-3.25') and (last_local_call_time < "2012-03-13 22:41:47") ) or ( (gmt_offset_now='-3.50') and (last_local_call_time < "2012-03-13 22:26:47") ) or ( (gmt_offset_now='-3.75') and (last_local_call_time < "2012-03-13 22:11:47") ) or ( (gmt_offset_now='-4.00') and (last_local_call_time < "2012-03-13 21:56:47") ) or ( (gmt_offset_now='-4.25') and (last_local_call_time < "2012-03-13 21:41:47") ) or ( (gmt_offset_now='-4.50') and (last_local_call_time < "2012-03-13 21:26:47") ) or ( (gmt_offset_now='-4.75') and (last_local_call_time < "2012-03-13 21:11:47") ) or ( (gmt_offset_now='-5.00') and (last_local_call_time < "2012-03-13 20:56:47") ) or ( (gmt_offset_now='-5.25') and (last_local_call_time < "2012-03-13 20:41:47") ) or ( (gmt_offset_now='-5.50') and (last_local_call_time < "2012-03-13 20:26:47") ) or ( (gmt_offset_now='-5.75') and (last_local_call_time < "2012-03-13 20:11:47") ) or ( (gmt_offset_now='-6.00') and (last_local_call_time < "2012-03-13 19:56:47") ) or ( (gmt_offset_now='-6.25') and (last_local_call_time < "2012-03-13 19:41:47") ) or ( (gmt_offset_now='-6.50') and (last_local_call_time < "2012-03-13 19:26:47") ) or ( (gmt_offset_now='-6.75') and (last_local_call_time < "2012-03-13 19:11:47") ) or ( (gmt_offset_now='-7.00') and (last_local_call_time < "2012-03-13 18:56:47") ) or ( (gmt_offset_now='-7.25') and (last_local_call_time < "2012-03-13 18:41:47") ) or ( (gmt_offset_now='-7.50') and (last_local_call_time < "2012-03-13 18:26:47") ) or ( (gmt_offset_now='-7.75') and (last_local_call_time < "2012-03-13 18:11:47") ) or ( (gmt_offset_now='-8.00') and (last_local_call_time < "2012-03-13 17:56:47") ) or ( (gmt_offset_now='-8.25') and (last_local_call_time < "2012-03-13 17:41:47") ) or ( (gmt_offset_now='-8.50') and (last_local_call_time < "2012-03-13 17:26:47") ) or ( (gmt_offset_now='-8.75') and (last_local_call_time < "2012-03-13 17:11:47") ) or ( (gmt_offset_now='-9.00') and (last_local_call_time < "2012-03-13 16:56:47") ) or ( (gmt_offset_now='-9.25') and (last_local_call_time < "2012-03-13 16:41:47") ) or ( (gmt_offset_now='-9.50') and (last_local_call_time < "2012-03-13 16:26:47") ) or ( (gmt_offset_now='-9.75') and (last_local_call_time < "2012-03-13 16:11:47") ) or ( (gmt_offset_now='-10.00') and (last_local_call_time < "2012-03-13 15:56:47") ) or ( (gmt_offset_now='-10.25') and (last_local_call_time < "2012-03-13 15:41:47") ) or ( (gmt_offset_now='-10.50') and (last_local_call_time < "2012-03-13 15:26:47") ) or ( (gmt_offset_now='-10.75') and (last_local_call_time < "2012-03-13 15:11:47") ) or ( (gmt_offset_now='-11.00') and (last_local_call_time < "2012-03-13 14:56:47") ) or ( (gmt_offset_now='-11.25') and (last_local_call_time < "2012-03-13 14:41:47") ) or ( (gmt_offset_now='-11.50') and (last_local_call_time < "2012-03-13 14:26:47") ) or ( (gmt_offset_now='-11.75') and (last_local_call_time < "2012-03-13 14:11:47") ) or ( (gmt_offset_now='-12.00') and (last_local_call_time < "2012-03-13 13:56:47") ) or ( (gmt_offset_now='-12.25') and (last_local_call_time < "2012-03-13 13:41:47") ) or ( (gmt_offset_now='-12.50') and (last_local_call_time < "2012-03-13 13:26:47") ) or ( (gmt_offset_now='-12.75') and (last_local_call_time < "2012-03-13 13:11:47") ) ) ) )|
Starting hopper run for HTLGRP campaign- GMT: 24hours HOPPER: 100 ORDER: DOWN 2nd NEW|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 116
|SELECT count(*) from vicidial_hopper where campaign_id='HTLGRP' and status='READY';|
campaign lists count: 1 | '909'
|SELECT list_id FROM vicidial_lists where campaign_id='HTLGRP' and active='Y';|
no lead filter defined for campaign: HTLGRP
|NONE|
call count limit 10 defined for HTLGRP
|and (called_count < 10)|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
leads to call count: 7283
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
NEW leads to call count: 316
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('909') 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') ) ) ;|

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-2246||-3.50-2-2231||-3.75-2-2216||-4.00-2-2201||-4.25-2-2146||-4.50-2-2131||-4.75-2-2116||-5.00-2-2101||-5.25-2-2046||-5.50-2-2031||-5.75-2-2016||-6.00-2-2001||-6.25-2-1946||-6.50-2-1931||-6.75-2-1916||-7.00-2-1901||-7.25-2-1846||-7.50-2-1831||-7.75-2-1816||-8.00-2-1801||-8.25-2-1746||-8.50-2-1731||-8.75-2-1716||-9.00-2-1701||-9.25-2-1646||-9.50-2-1631||-9.75-2-1616||-10.00-2-1601||-10.25-2-1546||-10.50-2-1531||-10.75-2-1516||-11.00-2-1501||-11.25-2-1446||-11.50-2-1431||-11.75-2-1416||-12.00-2-1401||-12.25-2-1346||-12.50-2-1331||-12.75-2-1316|
|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)|3|2|
RECYCLE: |HTLGRP-T|B|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP-T|STOR|300|10|2012-03-13 13:11:47|
RECYCLE: |HTLGRP-T|ERI|300|10|2012-03-13 13:11:47|
RECYCLE SQL: |( ( (called_since_last_reset

etc

Starting hopper run for HTLGRP campaign- GMT: 24hours HOPPER: 100 ORDER: DOWN 2nd NEW|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 116
|SELECT count(*) from vicidial_hopper where campaign_id='HTLGRP' and status='READY';|
campaign lists count: 1 | '909'
|SELECT list_id FROM vicidial_lists where campaign_id='HTLGRP' and active='Y';|
no lead filter defined for campaign: HTLGRP
|NONE|
call count limit 10 defined for HTLGRP
|and (called_count < 10)|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
leads to call count: 7283
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('909') 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 < 10);|
NEW leads to call count: 316
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('909') 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') ) ) ;|

|GMT-DAY-HOUR| |13.00-3-1501||12.75-3-1446||12.50-3-1431||12.25-3-1416||12.00-3-1401||11.75-3-1346||11.50-3-1331||11.25-3-1316||11.00-3-1301||10.75-3-1246||10.50-3-1231||10.25-3-1216||10.00-3-1201||9.75-3-1146||9.50-3-1131||9.25-3-1116||9.00-3-1101||8.75-3-1046||8.50-3-1031||8.25-3-1016||8.00-3-1001||7.75-3-946||7.50-3-931||7.25-3-916||7.00-3-901||6.75-3-846||6.50-3-831||6.25-3-816||6.00-3-801||5.75-3-746||5.50-3-731||5.25-3-716||5.00-3-701||4.75-3-646||4.50-3-631||4.25-3-616||4.00-3-601||3.75-3-546||3.50-3-531||3.25-3-516||3.00-3-501||2.75-3-446||2.50-3-431||2.25-3-416||2.00-3-401||1.75-3-346||1.50-3-331||1.25-3-316||1.00-3-301||0.75-3-246||0.50-3-231||0.25-3-216||0.00-3-201||-0.25-3-146||-0.50-3-131||-0.75-3-116||-1.00-3-101||-1.25-3-46||-1.50-3-31||-1.75-3-16||-2.00-3-1||-2.25-2-2346||-2.50-2-2331||-2.75-2-2316||-3.00-2-2301||-3.25-2-224

Starting hopper run for HTLGRP-T campaign- GMT: 24hours HOPPER: 100 ORDER: DOWN COUNT|N|LEAD_ASCEND
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP-T' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HTLGRP-T' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 198
|SELECT count(*) from vicidial_hopper where campaign_id='HTLGRP-T' and status='READY';|
campaign lists count: 1 | '803'
|SELECT list_id FROM vicidial_lists where campaign_id='HTLGRP-T' and active='Y';|
no lead filter defined for campaign: HTLGRP-T
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('803') 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') ) ) ;|
leads to call count: 1001
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','N','ERI','PDROP','DROP','NA','CALLBK','NEW') and list_id IN('803') 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') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER

SUMMARY: 4 campaigns
HG900 0 5 0
test05 972 5 5
HTLGRP 7283 100 116
HTLGRP-T 1001 100 198
DONE. Script execution time in seconds: 0

[dspaan]

Matt, any idea's on above problem?

I think i found another bug with call cound limit. It seems it ignores the statuses that have been defined in the Lead Recycle section. For instance i have defined Busy there.

Call count limit of the campaign is set to 10 but it seems Busy's are called endlessly:

---------- LEADS IN HOPPER
+------+--------+-----------+------------+------------+-------+--------+-------+--------+-------+-------+----------------------+
|ORDER |PRIORITY| LEAD ID | LIST ID | PHONE NUM | STATE | STATUS | COUNT | GMT | ALT | SOURCE| VENDOR LEAD CODE |
+------+--------+-----------+------------+------------+-------+--------+-------+--------+-------+-------+----------------------+
| 0 | 0 | 138397 | 910 | 183627787 | | NEW | 0 | 1.00 | NONE | N | |
| 1 | 0 | 118980 | 908 | 251226075 | | B | 36 | 1.00 | NONE | R | |
| 2 | 0 | 118291 | 908 | 615698763 | | AA | 4 | 1.00 | NONE | S | |
| 3 | 0 | 127857 | 909 | 365349793 | | B | 39 | 1.00 | NONE | R | |
| 4 | 0 | 118292 | 908 | 207737554 | | NA | 4 | 1.00 | NONE | S | |
| 5 | 0 | 138398 | 910 | 624301353 | | NEW | 0 | 1.00 | NONE | N | |
| 6 | 0 | 128397 | 909 | 485514217 | | B | 7 | 1.00 | NONE | R | |
| 7 | 0 | 118293 | 908 | 646490026 | | NA | 4 | 1.00 | NONE | S | |
| 8 | 0 | 130179 | 909 | 512531291 | | B | 7 | 1.00 | NONE | R | |
| 9 | 0 | 118296 | 908 | 624223101 | | AA | 4 | 1.00 | NONE | S | |
| 10 | 0 | 138399 | 910 | 624700492 | | NEW | 0 | 1.00 | NONE | N | |
| 11 | 0 | 130970 | 909 | 180785623 | | B | 37 | 1.00 | NONE | R | |
| 12 | 0 | 118305 | 908 | 647878414 | | NA | 4 | 1.00 | NONE | S | |
| 13 | 0 | 134187 | 909 | 612920346 | | B | 15 | 1.00 | NONE | R | |
| 14 | 0 | 118308 | 908 | 203300598 | | NA | 5 | 1.00 | NONE | S | |
| 15 | 0 | 138400 | 910 | 235368312 | | NEW | 0 | 1.00 | NONE | N | |
| 16 | 0 | 135834 | 909 | 237506500 | | B | 22 | 1.00 | NONE | R | |
| 17 | 0 | 118318 | 908 | 633991396 | | NA | 5 | 1.00 | NONE | S | |
| 18 | 0 | 118319 | 908 | 684470932 | | AA | 4 | 1.00 | NONE | S | |
| 19 | 0 | 138401 | 910 | 642598783 | | NEW | 0 | 1.00 | NONE | N | |
| 20 | 0 | 118321 | 908 | 206240485 | | NA | 4 | 1.00 | NONE | S | |
| 21 | 0 | 118323 | 908 | 206234249 | | CALLBK | 3 | 1.00 | NONE | S | |
| 22 | 0 | 138402 | 910 | 620608644 | | NEW | 0 | 1.00 | NONE | N | |
| 23 | 0 | 118324 | 908 | 684104585 | | AA | 5 | 1.00 | NONE | S | |
| 24 | 0 | 118328 | 908 | 207741340 | | NA | 5 | 1.00 | NONE | S | |

[mflorell]

called_count_limit does not affect lead recycling or auto-alt-dial calls. This is mentioned in the help.

[dspaan]

ok but in the lead recycle section i have specified 10 maximum attempts, should that setting not stop it from being put in the hopper endlessly?

[mflorell]

Are you resetting your lists at all?

That recycle setting is 10 attempts PER RESET, not overall.

[dspaan]

Ah, i see. Yes i'm resetting the lists. Still doesn't explain the call count limit not working for dial statuses in the campaign.

[viciboy]

Anyone can explain that how can we calculate Dialable and Penetration %age from the data and how they are related to Call Count Limit and Call Count Target

[mflorell]

Once a lead is past the called count limit it is no longer dialable
Once a lead is past the called count target, or it is flagged a status that is set as completed, it is considered penetrated

[williamconley]

OK, so 100% penetration would be that all leads have been either dialed to their called count limit OR has been set to a status flagged "completed". Cool.