Kovács Attila wrote:
> 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?
>
Akkor forditva lene ;) Amugy melyik elso kettore is gondolsz? Es miert
lenne ez nekem jo?
> 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.
>
Nincs.
--
Gabor HALASZ <[email protected]>
_________________________________________________
linux lista - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
