Not processing entire batch

Hi. I am having an issue with the entire batch size not being processed. Originally I had a cronjob set to process the queue every half hour with a batch size of 500 and it was only processing up to 300 emails. It recognises that the batch is 500. I then tried using 2 cronjobs every half hour and decreasing the size of the batch to 250 but it still doesn’t send the entire batch. I did set up a cronjob to process the bounces recently so I think this can be the cause of the issue but I have since deleted that cronjob. Do you have any idea what could be the cause. Below is an example of the report I receive. Thanks in advance

[Mon 24 Oct 2016 11:30] [CL] Started
[Mon 24 Oct 2016 11:30] [CL] Sending in batches of 250 emails [Mon 24 Oct 2016 11:30] [CL] Processing has started, [Mon 24 Oct 2016 11:30] [CL] 3 campaigns to process.
[Mon 24 Oct 2016 11:30] [CL] Processing message 1275 [Mon 24 Oct 2016 11:30] [CL] Looking for subscribers [Mon 24 Oct 2016 11:30] [CL] Found them: 3 to process [Mon 24 Oct 2016 11:30] [CL] Processing batch of: 3 [Mon 24 Oct 2016 11:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 11:30] [CL] Processed 3 out of 3 subscribers [Mon 24 Oct 2016 11:30] [CL] It took 29 minutes 45 seconds to send this message [Mon 24 Oct 2016 11:30] [CL] Processing message 1276 [Mon 24 Oct 2016 11:30] [CL] Looking for subscribers [Mon 24 Oct 2016 11:30] [CL] Found them: 3 to process [Mon 24 Oct 2016 11:30] [CL] Processing batch of: 3 [Mon 24 Oct 2016 11:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 11:30] [CL] Processed 3 out of 3 subscribers [Mon 24 Oct 2016 11:30] [CL] It took very little time to send this message [Mon 24 Oct 2016 11:30] [CL] Processing message 1277 [Mon 24 Oct 2016 11:30] [CL] Looking for subscribers [Mon 24 Oct 2016 11:30] [CL] Found them: 4 to process [Mon 24 Oct 2016 11:30] [CL] Processing batch of: 4 [Mon 24 Oct 2016 11:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 11:30] [CL] Processed 4 out of 4 subscribers [Mon 24 Oct 2016 11:30] [CL] It took very little time to send this message [Mon 24 Oct 2016 11:30] [CL] Script stage: 5 [Mon 24 Oct 2016 11:30] [CL] 10 messages sent in 3.82 seconds (9430
msgs/hr)

@Phatwozza Please use the code button </> on the toolbar so that the log is readable, currently its difficult to figure out what has happened.

But phplist seems to have processed only 10 subscribers, across three campaigns. What were you expecting to happen?

Hi Duncan
It should have processed 250 subscribers from the various campaigns, this is one of the worst results. Sometimes it processes other amounts but it never finds the 250 it should do as in the batch limit. It was working correctly but somewhere along the line it stopped finding the batch limit.

Sorry I’m not sure how the </> works but I’ll try using it and pasting a few other reports from today to give a better idea:

indent preformatted text by 4 spaces

[Mon 24 Oct 2016 08:30] [CL] Started
[Mon 24 Oct 2016 08:30] [CL] Sending in batches of 250 emails [Mon 24 Oct 2016 08:30] [CL] Processing has started, [Mon 24 Oct 2016 08:30] [CL] 5 campaigns to process.
[Mon 24 Oct 2016 08:30] [CL] Processing message 1257 [Mon 24 Oct 2016 08:30] [CL] Looking for subscribers [Mon 24 Oct 2016 08:30] [CL] Found them: 66 to process [Mon 24 Oct 2016 08:30] [CL] Processing batch of: 66 [Mon 24 Oct 2016 08:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 08:30] [CL] Processed 66 out of 66 subscribers [Mon 24 Oct 2016 08:30] [CL] It took 13 seconds to send this message [Mon 24 Oct 2016 08:30] [CL] Processing message 1258 [Mon 24 Oct 2016 08:30] [CL] Looking for subscribers [Mon 24 Oct 2016 08:30] [CL] Found them: 423 to process [Mon 24 Oct 2016 08:30] [CL] Processing batch of: 184 [Mon 24 Oct 2016 08:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 08:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 08:30] [CL] Size of Text email: 1Kb [Mon 24 Oct 2016 08:30] [CL] batch limit reached: 184 (184) [Mon 24 Oct 2016 08:30] [CL] Script stage: 5 [Mon 24 Oct 2016 08:30] [CL] 184 messages sent in 35.59 seconds (18612
msgs/hr)

