# can any one help me

**URL:** <https://forums.percona.com/t/can-any-one-help-me/1021>\
**Category:** Other MySQL® Questions\
**Created:** [December 4, 2008, 2:50am UTC](https://forums.percona.com/t/can-any-one-help-me/1021 "2008-12-04T02:50:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![daredavil82](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@daredavil82](https://forums.percona.com/u/daredavil82)\
**Post date:** [December 4, 2008, 2:50am UTC](https://forums.percona.com/t/can-any-one-help-me/1021/1 "2008-12-04T02:50:21Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [December 19, 2008, 2:30am UTC](https://forums.percona.com/t/can-any-one-help-me/1021/2 "2008-12-19T02:30:21Z")

</div>

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