Gli Espositori

Scarica l'elenco completo in formato .pdf

Visualizza tutti gli espositori



inizio ricerca: '1644';'()'
prefiltro -> and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2008') ) / filtro -> 1644';'() -> and
1644 : () : valore REGEXP '()'
insert into 00119_temp2 select distinct codice from catalogo.00119_desc where id_template='756' and campo='1644' and codice in (select codice from catalogo.00119_pk where id_template='756' and visibile=1) and valore REGEXP '()' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2008') )
ciclo 1 [1]: trovati 751 record
ciclo 1 [2]: trovati 751 record
sql che prende i codici: select codice from catalogo.00119_desc where id_template='756' and campo='1644' and codice in (select codice from 00119_temp) and codice in (select distinct codice from 00119_desc where id_template='756' and lingua='it') order by valore limit 0,999
codici trovati in temp: 1,5,2,6,8,11,12,13,15,16,17,21,22,26,28,29,30,37,39,41,1250,43,45,1251,48,50,53,56,58,59,61,62,1252,1253,64,65,67,1257,69,70,1263,72,77,78,79,81,80,83,85,89,1264,1267,90,92,1268,93,95,1271,96,98,103,108,111,114,115,116,122,124,125,128,1274,129,130,131,134,135,141,144,1275,145,146,1276,147,151,156,157,1279,158,164,167,168,170,1282,171,1283,173,174,175,1284,178,180,1289,1294,1299,181,183,184,185,186,190,191,192,195,196,197,1300,199,203,204,206,207,208,210,211,214,217,1301,1302,227,221,222,223,224,226,228,230,231,238,242,243,248,250,252,253,255,256,257,258,1304,260,262,263,264,265,10,266,269,270,271,273,275,276,280,288,289,290,293,297,299,301,309,1306,310,1310,312,1313,316,317,318,319,1317,1319,320,321,322,1321,324,326,327,328,330,332,333,335,340,1322,343,345,346,348,350,351,352,354,1040,1323,356,361,385,364,365,368,370,371,1324,372,377,1326,378,1332,379,380,1338,383,1341,391,394,397,401,402,404,407,409,1342,410,1343,411,412,1405,1344,415,416,1346,419,424,1349,429,425,1035,1350,426,1351,428,431,432,433,434,436,438,439,440,1354,1357,442,444,446,448,1364,1372,450,1373,451,453,454,455,457,462,464,466,1374,467,1376,470,473,474,475,477,482,488,491,493,494,496,498,1377,499,503,506,509,510,511,513,515,517,520,522,527,528,530,531,532,534,535,537,540,541,1378,544,545,546,547,1379,548,554,556,558,559,1380,560,563,564,1381,565,566,567,568,571,573,575,577,578,1386,579,580,581,582,1387,1388,584,586,1394,587,588,1395,589,590,591,594,595,596,599,601,603,606,610,611,612,617,618,621,622,624,625,1396,627,626,629,1397,631,636,641,642,643,644,646,647,651,652,658,661,665,666,1400,670,672,1401,1229,1403,675,680,681,684,1404,685,376,686,702,703,723,733,687,691,1406,1407,693,696,697,698,1410,699,707,709,711,713,715,716,717,1411,718,719,1412,1414,720,721,726,729,731,1415,1416,1417,734,737,740,742,743,745,746,1418,748,749,752,753,754,758,1419,763,1420,765,1421,771,774,779,781,782,784,785,1426,787,788,789,791,795,801,802,803,1427,804,807,809,811,813,816,817,818,821,822,823,824,825,826,1431,829,830,832,833,834,835,836,838,839,843,844,845,849,852,854,857,858,859,863,864,42,868,1433,872,875,876,1434,879,880,1436,882,885,886,888,890,891,893,1437,1438,894,1439,896,897,1440,901,1443,903,906,907,908,912,914,919,920,921,1444,922,1445,924,925,928,930,934,933,935,936,939,940,942,947,950,952,953,954,956,958,960,962,964,965,968,970,972,974,979,980,981,1446,982,983,988,1447,989,990,993,1448,994,995,997,999,1000,1003,1008,1013,1450,1014,1016,1018,1021,1023,1029,1030,1034,1036,1454,1455,1037,1038,1464,1041,1042,1044,1046,1048,1465,1466,1467,1468,1049,1050,1051,1471,1053,1054,1055,1058,1061,1062,1064,1067,1070,1071,1473,1072,1474,1073,1476,1479,1480,1076,1077,1078,1079,1080,1081,1086,1098,1092,1099,1485,1100,1103,1105,1107,1111,1115,1119,1486,1121,1488,1122,1123,1490,1124,1128,1491,1129,1130,1131,1133,1492,1135,1138,1495,1139,1140,1142,104,1496,1144,1145,1497,1146,1148,1150,1151,1153,1156,1157,1158,1163,1165,1498,1499,1168,1169,1500,1170,1502,1503,1505,1171,1172,1175,1176,1177,1179,1182,1184,1508,1185,1187,1188,1191,1194,1199,1200,1202,1203,1205,1208,1211,1514,1212,1214,1215,1218,1219,1220,1221,1511,1222,1515,1516,1518,1224,1519,1225,1227,1522,1523,1231,1233,1235,1240,1242,1243,1245,1247,1248
trovati 751 record corrispondenti
1,5,2,6,8,11,12,13,15,16,17,21,22,26,28,29,30,37,39,41,1250,43,45,1251,48,50,53,56,58,59,61,62,1252,1253,64,65,67,1257,69,70,1263,72,77,78,79,81,80,83,85,89,1264,1267,90,92,1268,93,95,1271,96,98,103,108,111,114,115,116,122,124,125,128,1274,129,130,131,134,135,141,144,1275,145,146,1276,147,151,156,157,1279,158,164,167,168,170,1282,171,1283,173,174,175,1284,178,180,1289,1294,1299,181,183,184,185,186,190,191,192,195,196,197,1300,199,203,204,206,207,208,210,211,214,217,1301,1302,227,221,222,223,224,226,228,230,231,238,242,243,248,250,252,253,255,256,257,258,1304,260,262,263,264,265,10,266,269,270,271,273,275,276,280,288,289,290,293,297,299,301,309,1306,310,1310,312,1313,316,317,318,319,1317,1319,320,321,322,1321,324,326,327,328,330,332,333,335,340,1322,343,345,346,348,350,351,352,354,1040,1323,356,361,385,364,365,368,370,371,1324,372,377,1326,378,1332,379,380,1338,383,1341,391,394,397,401,402,404,407,409,1342,410,1343,411,412,1405,1344,415,416,1346,419,424,1349,429,425,1035,1350,426,1351,428,431,432,433,434,436,438,439,440,1354,1357,442,444,446,448,1364,1372,450,1373,451,453,454,455,457,462,464,466,1374,467,1376,470,473,474,475,477,482,488,491,493,494,496,498,1377,499,503,506,509,510,511,513,515,517,520,522,527,528,530,531,532,534,535,537,540,541,1378,544,545,546,547,1379,548,554,556,558,559,1380,560,563,564,1381,565,566,567,568,571,573,575,577,578,1386,579,580,581,582,1387,1388,584,586,1394,587,588,1395,589,590,591,594,595,596,599,601,603,606,610,611,612,617,618,621,622,624,625,1396,627,626,629,1397,631,636,641,642,643,644,646,647,651,652,658,661,665,666,1400,670,672,1401,1229,1403,675,680,681,684,1404,685,376,686,702,703,723,733,687,691,1406,1407,693,696,697,698,1410,699,707,709,711,713,715,716,717,1411,718,719,1412,1414,720,721,726,729,731,1415,1416,1417,734,737,740,742,743,745,746,1418,748,749,752,753,754,758,1419,763,1420,765,1421,771,774,779,781,782,784,785,1426,787,788,789,791,795,801,802,803,1427,804,807,809,811,813,816,817,818,821,822,823,824,825,826,1431,829,830,832,833,834,835,836,838,839,843,844,845,849,852,854,857,858,859,863,864,42,868,1433,872,875,876,1434,879,880,1436,882,885,886,888,890,891,893,1437,1438,894,1439,896,897,1440,901,1443,903,906,907,908,912,914,919,920,921,1444,922,1445,924,925,928,930,934,933,935,936,939,940,942,947,950,952,953,954,956,958,960,962,964,965,968,970,972,974,979,980,981,1446,982,983,988,1447,989,990,993,1448,994,995,997,999,1000,1003,1008,1013,1450,1014,1016,1018,1021,1023,1029,1030,1034,1036,1454,1455,1037,1038,1464,1041,1042,1044,1046,1048,1465,1466,1467,1468,1049,1050,1051,1471,1053,1054,1055,1058,1061,1062,1064,1067,1070,1071,1473,1072,1474,1073,1476,1479,1480,1076,1077,1078,1079,1080,1081,1086,1098,1092,1099,1485,1100,1103,1105,1107,1111,1115,1119,1486,1121,1488,1122,1123,1490,1124,1128,1491,1129,1130,1131,1133,1492,1135,1138,1495,1139,1140,1142,104,1496,1144,1145,1497,1146,1148,1150,1151,1153,1156,1157,1158,1163,1165,1498,1499,1168,1169,1500,1170,1502,1503,1505,1171,1172,1175,1176,1177,1179,1182,1184,1508,1185,1187,1188,1191,1194,1199,1200,1202,1203,1205,1208,1211,1514,1212,1214,1215,1218,1219,1220,1221,1511,1222,1515,1516,1518,1224,1519,1225,1227,1522,1523,1231,1233,1235,1240,1242,1243,1245,1247,1248
pagina=20|num_pagine=76|num_records=751
20 / 76

