Error: SELECT DISTINCT cms_catalogo_new.marca FROM cms_catalogo_new,cms_marca WHERE cms_catalogo_new.attiva = 'SI' AND cms_catalogo_new.cat LIKE '%25%' AND cms_catalogo_new.subcat LIKE '%205%' AND cms_catalogo_new.marca = cms_marca.id ORDER BY cms_marca.titolo

Expression #1 of ORDER BY clause is not in SELECT list, references column 'primus_2011.cms_marca.titolo' which is not in SELECT list; this is incompatible with DISTINCT