can any one help me

MySQL & MariaDB Other MySQL® Questions
1

i have this query. it take over than 10 minute to execute. can any one guide me to improve this query performances? any help much appreciated.

2

I don’t see the query )
Please post the query, EXPLAIN … for this query, and information about tables involved in query (SHOW CREATE TABLE …)