inizio ricerca: '1643';'3';'list'
1643 : 3 : valore REGEXP '[[:<:]]3[[:>:]]'
insert into tmp.XXtiyxHpMV_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 '[[:<:]]3[[:>:]]' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2009') )
ciclo 1 [1]: trovati 117 record
ciclo 1 [2]: trovati 117 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 tmp.XXtiyxHpMV_temp) order by valore limit 80,10
codici trovati in temp: 774,779,1869,801,809,1619,824,843,1796,1621
trovati 117 record corrispondenti
774,779,1869,801,809,1619,824,843,1796,1621

9 / 12



pagina 9 di 12