iconsis Posted December 12, 2006 Share Posted December 12, 2006 [code]select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c,products_attributes pa where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id[/code] above query is used with custom oscommerce site, pls any one to optimize this query. because this is query take more query timing and server problem.Best Regards,iconsis online. Link to comment https://forums.phpfreaks.com/topic/30367-query-optimization-help/ Share on other sites More sharing options...
fenway Posted December 15, 2006 Share Posted December 15, 2006 Why is only half of it in proper JOIN syntax? And could you post the EXPLAIN? Link to comment https://forums.phpfreaks.com/topic/30367-query-optimization-help/#findComment-142095 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.