Select DISTINCT c.CategoryKey, c.SubCategoryKey, c.CategoryName, c.Description, cc.CategoryName as subCategoryName, p.ProductName From Categories c left join ProductList pl on c.CategoryKey = pl.CategoryKey left join Products p on pl.ProductKey = p.ProductKey LEFT JOIN Categories cc ON (c.SubCategoryKey = cc.CategoryKey) LEFT JOIN Categories ccc ON (cc.SubCategoryKey = ccc.CategoryKey) LEFT JOIN Categories cccc ON (ccc.SubCategoryKey = cccc.CategoryKey) where (c.CategoryName Like '%%' or c.Description like '%%' or c.Metadata like '%%' or p.sku = '') AND c.P_Protected = 0 AND p.productName != '' GROUP BY c.CategoryKey ORDER BY c.CategoryName ASC LIMIT 0, 25
Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bgscapit_subsite.p.ProductName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Unable to search for

You can try another search - or Click here to return to the previous page