06/03/2024 10:04:04 am >> SELECT document_num FROM ps_document WHERE document_num = '650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 10:04:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '650' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 06/03/2024 10:04:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90635' 06/03/2024 10:04:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90635' 06/03/2024 10:04:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90635' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 06/03/2024 10:19:19 am >> SELECT document_num FROM ps_document WHERE document_num = '651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 10:19:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '651' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.00' , '94.76' , NOW() , NOW() ) 06/03/2024 10:19:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90636' 06/03/2024 10:19:19 am >> DELETE FROM ps_document_detail WHERE id_document = '90636' 06/03/2024 10:19:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90636' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '78.1' , '64.016393442623' , '22' , '0' , '78.10' ) 06/03/2024 10:19:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90636' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/03/2024 10:19:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90636' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '14' , '-14' , '4' , '0.70' , '0.7' , '0' , '0' , '9.80' ) 06/03/2024 10:19:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90636' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/03/2024 10:52:06 am >> SELECT document_num FROM ps_document WHERE document_num = '652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 10:52:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '652' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '494.00' , '408.82' , NOW() , NOW() ) 06/03/2024 10:52:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90637' 06/03/2024 10:52:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90637' 06/03/2024 10:52:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 06/03/2024 10:52:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/03/2024 10:52:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 06/03/2024 10:52:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 06/03/2024 10:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.00' , '94.262295081967' , '22' , '0' , '115.00' ) 06/03/2024 10:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '100.00' ) 06/03/2024 10:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '52.00' ) 06/03/2024 10:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 06/03/2024 10:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '69.8' , '57.213114754098' , '22' , '0' , '69.80' ) 06/03/2024 10:58:42 am >> SELECT document_num FROM ps_document WHERE document_num = '653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 10:58:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '653' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.40' , '15.90' , NOW() , NOW() ) 06/03/2024 10:58:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90638' 06/03/2024 10:58:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90638' 06/03/2024 10:58:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90638' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 06/03/2024 10:58:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90638' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 06/03/2024 11:02:07 am >> SELECT document_num FROM ps_document WHERE document_num = '654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:02:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '654' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '10.61' , NOW() , NOW() ) 06/03/2024 11:02:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90639' 06/03/2024 11:02:07 am >> DELETE FROM ps_document_detail WHERE id_document = '90639' 06/03/2024 11:02:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90639' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 06/03/2024 11:02:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90639' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 06/03/2024 11:22:00 am >> SELECT document_num FROM ps_document WHERE document_num = '655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:22:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '655' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.50' , '120.67' , NOW() , NOW() ) 06/03/2024 11:22:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90640' 06/03/2024 11:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '90640' 06/03/2024 11:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90640' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 06/03/2024 11:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90640' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 06/03/2024 11:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90640' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '10' , '-10' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '43.00' ) 06/03/2024 11:25:32 am >> SELECT document_num FROM ps_document WHERE document_num = '656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:25:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '656' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.16' , '66.16' , NOW() , NOW() ) 06/03/2024 11:25:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90641' 06/03/2024 11:25:32 am >> DELETE FROM ps_document_detail WHERE id_document = '90641' 06/03/2024 11:25:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '22192' , 'PREGHIERA DI GESU' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/03/2024 11:25:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '22191' , 'PREGARE CON I SALMI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/03/2024 11:25:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '10' , '10' , '0' , '0' , '50.00' ) 06/03/2024 11:32:24 am >> SELECT document_num FROM ps_document WHERE document_num = '657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:32:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '657' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 06/03/2024 11:32:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90642' 06/03/2024 11:32:24 am >> DELETE FROM ps_document_detail WHERE id_document = '90642' 06/03/2024 11:32:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90642' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 06/03/2024 11:38:15 am >> SELECT document_num FROM ps_document WHERE document_num = '658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:38:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '658' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.85' , '23.64' , NOW() , NOW() ) 06/03/2024 11:38:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90643' 06/03/2024 11:38:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90643' 06/03/2024 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '22124' , 'UNA CAREZZA PER TUTTI - R. SEREGNI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 06/03/2024 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 06/03/2024 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 06/03/2024 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/03/2024 11:38:41 am >> SELECT document_num FROM ps_document WHERE document_num = '659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:38:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '659' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 06/03/2024 11:38:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90644' 06/03/2024 11:38:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90644' 06/03/2024 11:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90644' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 06/03/2024 11:45:41 am >> SELECT document_num FROM ps_document WHERE document_num = '660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:45:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '660' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.30' , '38.30' , NOW() , NOW() ) 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90645' 06/03/2024 11:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90645' 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90645' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90645' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90645' , '22191' , 'PREGARE CON I SALMI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90645' , '22192' , 'PREGHIERA DI GESU' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/03/2024 11:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90645' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/03/2024 11:58:17 am >> SELECT document_num FROM ps_document WHERE document_num = '661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 11:58:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '661' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 06/03/2024 11:58:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90646' 06/03/2024 11:58:17 am >> DELETE FROM ps_document_detail WHERE id_document = '90646' 06/03/2024 11:58:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90646' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 06/03/2024 12:41:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 12:41:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '662' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 06/03/2024 12:41:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90647' 06/03/2024 12:41:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90647' 06/03/2024 12:41:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90647' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 06/03/2024 12:54:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 12:54:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '663' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 06/03/2024 12:54:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90648' 06/03/2024 12:54:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '90648' 06/03/2024 12:54:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90648' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/03/2024 02:39:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001604' AND id_product != '17617' AND ean13 != '' 06/03/2024 02:39:50 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '001604', date_upd = NOW() WHERE id_product = '17617' 06/03/2024 02:39:50 pm >> UPDATE ps_product_lang SET name = 'IMMAGINI ISONZO X 100', description = '' WHERE id_product = '17617' 06/03/2024 02:39:50 pm >> UPDATE ps_product SET wholesale_price = '1.61', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '17617' 06/03/2024 02:39:50 pm >> UPDATE ps_product_shop SET wholesale_price = '1.61', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17617' 06/03/2024 02:39:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '17617' 06/03/2024 02:40:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'ISONZO125' AND id_product != '14136' AND ean13 != '' 06/03/2024 02:40:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'ISONZO125', date_upd = NOW() WHERE id_product = '14136' 06/03/2024 02:40:10 pm >> UPDATE ps_product_lang SET name = 'MADONNA DEL ROSARIO DI POMPEI - 125', description = '' WHERE id_product = '14136' 06/03/2024 02:40:10 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '14136' 06/03/2024 02:40:10 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14136' 06/03/2024 02:40:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '14136' 06/03/2024 02:40:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859016228' AND id_product != '18679' AND ean13 != '' 06/03/2024 02:40:32 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859016228', date_upd = NOW() WHERE id_product = '18679' 06/03/2024 02:40:32 pm >> UPDATE ps_product_lang SET name = 'ADORAZIONE DEI MAGI - 332', description = '' WHERE id_product = '18679' 06/03/2024 02:40:32 pm >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '18679' 06/03/2024 02:40:32 pm >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18679' 06/03/2024 02:40:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '18679' 06/03/2024 02:53:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859002757' AND id_product != '765' AND ean13 != '' 06/03/2024 02:53:11 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859002757', date_upd = NOW() WHERE id_product = '765' 06/03/2024 02:53:11 pm >> UPDATE ps_product_lang SET name = 'ASCENSIONE - 195', description = '' WHERE id_product = '765' 06/03/2024 02:53:11 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '765' 06/03/2024 02:53:11 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '765' 06/03/2024 02:53:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '765' 06/03/2024 02:53:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001811' AND id_product != '18796' AND ean13 != '' 06/03/2024 02:53:22 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001811', date_upd = NOW() WHERE id_product = '18796' 06/03/2024 02:53:22 pm >> UPDATE ps_product_lang SET name = 'BORDO PER COTTA - MPBR06R05', description = '' WHERE id_product = '18796' 06/03/2024 02:53:22 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '18796' 06/03/2024 02:53:22 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '440', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18796' 06/03/2024 02:53:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '18796' 06/03/2024 02:53:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002045' AND id_product != '1290' AND ean13 != '' 06/03/2024 02:53:30 pm >> UPDATE ps_product SET id_supplier = '60', reference = '2016', ean13 = '002045', date_upd = NOW() WHERE id_product = '1290' 06/03/2024 02:53:30 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE 7 DONI - 820/07', description = '' WHERE id_product = '1290' 06/03/2024 02:53:30 pm >> UPDATE ps_product SET wholesale_price = '1.26', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '1290' 06/03/2024 02:53:30 pm >> UPDATE ps_product_shop SET wholesale_price = '1.26', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1290' 06/03/2024 02:53:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '1290' 06/03/2024 02:53:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002045' AND id_product != '1290' AND ean13 != '' 06/03/2024 02:53:41 pm >> UPDATE ps_product SET id_supplier = '60', reference = '2016', ean13 = '002045', date_upd = NOW() WHERE id_product = '1290' 06/03/2024 02:53:41 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE 7 DONI - 820/07', description = '' WHERE id_product = '1290' 06/03/2024 02:53:41 pm >> UPDATE ps_product SET wholesale_price = '1.26', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '1290' 06/03/2024 02:53:41 pm >> UPDATE ps_product_shop SET wholesale_price = '1.26', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1290' 06/03/2024 02:53:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '1290' 06/03/2024 02:57:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 02:57:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '664' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 06/03/2024 02:57:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90649' 06/03/2024 02:57:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '90649' 06/03/2024 02:57:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90649' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 06/03/2024 03:08:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 03:08:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '665' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.50' , '87.80' , NOW() , NOW() ) 06/03/2024 03:08:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90650' 06/03/2024 03:08:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90650' 06/03/2024 03:08:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90650' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 06/03/2024 03:08:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90650' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '53.70' ) 06/03/2024 03:08:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90650' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 06/03/2024 03:08:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 03:08:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '666' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.55' , '46.55' , NOW() , NOW() ) 06/03/2024 03:08:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90651' 06/03/2024 03:08:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90651' 06/03/2024 03:08:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90651' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/03/2024 03:08:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90651' , '22171' , 'AMORE DI DIO E PER TUTTI - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/03/2024 03:08:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90651' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 06/03/2024 03:15:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 03:15:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '48' , '2024-03-06' , '' , '2755' , '0' , '4677545' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '60.80' , '60.80' , NOW() , NOW() ) 06/03/2024 03:15:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90652' 06/03/2024 03:15:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90652' 06/03/2024 03:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90652' , '22202' , 'MANUALE DEL PERFETTO CHIERICHETTO - D. COSO' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '5' , '22.80' ) 06/03/2024 03:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90652' , '15471' , 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.65' ) 06/03/2024 03:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90652' , '22208' , '7X3 GIORNATE EUCARISTICHE - G. RIZZI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 06/03/2024 03:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90652' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 06/03/2024 03:25:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 03:25:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '667' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '18.36' , NOW() , NOW() ) 06/03/2024 03:25:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90653' 06/03/2024 03:25:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90653' 06/03/2024 03:25:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90653' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 06/03/2024 03:25:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90653' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '1' , '-1' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '17.50' ) 06/03/2024 04:52:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 04:52:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '668' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.58' , '18.58' , NOW() , NOW() ) 06/03/2024 04:52:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90654' 06/03/2024 04:52:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90654' 06/03/2024 04:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90654' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 06/03/2024 04:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90654' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 06/03/2024 05:09:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 05:09:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '669' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.50' , '94.67' , NOW() , NOW() ) 06/03/2024 05:09:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90655' 06/03/2024 05:09:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90655' 06/03/2024 05:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90655' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 06/03/2024 05:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90655' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 06/03/2024 05:24:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 05:24:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '670' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 06/03/2024 05:24:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90656' 06/03/2024 05:24:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90656' 06/03/2024 05:24:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90656' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 06/03/2024 05:24:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90656' , '11151' , 'LIBRI' , '20' , '-20' , '4' , '0.05' , '0.05' , '0' , '0' , '1.00' ) 06/03/2024 05:41:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 06/03/2024 05:41:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '671' , '2024-03-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.70' , '2.21' , NOW() , NOW() ) 06/03/2024 05:41:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90657' 06/03/2024 05:41:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '90657' 06/03/2024 05:41:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90657' , '20160' , 'BRACCIALE IN CORDA E METALLO - 800/328' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 06/03/2024 05:41:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90657' , '9714' , 'SCATOLA OTTOGONALE - 7328' , '2' , '-2' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '1.40' ) 06/03/2024 05:58:17 pm >> DELETE FROM ps_document WHERE id_document = '90438' 06/03/2024 05:58:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90438'