03/05/2022 10:02:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 10:02: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 ( '11' , '1369' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '27.03' , NOW() , NOW() ) 03/05/2022 10:02: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 = '56557' 03/05/2022 10:02:36 am >> DELETE FROM ps_document_detail WHERE id_document = '56557' 03/05/2022 10:02: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 ( '56557' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/05/2022 10:02:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/05/2022 10:02:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/05/2022 10:02: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 ( '56557' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 03/05/2022 10:02:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 03/05/2022 10:02:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 03/05/2022 10:02: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 ( '56557' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3' , '3' , '0' , '0' , '9.00' ) 03/05/2022 10:02:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/05/2022 10:02:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/05/2022 10:17:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 10:17: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 ( '11' , '1370' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 03/05/2022 10:17: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 = '56558' 03/05/2022 10:17:40 am >> DELETE FROM ps_document_detail WHERE id_document = '56558' 03/05/2022 10:17: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 ( '56558' , '19454' , 'CAMICIONE MISTO COTONE - ONE0M18' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 03/05/2022 10:17:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19454' AND id_supplier = '' 03/05/2022 10:17:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19454' , '' , '1' ) 03/05/2022 10:52:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 10:52:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1371' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 03/05/2022 10:52:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56559' 03/05/2022 10:52:32 am >> DELETE FROM ps_document_detail WHERE id_document = '56559' 03/05/2022 10:52:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56559' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '54.00' ) 03/05/2022 10:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 03/05/2022 10:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 03/05/2022 11:04:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 11:04:57 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' , '1372' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.70' , '25.70' , NOW() , NOW() ) 03/05/2022 11:04:57 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 = '56560' 03/05/2022 11:04:57 am >> DELETE FROM ps_document_detail WHERE id_document = '56560' 03/05/2022 11:04:57 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 ( '56560' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '5' , '5' , '0' , '5' , '9.50' ) 03/05/2022 11:04:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 03/05/2022 11:04:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 03/05/2022 11:04:57 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 ( '56560' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 03/05/2022 11:04:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 03/05/2022 11:04:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 03/05/2022 11:04: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 ( '56560' , '18546' , 'QUANTO E BUONA MARIA SANTISSIMA - M. INGLESE' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 03/05/2022 11:04:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18546' AND id_supplier = '' 03/05/2022 11:04:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18546' , '' , '1' ) 03/05/2022 11:07:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 11:07: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' , '1373' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 03/05/2022 11:07: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 = '56561' 03/05/2022 11:07:37 am >> DELETE FROM ps_document_detail WHERE id_document = '56561' 03/05/2022 11:07: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 ( '56561' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 03/05/2022 11:07:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 03/05/2022 11:07:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 03/05/2022 11:15:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 11:15:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1374' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 03/05/2022 11:15:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56562' 03/05/2022 11:15:06 am >> DELETE FROM ps_document_detail WHERE id_document = '56562' 03/05/2022 11:15:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56562' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 03/05/2022 11:15:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19512' AND id_supplier = '' 03/05/2022 11:15:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19512' , '' , '1' ) 03/05/2022 11:22:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 11:22:46 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' , '1375' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 03/05/2022 11:22:46 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 = '56563' 03/05/2022 11:22:46 am >> DELETE FROM ps_document_detail WHERE id_document = '56563' 03/05/2022 11:22:46 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 ( '56563' , '17005' , 'BIGLIETTI AUGURALI medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 03/05/2022 11:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 03/05/2022 11:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 03/05/2022 11:57:17 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/05/2022 11:57:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19524' , '1' , '' , 'nuovo-prodotto' ) 03/05/2022 11:57:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19524' , '1' , '1' , '2' , NOW() , NOW() ) 03/05/2022 11:57:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19524' , '0' , '1' , '0' , '0' ) 03/05/2022 12:00:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 12:00:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1376' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.60' , '60.28' , NOW() , NOW() ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56564' 03/05/2022 12:00:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '56564' 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '3' , '-3' , '4' , '1.60' , '1.6' , '0' , '0' , '4.80' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '800' , '-800' , '4' , '0.03' , '0.03' , '0' , '0' , '24.00' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 03/05/2022 12:00:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56564' , '15387' , 'VESTINA BATTESIMALE ' , '10' , '-10' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '28.00' ) 03/05/2022 12:00:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 03/05/2022 12:00:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 03/05/2022 12:49:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 12:49:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1377' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 03/05/2022 12:49:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56565' 03/05/2022 12:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '56565' 03/05/2022 12:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56565' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '50' , '-50' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '65.00' ) 03/05/2022 12:49:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 03/05/2022 12:49:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 03/05/2022 01:01:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 01:01:08 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' , '1378' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 03/05/2022 01:01:08 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 = '56566' 03/05/2022 01:01:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '56566' 03/05/2022 01:01:08 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 ( '56566' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/05/2022 01:01:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 03/05/2022 01:01:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 03/05/2022 01:01:08 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 ( '56566' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/05/2022 01:01:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 03/05/2022 01:01:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 03/05/2022 01:01:09 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 ( '56566' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/05/2022 01:01:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 03/05/2022 01:01:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 03/05/2022 01:01:09 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 ( '56566' , '19275' , 'AMEN - MAG. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/05/2022 01:01:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 03/05/2022 01:01:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 03/05/2022 01:56:36 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '22LER230', document_date = '2022-04-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', 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 = '90.00', price_tax_excluded = '90.00', date_upd = NOW() WHERE id_document = '56475' 03/05/2022 01:56:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56475' 03/05/2022 01:56:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56475' 03/05/2022 01:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56475' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '4000' , '4000' , '4' , '0.0300' , '0.03' , '0' , '25' , '90.00' ) 03/05/2022 01:56:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 03/05/2022 01:56:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 03/05/2022 02:00:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 02:00:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '15' , '2022-05-03' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3640.00' , '3640.00' , NOW() , NOW() ) 03/05/2022 02:00:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56567' 03/05/2022 02:00:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '56567' 03/05/2022 02:00:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56567' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1600' , '-1600' , '4' , '1.60' , '1.6' , '0' , '0' , '2560.00' ) 03/05/2022 02:00:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56567' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '60' , '-60' , '4' , '18.00' , '18' , '0' , '0' , '1080.00' ) 03/05/2022 02:04:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 02:04:39 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' , '5' , '2022-05-03' , '' , '6541' , '0' , '9339920' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1160.00' , '1160.00' , NOW() , NOW() ) 03/05/2022 02:04:39 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 = '4444' 03/05/2022 02:04:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '4444' 03/05/2022 02:04:39 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 ( '4444' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '160' , '-160' , '4' , '2.00' , '2' , '0' , '0' , '320.00' ) 03/05/2022 02:04:39 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 ( '4444' , '125' , 'MIE PREGHIERINE - N. E.' , '560' , '-560' , '4' , '1.50' , '1.5' , '0' , '0' , '840.00' ) 03/05/2022 02:08:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '56567' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 02:08:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '15', document_date = '2022-05-03', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '4216.00', price_tax_excluded = '4216.00', date_upd = NOW() WHERE id_document = '56567' 03/05/2022 02:08:53 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 = '56567' 03/05/2022 02:08:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '56567' 03/05/2022 02:08:53 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 ( '56567' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1600' , '-1600' , '4' , '1.6000' , '1.6' , '0' , '0' , '2560.00' ) 03/05/2022 02:08:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 03/05/2022 02:08:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 03/05/2022 02:08:53 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 ( '56567' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '92' , '-92' , '4' , '18.0000' , '18' , '0' , '0' , '1656.00' ) 03/05/2022 02:08:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18950' AND id_supplier = '' 03/05/2022 02:08:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18950' , '' , '1' ) 03/05/2022 02:21:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '49993' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-01-05') 03/05/2022 02:21:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '57', document_date = '2022-01-05', 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 = '570.00', price_tax_excluded = '467.21', date_upd = NOW() WHERE id_document = '49993' 03/05/2022 02:21:32 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 = '49993' 03/05/2022 02:21:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '49993' 03/05/2022 02:21:32 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 ( '49993' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '168.0000' , '137.70491803279' , '22' , '0' , '168.00' ) 03/05/2022 02:21:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15541' AND id_supplier = '' 03/05/2022 02:21:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15541' , '' , '1' ) 03/05/2022 02:21:32 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 ( '49993' , '19028' , 'STOLA MISTO LA/SE - 1010/46' , '1' , '-1' , '1' , '125.0000' , '102.45901639344' , '22' , '0' , '125.00' ) 03/05/2022 02:21:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19028' AND id_supplier = '' 03/05/2022 02:21:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19028' , '' , '1' ) 03/05/2022 02:21:32 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 ( '49993' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '277' , '227.04918032787' , '22' , '0' , '277.00' ) 03/05/2022 02:21:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/05/2022 02:21:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/05/2022 02:22:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60-1009' AND id_product != '17212' AND ean13 != '' 03/05/2022 02:22:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60-1009', date_upd = NOW() WHERE id_product = '17212' 03/05/2022 02:22:12 pm >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO RICAMO A MANO', description = '' WHERE id_product = '17212' 03/05/2022 02:22:12 pm >> UPDATE ps_product SET wholesale_price = '78.57', on_sale = '0', price = '139.34426229508196' WHERE id_product = '17212' 03/05/2022 02:22:12 pm >> UPDATE ps_product_shop SET wholesale_price = '78.57', price = '139.34426229508196', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17212' 03/05/2022 02:22:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '17212' 03/05/2022 03:46:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 03:46:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1379' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 03/05/2022 03:46:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56568' 03/05/2022 03:46:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '56568' 03/05/2022 03:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56568' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/05/2022 03:46:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/05/2022 03:46:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/05/2022 04:09:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 04:09:54 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' , '1380' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 03/05/2022 04:09:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56569' 03/05/2022 04:09:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '56569' 03/05/2022 04:09:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56569' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/05/2022 04:09:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13805' AND id_supplier = '' 03/05/2022 04:09:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13805' , '' , '1' ) 03/05/2022 04:11:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 04:11:33 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' , '1381' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.66' , NOW() , NOW() ) 03/05/2022 04:11:33 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 = '56570' 03/05/2022 04:11:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '56570' 03/05/2022 04:11:33 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 ( '56570' , '17004' , 'BIGLIETTI AUGURALI PICCOLI' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 03/05/2022 04:11:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 03/05/2022 04:11:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 03/05/2022 05:25:23 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '363/22', document_date = '2022-04-14', document_letter = '22', id_customer = '0', id_supplier = '40', id_address = '2635', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '12', id_causal = '0', price_tax_included = '57.60', price_tax_excluded = '57.60', date_upd = NOW() WHERE id_document = '56528' 03/05/2022 05:25:23 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 = '56528' 03/05/2022 05:25:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '56528' 03/05/2022 05:25:23 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 ( '56528' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '8' , '8' , '4' , '4.0000' , '4' , '0' , '40' , '19.20' ) 03/05/2022 05:25:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = '40' 03/05/2022 05:25:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '40' , '1' ) 03/05/2022 05:25:23 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 ( '56528' , '19507' , 'MESSA MEDITAZIONE - LUG AGO 2022' , '8' , '8' , '4' , '8.0000' , '8' , '0' , '40' , '38.40' ) 03/05/2022 05:25:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = '40' 03/05/2022 05:25:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '40' , '1' ) 03/05/2022 05:31:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '1100' , '2022-04-30' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.35' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.17' , '76.17' , NOW() , NOW() ) 03/05/2022 05:31:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56571' 03/05/2022 05:31:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '56571' 03/05/2022 05:31:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56571' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '7' , '0' , '4' , '12.9000' , '12.9' , '0' , '27' , '65.92' ) 03/05/2022 05:31:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 03/05/2022 05:31:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 03/05/2022 05:31:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56571' , '117' , 'A SARA E ALLE ALTRE DONNE - TONINO BELLO' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 03/05/2022 05:31:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '117' AND id_supplier = '47' 03/05/2022 05:31:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '117' , '47' , '1' ) 03/05/2022 05:32:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/L' AND id_document != '55341' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-04-21') 03/05/2022 05:32:47 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '5/L', document_date = '2022-04-21', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania ospedaliera battipaglia', 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 = '88.10', price_tax_excluded = '76.74', date_upd = NOW() WHERE id_document = '55341' 03/05/2022 05:32:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55341' 03/05/2022 05:32:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '55341' 03/05/2022 05:32:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55341' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 03/05/2022 05:32:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 03/05/2022 05:32:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 03/05/2022 05:32:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55341' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '20' , '14.00' ) 03/05/2022 05:32:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 03/05/2022 05:32:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 03/05/2022 05:32:48 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 ( '55341' , '7673' , 'PARTICOLE MM38' , '3' , '-3' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '9.00' ) 03/05/2022 05:32:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 03/05/2022 05:32:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 03/05/2022 05:32:48 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 ( '55341' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '5.10' ) 03/05/2022 05:32:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/05/2022 05:32:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/05/2022 05:32:48 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 ( '55341' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 03/05/2022 05:32:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 03/05/2022 05:32:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 03/05/2022 05:40:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022245571' , '2022-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.38' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '13.35' , '13.35' , NOW() , NOW() ) 03/05/2022 05:40:35 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 = '56572' 03/05/2022 05:40:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '56572' 03/05/2022 05:40:35 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 ( '56572' , '17875' , 'VITA COME FINE DEL MONDO - L. M. EPICOCO' , '1' , '0' , '4' , '12.97' , '12.97' , '0' , '0' , '12.9700' ) 03/05/2022 05:40:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '109' 03/05/2022 05:40:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '109' , '1' ) 03/05/2022 05:43:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 05:43:30 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' , '1382' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '110.50' , '99.23' , NOW() , NOW() ) 03/05/2022 05:43:30 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 = '56573' 03/05/2022 05:43:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '56573' 03/05/2022 05:43:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56573' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '0' , '10.00' ) 03/05/2022 05:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '' 03/05/2022 05:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '' , '1' ) 03/05/2022 05:43:31 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 ( '56573' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '3' , '-3' , '1' , '20.0000' , '16.3934' , '22' , '0' , '60.00' ) 03/05/2022 05:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 03/05/2022 05:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 03/05/2022 05:43:31 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 ( '56573' , '7202' , 'ARTICOLI RELIGIOSI ADESIVO NUMERI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/05/2022 05:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/05/2022 05:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/05/2022 05:43:31 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 ( '56573' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '5' , '38.00' ) 03/05/2022 05:43:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 03/05/2022 05:43:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 03/05/2022 05:43:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1382' AND id_document != '56573' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 05:43:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1382', document_date = '2022-05-03', 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 = '3', id_causal = '0', price_tax_included = '110.50', price_tax_excluded = '99.23', date_upd = NOW() WHERE id_document = '56573' 03/05/2022 05:43:50 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 = '56573' 03/05/2022 05:43:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '56573' 03/05/2022 05:43:50 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 ( '56573' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '0' , '10.00' ) 03/05/2022 05:43:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '' 03/05/2022 05:43:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '' , '1' ) 03/05/2022 05:43:50 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 ( '56573' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '60.00' ) 03/05/2022 05:43:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 03/05/2022 05:43:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 03/05/2022 05:43:50 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 ( '56573' , '7202' , 'ARTICOLI RELIGIOSI ADESIVO NUMERI' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 03/05/2022 05:43:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/05/2022 05:43:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/05/2022 05:43:50 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 ( '56573' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '5' , '38.00' ) 03/05/2022 05:43:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 03/05/2022 05:43:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 03/05/2022 05:46:34 pm >> DELETE FROM ps_document WHERE id_document = '53282' 03/05/2022 05:46:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '53282' 03/05/2022 05:47:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 05:47:51 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' , '1383' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1000.00' , '819.67' , NOW() , NOW() ) 03/05/2022 05:47:51 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 = '56574' 03/05/2022 05:47:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '56574' 03/05/2022 05:47:51 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 ( '56574' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1000' , '819.67213114754' , '22' , '0' , '1000.00' ) 03/05/2022 05:47:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 03/05/2022 05:47:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 03/05/2022 06:00:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 06:00:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1384' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 03/05/2022 06:00:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56575' 03/05/2022 06:00:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '56575' 03/05/2022 06:00:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56575' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 03/05/2022 06:00:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 03/05/2022 06:00:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 03/05/2022 06:38:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 06:38:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1385' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.20' , '31.44' , NOW() , NOW() ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56576' 03/05/2022 06:38:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '56576' 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.00' , '2.8846153846154' , '4' , '0' , '3.00' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.70' , '1.6346153846154' , '4' , '0' , '1.70' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 03/05/2022 06:38:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56576' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 03/05/2022 06:38:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 03/05/2022 06:38:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 03/05/2022 07:24:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 03/05/2022 07:24:11 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' , '1386' , '2022-05-03' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '9.94' , NOW() , NOW() ) 03/05/2022 07:24:11 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 = '56577' 03/05/2022 07:24:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '56577' 03/05/2022 07:24:11 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 ( '56577' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '9.65' , '9.65' , '0' , '0' , '9.65' ) 03/05/2022 07:24:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 03/05/2022 07:24:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 03/05/2022 07:24:11 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 ( '56577' , '17747' , 'SEGNALIBRO - PR SP 100' , '1' , '-1' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '0.35' ) 03/05/2022 07:24:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17747' AND id_supplier = '' 03/05/2022 07:24:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17747' , '' , '1' )