inizio ricerca: '1643';'12';'list'
prefiltro -> and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') ) / filtro -> 1643';'12';'list
1643 : 12 : valore REGEXP '[[:<:]]12[[:>:]]'
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 '[[:<:]]12[[:>:]]' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2010') )
ciclo 1 [1]: trovati 64 record
ciclo 1 [2]: trovati 64 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: 1847,79,1804,1659,1952,211,2106,230,301,319,1346,1784,1826,1834,1981,454,1585,1816,1627,527,1591,1904,1839,2115,1988,586,610,643,376,691,2006,2008,2009,784,2013,1618,1619,2065,854,2016,864,872,2086,2025,912,940,952,964,979,997,1049,1948,1878,1636,1766,1909,1491,104,2049,2118,2050,2052,1651,1684
trovati 64 record corrispondenti
1847,79,1804,1659,1952,211,2106,230,301,319,1346,1784,1826,1834,1981,454,1585,1816,1627,527,1591,1904,1839,2115,1988,586,610,643,376,691,2006,2008,2009,784,2013,1618,1619,2065,854,2016,864,872,2086,2025,912,940,952,964,979,997,1049,1948,1878,1636,1766,1909,1491,104,2049,2118,2050,2052,1651,1684

pagina=7|num_pagine=7|num_records=64

7 / 7



pagina 7 di 7