[Mon 24 Oct 2016 09:30] [CL] Started
[Mon 24 Oct 2016 09:30] [CL] Sending in batches of 250 emails [Mon 24 Oct 2016 09:30] [CL] Processing has started, [Mon 24 Oct 2016 09:30] [CL] 16 campaigns to process.
[Mon 24 Oct 2016 09:30] [CL] Processing message 1258 [Mon 24 Oct 2016 09:30] [CL] Looking for subscribers [Mon 24 Oct 2016 09:30] [CL] Found them: 55 to process [Mon 24 Oct 2016 09:30] [CL] Processing batch of: 55 [Mon 24 Oct 2016 09:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 09:30] [CL] Processed 55 out of 55 subscribers [Mon 24 Oct 2016 09:30] [CL] It took 1 hours 02 seconds to send this message [Mon 24 Oct 2016 09:30] [CL] Processing message 1259 [Mon 24 Oct 2016 09:30] [CL] Looking for subscribers [Mon 24 Oct 2016 09:30] [CL] Found them: 174 to process [Mon 24 Oct 2016 09:30] [CL] Processing batch of: 174 [Mon 24 Oct 2016 09:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 09:30] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 09:30] [CL] Size of Text email: 1Kb [Mon 24 Oct 2016 09:30] [CL] batch limit reached: 195 (195) [Mon 24 Oct 2016 09:30] [CL] Script stage: 5 [Mon 24 Oct 2016 09:30] [CL] 195 messages sent in 50.98 seconds (13771
msgs/hr)

[Mon 24 Oct 2016 10:00] [CL] Started
[Mon 24 Oct 2016 10:00] [CL] Sending in batches of 250 emails [Mon 24 Oct 2016 10:00] [CL] Processing has started, [Mon 24 Oct 2016 10:00] [CL] 19 campaigns to process.
[Mon 24 Oct 2016 10:00] [CL] Processing message 1259 [Mon 24 Oct 2016 10:00] [CL] Looking for subscribers [Mon 24 Oct 2016 10:00] [CL] Found them: 34 to process [Mon 24 Oct 2016 10:00] [CL] Processing batch of: 34 [Mon 24 Oct 2016 10:00] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 10:00] [CL] Processed 34 out of 34 subscribers [Mon 24 Oct 2016 10:00] [CL] It took 59 minutes 13 seconds to send this message [Mon 24 Oct 2016 10:00] [CL] Processing message 1260 [Mon 24 Oct 2016 10:00] [CL] Looking for subscribers [Mon 24 Oct 2016 10:00] [CL] Found them: 133 to process [Mon 24 Oct 2016 10:00] [CL] Processing batch of: 133 [Mon 24 Oct 2016 10:00] [CL] Size of HTML email: 69Kb [Mon 24 Oct 2016 10:00] [CL] Processed 133 out of 133 subscribers [Mon 24 Oct 2016 10:00] [CL] It took 59 minutes 54 seconds to send this message [Mon 24 Oct 2016 10:00] [CL] Processing message 1261 [Mon 24 Oct 2016 10:00] [CL] Looking for subscribers [Mon 24 Oct 2016 10:00] [CL] Found them: 10 to process [Mon 24 Oct 2016 10:00] [CL] Processing batch of: 10 [Mon 24 Oct 2016 10:00] [CL] batch limit reached: 167 (49) [Mon 24 Oct 2016 10:00] [CL] Script stage: 5 [Mon 24 Oct 2016 10:00] [CL] 167 messages sent in 53.29 seconds (11282
msgs/hr)

