SELECT prd.cod,prd.denumire FROM mv_producatori prd
, mv_categorii c
, mv_categorii_producatori cp
WHERE prd.activ=1 AND prd.cod=cp.cod_producator AND c.cod=cp.cod_categorie AND c.cod=184 GROUP BY prd.cod ORDER BY cp.ordine
--> query
Array
(
[0] => 42000
[1] => 1055
[2] => Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'unic_over.cp.ordine' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
Array
(
[0] =>
SELECT prd.cod,prd.denumire FROM mv_producatori prd
, mv_categorii c
, mv_categorii_producatori cp
WHERE prd.activ=1 AND prd.cod=cp.cod_producator AND c.cod=cp.cod_categorie AND c.cod=184 GROUP BY prd.cod ORDER BY cp.ordine
)