inizio ricerca: '1643';'11';'list' 1643 : 11 : valore REGEXP '[[:<:]]11[[:>:]]' 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 '[[:<:]]11[[:>:]]' and codice in (select distinct codice FROM catalogo.00119_desc WHERE id_template = '756' and valore REGEXP ('valcucine')) and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2009') ) ciclo 1 [1]: trovati 2 record ciclo 1 [2]: trovati 2 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: 1792,1793 trovati 2 record corrispondenti 1792,1793