codice:
select maglie,group_concat(colori) as colori
from tabella
group by maglie
having find_in_set('rosso',colori) > 0 and find_in_set('verde',colori) > 0