select id_progettoprodotto as id, tipo, realizzato, anno, nome, regione, citta, id_stile as ids, descrizione, imgthumb as img, url from progettoprodotto where id_designer != 1610 AND id_designer = '49' || id_designer = '56' || id_designer = '61' || id_designer = '65' || id_designer = '67' || id_designer = '68' || id_designer = '70' || id_designer = '75' || id_designer = '78' || id_designer = '80' || id_designer = '81' || id_designer = '86' || id_designer = '87' || id_designer = '88' || id_designer = '89' || id_designer = '95' || id_designer = '97' || id_designer = '98' || id_designer = '107' || id_designer = '108' || id_designer = '114' || id_designer = '118' || id_designer = '123' || id_designer = '124' || id_designer = '132' || id_designer = '141' || id_designer = '146' || id_designer = '152' || id_designer = '159' || id_designer = '166' || id_designer = '167' || id_designer = '174' || id_designer = '181' || id_designer = '182' || id_designer = '189' || id_designer = '190' || id_designer = '191' || id_designer = '197' || id_designer = '198' || id_designer = '207' || id_designer = '215' || id_designer = '219' || id_designer = '222' || id_designer = '225' || id_designer = '242' || id_designer = '243' || id_designer = '247' || id_designer = '252' || id_designer = '258' || id_designer = '265' || id_designer = '267' || id_designer = '271' || id_designer = '283' || id_designer = '284' || id_designer = '285' || id_designer = '288' || id_designer = '297' || id_designer = '298' || id_designer = '299' || id_designer = '301' || id_designer = '302' || id_designer = '309' || id_designer = '310' || id_designer = '320' || id_designer = '322' || id_designer = '324' || id_designer = '325' || id_designer = '326' || id_designer = '333' || id_designer = '334' || id_designer = '337' || id_designer = '339' || id_designer = '345' || id_designer = '348' || id_designer = '352' || id_designer = '355' || id_designer = '357' || id_designer = '360' || id_designer = '361' || id_designer = '362' || id_designer = '363' || id_designer = '366' || id_designer = '367' || id_designer = '368' || id_designer = '378' || id_designer = '379' || id_designer = '381' || id_designer = '383' || id_designer = '384' || id_designer = '386' || id_designer = '395' || id_designer = '400' || id_designer = '404' || id_designer = '405' || id_designer = '406' || id_designer = '409' || id_designer = '410' || id_designer = '417' || id_designer = '418' || id_designer = '419' || id_designer = '421' || id_designer = '423' || id_designer = '427' || id_designer = '431' || id_designer = '434' || id_designer = '435' || id_designer = '440' || id_designer = '443' || id_designer = '444' || id_designer = '454' || id_designer = '462' || id_designer = '467' || id_designer = '479' || id_designer = '480' || id_designer = '482' || id_designer = '484' || id_designer = '487' || id_designer = '488' || id_designer = '494' || id_designer = '499' || id_designer = '500' || id_designer = '503' || id_designer = '504' || id_designer = '506' || id_designer = '507' || id_designer = '509' || id_designer = '519' || id_designer = '520' || id_designer = '522' || id_designer = '524' || id_designer = '525' || id_designer = '527' || id_designer = '530' || id_designer = '531' || id_designer = '533' || id_designer = '537' || id_designer = '553' || id_designer = '566' || id_designer = '567' || id_designer = '571' || id_designer = '575' || id_designer = '579' || id_designer = '584' || id_designer = '591' || id_designer = '592' || id_designer = '597' || id_designer = '599' || id_designer = '600' || id_designer = '603' || id_designer = '604' || id_designer = '610' || id_designer = '612' || id_designer = '614' || id_designer = '615' || id_designer = '621' || id_designer = '624' || id_designer = '631' || id_designer = '642' || id_designer = '646' || id_designer = '647' || id_designer = '654' || id_designer = '655' || id_designer = '656' || id_designer = '659' || id_designer = '662' || id_designer = '664' || id_designer = '667' || id_designer = '671' || id_designer = '672' || id_designer = '688' || id_designer = '694' || id_designer = '696' || id_designer = '702' || id_designer = '705' || id_designer = '710' || id_designer = '715' || id_designer = '726' || id_designer = '730' || id_designer = '732' || id_designer = '741' || id_designer = '743' || id_designer = '750' || id_designer = '757' || id_designer = '758' || id_designer = '761' || id_designer = '768' || id_designer = '774' || id_designer = '776' || id_designer = '778' || id_designer = '779' || id_designer = '780' || id_designer = '781' || id_designer = '782' || id_designer = '784' || id_designer = '794' || id_designer = '797' || id_designer = '798' || id_designer = '800' || id_designer = '801' || id_designer = '804' || id_designer = '817' || id_designer = '818' || id_designer = '821' || id_designer = '826' || id_designer = '829' || id_designer = '833' || id_designer = '836' || id_designer = '841' || id_designer = '843' || id_designer = '847' || id_designer = '854' || id_designer = '866' || id_designer = '868' || id_designer = '871' || id_designer = '873' || id_designer = '874' || id_designer = '879' || id_designer = '885' || id_designer = '892' || id_designer = '894' || id_designer = '896' || id_designer = '900' || id_designer = '904' || id_designer = '910' || id_designer = '911' || id_designer = '915' || id_designer = '916' || id_designer = '918' || id_designer = '922' || id_designer = '926' || id_designer = '933' || id_designer = '938' || id_designer = '941' || id_designer = '948' || id_designer = '949' || id_designer = '956' || id_designer = '957' || id_designer = '959' || id_designer = '961' || id_designer = '963' || id_designer = '965' || id_designer = '969' || id_designer = '973' || id_designer = '982' || id_designer = '983' || id_designer = '985' || id_designer = '988' || id_designer = '993' || id_designer = '994' || id_designer = '1003' || id_designer = '1007' || id_designer = '1017' || id_designer = '1019' || id_designer = '1025' || id_designer = '1028' || id_designer = '1031' || id_designer = '1033' || id_designer = '1034' || id_designer = '1037' || id_designer = '1040' || id_designer = '1042' || id_designer = '1043' || id_designer = '1044' || id_designer = '1045' || id_designer = '1048' || id_designer = '1051' || id_designer = '1052' || id_designer = '1057' || id_designer = '1061' || id_designer = '1067' || id_designer = '1069' || id_designer = '1071' || id_designer = '1074' || id_designer = '1075' || id_designer = '1076' || id_designer = '1087' || id_designer = '1097' || id_designer = '1105' || id_designer = '1108' || id_designer = '1109' || id_designer = '1111' || id_designer = '1119' || id_designer = '1120' || id_designer = '1127' || id_designer = '1129' || id_designer = '1132' || id_designer = '1133' || id_designer = '1135' || id_designer = '1143' || id_designer = '1147' || id_designer = '1151' || id_designer = '1153' || id_designer = '1155' || id_designer = '1161' || id_designer = '1164' || id_designer = '1165' || id_designer = '1167' || id_designer = '1168' || id_designer = '1171' || id_designer = '1176' || id_designer = '1177' || id_designer = '1179' || id_designer = '1184' || id_designer = '1187' || id_designer = '1195' || id_designer = '1196' || id_designer = '1197' || id_designer = '1211' || id_designer = '1212' || id_designer = '1218' || id_designer = '1220' || id_designer = '1222' || id_designer = '1228' || id_designer = '1233' || id_designer = '1236' || id_designer = '1239' || id_designer = '1245' || id_designer = '1248' || id_designer = '1249' || id_designer = '1252' || id_designer = '1256' || id_designer = '1257' || id_designer = '1260' || id_designer = '1262' || id_designer = '1265' || id_designer = '1269' || id_designer = '1272' || id_designer = '1275' || id_designer = '1283' || id_designer = '1284' || id_designer = '1285' || id_designer = '1286' || id_designer = '1287' || id_designer = '1290' || id_designer = '1292' || id_designer = '1294' || id_designer = '1297' || id_designer = '1299' || id_designer = '1302' || id_designer = '1304' || id_designer = '1305' || id_designer = '1308' || id_designer = '1309' || id_designer = '1310' || id_designer = '1313' || id_designer = '1323' || id_designer = '1334' || id_designer = '1339' || id_designer = '1343' || id_designer = '1352' || id_designer = '1361' || id_designer = '1365' || id_designer = '1369' || id_designer = '1371' || id_designer = '1380' || id_designer = '1384' || id_designer = '1386' || id_designer = '1387' || id_designer = '1388' || id_designer = '1402' || id_designer = '1406' || id_designer = '1414' || id_designer = '1416' || id_designer = '1418' || id_designer = '1433' || id_designer = '1441' || id_designer = '1442' || id_designer = '1443' || id_designer = '1450' || id_designer = '1456' || id_designer = '1460' || id_designer = '1475' || id_designer = '1487' || id_designer = '1490' || id_designer = '1491' || id_designer = '1498' || id_designer = '1500' || id_designer = '1501' || id_designer = '1505' || id_designer = '1508' || id_designer = '1511' || id_designer = '1512' || id_designer = '1524' || id_designer = '1528' || id_designer = '1534' || id_designer = '1539' || id_designer = '1544' || id_designer = '1562' || id_designer = '1568' || id_designer = '1569' || id_designer = '1577' || id_designer = '1579' || id_designer = '1582' || id_designer = '1584' || id_designer = '1585' || id_designer = '1586' || id_designer = '1595' || id_designer = '1597' || id_designer = '1602' || id_designer = '1614' || id_designer = '1621' || id_designer = '1624' || id_designer = '1634' || id_designer = '1638' || id_designer = '1639' || id_designer = '1643' || id_designer = '1644' || id_designer = '1645' || id_designer = '1647' || id_designer = '1649' || id_designer = '1651' || id_designer = '1654' || id_designer = '1655' || id_designer = '1666' || id_designer = '1667' || id_designer = '1669' || id_designer = '1677' || id_designer = '1681' || id_designer = '1683' || id_designer = '1685' || id_designer = '1686' || id_designer = '1689' || id_designer = '1692' || id_designer = '1703' || id_designer = '1708' || id_designer = '1710' || id_designer = '1713' || id_designer = '1718' || id_designer = '1719' || id_designer = '1720' || nome like '%B%' || descrizione like '%B%' || regione like '%B%' || citta like '%B%' group by id_progettoprodotto