Customer SQL Statement

[Jamie Whittingham]

@twisted1919

How would I / what query could i run to find out all campaigns that are waiting to be processed / waiting to sending to start.

Not ones that are scheduled for next week but ones that should start now, should have started a minute ago but the cron's have not caught up yet etc etc

thanks

 

[twisted1919]

Something like:

SELECT * FROM mw_campaign WHERE `status` IN('sending', 'pending-sending') and start_at <= NOW();

 

[Jamie Whittingham]

Hi @twisted1919

Unknown column 'start_at' in 'where clause' is the error I get

 

[twisted1919]

send_at, my bad.

 

[frm.mwz]

send_at, my bad.

idea: another class in the column that has sending, processing, sent, etc...would be 'to be sent now' (or something better), which would run the above query