Struggling with MySQL query

Struggling with MySQL query

References

Reference NO 1

http://stackoverflow.com/questions/4326561/mysql-struggling-with-query-in-one-to-many-relationship-matching-multiple-condit

Reference NO 2

http://www.webmasterworld.com/php/4361289.htm

Reference NO 3

http://forums.mysql.com/read.php?10,1365828051,older

Reference NO 4

http://www.percona.com/webinars/mysql-query-patterns-optimized

Reference NO 5

http://dba.stackexchange.com/questions/27897/struggling-to-debug-high-cpu-usage-on-amazon-rds-mysql-instance

Reference NO 6

http://www.mysqlperformanceblog.com/2013/05/20/webinar-sql-query-patterns-optimized/

Reference NO 7

http://forums.devshed.com/mysql-help-4/mysql-query-to-display-records-from-march-2013-to-may-947386.html

Reference NO 8

https://groups.google.com/d/topic/joomla-dev-general/-zcySXBjjHw