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_ambiente_n natural join ambientem where id_designer != 1610 AND ambientem='STUDIO' || id_designer = '35' || id_designer = '37' || id_designer = '73' || id_designer = '79' || id_designer = '82' || id_designer = '83' || id_designer = '84' || id_designer = '88' || id_designer = '93' || id_designer = '99' || id_designer = '100' || id_designer = '106' || id_designer = '108' || id_designer = '110' || id_designer = '117' || id_designer = '126' || id_designer = '127' || id_designer = '131' || id_designer = '135' || id_designer = '136' || id_designer = '137' || id_designer = '138' || id_designer = '139' || id_designer = '146' || id_designer = '150' || id_designer = '152' || id_designer = '156' || id_designer = '159' || id_designer = '162' || id_designer = '168' || id_designer = '189' || id_designer = '196' || id_designer = '197' || id_designer = '199' || id_designer = '202' || id_designer = '208' || id_designer = '222' || id_designer = '241' || id_designer = '242' || id_designer = '243' || id_designer = '259' || id_designer = '261' || id_designer = '271' || id_designer = '278' || id_designer = '286' || id_designer = '298' || id_designer = '319' || id_designer = '328' || id_designer = '334' || id_designer = '335' || id_designer = '337' || id_designer = '349' || id_designer = '353' || id_designer = '358' || id_designer = '365' || id_designer = '367' || id_designer = '370' || id_designer = '372' || id_designer = '375' || id_designer = '376' || id_designer = '377' || id_designer = '380' || id_designer = '381' || id_designer = '382' || id_designer = '384' || id_designer = '389' || id_designer = '396' || id_designer = '397' || id_designer = '399' || id_designer = '400' || id_designer = '401' || id_designer = '402' || id_designer = '403' || id_designer = '406' || id_designer = '407' || id_designer = '408' || id_designer = '409' || id_designer = '410' || id_designer = '411' || id_designer = '412' || id_designer = '413' || id_designer = '416' || id_designer = '424' || id_designer = '435' || id_designer = '439' || id_designer = '440' || id_designer = '443' || id_designer = '447' || id_designer = '448' || id_designer = '473' || id_designer = '478' || id_designer = '479' || id_designer = '480' || id_designer = '481' || id_designer = '483' || id_designer = '487' || id_designer = '488' || id_designer = '491' || id_designer = '492' || id_designer = '493' || id_designer = '499' || id_designer = '500' || id_designer = '503' || id_designer = '505' || id_designer = '507' || id_designer = '509' || id_designer = '511' || id_designer = '518' || id_designer = '530' || id_designer = '535' || id_designer = '543' || id_designer = '552' || id_designer = '568' || id_designer = '571' || id_designer = '572' || id_designer = '584' || id_designer = '592' || id_designer = '593' || id_designer = '604' || id_designer = '608' || id_designer = '611' || id_designer = '612' || id_designer = '617' || id_designer = '618' || id_designer = '649' || id_designer = '653' || id_designer = '654' || id_designer = '660' || id_designer = '661' || id_designer = '662' || id_designer = '664' || id_designer = '668' || id_designer = '669' || id_designer = '675' || id_designer = '682' || id_designer = '685' || id_designer = '686' || id_designer = '689' || id_designer = '690' || id_designer = '727' || id_designer = '729' || id_designer = '739' || id_designer = '741' || id_designer = '742' || id_designer = '743' || id_designer = '760' || id_designer = '761' || id_designer = '764' || id_designer = '768' || id_designer = '788' || id_designer = '796' || id_designer = '802' || id_designer = '807' || id_designer = '814' || id_designer = '827' || id_designer = '829' || id_designer = '830' || id_designer = '832' || id_designer = '835' || id_designer = '840' || id_designer = '845' || id_designer = '854' || id_designer = '862' || id_designer = '868' || id_designer = '894' || id_designer = '897' || id_designer = '908' || id_designer = '910' || id_designer = '911' || id_designer = '925' || id_designer = '926' || id_designer = '933' || id_designer = '937' || id_designer = '939' || id_designer = '951' || id_designer = '953' || id_designer = '957' || id_designer = '960' || id_designer = '962' || id_designer = '974' || id_designer = '977' || id_designer = '984' || id_designer = '990' || id_designer = '996' || id_designer = '997' || id_designer = '1007' || id_designer = '1013' || id_designer = '1014' || id_designer = '1015' || id_designer = '1021' || id_designer = '1023' || id_designer = '1030' || id_designer = '1031' || id_designer = '1044' || id_designer = '1045' || id_designer = '1046' || id_designer = '1048' || id_designer = '1061' || id_designer = '1071' || id_designer = '1093' || id_designer = '1095' || id_designer = '1107' || id_designer = '1112' || id_designer = '1113' || id_designer = '1114' || id_designer = '1115' || id_designer = '1116' || id_designer = '1130' || id_designer = '1135' || id_designer = '1138' || id_designer = '1142' || id_designer = '1145' || id_designer = '1153' || id_designer = '1156' || id_designer = '1159' || id_designer = '1161' || id_designer = '1162' || id_designer = '1166' || id_designer = '1167' || id_designer = '1177' || id_designer = '1184' || id_designer = '1194' || id_designer = '1195' || id_designer = '1196' || id_designer = '1200' || id_designer = '1201' || id_designer = '1205' || id_designer = '1215' || id_designer = '1223' || id_designer = '1226' || id_designer = '1233' || id_designer = '1239' || id_designer = '1251' || id_designer = '1263' || id_designer = '1277' || id_designer = '1292' || id_designer = '1294' || id_designer = '1296' || id_designer = '1298' || id_designer = '1313' || id_designer = '1317' || id_designer = '1339' || id_designer = '1348' || id_designer = '1361' || id_designer = '1370' || id_designer = '1381' || id_designer = '1389' || id_designer = '1402' || id_designer = '1403' || id_designer = '1406' || id_designer = '1412' || id_designer = '1413' || id_designer = '1415' || id_designer = '1422' || id_designer = '1426' || id_designer = '1429' || id_designer = '1431' || id_designer = '1443' || id_designer = '1445' || id_designer = '1447' || id_designer = '1448' || id_designer = '1454' || id_designer = '1456' || id_designer = '1493' || id_designer = '1495' || id_designer = '1505' || id_designer = '1510' || id_designer = '1513' || id_designer = '1522' || id_designer = '1527' || id_designer = '1528' || id_designer = '1529' || id_designer = '1538' || id_designer = '1544' || id_designer = '1547' || id_designer = '1567' || id_designer = '1578' || id_designer = '1582' || id_designer = '1588' || id_designer = '1597' || id_designer = '1600' || id_designer = '1612' || id_designer = '1615' || id_designer = '1624' || id_designer = '1647' || id_designer = '1653' || id_designer = '1655' || id_designer = '1658' || id_designer = '1666' || id_designer = '1692' || id_designer = '1693' || id_designer = '1698' || id_designer = '1701' || id_designer = '1702' || nome like '%STUDIO%' || descrizione like '%STUDIO%' || regione like '%STUDIO%' || citta like '%STUDIO%' group by id_progettoprodotto