Our products
SELECT distinct(tab_categorie.categoria_id) AS id, tab_categorie.categoria_idpadre AS idpadre FROM tab_categorie_stati INNER JOIN tab_categorie ON (tab_categorie_stati.categoria_id = tab_categorie.categoria_id) WHERE (tab_categorie_stati.lingua_id = '2') AND (tab_categorie.categoria_idpadre='0') AND (tab_categorie_stati.attivo = '1') ORDER BY tab_categorie.categorie_ordine;-Expression #1 of ORDER BY clause is not in SELECT list, references column 'dogo_db.tab_categorie.categorie_ordine' which is not in SELECT list; this is incompatible with DISTINCT