select id_progettoprodotto as id, tipo, realizzato, anno, nome, regione, citta, id_stile as ids, descrizione, imgthumb as img, url from progettoprodotto natural join pp_colore_n natural join colorem where id_designer != 1610 AND colorem='red' || id_designer = '66' || id_designer = '72' || id_designer = '160' || id_designer = '303' || id_designer = '396' || id_designer = '524' || id_designer = '610' || id_designer = '622' || id_designer = '639' || id_designer = '645' || id_designer = '725' || id_designer = '828' || id_designer = '995' || id_designer = '1146' || id_designer = '1202' || id_designer = '1256' || id_designer = '1328' || id_designer = '1459' || id_designer = '1487' || id_designer = '1526' || id_designer = '1530' || id_designer = '1540' || id_designer = '1603' || nome like '%red%' || descrizione like '%red%' || regione like '%red%' || citta like '%red%' group by id_progettoprodotto