inizio ricerca: '1643';'1';'list'
1643 : 1 : valore REGEXP '[[:<:]]1[[:>:]]'
insert into 00119_temp2 select distinct codice from catalogo.00119_desc where id_template='756' and campo='1643' and codice in (select codice from catalogo.00119_pk where id_template='756' and visibile=1) and valore REGEXP '[[:<:]]1[[:>:]]' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') )
ciclo 1 [1]: trovati 123 record
ciclo 1 [2]: trovati 123 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: 1941,58,69,2094,1267,1943,1817,116,1950,141,1804,156,170,183,2064,1954,1955,1557,221,1956,252,1563,276,280,293,297,1313,1806,1963,1567,1966,324,356,364,1969,1326,1972,1973,1840,1871,1974,1977,1578,1834,1899,1982,1364,1372,462,1907,1983,517,1667,1985,1986,540,2083,571,573,1991,1931,601,2068,1605,1994,1997,658,1999,2000,2065,2003,1818,2007,691,1611,1612,2004,2092,1866,758,779,1619,825,826,839,843,2015,2016,875,2021,2086,2024,901,912,2027,939,2029,947,964,2030,979,2031,2036,2037,2038,2039,1633,1050,2042,1076,1103,1767,2046,1909,2047,104,2051,1184,1194,1649,1651,2059,1240
trovati 123 record corrispondenti
1941,58,69,2094,1267,1943,1817,116,1950,141,1804,156,170,183,2064,1954,1955,1557,221,1956,252,1563,276,280,293,297,1313,1806,1963,1567,1966,324,356,364,1969,1326,1972,1973,1840,1871,1974,1977,1578,1834,1899,1982,1364,1372,462,1907,1983,517,1667,1985,1986,540,2083,571,573,1991,1931,601,2068,1605,1994,1997,658,1999,2000,2065,2003,1818,2007,691,1611,1612,2004,2092,1866,758,779,1619,825,826,839,843,2015,2016,875,2021,2086,2024,901,912,2027,939,2029,947,964,2030,979,2031,2036,2037,2038,2039,1633,1050,2042,1076,1103,1767,2046,1909,2047,104,2051,1184,1194,1649,1651,2059,1240

pagina=7|num_pagine=13|num_records=123

7 / 13



pagina 7 di 13