@Phatwozza

What are the batch settings? You should set the batch period to a small number, say 5s.

Hi Duncan

Thanks so much for your assistance, I really hope I’m not waisting your time. I reduced my batch period to 10secs as suggested ant the emails went out as follows:
08.30am - 198 processed
09.00am - 105 processed
09.30am - 50 processed
10.00am - 48 processed
10.30am - 198 processed campaign complete

Here are my Queue and Load Management settings in the config.php file:

# If you set up your system to send the message automatically (from commandline),
# you can set this value to 0, so "Process Queue" will disappear from the site
# this will also stop users from loading the page on the web frontend, so you will
# have to make sure that you run the queue from the commandline
# check README.commandline how to do this
define('MANUALLY_PROCESS_QUEUE', 0);

# This setting will activate an initial setup choice for processing the queue
# When "true" it will allow a choice between remote queue processing with the
# phpList.com service or processing it locally in the browser.
# when the value is "false", you can use remote processing in your own way
# as explain at https://resources.phplist.com/system/remote_processing
# define('SHOW_PQCHOICE',false);

# batch processing
# if you are on a shared host, it will probably be appreciated if you don't send
# out loads of emails in one go. To do this, you can configure batch processing.
# Please note, the following two values can be overridden by your ISP by using
# a server wide configuration. So if you notice these values to be different
# in reality, that may be the case

# max messages to process
# if there are multiple messages in the queue, set a maximum to work on
define('MAX_PROCESS_MESSAGE', 999);

# process parallel
# if there are multiple messages in the queue, divide the max batch across them
# instead of sending them one by one.
# this only works if you use batch processing. It will divide the batch between the
# campaigns that need sending.
#define('PROCESSCAMPAIGNS_PARALLEL',true);

# define the amount of emails you want to send per period. If 0, batch processing
# is disabled and messages are sent out as fast as possible
define('MAILQUEUE_BATCH_SIZE', 250);

# define the length of one batch processing period, in seconds (3600 is an hour)
define('MAILQUEUE_BATCH_PERIOD', 10);

# to avoid overloading the server that sends your email, you can add a little delay
# between messages that will spread the load of sending
# you will need to find a good value for your own server
# value is in seconds, and you can use fractions, eg "0.5" is half a second
# (or you can play with the autothrottle below)
define('MAILQUEUE_THROTTLE', 0);

# Mailqueue autothrottle. This will try to automatically change the delay
# between messages to make sure that the MAILQUEUE_BATCH_SIZE (above) is spread evently over
# MAILQUEUE_BATCH_PERIOD, instead of firing the Batch in the first few minutes of the period
# and then waiting for the next period. This only works with mailqueue_throttle off
# and MAILQUEUE_BATCH_PERIOD being a positive value
# it still needs tweaking, so send your feedback to mantis.phplist.com if you find
# any issues with it
define('MAILQUEUE_AUTOTHROTTLE', 0);

# Domain Throttling
# You can activate domain throttling, by setting USE_DOMAIN_THROTTLE to 1
# define the maximum amount of emails you want to allow sending to any domain and the number
# of seconds for that amount. This will make sure you don't send too many emails to one domain
# which may cause blacklisting. Particularly the big ones are tricky about this.
# it may cause a dramatic increase in the amount of time to send a message, depending on how
# many users you have that have the same domain (eg hotmail.com)
# if too many failures for throttling occur, the send process will automatically add an extra
# delay to try to improve that. The example sends 1 message every 2 minutes.

define('USE_DOMAIN_THROTTLE', 0);
define('DOMAIN_BATCH_SIZE', 1);
define('DOMAIN_BATCH_PERIOD', 120);

