Gabor HALASZ írta: > SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON > m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id > JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=29 > AND n.headername IN ('resent-message-id','message-id') AND > v.headervalue='<x...@x>' AND p.internal_date > NOW() - INTERVAL 3 DAY; > > > Valami otlet, hogyan lehet reprodukalni/kideriteni? > > Mi lenne, ha a queryben felcserélnéd az első két táblát?
SELECT m.message_idnr FROM dbmail_physmessage p JOIN dbmail_messages m ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=29 AND n.headername IN ('resent-message-id','message-id') AND v.headervalue='<x...@x>' AND p.internal_date > NOW() - INTERVAL 3 DAY; Gondolom az internal_date -re van index. -- k-atti- _________________________________________________ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux