Re: query problem..

[Baris Cicek]

Have you ever tried using `explain <i>query</i>` to see if there're indexes that mysql does not use.

That kind of queries directly related with the indexes you got on tables. And another note is, why do you use left join, instead of direct joining. Using left join make you increase records with cartesian multiply which is 5000*11000*11000*10000. Insted use direct join and indexes.

Also think about dividing query into two that way you can see what kind of index you can use on each query.

if you can paste explain output of the query and index status of tables (show create table) I can help you a little more.