sql join that works

SELECT m.from_address,m.from_domain,m.subject,m.spamreport,r.to_user,r.to_domain FROM mainlog m join recipientlog r on (m.id=r.id) where m.from_address='lvideals' and to_domain like '%emerald%' \G

select e.rule as rule, r.location as location, e.to_from as to_from, u.user as user, e.arg as arg, r.box as box from entrys e join rules r on (r.rinc=e.rule) join users u on (e.to_from=u.ainc) order by rule asc, to_from desc