Kategorie
Filtry
Could not execute query [Native Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opel24_elanaskleptest.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 (158) AND IF(PR.producerid IS NOT NULL, PV.viewid = 3, 1)
GROUP BY P.idproducer
ORDER BY PT.name ASC]
Prześcieradła
Could not execute query [Native Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opel24_elanaskleptest.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]