03/09/2022 08:49:40 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 08:49:40 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' , '66/A' , '2022-09-03' , 'A' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '624.00' , '624.00' , NOW() , NOW() ) 03/09/2022 08:49:40 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 = '61145' 03/09/2022 08:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '61145' 03/09/2022 08:49:40 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 ( '61145' , '12817' , 'LIBRO DEI MATRIMONI' , '24' , '-24' , '4' , '40.00' , '40' , '0' , '35' , '624.00' ) 03/09/2022 09:17:11 am >> DELETE FROM ps_document WHERE id_document = '61130' 03/09/2022 09:17:11 am >> DELETE FROM ps_document_detail WHERE id_document = '61130' 03/09/2022 09:17:23 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '61066' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-01') 03/09/2022 09:17:23 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22', document_date = '2022-09-01', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '7450.00', price_tax_excluded = '7450.00', date_upd = NOW() WHERE id_document = '61066' 03/09/2022 09:17:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61066' 03/09/2022 09:17:24 am >> DELETE FROM ps_document_detail WHERE id_document = '61066' 03/09/2022 09:17: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 ( '61066' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '20' , '-20' , '4' , '20.0000' , '20' , '0' , '0' , '400.00' ) 03/09/2022 09:17:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19562' AND id_supplier = '' 03/09/2022 09:17:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19562' , '' , '1' ) 03/09/2022 09:17: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 ( '61066' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '100' , '-100' , '4' , '12.0000' , '12' , '0' , '0' , '1200.00' ) 03/09/2022 09:17:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 03/09/2022 09:17:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 03/09/2022 09:17: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 ( '61066' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '126' , '-126' , '4' , '35.0000' , '35' , '0' , '0' , '4410.00' ) 03/09/2022 09:17:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 03/09/2022 09:17:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 03/09/2022 09:17: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 ( '61066' , '6629' , 'MIA PREGHIERA' , '1600' , '-1600' , '4' , '0.9000' , '0.9' , '0' , '0' , '1440.00' ) 03/09/2022 09:17:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 03/09/2022 09:17:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 03/09/2022 09:59:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 09:59:38 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' , '2620' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 03/09/2022 09:59:38 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 = '61146' 03/09/2022 09:59:38 am >> DELETE FROM ps_document_detail WHERE id_document = '61146' 03/09/2022 09:59:38 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 ( '61146' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/09/2022 09:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 03/09/2022 09:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 03/09/2022 10:04:22 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'a5nDZhrHm2Y0n39s' , NOW() , NOW() ) 03/09/2022 10:04:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3899' , '1' ) 03/09/2022 10:04:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3899' , '2' ) 03/09/2022 10:04:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3899' , '3' ) 03/09/2022 10:05:20 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3899' 03/09/2022 10:05:20 am >> 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 ( '3899' , '10' , '232' , '' , 'GIOACCHINI' , 'ANNAPIA ' , 'VIA CARRACCIA 50' , '' , '01030' , 'CIVITA CASTELLANA' , '' , '' , '3208417240' , '' , '' , NOW() , NOW() ) 03/09/2022 10:05:20 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3899' 03/09/2022 10:06:20 am >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:06:20 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 ( '21' , '111' , '2022-09-03' , '' , '3899' , '0' , '4674768' , 'VIA CARRACCIA 50 01030 CIVITA CASTELLANA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 03/09/2022 10:06: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 = '61147' 03/09/2022 10:06:20 am >> DELETE FROM ps_document_detail WHERE id_document = '61147' 03/09/2022 10:06: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 ( '61147' , '8254' , 'PREGHIAMO CON MARIA' , '30' , '-30' , '4' , '0.65' , '0.65' , '0' , '0' , '19.50' ) 03/09/2022 10:11:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3899' 03/09/2022 10:11:13 am >> 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 ( '3899' , '10' , '232' , '' , 'GIOACCHINI' , 'ANNAPIA ' , 'VIA CARRACCIA 50' , '' , '01033' , 'CIVITA CASTELLANA' , '' , '' , '3208417240' , '' , '' , NOW() , NOW() ) 03/09/2022 10:11:13 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3899' 03/09/2022 10:13:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3899' 03/09/2022 10:13:45 am >> 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 ( '3899' , '10' , '232' , '' , 'GIOACCHINI' , 'ANNAPIA ' , 'VIA DELLA CARRACCIA 50' , '' , '01033' , 'CIVITA CASTELLANA' , '' , '' , '3208417240' , '' , '' , NOW() , NOW() ) 03/09/2022 10:13:45 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3899' 03/09/2022 10:26:15 am >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:26:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '112' , '2022-09-03' , '' , '229' , '0' , '4673704' , 'VIA TORINO 84092 BELLIZZI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.90' , '45.90' , NOW() , NOW() ) 03/09/2022 10:26:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61148' 03/09/2022 10:26:15 am >> DELETE FROM ps_document_detail WHERE id_document = '61148' 03/09/2022 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61148' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.80' , '1.8' , '0' , '15' , '45.90' ) 03/09/2022 10:26:40 am >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '61148' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:26:40 am >> UPDATE ps_document SET id_document_type = '21', document_num = '112', document_date = '2022-09-03', document_letter = '', id_customer = '229', id_supplier = '', id_address = '4673704', address1 = 'VIA TORINO 84092 BELLIZZI', address2 = '', note = '', 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 = '45.90', price_tax_excluded = '45.90', date_upd = NOW() WHERE id_document = '61148' 03/09/2022 10:26:40 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 = '61148' 03/09/2022 10:26:40 am >> DELETE FROM ps_document_detail WHERE id_document = '61148' 03/09/2022 10:26:40 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 ( '61148' , '17257' , 'IO TI BATTEZZO ' , '30' , '-30' , '4' , '1.8000' , '1.8' , '0' , '15' , '45.90' ) 03/09/2022 10:26:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 03/09/2022 10:26:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 03/09/2022 10:27:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:27:28 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' , '2621' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.52' , NOW() , NOW() ) 03/09/2022 10:27:28 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 = '61149' 03/09/2022 10:27:28 am >> DELETE FROM ps_document_detail WHERE id_document = '61149' 03/09/2022 10:27:28 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 ( '61149' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 03/09/2022 10:27:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 03/09/2022 10:27:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 03/09/2022 10:27:28 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 ( '61149' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 03/09/2022 10:27:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 03/09/2022 10:27:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 03/09/2022 10:34:08 am >> UPDATE ps_document SET id_document_type = '33', document_num = '4409/00', document_date = '2022-08-30', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RIENTRO', 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 = '180.00', price_tax_excluded = '180.00', date_upd = NOW() WHERE id_document = '5404' 03/09/2022 10:34: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 = '5404' 03/09/2022 10:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '5404' 03/09/2022 10:34: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 ( '5404' , '110' , 'SE MI AMI NON PIANGERE' , '100' , '100' , '4' , '1.5000' , '1.5' , '0' , '0' , '150.00' ) 03/09/2022 10:34:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '' 03/09/2022 10:34:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '' , '1' ) 03/09/2022 10:34: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 ( '5404' , '26' , 'TU SOLO HAI PAROLE DI VITA ETERNA' , '20' , '20' , '4' , '1.5000' , '1.5' , '0' , '0' , '30.00' ) 03/09/2022 10:34:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '26' AND id_supplier = '' 03/09/2022 10:34:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '26' , '' , '1' ) 03/09/2022 10:40:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:40: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 ( '11' , '2622' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.23' , '67.37' , NOW() , NOW() ) 03/09/2022 10:40: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 = '61150' 03/09/2022 10:40:23 am >> DELETE FROM ps_document_detail WHERE id_document = '61150' 03/09/2022 10:40: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 ( '61150' , '19474' , '100 E + GIOCHI ' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19474' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19474' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '19806' , 'AGENDA DEL CATECHISTA 2022-2023' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19806' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19806' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '4.75' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '18707' , 'CRESCERE IN ETA SAPIENZA E GRAZIA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18707' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18707' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '18708' , 'AL SOFFIO DELLO SPIRITO - U. DE VANNA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18708' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18708' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '18564' , 'PASSO DOPO PASSO 6 - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '' , '1' ) 03/09/2022 10:40: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 ( '61150' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/09/2022 10:40:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '' 03/09/2022 10:40:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '' , '1' ) 03/09/2022 10:44:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:44:12 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' , '2623' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.85' , '39.74' , NOW() , NOW() ) 03/09/2022 10:44:12 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 = '61151' 03/09/2022 10:44:12 am >> DELETE FROM ps_document_detail WHERE id_document = '61151' 03/09/2022 10:44:12 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 ( '61151' , '2935' , 'CROCE 20 CM FORATO - 4493/2' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/09/2022 10:44:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2935' AND id_supplier = '' 03/09/2022 10:44:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2935' , '' , '1' ) 03/09/2022 10:44:12 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 ( '61151' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/09/2022 10:44:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 03/09/2022 10:44:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 03/09/2022 10:44:12 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 ( '61151' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/09/2022 10:44:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 03/09/2022 10:44:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 03/09/2022 10:44:12 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 ( '61151' , '7920' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. A' , '12' , '-12' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '6.00' ) 03/09/2022 10:44:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7920' AND id_supplier = '' 03/09/2022 10:44:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7920' , '' , '1' ) 03/09/2022 10:44:12 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 ( '61151' , '14712' , 'VERGINE DEL SILENZIO - E. ANTENUCCI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/09/2022 10:44:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '14712' AND id_supplier = '' 03/09/2022 10:44:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14712' , '' , '1' ) 03/09/2022 10:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 10:50:52 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' , '2624' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 03/09/2022 10:50:52 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 = '61152' 03/09/2022 10:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '61152' 03/09/2022 10:50:52 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 ( '61152' , '18604' , 'DISCERNERE DA GIOVANI - A. DI MEDIO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 03/09/2022 10:50:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '18604' AND id_supplier = '' 03/09/2022 10:50:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18604' , '' , '1' ) 03/09/2022 10:58:23 am >> UPDATE ps_document SET id_document_type = '33', document_num = '4403/00', document_date = '2022-08-30', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RIENTRO', 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 = '432.90', price_tax_excluded = '432.90', date_upd = NOW() WHERE id_document = '61094' 03/09/2022 10:58: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 = '61094' 03/09/2022 10:58:23 am >> DELETE FROM ps_document_detail WHERE id_document = '61094' 03/09/2022 10:58: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 ( '61094' , '6629' , 'MIA PREGHIERA' , '666' , '666' , '4' , '0.65' , '0.65' , '0' , '0' , '432.9000' ) 03/09/2022 10:58:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 03/09/2022 10:58:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 03/09/2022 11:07:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:07:44 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' , '2625' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 03/09/2022 11:07: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 = '61153' 03/09/2022 11:07:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61153' 03/09/2022 11:07: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 ( '61153' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 03/09/2022 11:07:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 03/09/2022 11:07:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 03/09/2022 11:33:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:33:53 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' , '2626' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.70' , '48.03' , NOW() , NOW() ) 03/09/2022 11:33:53 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 = '61154' 03/09/2022 11:33:53 am >> DELETE FROM ps_document_detail WHERE id_document = '61154' 03/09/2022 11:33:53 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 ( '61154' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/09/2022 11:33:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 03/09/2022 11:33:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 03/09/2022 11:33:53 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 ( '61154' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 03/09/2022 11:33:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 03/09/2022 11:33:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 03/09/2022 11:33:53 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 ( '61154' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 03/09/2022 11:33:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/09/2022 11:33:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/09/2022 11:36:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:36: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' , '2627' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.00' , '88.12' , NOW() , NOW() ) 03/09/2022 11:36: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 = '61155' 03/09/2022 11:36:37 am >> DELETE FROM ps_document_detail WHERE id_document = '61155' 03/09/2022 11:36: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 ( '61155' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '12' , '-12' , '1' , '7' , '5.7377049180328' , '22' , '0' , '84.00' ) 03/09/2022 11:36:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 03/09/2022 11:36:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 03/09/2022 11:36: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 ( '61155' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '19.00' ) 03/09/2022 11:36:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/09/2022 11:36:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/09/2022 11:36: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 ( '61155' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 03/09/2022 11:36:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 03/09/2022 11:36:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 03/09/2022 11:44:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:44:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2628' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 03/09/2022 11:44: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 = '61156' 03/09/2022 11:44:19 am >> DELETE FROM ps_document_detail WHERE id_document = '61156' 03/09/2022 11:44: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 ( '61156' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 03/09/2022 11:44:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 03/09/2022 11:44:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 03/09/2022 11:44: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 ( '61156' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 03/09/2022 11:44:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '15744' AND id_supplier = '' 03/09/2022 11:44:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15744' , '' , '1' ) 03/09/2022 11:46:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:46:55 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' , '2629' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 03/09/2022 11:46:55 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 = '61157' 03/09/2022 11:46:55 am >> DELETE FROM ps_document_detail WHERE id_document = '61157' 03/09/2022 11:46:55 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 ( '61157' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '11.00' ) 03/09/2022 11:46:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 03/09/2022 11:46:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 03/09/2022 11:47:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 03/09/2022 11:47: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' , '2630' , '2022-09-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 03/09/2022 11:47: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 = '61158' 03/09/2022 11:47:59 am >> DELETE FROM ps_document_detail WHERE id_document = '61158' 03/09/2022 11:47: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 ( '61158' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/09/2022 11:47:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/09/2022 11:47:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )