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 - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
