Help needed with complex mysql select

Anon

Can anyone tell me what I may be doing wrong with this statement?

SELECT q.*, y.cj_m_epc3, y.cj_mid

from product q,

cjmerch y

WHERE

(q.aut IN ( 20334792, 20342774, 20343768, 20343777, 0626196, 20626197, 20626198))

and

(q.product_m_id = 965168745 or q.product_m_id = 1013712945 or q.product_m_id = 903069221 or q.product_m_id = 959129110)

and

y.cj_mid = q.product_m_id

order by y.cj_m_epc3 desc

limit 0, 10

Thanks!
Amy Strycula

mistcat

what error does it give you?
you might try putting ()'s around your or's

like
( (q.product_m_id = 965168745) or (q.product_m_id = 1013712945) )

you know?

Anon

It is not returning any results, when there should be.

I don't think parentheses are needed around the 'or' statements, because this query (in a simpler form) was working before I started playing with it, and there were no parentheses.

Thanks. If you or anyone sees any other problem, please let me know. I'm stumped.

Anon

Never mind - got it working! I wasn't actually hitting this call in the code, it ends up!