hurrray.sql

gistfile1.txt

 SELECT * FROM message_logs JOIN message_acks ON(message_logs.id = message_acks.message_log_id) LEFT OUTER JOIN message_logs message_logs_not_latest ON(message_logs_not_latest.publisher_id = message_logs.publisher_id AND message_logs_not_latest.created_at > message_logs.created_at) JOIN receivers ON(receivers.id = message_acks.receiver_id) WHERE message_logs_not_latest.id IS NULL AND message_acks.status='failure' AND receivers.name='ad_server' AND message_logs.publisher_id IS NOT NULL;