Home News
inizio ricerca: '1635','1636';'2010-04-18 14:33:52','2010-04-18 14:33:52';'valore<=','valore>='
1635 : 2010-04-18 14:33:52 : valore<= '2010-04-18 14:33:52' insert into 00119_temp2 select distinct codice from catalogo.00119_desc where id_template='751' and campo='1635' and codice in (select codice from catalogo.00119_pk where id_template='751' and lingua='it' and visibile=1) and valore<= '2010-04-18 14:33:52' ciclo 1 [1]: trovati 2 record ciclo 1 [2]: trovati 2 record 1636 : 2010-04-18 14:33:52 : valore>= '2010-04-18 14:33:52' insert into 00119_temp2 select distinct codice from catalogo.00119_desc where id_template='751' and lingua='it' and campo='1636' and valore>= '2010-04-18 14:33:52' and codice in (select codice from 00119_temp) ciclo 2 [1]: trovati 0 record ciclo 2 [2]: trovati 0 record sql che prende i codici: select codice from catalogo.00119_desc where id_template='751' and lingua='it' and campo='1635' and codice in (select codice from 00119_temp) order by valore desc limit 0,10 codici trovati in temp: trovati 0 record corrispondenti |