inizio ricerca: '1643';'4';'list'
prefiltro -> and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') ) / filtro -> 1643';'4';'list
1643 : 4 : valore REGEXP '[[:<:]]4[[:>:]]'
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 '[[:<:]]4[[:>:]]' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') )
ciclo 1 [1]: trovati 78 record
ciclo 1 [2]: trovati 78 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: 17,72,1540,1541,1789,96,116,1949,2087,195,227,258,271,276,280,1306,317,1662,1319,361,1572,1971,424,1974,1372,462,1907,1666,527,1592,556,1593,1882,582,658,1999,691,707,1676,720,734,1866,763,1616,817,818,843,872,880,2022,2026,1625,2105,2031,2032,2035,1454,2076,1051,1635,1070,1081,1767,1490,1495,1139,1874,1157,1502,1171,2053,1212,1652,2059,2061,1225,1522,1240
trovati 78 record corrispondenti
17,72,1540,1541,1789,96,116,1949,2087,195,227,258,271,276,280,1306,317,1662,1319,361,1572,1971,424,1974,1372,462,1907,1666,527,1592,556,1593,1882,582,658,1999,691,707,1676,720,734,1866,763,1616,817,818,843,872,880,2022,2026,1625,2105,2031,2032,2035,1454,2076,1051,1635,1070,1081,1767,1490,1495,1139,1874,1157,1502,1171,2053,1212,1652,2059,2061,1225,1522,1240

pagina=8|num_pagine=8|num_records=78

8 / 8



pagina 8 di 8