15/07/2022 08:55:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1314' AND id_document != '56495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 15/07/2022 08:55:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1314', document_date = '2022-04-29', 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 = '165.00', price_tax_excluded = '136.33', date_upd = NOW() WHERE id_document = '56495' 15/07/2022 08:55:58 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 = '56495' 15/07/2022 08:55:58 am >> DELETE FROM ps_document_detail WHERE id_document = '56495' 15/07/2022 08:55:58 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 ( '56495' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 15/07/2022 08:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 15/07/2022 08:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 15/07/2022 08:55:58 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 ( '56495' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 15/07/2022 08:55:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 15/07/2022 08:55:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 15/07/2022 08:55: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 ( '56495' , '13071' , 'ICONA DIPINTA A MANO 22X32' , '1' , '-1' , '1' , '159' , '130.32786885246' , '22' , '0' , '159.00' ) 15/07/2022 08:55:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '13071' AND id_supplier = '' 15/07/2022 08:55:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13071' , '' , '1' ) 15/07/2022 08:59:56 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 08:59:56 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 ( '24' , '51/A' , '2022-07-15' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA BATTIPAGLIA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.70' , '30.59' , NOW() , NOW() ) 15/07/2022 08:59:56 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 = '59691' 15/07/2022 08:59:56 am >> DELETE FROM ps_document_detail WHERE id_document = '59691' 15/07/2022 08:59:56 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 ( '59691' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 15/07/2022 08:59:56 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 ( '59691' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/07/2022 08:59:56 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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 15/07/2022 08:59:56 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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.56' , '0.56' , '0' , '0' , '14.00' ) 15/07/2022 09:22:08 am >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '59687' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-14') 15/07/2022 09:22:08 am >> UPDATE ps_document SET id_document_type = '21', document_num = '105', document_date = '2022-07-14', document_letter = '', id_customer = '2866', id_supplier = '', id_address = '4674412', address1 = 'VIA ROMA, 9 81016 SAN POTITO SANNITICO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '43.00', date_upd = NOW() WHERE id_document = '59687' 15/07/2022 09:22: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 = '59687' 15/07/2022 09:22:08 am >> DELETE FROM ps_document_detail WHERE id_document = '59687' 15/07/2022 09:22: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 ( '59687' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '25' , '-25' , '4' , '1.6000' , '1.6' , '0' , '5' , '38.00' ) 15/07/2022 09:22:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 15/07/2022 09:22:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 15/07/2022 09:49: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 ( '33' , '604819' , '2022-07-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.06' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.12' , '72.12' , NOW() , NOW() ) 15/07/2022 09:49: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 = '59692' 15/07/2022 09:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '59692' 15/07/2022 09:49: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 ( '59692' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 15/07/2022 09:49:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '15939' AND id_supplier = '7' 15/07/2022 09:49:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15939' , '7' , '1' ) 15/07/2022 09:49: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 ( '59692' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 15/07/2022 09:49:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '10060' AND id_supplier = '7' 15/07/2022 09:49:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10060' , '7' , '1' ) 15/07/2022 09:49:20 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 ( '59692' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/07/2022 09:49:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '7' 15/07/2022 09:49:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '7' , '1' ) 15/07/2022 09:49:20 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 ( '59692' , '19377' , 'VANGELO SECONDO MARCO - L. BRUNI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 15/07/2022 09:49:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19377' AND id_supplier = '7' 15/07/2022 09:49:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19377' , '7' , '1' ) 15/07/2022 09:49:20 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 ( '59692' , '19741' , 'PARLARE CON DIO - J. MARTIN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 15/07/2022 09:49:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19741' AND id_supplier = '7' 15/07/2022 09:49:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19741' , '7' , '1' ) 15/07/2022 09:49:20 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 ( '59692' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 15/07/2022 09:49:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18373' AND id_supplier = '7' 15/07/2022 09:49:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18373' , '7' , '1' ) 15/07/2022 10:47:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 10:47: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' , '2275' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.30' , '22.38' , NOW() , NOW() ) 15/07/2022 10:47: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 = '59693' 15/07/2022 10:47:39 am >> DELETE FROM ps_document_detail WHERE id_document = '59693' 15/07/2022 10:47: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 ( '59693' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '8' , '-8' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '22.40' ) 15/07/2022 10:47:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 15/07/2022 10:47:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 15/07/2022 10:47: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 ( '59693' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 15/07/2022 10:47:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/07/2022 10:47:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/07/2022 10:56:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2276' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 10:56:16 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' , '2276' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 15/07/2022 10:56:16 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 = '59694' 15/07/2022 10:56:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59694' 15/07/2022 10:56:16 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 ( '59694' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 15/07/2022 10:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = '' 15/07/2022 10:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' ) 15/07/2022 10:56:16 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 ( '59694' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 15/07/2022 10:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 15/07/2022 10:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 15/07/2022 10:56:16 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 ( '59694' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 15/07/2022 10:56:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 15/07/2022 10:56:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 15/07/2022 10:57:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2277' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 10:57:03 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' , '2277' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '8.42' , NOW() , NOW() ) 15/07/2022 10:57:03 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 = '59695' 15/07/2022 10:57:03 am >> DELETE FROM ps_document_detail WHERE id_document = '59695' 15/07/2022 10:57:03 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 ( '59695' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 15/07/2022 10:57:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/07/2022 10:57:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/07/2022 10:57:03 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 ( '59695' , '9384' , 'SAN BARTOLOMEO APOSTOLO - G. PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 15/07/2022 10:57:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9384' AND id_supplier = '' 15/07/2022 10:57:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9384' , '' , '1' ) 15/07/2022 11:06:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2278' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:06:37 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' , '2278' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.90' , '162.98' , NOW() , NOW() ) 15/07/2022 11:06:37 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 = '59696' 15/07/2022 11:06:37 am >> DELETE FROM ps_document_detail WHERE id_document = '59696' 15/07/2022 11:06:37 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 ( '59696' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 15/07/2022 11:06:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/07/2022 11:06:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/07/2022 11:06:37 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 ( '59696' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 15/07/2022 11:06:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/07/2022 11:06:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/07/2022 11:06:37 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 ( '59696' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 15/07/2022 11:06:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 15/07/2022 11:06:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 15/07/2022 11:06:37 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 ( '59696' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/07/2022 11:06:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/07/2022 11:06:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/07/2022 11:06:37 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 ( '59696' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 15/07/2022 11:06:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 15/07/2022 11:06:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 15/07/2022 11:16:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2279' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:16:34 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' , '2279' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.00' , '113.93' , NOW() , NOW() ) 15/07/2022 11:16:34 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 = '59697' 15/07/2022 11:16:34 am >> DELETE FROM ps_document_detail WHERE id_document = '59697' 15/07/2022 11:16:34 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 ( '59697' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '139.00' , '113.93442622951' , '22' , '0' , '139.00' ) 15/07/2022 11:16:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 15/07/2022 11:16:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 15/07/2022 11:47:56 am >> SELECT document_num FROM ps_document WHERE document_num = '23/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:47:56 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 ( '23' , '23/E' , '2022-07-15' , 'E' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1084.00' , '1084.00' , NOW() , NOW() ) 15/07/2022 11:47:56 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 = '59698' 15/07/2022 11:47:56 am >> DELETE FROM ps_document_detail WHERE id_document = '59698' 15/07/2022 11:47:56 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 ( '59698' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '10' , '135.00' ) 15/07/2022 11:47:56 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 ( '59698' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '50' , '-50' , '4' , '5.0000' , '5' , '0' , '10' , '225.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 15/07/2022 11:47:56 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 ( '59698' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '80' , '-80' , '4' , '3.0000' , '3' , '0' , '10' , '216.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '10' , '135.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 15/07/2022 11:47:56 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 ( '59698' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '20' , '8.00' ) 15/07/2022 11:47:56 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 ( '59698' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.4000' , '3.4' , '0' , '20' , '68.00' ) 15/07/2022 11:48:20 am >> SELECT document_num FROM ps_document WHERE document_num = '23/E' AND id_document != '59698' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:48:20 am >> UPDATE ps_document SET id_document_type = '23', document_num = '23/E', document_date = '2022-07-15', document_letter = 'E', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1084.00', price_tax_excluded = '1084.00', date_upd = NOW() WHERE id_document = '59698' 15/07/2022 11:48:20 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 = '59698' 15/07/2022 11:48:20 am >> DELETE FROM ps_document_detail WHERE id_document = '59698' 15/07/2022 11:48:20 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 ( '59698' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '10' , '135.00' ) 15/07/2022 11:48:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '' 15/07/2022 11:48:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '' , '1' ) 15/07/2022 11:48:20 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 ( '59698' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '50' , '-50' , '4' , '5.0000' , '5' , '0' , '10' , '225.00' ) 15/07/2022 11:48:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '' 15/07/2022 11:48:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '' , '1' ) 15/07/2022 11:48:20 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 ( '59698' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 15/07/2022 11:48:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 15/07/2022 11:48:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 15/07/2022 11:48:20 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 ( '59698' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 15/07/2022 11:48:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 15/07/2022 11:48:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 15/07/2022 11:48:20 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 ( '59698' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '80' , '-80' , '4' , '3.0000' , '3' , '0' , '10' , '216.00' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 15/07/2022 11:48:21 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 ( '59698' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '10' , '135.00' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 15/07/2022 11:48:21 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 ( '59698' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 15/07/2022 11:48:21 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 ( '59698' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 15/07/2022 11:48:21 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 ( '59698' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '20' , '8.00' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 15/07/2022 11:48:21 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 ( '59698' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.4000' , '3.4' , '0' , '20' , '68.00' ) 15/07/2022 11:48:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 15/07/2022 11:48:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 15/07/2022 11:48:32 am >> DELETE FROM ps_document WHERE id_document = '59120' 15/07/2022 11:48:32 am >> DELETE FROM ps_document_detail WHERE id_document = '59120' 15/07/2022 11:49:45 am >> SELECT document_num FROM ps_document WHERE document_num = '24/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:49:45 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 ( '23' , '24/E' , '2022-07-15' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '787.20' , '645.25' , NOW() , NOW() ) 15/07/2022 11:49:45 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 = '59699' 15/07/2022 11:49:45 am >> DELETE FROM ps_document_detail WHERE id_document = '59699' 15/07/2022 11:49:45 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 ( '59699' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 15/07/2022 11:49:45 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 ( '59699' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 15/07/2022 11:49:45 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 ( '59699' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '240.00' ) 15/07/2022 11:51:36 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 11:51: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 ( '24' , '20' , '2022-07-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39328.00' , '39144.07' , NOW() , NOW() ) 15/07/2022 11:51: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 = '59700' 15/07/2022 11:51:36 am >> DELETE FROM ps_document_detail WHERE id_document = '59700' 15/07/2022 11:51: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 ( '59700' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '480' , '-480' , '4' , '2.50' , '2.5' , '0' , '0' , '1200.00' ) 15/07/2022 11:51: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 ( '59700' , '9675' , 'SARETE MIEI TESTIMONI' , '600' , '-600' , '4' , '3.00' , '3' , '0' , '0' , '1800.00' ) 15/07/2022 11:51: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 ( '59700' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '320' , '-320' , '4' , '1.90' , '1.9' , '0' , '0' , '608.00' ) 15/07/2022 11:51: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 ( '59700' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1020' , '-1020' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1020.00' ) 15/07/2022 11:51: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 ( '59700' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4420' , '-4420' , '4' , '2.50' , '2.5' , '0' , '0' , '11050.00' ) 15/07/2022 11:51: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 ( '59700' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4420' , '-4420' , '4' , '2.50' , '2.5' , '0' , '0' , '11050.00' ) 15/07/2022 11:51: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 ( '59700' , '11191' , 'VENITE CON ME 1 PARTE' , '5040' , '-5040' , '4' , '2.50' , '2.5' , '0' , '0' , '12600.00' ) 15/07/2022 04:08:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '52/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 04:08:04 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 ( '24' , '52/A' , '2022-07-15' , 'A' , '1184' , '0' , '1184' , 'VIA SERRACAPILLI 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.00' , '144.00' , NOW() , NOW() ) 15/07/2022 04:08:04 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 = '59701' 15/07/2022 04:08:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '59701' 15/07/2022 04:08:04 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 ( '59701' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '4' , '-4' , '0' , '36.00' , '36' , '' , '0' , '144.00' ) 15/07/2022 04:50:55 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'g2rhBf6GPtmX5IVm' , NOW() , NOW() ) 15/07/2022 04:50:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6972' , '1' ) 15/07/2022 04:50:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6972' , '2' ) 15/07/2022 04:50:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6972' , '3' ) 15/07/2022 04:52:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6972' 15/07/2022 04:52:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6972' , '10' , '215' , 'SANTUARIO MADONNA DI TIRANO' , 'CITTERIO' , 'DON FERRUCCIO ' , 'P. ZZA DELLA BASILICA 1' , '' , '23037' , 'TIRANO ' , '' , '' , '3334211260' , '' , '' , NOW() , NOW() ) 15/07/2022 04:52:23 pm >> UPDATE ps_customer SET email = 'citterioferruccio@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6972' 15/07/2022 04:56:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '31' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 04:56: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 ( '21' , '31' , '2022-07-15' , '' , '6972' , '0' , '74680479' , 'P. ZZA DELLA BASILICA 1 23037 TIRANO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 15/07/2022 04:56: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 = '5378' 15/07/2022 04:56:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '5378' 15/07/2022 04:56: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 ( '5378' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 15/07/2022 06:35:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2280' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 06:35:16 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' , '2280' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 15/07/2022 06:35:16 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 = '59702' 15/07/2022 06:35:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '59702' 15/07/2022 06:35:16 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 ( '59702' , '9236' , 'S. TERESA - CM 15 - 023 STH/15' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/07/2022 06:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9236' AND id_supplier = '' 15/07/2022 06:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9236' , '' , '1' ) 15/07/2022 06:35:16 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 ( '59702' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 15/07/2022 06:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10207' AND id_supplier = '' 15/07/2022 06:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10207' , '' , '1' ) 15/07/2022 06:35:16 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 ( '59702' , '9223' , 'S. MICHELE - CM 15 - 023 SMK/15' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 15/07/2022 06:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9223' AND id_supplier = '' 15/07/2022 06:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9223' , '' , '1' ) 15/07/2022 06:38:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2281' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 06:38:45 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' , '2281' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 15/07/2022 06:38:45 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 = '59703' 15/07/2022 06:38:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '59703' 15/07/2022 06:38:45 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 ( '59703' , '18222' , 'ROSARIO COLORATO - R316' , '40' , '-40' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '28.00' ) 15/07/2022 06:38:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 15/07/2022 06:38:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 15/07/2022 07:08:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2282' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 07:08: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' , '2282' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '183.57' , NOW() , NOW() ) 15/07/2022 07:08: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 = '59704' 15/07/2022 07:08:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '59704' 15/07/2022 07:08: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 ( '59704' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '45' , '36.885245901639' , '22' , '0' , '135.00' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/07/2022 07:08: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 ( '59704' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' , '-1' , '1' , '54.54' , '44.704918032787' , '22' , '0' , '54.54' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12659' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12659' , '' , '1' ) 15/07/2022 07:08: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 ( '59704' , '14796' , 'BELLA ADDORMENTATA' , '1' , '-1' , '4' , '8.90' , '8.9' , '0' , '5' , '8.46' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14796' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14796' , '' , '1' ) 15/07/2022 07:08: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 ( '59704' , '11881' , 'IO E TE - BIBBIA DEI PICCOLI - 8828' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11881' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11881' , '' , '1' ) 15/07/2022 07:08: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 ( '59704' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/07/2022 07:08: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 ( '59704' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 15/07/2022 07:08:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 15/07/2022 07:08:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 15/07/2022 07:43:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 15/07/2022 07:43:28 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' , '2283' , '2022-07-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 15/07/2022 07:43:28 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 = '59705' 15/07/2022 07:43:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '59705' 15/07/2022 07:43:28 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 ( '59705' , '19017' , 'VIRTU TEOLOGALI - PADRE LIVIO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 15/07/2022 07:43:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19017' AND id_supplier = '' 15/07/2022 07:43:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19017' , '' , '1' )