13/05/2023 09:07:01 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/05/2023 09:07:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21093' , '1' , '' , 'nuovo-prodotto' ) 13/05/2023 09:07:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21093' , '1' , '1' , '2' , NOW() , NOW() ) 13/05/2023 09:07:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21093' , '0' , '1' , '0' , '0' ) 13/05/2023 09:07:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831304139' AND id_product != '21093' AND ean13 != '' 13/05/2023 09:07:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831304139', date_upd = NOW() WHERE id_product = '21093' 13/05/2023 09:07:52 am >> UPDATE ps_product_lang SET name = 'POCO MENO DEGLI ANGELI - M. RUGGIERO', description = '' WHERE id_product = '21093' 13/05/2023 09:07:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21093' 13/05/2023 09:07:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21093' 13/05/2023 09:07:52 am >> DELETE FROM ps_specific_price WHERE id_product = '21093' 13/05/2023 09:08:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831304139' AND id_product != '21093' AND ean13 != '' 13/05/2023 09:08:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831304139', date_upd = NOW() WHERE id_product = '21093' 13/05/2023 09:08:27 am >> UPDATE ps_product_lang SET name = 'POCO MENO DEGLI ANGELI - M. RUGGIERO', description = '' WHERE id_product = '21093' 13/05/2023 09:08:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21093' 13/05/2023 09:08:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21093' 13/05/2023 09:08:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21093' 13/05/2023 09:08:28 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21093' 13/05/2023 09:08:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21094' , '1' , '' , 'nuovo-prodotto' ) 13/05/2023 09:08:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21094' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21093' 13/05/2023 09:08:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21094' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21093' 13/05/2023 09:08:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817037327' AND id_product != '21094' AND ean13 != '' 13/05/2023 09:09:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788817037327', date_upd = NOW() WHERE id_product = '21094' 13/05/2023 09:09:00 am >> UPDATE ps_product_lang SET name = 'RIFUGIO', description = '' WHERE id_product = '21094' 13/05/2023 09:09:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '21094' 13/05/2023 09:09:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '113', id_argoment_default = '49', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21094' 13/05/2023 09:09:00 am >> DELETE FROM ps_specific_price WHERE id_product = '21094' 13/05/2023 09:11:30 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 ( '31' , '4604' , '2023-05-12' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '6.67' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '64.21' , '64.21' , NOW() , NOW() ) 13/05/2023 09:11:30 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 = '84315' 13/05/2023 09:11:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84315' 13/05/2023 09:11:30 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 ( '84315' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '2' , '2' , '4' , '10.90' , '10.9' , '0' , '30' , '15.2600' ) 13/05/2023 09:11:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '20326' AND id_supplier = '105' 13/05/2023 09:11:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20326' , '105' , '1' ) 13/05/2023 09:11:30 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 ( '84315' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '30' , '11.8300' ) 13/05/2023 09:11:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '105' 13/05/2023 09:11:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '105' , '1' ) 13/05/2023 09:11:30 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 ( '84315' , '21093' , 'POCO MENO DEGLI ANGELI - M. RUGGIERO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 13/05/2023 09:11:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21093' AND id_supplier = '105' 13/05/2023 09:11:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21093' , '105' , '1' ) 13/05/2023 09:11:30 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 ( '84315' , '21094' , 'RIFUGIO' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '30' , '8.7500' ) 13/05/2023 09:11:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21094' AND id_supplier = '105' 13/05/2023 09:11:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21094' , '105' , '1' ) 13/05/2023 09:11:30 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 ( '84315' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 13/05/2023 09:11:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '105' 13/05/2023 09:11:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '105' , '1' ) 13/05/2023 09:20:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 09:20: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' , '1647' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 13/05/2023 09:20: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 = '84316' 13/05/2023 09:20:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84316' 13/05/2023 09:20: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 ( '84316' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 13/05/2023 09:20: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 ( '84316' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 13/05/2023 09:26:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 09:26:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1648' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.80' , '19.31' , NOW() , NOW() ) 13/05/2023 09:26:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84317' 13/05/2023 09:26:42 am >> DELETE FROM ps_document_detail WHERE id_document = '84317' 13/05/2023 09:26:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84317' , '21061' , 'ALLE SORGENTI DELLA FEDE IN TERRA SANTA - F. VOLTAGGIO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5.' , '17.10' ) 13/05/2023 09:26:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84317' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/05/2023 09:26:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84317' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 13/05/2023 09:48:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 09:48:58 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' , '1649' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.60' , '45.60' , NOW() , NOW() ) 13/05/2023 09:48:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84318' 13/05/2023 09:48:58 am >> DELETE FROM ps_document_detail WHERE id_document = '84318' 13/05/2023 09:48: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 ( '84318' , '17734' , 'VANGELO E ATTI BAMBINI' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '5' , '45.60' ) 13/05/2023 09:49:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 09:49:13 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' , '1650' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.60' , '45.60' , NOW() , NOW() ) 13/05/2023 09:49:13 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 = '84319' 13/05/2023 09:49:13 am >> DELETE FROM ps_document_detail WHERE id_document = '84319' 13/05/2023 09:49:13 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 ( '84319' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '12' , '-12' , '4' , '4.00' , '4' , '0' , '5' , '45.60' ) 13/05/2023 09:53:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 09:53:47 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' , '1651' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.00' , '85.70' , NOW() , NOW() ) 13/05/2023 09:53:47 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 = '84320' 13/05/2023 09:53:47 am >> DELETE FROM ps_document_detail WHERE id_document = '84320' 13/05/2023 09:53:47 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 ( '84320' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '44.85' , '36.762295081967' , '22' , '0' , '44.85' ) 13/05/2023 09:53:47 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 ( '84320' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 13/05/2023 09:53:47 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 ( '84320' , '19379' , 'MISTERI MARIANI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 13/05/2023 10:11:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 10:11: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' , '1652' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.65' , '23.22' , NOW() , NOW() ) 13/05/2023 10:11: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 = '84321' 13/05/2023 10:11:12 am >> DELETE FROM ps_document_detail WHERE id_document = '84321' 13/05/2023 10:11: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 ( '84321' , '21093' , 'POCO MENO DEGLI ANGELI - M. RUGGIERO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 13/05/2023 10:11: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 ( '84321' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '5' , '-5' , '4' , '1.40' , '1.4' , '0' , '0' , '7.00' ) 13/05/2023 10:11: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 ( '84321' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 13/05/2023 10:15:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1626' AND id_document != '84294' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-12') 13/05/2023 10:15:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1626', document_date = '2023-05-12', 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 = '320.00', price_tax_excluded = '269.25', date_upd = NOW() WHERE id_document = '84294' 13/05/2023 10:15: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 = '84294' 13/05/2023 10:15:20 am >> DELETE FROM ps_document_detail WHERE id_document = '84294' 13/05/2023 10:15: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 ( '84294' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '65' , '-65' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '78.00' ) 13/05/2023 10:15: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 ( '84294' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '70' , '-70' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '35.00' ) 13/05/2023 10:15: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 ( '84294' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 13/05/2023 10:15: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 ( '84294' , '15334' , 'CANDELA VOTIVA 20X40' , '95' , '-95' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '61.75' ) 13/05/2023 10:15: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 ( '84294' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 13/05/2023 10:15: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 ( '84294' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/05/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84294' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 13/05/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84294' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '30.00' ) 13/05/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84294' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 13/05/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84294' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 13/05/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84294' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 13/05/2023 10:17:03 am >> DELETE FROM ps_document WHERE id_document = '83047' 13/05/2023 10:17:03 am >> DELETE FROM ps_document_detail WHERE id_document = '83047' 13/05/2023 10:23:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 10:23:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1653' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '11.40' , NOW() , NOW() ) 13/05/2023 10:23:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84322' 13/05/2023 10:23:41 am >> DELETE FROM ps_document_detail WHERE id_document = '84322' 13/05/2023 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84322' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 13/05/2023 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84322' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/05/2023 10:41:00 am >> SELECT document_num FROM ps_document WHERE document_num = '931' AND id_document != '82412' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-22') 13/05/2023 10:41:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '931', document_date = '2023-03-22', 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 = '60.00', price_tax_excluded = '53.98', date_upd = NOW() WHERE id_document = '82412' 13/05/2023 10:41:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82412' 13/05/2023 10:41:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82412' 13/05/2023 10:41:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82412' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/05/2023 10:41:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82412' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 13/05/2023 10:41:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82412' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 13/05/2023 10:41:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82412' , '18760' , 'BRACCIALE ARG - 1819' , '1' , '-1' , '1' , '31.4' , '25.737704918033' , '22' , '0' , '31.40' ) 13/05/2023 10:58:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 10:58: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' , '1654' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 13/05/2023 10:58: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 = '84323' 13/05/2023 10:58:12 am >> DELETE FROM ps_document_detail WHERE id_document = '84323' 13/05/2023 10:58: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 ( '84323' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 13/05/2023 10:58: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 ( '84323' , '19772' , 'BRACCIALE ARGENTO/EMATITE - 1374CAV' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 13/05/2023 10:59:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 10:59:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1655' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 13/05/2023 10:59: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 = '84324' 13/05/2023 10:59:24 am >> DELETE FROM ps_document_detail WHERE id_document = '84324' 13/05/2023 10:59: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 ( '84324' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 13/05/2023 11:10:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:10: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' , '1656' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.60' , '143.11' , NOW() , NOW() ) 13/05/2023 11:10: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 = '84325' 13/05/2023 11:10:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84325' 13/05/2023 11:10: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 ( '84325' , '18276' , 'CINGOLO CON NODI - 3280' , '3' , '-3' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '6.60' ) 13/05/2023 11:10: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 ( '84325' , '2652' , 'CONFEZIONE CARTONCINO COMUNIONE - 2331/K126' , '5' , '-5' , '1' , '2' , '1.6393442622951' , '22' , '0' , '10.00' ) 13/05/2023 11:10: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 ( '84325' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '158' , '129.50819672131' , '22' , '0' , '158.00' ) 13/05/2023 11:10:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:10:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1657' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 13/05/2023 11:10:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84326' 13/05/2023 11:10:39 am >> DELETE FROM ps_document_detail WHERE id_document = '84326' 13/05/2023 11:10:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84326' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 13/05/2023 11:23:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:23:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1658' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '16.60' , NOW() , NOW() ) 13/05/2023 11:23:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84327' 13/05/2023 11:23:39 am >> DELETE FROM ps_document_detail WHERE id_document = '84327' 13/05/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84327' , '11376' , 'VIENI SPIRITO SANTO' , '17' , '-17' , '4' , '0.20' , '0.2' , '0' , '0' , '3.40' ) 13/05/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84327' , '16310' , 'PORTACHIAVI COLOMBA' , '14' , '-14' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '14.00' ) 13/05/2023 11:23:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84327' , '18222' , 'ROSARIO COLORATO - R316' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 13/05/2023 11:41:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1656' AND id_document != '84325' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:41:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1656', document_date = '2023-05-13', 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 = '174.60', price_tax_excluded = '143.11', date_upd = NOW() WHERE id_document = '84325' 13/05/2023 11:41:21 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 = '84325' 13/05/2023 11:41:21 am >> DELETE FROM ps_document_detail WHERE id_document = '84325' 13/05/2023 11:41:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84325' , '18276' , 'CINGOLO CON NODI - 3280' , '3' , '-3' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '6.60' ) 13/05/2023 11:41:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84325' , '2652' , 'CONFEZIONE CARTONCINO COMUNIONE - 2331/K126' , '7' , '-7' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '15.40' ) 13/05/2023 11:41:22 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 ( '84325' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '152.6' , '125.08196721311' , '22' , '0' , '152.60' ) 13/05/2023 11:43:15 am >> SELECT document_num FROM ps_document WHERE document_num = '955' AND id_document != '82444' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-24') 13/05/2023 11:43:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '955', document_date = '2023-03-24', 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 = '349.10', price_tax_excluded = '290.93', date_upd = NOW() WHERE id_document = '82444' 13/05/2023 11:43: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 = '82444' 13/05/2023 11:43:15 am >> DELETE FROM ps_document_detail WHERE id_document = '82444' 13/05/2023 11:43: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 ( '82444' , '16310' , 'PORTACHIAVI COLOMBA' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 13/05/2023 11:43: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 ( '82444' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/05/2023 11:43: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 ( '82444' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '12.00' ) 13/05/2023 11:43: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 ( '82444' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 13/05/2023 11:43: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 ( '82444' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '2' , '-2' , '1' , '38.5000' , '31.55737704918' , '22' , '0' , '77.00' ) 13/05/2023 11:43: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 ( '82444' , '4200' , 'FINTA CANDELA 3,2X80 - 136' , '4' , '-4' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '68.00' ) 13/05/2023 11:43: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 ( '82444' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 13/05/2023 11:43:31 am >> SELECT document_num FROM ps_document WHERE document_num = '980' AND id_document != '82474' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 13/05/2023 11:43:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '980', document_date = '2023-03-25', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '82474' 13/05/2023 11:43:31 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 = '82474' 13/05/2023 11:43:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82474' 13/05/2023 11:43:31 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 ( '82474' , '16310' , 'PORTACHIAVI COLOMBA' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 13/05/2023 11:43:31 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 ( '82474' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 13/05/2023 11:43:31 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 ( '82474' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 13/05/2023 11:44:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1652' AND id_document != '84321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:44:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1652', document_date = '2023-05-13', 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 = '23.65', price_tax_excluded = '23.22', date_upd = NOW() WHERE id_document = '84321' 13/05/2023 11:44:30 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 = '84321' 13/05/2023 11:44:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84321' 13/05/2023 11:44:30 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 ( '84321' , '21093' , 'POCO MENO DEGLI ANGELI - M. RUGGIERO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 13/05/2023 11:44:30 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 ( '84321' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '5' , '-5' , '4' , '1.4000' , '1.4' , '0' , '0' , '7.00' ) 13/05/2023 11:44:30 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 ( '84321' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 13/05/2023 11:44:31 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 ( '84321' , '16310' , 'PORTACHIAVI COLOMBA' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/05/2023 11:45:37 am >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 13/05/2023 11:45:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '344.00', price_tax_excluded = '281.97', date_upd = NOW() WHERE id_document = '82684' 13/05/2023 11:45: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 = '82684' 13/05/2023 11:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82684' 13/05/2023 11:45: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 13/05/2023 11:45: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 ( '82684' , '20120' , 'FATIMA CM 27 -1025' , '2' , '-2' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '44.00' ) 13/05/2023 11:51:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 13/05/2023 11:51:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1659' , '2023-05-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 13/05/2023 11:51:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84328' 13/05/2023 11:51:43 am >> DELETE FROM ps_document_detail WHERE id_document = '84328' 13/05/2023 11:51:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84328' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '7' , '-7' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '21.00' )