05/06/2024 08:48:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1808' AND id_document != '92071' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-30') 05/06/2024 08:48:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1808', document_date = '2024-05-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.50', price_tax_excluded = '2.87', date_upd = NOW() WHERE id_document = '92071' 05/06/2024 08:48:01 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 = '92071' 05/06/2024 08:48:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92071' 05/06/2024 08:48:01 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 ( '92071' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 05/06/2024 09:58:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 09:58:43 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' , '1875' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.70' , '10.41' , NOW() , NOW() ) 05/06/2024 09:58:43 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 = '92156' 05/06/2024 09:58:43 am >> DELETE FROM ps_document_detail WHERE id_document = '92156' 05/06/2024 09:58:43 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 ( '92156' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '13' , '-13' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '9.10' ) 05/06/2024 09:58:43 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 ( '92156' , '12685' , 'SACRO CUORE - 209' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/06/2024 10:12:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1664' AND id_document != '91897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 05/06/2024 10:12:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1664', document_date = '2024-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '46.25', price_tax_excluded = '39.65', date_upd = NOW() WHERE id_document = '91897' 05/06/2024 10:12:44 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 = '91897' 05/06/2024 10:12:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91897' 05/06/2024 10:12:44 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 ( '91897' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/06/2024 10:12:44 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 ( '91897' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/06/2024 10:12:44 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 ( '91897' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 05/06/2024 10:12:44 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 ( '91897' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 05/06/2024 10:22:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 10:22:35 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' , '1876' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '252.20' , '211.84' , NOW() , NOW() ) 05/06/2024 10:22:35 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 = '92157' 05/06/2024 10:22:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92157' 05/06/2024 10:22:35 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 ( '92157' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '175' , '143.44262295082' , '22' , '0' , '175.00' ) 05/06/2024 10:22:35 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 ( '92157' , '22337' , 'CROCE IN POLIMERO - 2748' , '15' , '-15' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '37.50' ) 05/06/2024 10:22:35 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 ( '92157' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 05/06/2024 10:22:35 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 ( '92157' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/06/2024 10:22:35 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 ( '92157' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 05/06/2024 10:22:35 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 ( '92157' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/06/2024 10:22:35 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 ( '92157' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 05/06/2024 10:22:35 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 ( '92157' , '12685' , 'SACRO CUORE - 209' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/06/2024 10:43:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 10:43:39 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' , '1877' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.40' , '69.79' , NOW() , NOW() ) 05/06/2024 10:43:39 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 = '92158' 05/06/2024 10:43:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92158' 05/06/2024 10:43:39 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 ( '92158' , '8179' , 'PORTACORONA - 017' , '1' , '-1' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '1.70' ) 05/06/2024 10:43:39 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 ( '92158' , '22336' , 'CALAMITE ' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 05/06/2024 10:43:39 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 ( '92158' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 05/06/2024 10:43:39 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 ( '92158' , '16970' , 'PELLEGRINI DI MARIA - GIOCO' , '1' , '-1' , '4' , '19.90' , '19.9' , '0' , '0' , '19.90' ) 05/06/2024 10:43:39 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 ( '92158' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 05/06/2024 10:43:39 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 ( '92158' , '7436' , 'PANE DI SANTANTONIO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/06/2024 11:02:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 11:02: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' , '1878' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.50' , '53.71' , NOW() , NOW() ) 05/06/2024 11:02: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 = '92159' 05/06/2024 11:02:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92159' 05/06/2024 11:02:32 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 ( '92159' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 05/06/2024 11:02:32 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 ( '92159' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/06/2024 11:03:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 11:03:10 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' , '1879' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 05/06/2024 11:03:10 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 = '92160' 05/06/2024 11:03:10 am >> DELETE FROM ps_document_detail WHERE id_document = '92160' 05/06/2024 11:03:10 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 ( '92160' , '19463' , 'PIATTINO CM 18 - 1006/18' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 05/06/2024 11:03:10 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 ( '92160' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/06/2024 11:23:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1291' AND id_document != '91441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-26') 05/06/2024 11:23:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1291', document_date = '2024-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.80', price_tax_excluded = '3.93', date_upd = NOW() WHERE id_document = '91441' 05/06/2024 11:23:08 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 = '91441' 05/06/2024 11:23:08 am >> DELETE FROM ps_document_detail WHERE id_document = '91441' 05/06/2024 11:23:08 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 ( '91441' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '1.60' ) 05/06/2024 11:23:08 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 ( '91441' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 05/06/2024 11:23:08 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 ( '91441' , '16132' , 'DECINA IN METALLO - M0123' , '2' , '-2' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.80' ) 05/06/2024 11:47:23 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 ( '32' , '6224728425' , '2024-05-31' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.51' , '171.51' , NOW() , NOW() ) 05/06/2024 11:47:23 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 = '92161' 05/06/2024 11:47:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92161' 05/06/2024 11:47:23 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 ( '92161' , '22534' , 'GIOISCI MARIA - A. AMAPANI' , '1' , '0' , '4' , '2.85' , '2.85' , '0' , '0' , '2.8500' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22534' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22534' , '177' , '1' ) 05/06/2024 11:47:23 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 ( '92161' , '22535' , 'CARA GIULIA ' , '1' , '0' , '4' , '10.67' , '10.67' , '0' , '0' , '10.6700' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22535' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22535' , '177' , '1' ) 05/06/2024 11:47:23 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 ( '92161' , '21780' , 'FRATELLINO' , '1' , '0' , '4' , '8.54' , '8.54' , '0' , '0' , '8.5400' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 05/06/2024 11:47:23 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 ( '92161' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '0' , '4' , '13.52' , '13.52' , '0' , '0' , '13.5200' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '177' , '1' ) 05/06/2024 11:47:23 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 ( '92161' , '22536' , 'MESSA E SBIADITA - L. DIOTALLEVI' , '2' , '0' , '4' , '9.5' , '9.5' , '0' , '0' , '19.0000' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22536' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22536' , '177' , '1' ) 05/06/2024 11:47:23 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 ( '92161' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '1' , '0' , '4' , '8.54' , '8.54' , '0' , '0' , '8.5400' ) 05/06/2024 11:47:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 05/06/2024 11:47:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '2' , '0' , '4' , '7.76' , '7.76' , '0' , '0' , '15.5200' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20326' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20326' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '22537' , 'HAI LA MIA PAROLA! ' , '2' , '0' , '4' , '11.69' , '11.69' , '0' , '0' , '23.3800' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22537' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22537' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '22538' , 'IMPLOSIONE DI UNA RELIGIONE - B. MORI' , '1' , '0' , '4' , '15.19' , '15.19' , '0' , '0' , '15.1900' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22538' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22538' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '22539' , 'PER UN CRISTIANESIMO SENZA RELIGIONE - B. MORI' , '1' , '0' , '4' , '14.05' , '14.05' , '0' , '0' , '14.0500' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22539' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22539' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '22541' , 'PORTA DI MEZZO ' , '1' , '0' , '4' , '11.25' , '11.25' , '0' , '0' , '11.2500' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22541' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22541' , '177' , '1' ) 05/06/2024 11:47: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 ( '92161' , '17893' , 'POTENZA DELLA LODE - M. CAROTHERS' , '2' , '0' , '4' , '7.5' , '7.5' , '0' , '0' , '15.0000' ) 05/06/2024 11:47:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '17893' AND id_supplier = '177' 05/06/2024 11:47:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17893' , '177' , '1' ) 05/06/2024 11:49:36 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 ( '32' , '1208' , '2024-05-31' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '16.51' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '38.91' , '38.91' , NOW() , NOW() ) 05/06/2024 11:49:36 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 = '92162' 05/06/2024 11:49:36 am >> DELETE FROM ps_document_detail WHERE id_document = '92162' 05/06/2024 11:49:36 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 ( '92162' , '22510' , 'DA CUORE A CUORE - M. CROVETTO' , '1' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '9.8000' ) 05/06/2024 11:49:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22510' AND id_supplier = '47' 05/06/2024 11:49:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22510' , '47' , '1' ) 05/06/2024 11:49:36 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 ( '92162' , '22432' , 'IN SINU JESU' , '1' , '0' , '4' , '12.6' , '12.6' , '0' , '0' , '12.6000' ) 05/06/2024 11:49:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47' 05/06/2024 11:49:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' ) 05/06/2024 11:49:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 11:49:59 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' , '1880' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 05/06/2024 11:49:59 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 = '92163' 05/06/2024 11:49:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92163' 05/06/2024 11:49:59 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 ( '92163' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 05/06/2024 12:01:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 12:01:02 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' , '1881' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '14.54' , NOW() , NOW() ) 05/06/2024 12:01:02 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 = '92164' 05/06/2024 12:01:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92164' 05/06/2024 12:01:02 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 ( '92164' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 05/06/2024 12:01:02 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 ( '92164' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 05/06/2024 12:01:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 12:01:59 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' , '1882' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 05/06/2024 12:01:59 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 = '92165' 05/06/2024 12:01:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92165' 05/06/2024 12:01:59 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 ( '92165' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 05/06/2024 12:05:29 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 ( '32' , '6024218918' , '2024-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.76' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '96.99' , '96.99' , NOW() , NOW() ) 05/06/2024 12:05:29 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 = '92166' 05/06/2024 12:05:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '92166' 05/06/2024 12:05:30 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 ( '92166' , '5780' , 'LEZIONARIO QUOTIDIANO 4' , '1' , '0' , '4' , '23.9' , '23.9' , '0' , '0' , '23.9000' ) 05/06/2024 12:05:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5780' AND id_supplier = '109' 05/06/2024 12:05:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5780' , '109' , '1' ) 05/06/2024 12:05:30 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 ( '92166' , '5779' , 'LEZIONARIO QUOTIDIANO 3' , '1' , '0' , '4' , '24.58' , '24.58' , '0' , '0' , '24.5800' ) 05/06/2024 12:05:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5779' AND id_supplier = '109' 05/06/2024 12:05:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5779' , '109' , '1' ) 05/06/2024 12:05:30 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 ( '92166' , '5778' , 'LEZIONARIO QUOTIDIANO 2' , '1' , '0' , '4' , '21.85' , '21.85' , '0' , '0' , '21.8500' ) 05/06/2024 12:05:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5778' AND id_supplier = '109' 05/06/2024 12:05:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5778' , '109' , '1' ) 05/06/2024 12:05:30 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 ( '92166' , '5777' , 'LEZIONARIO QUOTIDIANO 1' , '1' , '0' , '4' , '23.9' , '23.9' , '0' , '0' , '23.9000' ) 05/06/2024 12:05:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5777' AND id_supplier = '109' 05/06/2024 12:05:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5777' , '109' , '1' ) 05/06/2024 12:08: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 ( '32' , '6024218917' , '2024-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.2' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '79.39' , '79.39' , NOW() , NOW() ) 05/06/2024 12:08: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 = '92167' 05/06/2024 12:08:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92167' 05/06/2024 12:08: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 ( '92167' , '22040' , 'LOTTANDO INSIEME A GIOBBE - P. RIBET' , '2' , '0' , '4' , '12.595' , '12.595' , '0' , '0' , '25.1900' ) 05/06/2024 12:08:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22040' AND id_supplier = '109' 05/06/2024 12:08:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22040' , '109' , '1' ) 05/06/2024 12:08: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 ( '92167' , '22457' , 'GRANDE SINFONIA DI PREGHIERA - L. MAROTTA' , '1' , '0' , '4' , '10.5' , '10.5' , '0' , '0' , '10.5000' ) 05/06/2024 12:08:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22457' AND id_supplier = '109' 05/06/2024 12:08:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22457' , '109' , '1' ) 05/06/2024 12:08: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 ( '92167' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '1' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '9.8000' ) 05/06/2024 12:08:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 05/06/2024 12:08:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 05/06/2024 12:08: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 ( '92167' , '22571' , 'BENEDETTO IL GIORNO CHE ABBIAMO SBAGLIATO - C. MIRIANO' , '1' , '0' , '4' , '11.39' , '11.39' , '0' , '0' , '11.3900' ) 05/06/2024 12:08:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22571' AND id_supplier = '109' 05/06/2024 12:08:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22571' , '109' , '1' ) 05/06/2024 12:08: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 ( '92167' , '17421' , 'DIALOGO DELLA DIVINA PROVVIDENZA ' , '1' , '0' , '4' , '20.31' , '20.31' , '0' , '0' , '20.3100' ) 05/06/2024 12:08:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17421' AND id_supplier = '109' 05/06/2024 12:08:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17421' , '109' , '1' ) 05/06/2024 12:10:06 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 ( '32' , '6024218916' , '2024-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '16.38' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '481.00' , '481.00' , NOW() , NOW() ) 05/06/2024 12:10:06 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 = '92168' 05/06/2024 12:10:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92168' 05/06/2024 12:10:06 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 ( '92168' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '5' , '0' , '4' , '19.856' , '19.856' , '0' , '0' , '99.2800' ) 05/06/2024 12:10:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22331' AND id_supplier = '109' 05/06/2024 12:10:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22331' , '109' , '1' ) 05/06/2024 12:10:06 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 ( '92168' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '2' , '0' , '4' , '29.5' , '29.5' , '0' , '0' , '59.0000' ) 05/06/2024 12:10:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 05/06/2024 12:10:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 05/06/2024 12:10:06 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 ( '92168' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '5' , '0' , '4' , '18.154' , '18.154' , '0' , '0' , '90.7700' ) 05/06/2024 12:10:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22283' AND id_supplier = '109' 05/06/2024 12:10:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22283' , '109' , '1' ) 05/06/2024 12:10:06 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 ( '92168' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '10' , '0' , '4' , '21.557' , '21.557' , '0' , '0' , '215.5700' ) 05/06/2024 12:10:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 05/06/2024 12:10:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '32' , '6024218915' , '2024-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.16' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '105.76' , '105.76' , NOW() , NOW() ) 05/06/2024 12:15:05 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 = '92169' 05/06/2024 12:15:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92169' 05/06/2024 12:15:05 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 ( '92169' , '22575' , 'CONVERSAZIONI SUL VANGELO DI GIOVANNI - G. SANDRI' , '1' , '0' , '4' , '14.29' , '14.29' , '0' , '0' , '14.2900' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22575' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22575' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22572' , '5 MINUTI AL GIORNO PER UNA VITA PIENA - R. CARTA' , '1' , '0' , '4' , '8.44' , '8.44' , '0' , '0' , '8.4400' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22572' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22572' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22573' , 'UOMO DAVANTI LA SUA MORTE - M. GOUTIERRE' , '1' , '0' , '4' , '10.4' , '10.4' , '0' , '0' , '10.4000' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22573' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22573' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22574' , 'CANTO DELLA VITA - P. PROSPERI' , '1' , '0' , '4' , '11.04' , '11.04' , '0' , '0' , '11.0400' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22574' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22574' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22570' , 'IN TERRA SANTA - G. RAVASI' , '1' , '0' , '4' , '9.68' , '9.68' , '0' , '0' , '9.6800' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22570' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22570' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '21340' , 'ECCO LAGNELLO DI DIO - M.D. GOUTIERRE' , '1' , '0' , '4' , '11.7' , '11.7' , '0' , '0' , '11.7000' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21340' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21340' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22664' , 'LAUDATE DOMINUM' , '1' , '0' , '4' , '16.9' , '16.9' , '0' , '0' , '16.9000' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22664' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22664' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22665' , 'DOMANDE CHE NON TI HO FATTO - FRATINI/SEGHEDONI' , '1' , '0' , '4' , '7.8' , '7.8' , '0' , '0' , '7.8000' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22665' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22665' , '109' , '1' ) 05/06/2024 12:15:05 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 ( '92169' , '22666' , 'DIECI COMANDAMENTI - M. COOGAN' , '1' , '0' , '4' , '12.35' , '12.35' , '0' , '0' , '12.3500' ) 05/06/2024 12:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22666' AND id_supplier = '109' 05/06/2024 12:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22666' , '109' , '1' ) 05/06/2024 12:18:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 12:18: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' , '1883' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 05/06/2024 12:18: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 = '92170' 05/06/2024 12:18:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92170' 05/06/2024 12:18: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 ( '92170' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/06/2024 12:27:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 12:27:02 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' , '1884' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.64' , '64.64' , NOW() , NOW() ) 05/06/2024 12:27:02 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 = '92171' 05/06/2024 12:27:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92171' 05/06/2024 12:27:02 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 ( '92171' , '22111' , 'PREGARE OGGI - 1' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22290' , 'CHIESA IN PREGHIERA - 6' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:27:02 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 ( '92171' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 05/06/2024 12:29:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 12:29:25 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' , '1885' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.50' , '116.86' , NOW() , NOW() ) 05/06/2024 12:29:25 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 = '92172' 05/06/2024 12:29:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92172' 05/06/2024 12:29:25 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 ( '92172' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '16' , '-16' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '108.80' ) 05/06/2024 12:29:26 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 ( '92172' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' , '-1' , '1' , '6.2' , '5.0819672131148' , '22' , '0' , '6.20' ) 05/06/2024 12:29:26 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 ( '92172' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/06/2024 12:29:26 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 ( '92172' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 05/06/2024 12:51:34 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 ( '31' , '129/A' , '2024-06-05' , 'A' , '0' , '116' , '4669160' , 'VIA SAN DOMENICO snc 80044 OTTAVIANO' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '105.56' , '86.53' , NOW() , NOW() ) 05/06/2024 12:51:34 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 = '92173' 05/06/2024 12:51:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '92173' 05/06/2024 12:51:34 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 ( '92173' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '15' , '15' , '1' , '6.5' , '5.327868852459' , '22' , '45' , '65.4225' ) 05/06/2024 12:51:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '116' 05/06/2024 12:51:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '116' , '1' ) 05/06/2024 12:51:34 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 ( '92173' , '20487' , 'STELLARIO CM 14 - ART. 70' , '5' , '5' , '1' , '7.6' , '6.2295081967213' , '22' , '45' , '25.4980' ) 05/06/2024 12:51:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20487' AND id_supplier = '116' 05/06/2024 12:51:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20487' , '116' , '1' ) 05/06/2024 03:03:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 03:03:05 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' , '1886' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 05/06/2024 03:03:05 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 = '92174' 05/06/2024 03:03:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92174' 05/06/2024 03:03:05 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 ( '92174' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/06/2024 03:40:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 03:40:56 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' , '1887' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 05/06/2024 03:40:56 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 = '92175' 05/06/2024 03:40:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92175' 05/06/2024 03:40:56 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 ( '92175' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 05/06/2024 03:58:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 03:58:26 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' , '1888' , '2024-06-05' , '' , '0' , '0' , '0' , 'LARGO FRATELLI DEL GIUDICE 37 84069 ROCCADASPIDE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.30' , '225.30' , NOW() , NOW() ) 05/06/2024 03:58:26 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 = '92176' 05/06/2024 03:58:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92176' 05/06/2024 03:58:26 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 ( '92176' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 05/06/2024 03:58:26 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 ( '92176' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 05/06/2024 03:58:26 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 ( '92176' , '18276' , 'CINGOLO CON NODI - 3280' , '6' , '-6' , '0' , '2.5000' , '2.5' , '0' , '0' , '15.00' ) 05/06/2024 03:58:26 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 ( '92176' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '8' , '-8' , '0' , '8.0000' , '8' , '0' , '0' , '64.00' ) 05/06/2024 03:58:26 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 ( '92176' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/06/2024 03:58:26 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 ( '92176' , '22494' , 'BASTA UNO SGUARDO - M. FALABRETTI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/06/2024 04:31:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1845' AND id_document != '92117' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 05/06/2024 04:31:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1845', document_date = '2024-06-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '92117' 05/06/2024 04:31:38 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 = '92117' 05/06/2024 04:31:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92117' 05/06/2024 04:31:38 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 ( '92117' , '21424' , 'STOLA ROMANA S. MOIRE - 7248S' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 05/06/2024 05:01:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 05:01:44 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' , '1889' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/06/2024 05:01:44 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 = '92177' 05/06/2024 05:01:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '92177' 05/06/2024 05:01:44 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 ( '92177' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/06/2024 05:25:54 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '128', document_date = '2022-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4673833', address1 = 'VIA TORRIONE 125 84127 SALERNO', address2 = '', note = 'CONTO DEPOSITO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '24.00', date_upd = NOW() WHERE id_document = '73129' 05/06/2024 05:25:54 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 = '73129' 05/06/2024 05:25:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '73129' 05/06/2024 05:25:54 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 ( '73129' , '19452' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '0' , '4' , '24' , '24' , '0' , '0' , '24.0000' ) 05/06/2024 06:22:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 06:22: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' , '1890' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/06/2024 06:22: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 = '92178' 05/06/2024 06:22:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92178' 05/06/2024 06:22: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 ( '92178' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/06/2024 06:24:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 06:24: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' , '1891' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 05/06/2024 06:24: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 = '92179' 05/06/2024 06:24:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '92179' 05/06/2024 06:24: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 ( '92179' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 05/06/2024 06:34:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 06:34: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' , '1892' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.90' , '8.93' , NOW() , NOW() ) 05/06/2024 06:34: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 = '92180' 05/06/2024 06:34:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92180' 05/06/2024 06:34: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 ( '92180' , '4840' , 'HOLY CARD - MISERICORDIOSO - M0100/G001' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 05/06/2024 06:34: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 ( '92180' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '6' , '-6' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.90' ) 05/06/2024 07:18:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/06/2024 07:18:58 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' , '1893' , '2024-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.70' , '9.82' , NOW() , NOW() ) 05/06/2024 07:18:58 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 = '92181' 05/06/2024 07:18:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '92181' 05/06/2024 07:18:58 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 ( '92181' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 05/06/2024 07:18:58 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 ( '92181' , '7134' , 'NOZIONI E PRECI' , '1' , '-1' , '4' , '1.3' , '1.3' , '0' , '0' , '1.30' ) 05/06/2024 07:18:58 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 ( '92181' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '3' , '-3' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '3.90' ) 05/06/2024 07:18:59 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 ( '92181' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 05/06/2024 07:18:59 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 ( '92181' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '3' , '-3' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '3.90' )