Filtry

Could not execute query [Native Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'homeline_sklep.PT.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [User Info: SELECT P.idproducer AS id, PT.name, PT.seo FROM producer P LEFT JOIN producerview PV ON PV.producerid = P.idproducer INNER JOIN product PR ON PR.producerid = P.idproducer LEFT JOIN productcategory PC ON PC.productid = PR.idproduct LEFT JOIN producertranslation PT ON PT.producerid = P.idproducer AND PT.languageid = 1 WHERE PC.categoryid IN (7) AND IF(PR.producerid IS NOT NULL, PV.viewid = 3, 1) GROUP BY P.idproducer ORDER BY PT.name ASC]

Masz pytania ?

Firana Ekran Komplet

Could not execute query [Native Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'homeline_sklep.PT.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [User Info: SELECT P.idproducer AS id, PT.name, PT.seo FROM producer P LEFT JOIN producertranslation PT ON PT.producerid = P.idproducer AND PT.languageid = 1 GROUP BY P.idproducer ORDER BY PT.name ASC]