select c.id,c.titolo as marca,gruppo,case when id_marca=40 then 1 else 0 end as selected from (select distinct id_marca,id_gruppo from articoli where id_gruppo=48) as a join marche as c on a.id_marca=c.id join gruppi as g on g.id_gruppo=a.id_gruppo|||||
