inizio ricerca: '1644';'()'
prefiltro -> and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') ) / 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 ('2010') )
ciclo 1 [1]: trovati 502 record
ciclo 1 [2]: trovati 502 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: 2081,1787,1941,12,13,16,2089,1894,17,1529,30,45,1788,1634,58,2139,59,1538,1847,1253,64,1942,69,72,77,1540,1541,2094,79,1267,1789,2108,1944,1943,1268,2062,1945,96,2119,1946,1817,1528,1947,116,124,125,2103,1949,1950,2133,130,131,135,141,1804,1659,156,158,170,174,183,1952,2087,1953,192,195,2064,2072,1954,1955,1557,2142,203,207,208,211,2091,2102,2106,1963,227,221,222,1990,1956,230,1957,252,1958,257,258,2100,1853,263,264,265,10,1563,271,2144,276,280,2056,1959,1960,2078,293,1961,1802,2075,297,301,1306,1313,317,1806,319,1662,2067,1964,1567,1965,1966,1319,321,324,2140,1569,335,1967,2130,1705,1968,1040,356,2088,361,2085,364,2143,365,2096,1862,1572,1969,372,1970,1326,1971,378,1332,1574,402,1972,2135,1973,2071,1840,1342,410,1576,2063,1405,1871,1346,1784,424,1974,425,1035,1976,2079,426,1351,1977,1978,432,1873,433,434,1578,1826,1979,1980,1834,1899,1981,1982,1364,1372,2111,450,1996,2116,451,454,455,462,1907,1585,1666,1551,1816,1627,1983,493,494,498,1377,1868,513,515,517,2077,2131,1984,1590,520,1667,522,527,530,1985,532,1986,540,1591,1668,1904,544,1592,1987,556,2115,1593,1594,559,1914,1988,1381,2098,1721,2083,571,573,1882,582,586,1989,1928,594,595,1874,1601,2069,1991,1931,1602,601,610,2068,2090,612,1605,1992,1993,1994,1995,2122,1997,1396,627,626,642,643,647,658,1998,1999,2000,672,2001,1919,2002,376,2003,686,702,1818,733,2007,691,707,1611,1612,2004,719,1676,2005,720,2006,1416,734,2008,2092,2009,746,1866,2010,754,758,2011,763,2129,779,784,1426,1821,2128,789,2012,1837,1616,2013,2014,2070,809,813,1618,817,818,1619,2065,824,825,2073,826,2095,835,2121,2101,2109,839,843,2015,854,2016,2017,864,42,872,875,876,880,2021,1621,2022,2086,2093,2023,896,1440,2024,2025,901,907,2026,912,1625,2137,2027,2127,922,2105,2028,935,936,939,940,2029,947,950,952,960,964,2030,2107,979,2138,2031,1447,2032,2034,994,1856,997,2033,1000,1021,2035,1023,1631,2082,1454,2036,2037,2038,2039,2104,2040,1633,2076,1466,1467,1049,1050,1948,1051,1635,2042,1061,1070,1071,1962,1878,1479,1076,1636,2080,1081,2043,1099,1766,2044,2045,1103,2134,1767,2046,1909,1488,1123,1490,1124,1491,2097,1133,2099,2047,1495,1139,104,2048,1144,2049,1157,1499,1169,1500,1502,1505,2118,2110,1171,1172,1179,2050,2051,2052,1940,1939,1184,1646,1647,2053,1194,2054,1200,1202,2066,1211,1212,1649,1651,1218,2057,2058,1221,1652,2059,2060,1622,1515,2074,1684,2061,1225,1522,2136,1240,1780,1243
trovati 502 record corrispondenti
2081,1787,1941,12,13,16,2089,1894,17,1529,30,45,1788,1634,58,2139,59,1538,1847,1253,64,1942,69,72,77,1540,1541,2094,79,1267,1789,2108,1944,1943,1268,2062,1945,96,2119,1946,1817,1528,1947,116,124,125,2103,1949,1950,2133,130,131,135,141,1804,1659,156,158,170,174,183,1952,2087,1953,192,195,2064,2072,1954,1955,1557,2142,203,207,208,211,2091,2102,2106,1963,227,221,222,1990,1956,230,1957,252,1958,257,258,2100,1853,263,264,265,10,1563,271,2144,276,280,2056,1959,1960,2078,293,1961,1802,2075,297,301,1306,1313,317,1806,319,1662,2067,1964,1567,1965,1966,1319,321,324,2140,1569,335,1967,2130,1705,1968,1040,356,2088,361,2085,364,2143,365,2096,1862,1572,1969,372,1970,1326,1971,378,1332,1574,402,1972,2135,1973,2071,1840,1342,410,1576,2063,1405,1871,1346,1784,424,1974,425,1035,1976,2079,426,1351,1977,1978,432,1873,433,434,1578,1826,1979,1980,1834,1899,1981,1982,1364,1372,2111,450,1996,2116,451,454,455,462,1907,1585,1666,1551,1816,1627,1983,493,494,498,1377,1868,513,515,517,2077,2131,1984,1590,520,1667,522,527,530,1985,532,1986,540,1591,1668,1904,544,1592,1987,556,2115,1593,1594,559,1914,1988,1381,2098,1721,2083,571,573,1882,582,586,1989,1928,594,595,1874,1601,2069,1991,1931,1602,601,610,2068,2090,612,1605,1992,1993,1994,1995,2122,1997,1396,627,626,642,643,647,658,1998,1999,2000,672,2001,1919,2002,376,2003,686,702,1818,733,2007,691,707,1611,1612,2004,719,1676,2005,720,2006,1416,734,2008,2092,2009,746,1866,2010,754,758,2011,763,2129,779,784,1426,1821,2128,789,2012,1837,1616,2013,2014,2070,809,813,1618,817,818,1619,2065,824,825,2073,826,2095,835,2121,2101,2109,839,843,2015,854,2016,2017,864,42,872,875,876,880,2021,1621,2022,2086,2093,2023,896,1440,2024,2025,901,907,2026,912,1625,2137,2027,2127,922,2105,2028,935,936,939,940,2029,947,950,952,960,964,2030,2107,979,2138,2031,1447,2032,2034,994,1856,997,2033,1000,1021,2035,1023,1631,2082,1454,2036,2037,2038,2039,2104,2040,1633,2076,1466,1467,1049,1050,1948,1051,1635,2042,1061,1070,1071,1962,1878,1479,1076,1636,2080,1081,2043,1099,1766,2044,2045,1103,2134,1767,2046,1909,1488,1123,1490,1124,1491,2097,1133,2099,2047,1495,1139,104,2048,1144,2049,1157,1499,1169,1500,1502,1505,2118,2110,1171,1172,1179,2050,2051,2052,1940,1939,1184,1646,1647,2053,1194,2054,1200,1202,2066,1211,1212,1649,1651,1218,2057,2058,1221,1652,2059,2060,1622,1515,2074,1684,2061,1225,1522,2136,1240,1780,1243

pagina=37|num_pagine=51|num_records=502

37 / 51



pagina 37 di 51