Categoria Cucine, Contract
CORAZZOLLA Arredamenti su misura
TRES (TN)
Tel: 0463-468186
Fax: 0463-466815
Categoria Arredobagno, Architettura d'interni
CORDIVARI DESIGN
MORRO D'ORO (TE)
Tel: 085-80401
Fax: 085-8041418
Categoria Tessuti - Biancheria - Tappeti - Tendaggi
COREN
CABIATE (CO)
Tel: 031-768442
Fax: 031-768600
Categoria Mobili ed arredi per gli esterni, Contract
CORO
MONZA (MI)
Tel: 039-2726260
Fax: 039-2727409
Categoria Mobili - Tavoli - Sedie, Imbottiti, Arte della Tavola, Complementi d'arredo e oggettistica, dipinti
COVO
FORMELLO (RM)
Tel: 06-90400311
Fax: 06-90409175
Categoria Complementi d'arredo e oggettistica, dipinti
CRAYE Group Flemish Tapestries
ROUBAIX (Francia)
Tel: -
Fax: -
Categoria Pavimenti e rivestimenti, porte, maniglie, scale, caminetti, Architettura d'interni, Contract
CREATE
FINALE EMILIA (MO)
Tel: 0535-761811
Fax: 0535-761800
Categoria Mobili - Tavoli - Sedie, Imbottiti
CREAZIONI by SILIK
VIGHIZZOLO DI CANTÙ (CO)
Tel: 031-730000
Fax: 031-735371
;
Categoria Pavimenti e rivestimenti, porte, maniglie, scale, caminetti
CUOIOARREDO by Cuoificio Bisonte
S. CROCE SULL'ARNO (PI)
Tel: 0571-30036
Fax: 0571-33894
Categoria Mobili - Tavoli - Sedie, Complementi d'arredo e oggettistica, dipinti
CUPROOM di Celato Rito
MONTEBELLUNA (TV)
Tel: 0423-302292
Fax: 0423-600130


pagina 20 di 76
 
var1: var2: var3: var4: var5: var6:
Apache::DBI::db=HASH(0x7f6329e1ad90)