Miscellany

explain INSERT INTO og2list_outgoing_recipients (mid, nid, recipient_name, recipient_address, timestamp, status) SELECT ?, ?, u.name AS recipient_name, u.mail AS recipient_address, ?, ? FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE u.uid != ? AND ou.nid = ? AND u.status > 0 AND ou.is_active >= 1 AND ou.mail_type >= 1;