I need someone to have a look at joomla mysql queries to see why they are so lazy and takes time to be executed. I have attached a file that there is some of problematic queries.
It is a joomla site that has about 10000 of articles. the lazy queries is now causing the server to load high.
Can any one gime me an offer and also time table for optimizing the database.