Mine

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