Optimizing my sql query

Optimizing my sql query

References

Reference NO 1

http://dev.mysql.com/doc/refman/5.0/en/using-explain.html

Reference NO 2

http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-queries.html

Reference NO 3

http://dev.mysql.com/doc/refman/5.5/en/statement-optimization.html

Reference NO 4

http://www.mysqlperformanceblog.com/2012/09/11/how-to-find-mysql-queries-worth-optimizing/

Reference NO 5

http://20bits.com/article/10-tips-for-optimizing-mysql-queries-that-dont-suck

Reference NO 6

http://www.percona.com/files/presentations/percona-live/dc-2012/PLDC2012-mysql-query-optimization.pdf

Reference NO 7

http://techblog.careesma.com/2010/05/27/optimizing-slow-queries-in-mysql/

Reference NO 8

#EANF#