DB Transaction Failure
Query error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
SELECT count(*) as tot, producer_master.vPhone1 as producerphone, category_master_lang.vCategoryName as categoryname FROM (sitecontent_master) LEFT JOIN sitecontent_master_lang ON sitecontent_master_lang.iSiteContentId = sitecontent_master.iSiteContentId and sitecontent_master_lang.iLangId = 5 LEFT JOIN producer_master ON producer_master.iProducerId = sitecontent_master.iProducerId LEFT JOIN category_master ON category_master.iCategoryId = sitecontent_master.iCategoryId LEFT JOIN category_master_lang ON category_master_lang.iCategoryId = category_master.iCategoryId and category_master_lang.iLangId = 5 LEFT JOIN country ON country.iCountryId= sitecontent_master.iCountryId LEFT JOIN country_lang ON country_lang.iCountryId = country.iCountryId and country_lang.iLangId = 5 LEFT JOIN state ON state.iStateId= sitecontent_master.iStateId LEFT JOIN state_lang ON state_lang.iStateId = state.iStateId and state_lang.iLangId = 5 LEFT JOIN city_master ON city_master.iCityId= sitecontent_master.iCityId LEFT JOIN city_master_lang ON city_master_lang.iCityId = city_master.iCityId and city_master_lang.iLangId = 5 WHERE `sitecontent_master`.`eSiteContentType` = 'ServiceGuide' AND sitecontent_master.eStatus = 'Active' AND sitecontent_master_lang.iLangId = 5 ORDER BY sitecontent_master.iViews DESC