# if you have very large numbers of users on the same domains, this may result in the need
# to run processqueue many times, when you use domain throttling. You can also tell phplist
# to simply delay a bit between messages to increase the number of messages sent per queue run
# if you want to use that set this to 1, otherwise simply run the queue many times. A cron
# process every 10 or 15 minutes is recommended.
define('DOMAIN_AUTO_THROTTLE', 0);

# MAX_PROCESSQUEUE_TIME
# to limit the time, regardless of batch processing or other throttling of a single run of "processqueue"
# you can set the MAX_PROCESSQUEUE_TIME in seconds
# if a single queue run exceeds this amount, it will stop, just to pick up from where it left off next time
# this allows multiple installations each to run the queue, but slow installations (eg with large emails)
# set to 0 to disable this feature.
define('MAX_PROCESSQUEUE_TIME', 0);

/*

Do you have any idea what could be wrong or what I can try. It’s strange because I haven’t had this issue before, it normally sends my batch size no problem. Could it have something to do with the process bounces cronjob I installed and removed last week? Much appreciated.

Sorry I’m still not sure how to use the </> tool.

@Phatwozza Highlight the text then click the </> button

sdfsdaf sfsdf sfdsdfsd
sdfdsf sdfdsf sdfsd
sdfdsg fdgdfg

I suggest disabling the parallel processing so that phplist will work on only one campaign at a time.

define('PROCESSCAMPAIGNS_PARALLEL',false);

Also, you can enable verbose output which will add more information to the system log when phplist sends emails

define('VERBOSE', 1);

Hi Duncan. Thanks again for your help.
I am still having issues reaching my batch limit. The campaign reaches its limit in various sizes. Each message is meant to go to a different lists of varying sizes with batch sizes set to 250 every half hour using cronjobs. The messages are created daily. Sometimes the campaign reaches it batch limit over 200 but often it is as low as 60. Do you have an idea if there is another setting I can create or do you think the load of different lists being sent at the same time is too much for phplist to handle? Please let me know if there is anything I can send you to help figure it out. Thanks in advance.

@Phatwozza Did you enable the VERBOSE setting? Please do that then look in the event log. There will be entries in the event log concerning the number of emails to be sent in each batch.

@duncanc Yes I did set VERBOSE to (‘VERBOSE’, 1). The Log of events is a bit difficult to make out because it shows a report for each message - please let me know if there is anything specific I should be looking for. All the campaigns were sent by 10.00 today and this is the summary for each time the cronjob processed them.

8.30 - 180
9.00 - 250
9.30 - 133
10.00 - 250
10.30 - 134
11.00 - 57
11.30 - 58
12.00 - 20

As you can see there on 2 occasions the full batch size was sent but after 10.00 the campaigns still need to be processed 4 times where they should have only needed to be processed twice.

I am not sure if this will effect the sending but sometimes I get this notice in the report for some addresses:

[Tue 1 Nov 2016 10:00] [CL] select id from phplist_message where status not
in ('draft', 'sent', 'prepared', 'suspended') and embargo select distinct
u.id from phplist_listuser as listuser cross join phplist_user_user as u
cross join phplist_listmessage as listmessage left join phplist_usermessage
as um on (um.messageid = ? and um.userid = listuser.userid) where true and
listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id
= listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted
and !u.disabled limit 0,250

I am going to try send the email report I received for the 11.30 batch where 58 emails were processed and 20 were left behind. There isn’t enough space in this message to allow it.

I have split it in half:

 [Tue 1 Nov 2016 11:30] [CL] Started
    [Tue 1 Nov 2016 11:30] [CL] Sending in batches of 250 emails 
    [Tue 1 Nov 2016 11:30] [CL] select id from phplist_message where status not in ('draft', 'sent', 'prepared', 'suspended') and embargo select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,250 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 3 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1387 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1387 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 68Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2355900000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1387 to goldlink@iafrica.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1387 with subject CPM Prices & Silver Sale to goldlink@iafrica.com [Tue 1 Nov 2016 11:30] [CL] It took 0.1159120000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1387 to chris@nwjcorp.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message
     [Tue 1 Nov 2016 11:30] [CL] Sending message 1387 with subject CPM Prices & Silver Sale to chris@nwjcorp.co.za [Tue 1 Nov 2016 11:30] [CL] It took 0.1874930000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 3 out of 3 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 34 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 57 seconds 
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1388 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 3 to process 
    [Tue 1 Nov 2016 11:30] [CL] 247 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,247 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 3 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1388 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1388 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 68Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1929830000 seconds to send [Tue 1 Nov 2016 11:30] [CL] Sending 1388 to navinjagath372@gmail.com [
    Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1388 with subject CPM Prices & Silver Sale to navinjagath372@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1331710000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1388 to kamtak1122@yahoo.com.hk 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1388 with subject CPM Prices & Silver Sale to kamtak1122@yahoo.com.hk 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1447740000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 3 out of 3 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 34 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 57 seconds
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1389 [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 4 to process [Tue 1 Nov 2016 11:30] [CL] 241 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,241 [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 4 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1389 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1389 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 68Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1905430000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1389 to millenium.metals@yahoo.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1389 with subject CPM Prices & Silver Sale to millenium.metals@yahoo.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1705860000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1389 to ellassa@iafrica.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1389 with subject CPM Prices & Silver Sale to ellassa@iafrica.com [Tue 1 Nov 2016 11:30] [CL] It took 0.1845240000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1389 to keywest@internetafrica.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1389 with subject CPM Prices & Silver Sale to keywest@internetafrica.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1779660000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 4 out of 4 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 35 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 56 seconds 
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1390 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 4 to process 
    [Tue 1 Nov 2016 11:30] [CL] 231 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,231 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 4 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1390 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1390 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.4068590000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1390 to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1390 with subject CPM Prices & Silver Sale to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.9695420000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1390 to karlsen@jewelleryco.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1390 with subject CPM Prices & Silver Sale to karlsen@jewelleryco.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1593270000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1390 to chagannj@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1390 with subject CPM Prices & Silver Sale to chagannj@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1951640000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 4 out of 4 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 37 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 54 seconds 
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1391 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 18 to process 
    [Tue 1 Nov 2016 11:30] [CL] 217 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,217 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 18 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1771700000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1535570000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to stevetwilson@telkomsa.net 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to stevetwilson@telkomsa.net 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] Size of Text email: 1Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1655390000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to durgajewllers06@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to durgajewllers06@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1580240000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to suzaraloots@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to suzaraloots@gmail.com
[Tue 1 Nov 2016 11:30] [CL] It took 0.2093530000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to rbspawn@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to rbspawn@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1819490000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to info@bluffpawn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to info@bluffpawn.co.za [Tue 1 Nov 2016 11:30] [CL] It took 0.1928650000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to bluffpawn@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to bluffpawn@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1492380000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to nsjewelers@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to nsjewelers@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1999160000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to ehofmeyr@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to ehofmeyr@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2281110000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to gemnel7@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to gemnel7@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 1.0212120000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to joanigroen@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to joanigroen@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2583540000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to annemi.nelson@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to annemi.nelson@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2347230000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to jaydeejewellers@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to jaydeejewellers@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2714280000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to andrewc2@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to andrewc2@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2763910000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to anna.rosholt@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to anna.rosholt@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1687280000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to doritaqbrink@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to doritaqbrink@gmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2190410000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1391 to philtins@webmail.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1391 with subject CPM Prices & Silver Sale to philtins@webmail.co.za
     [Tue 1 Nov 2016 11:30] [CL] It took 0.1768690000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 18 out of 18 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 42 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 48 seconds 
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1392 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 4 to process 
    [Tue 1 Nov 2016 11:30] [CL] 185 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,185 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 4 [Tue 1 Nov 2016 11:30] [CL] Sending 1392 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1392 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2380790000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1392 to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1392 with subject CPM Prices & Silver Sale to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1413440000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1392 to tkh@capewatch.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1392 with subject CPM Prices & Silver Sale to tkh@capewatch.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1479630000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1392 to herbertdaddy@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1392 with subject CPM Prices & Silver Sale to herbertdaddy@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1751680000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 4 out of 4 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 44 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 46 seconds [Tue 1 Nov 2016 11:30] [CL] Processing message 1393 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 2 to process 
    [Tue 1 Nov 2016 11:30] [CL] 149 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,149 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 2 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1393 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1393 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1957140000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1393 to e_draper@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1393 with subject CPM Prices & Silver Sale to e_draper@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1509540000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 2 out of 2 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 44 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 46 seconds 
    [Tue 1 Nov 2016 11:30] [CL] Processing message 1394 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 20 to process 
    [Tue 1 Nov 2016 11:30] [CL] 111 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,111 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 20 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to malcolm@cpmdbn.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Size of HTML email: 56Kb 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1958500000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to seanscrase@hotmail.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to seanscrase@hotmail.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2886050000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to carinvn@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to carinvn@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1999660000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to veensd04@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to veensd04@yahoo.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2289220000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to ottery@cashconverters.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to ottery@cashconverters.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1556620000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to info@antonhattingh.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to info@antonhattingh.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2130580000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to vanessa@straussart.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to vanessa@straussart.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1380760000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to warren@blnkmarketing.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1450660000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to joachim@freshtake.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to joachim@freshtake.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.9138370000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to patricia@patriciag.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to patricia@patriciag.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2600290000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to ryno@patriciag.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to ryno@patriciag.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1558040000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to db@xsinet.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to db@xsinet.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1769890000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to philip@breede.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to philip@breede.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1791040000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to dbdesign@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to dbdesign@mweb.co.za 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.2074750000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to dean@markgold.net 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to dean@markgold.net 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1779440000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to imraan@randereejewellers.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to imraan@randereejewellers.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1669990000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to shahjewellers@telkomsa.net 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to shahjewellers@telkomsa.net 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1473880000 seconds to send
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to info@mayuris.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to info@mayuris.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1907660000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to shashika@mayuris.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to shashika@mayuris.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1550180000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Sending 1394 to ryno@patriciagreatorex.com 
    [Tue 1 Nov 2016 11:30] [CL] Using cached message 
    [Tue 1 Nov 2016 11:30] [CL] Sending message 1394 with subject CPM Prices & Silver Sale to ryno@patriciagreatorex.com 
    [Tue 1 Nov 2016 11:30] [CL] It took 0.1614150000 seconds to send 
    [Tue 1 Nov 2016 11:30] [CL] Processed 20 out of 20 subscribers 
    [Tue 1 Nov 2016 11:30] [CL] It took 1 hours 28 minutes 49 seconds to send this message 
    [Tue 1 Nov 2016 11:30] [CL] sending of this campaign will stop, if it is still going in 182 days 11 hours 59 minutes 40 seconds [Tue 1 Nov 2016 11:30] [CL] Processing message 1395 
    [Tue 1 Nov 2016 11:30] [CL] Looking for subscribers 
    [Tue 1 Nov 2016 11:30] [CL] User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled 
    [Tue 1 Nov 2016 11:30] [CL] Found them: 8 to process 
    [Tue 1 Nov 2016 11:30] [CL] 53 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,53 
    [Tue 1 Nov 2016 11:30] [CL] Processing batch of: 8 
    [Tue 1 Nov 2016 11:30] [CL] batch limit reached: 58 (53) 
    [Tue 1 Nov 2016 11:30] [CL] Script stage: 5 
    [Tue 1 Nov 2016 11:30] [CL] 58 messages sent in 18.32 seconds (11397
        msgs/hr)

@Phatwozza Which release of phplist are you using? There might be a bug in the code but I cannot match the output with the latest release, 3.2.5.

There were some changes in the area of batch processing in release 3.2.5 so you should update to that release.

Hi Duncan. I was running 3.0.12 - it is working properly since upgrading to 3.2.5. Thanks again for your assistance.