inizio ricerca: '1643';'14';'list' 1643 : 14 : valore REGEXP '[[:<:]]14[[:>:]]' 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 '[[:<:]]14[[:>:]]' and codice in (select distinct id_record from site.00119_tags where id_template = '756' and tag in ('2009') ) 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: 13,1529,30,1537,1687,1820,1804,1695,1551,1864,1699,1559,1809,1883,1702,424,1710,1717,498,1828,1718,1720,1595,1914,1721,1724,1725,606,1836,1726,1920,1728,672,1229,1731,1614,745,1869,813,1814,1738,843,857,1739,872,875,1741,879,1849,1624,1747,1748,956,960,1750,1848,1756,1758,1761,1767,1768,1121,1653,1779 trovati 64 record corrispondenti 13,1529,30,1537,1687,1820,1804,1695,1551,1864,1699,1559,1809,1883,1702,424,1710,1717,498,1828,1718,1720,1595,1914,1721,1724,1725,606,1836,1726,1920,1728,672,1229,1731,1614,745,1869,813,1814,1738,843,857,1739,872,875,1741,879,1849,1624,1747,1748,956,960,1750,1848,1756,1758,1761,1767,1768,1121,1653,1779