06/07/2023 08:17:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 08:17: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' , '2308' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.00' , '81.15' , NOW() , NOW() ) 06/07/2023 08:17: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 = '86650' 06/07/2023 08:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '86650' 06/07/2023 08:17: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 ( '86650' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 06/07/2023 10:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 10:12:00 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' , '2309' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '79.42' , NOW() , NOW() ) 06/07/2023 10:12: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 = '86651' 06/07/2023 10:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '86651' 06/07/2023 10:12: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 ( '86651' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '58.65' , '48.073770491803' , '22' , '0' , '58.65' ) 06/07/2023 10:12: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 ( '86651' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 06/07/2023 10:12: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 ( '86651' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 06/07/2023 10:12: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 ( '86651' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/07/2023 10:12: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 ( '86651' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/07/2023 10:30:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/07/2023 10:30:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21348' , '1' , '' , 'nuovo-prodotto' ) 06/07/2023 10:30:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21348' , '1' , '1' , '2' , NOW() , NOW() ) 06/07/2023 10:30:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21348' , '0' , '1' , '0' , '0' ) 06/07/2023 10:31:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546623' AND id_product != '21348' AND ean13 != '' 06/07/2023 10:31:28 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791280546623', date_upd = NOW() WHERE id_product = '21348' 06/07/2023 10:31:28 am >> UPDATE ps_product_lang SET name = 'PAPA FRANCESCO - UN RITRATTO SPIRITUALE - G. VIGINI', description = '' WHERE id_product = '21348' 06/07/2023 10:31:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21348' 06/07/2023 10:31:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '483', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21348' 06/07/2023 10:31:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21348' 06/07/2023 10:32: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 ( '33' , '635894' , '2023-07-04' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.48' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '87.68' , '87.68' , NOW() , NOW() ) 06/07/2023 10:32: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 = '86652' 06/07/2023 10:32:24 am >> DELETE FROM ps_document_detail WHERE id_document = '86652' 06/07/2023 10:32: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 ( '86652' , '21118' , 'MARIA MADRE DELLEUCARISTIA - D. RUOTOLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21118' AND id_supplier = '7' 06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21118' , '7' , '1' ) 06/07/2023 10:32: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 ( '86652' , '21067' , 'AMEN - AGO 23' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21067' AND id_supplier = '7' 06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21067' , '7' , '1' ) 06/07/2023 10:32: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 ( '86652' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 06/07/2023 10:32: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 ( '86652' , '21199' , 'AMEN - OTT 2023' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 06/07/2023 10:32: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 ( '86652' , '21198' , 'AMEN - SET 2023' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' ) 06/07/2023 10:32:25 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 ( '86652' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '4' , '4' , '4' , '6.00' , '6' , '0' , '30' , '16.8000' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21068' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21068' , '7' , '1' ) 06/07/2023 10:32:25 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 ( '86652' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '15939' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15939' , '7' , '1' ) 06/07/2023 10:32:25 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 ( '86652' , '11743' , 'MINISTERO STRAORDINARIO DELLA COMUNIONE' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11743' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11743' , '7' , '1' ) 06/07/2023 10:32:25 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 ( '86652' , '20935' , 'TU X TUTTI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '20935' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20935' , '7' , '1' ) 06/07/2023 10:32:25 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 ( '86652' , '21348' , 'PAPA FRANCESCO - UN RITRATTO SPIRITUALE - G. VIGINI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21348' AND id_supplier = '7' 06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21348' , '7' , '1' ) 06/07/2023 10:35:45 am >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 10:35:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '34' , '2023-07-06' , '' , '3463' , '0' , '4670120' , 'VIA MARCO AURELIO 81 80126 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 06/07/2023 10:35:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11353' 06/07/2023 10:35:45 am >> DELETE FROM ps_document_detail WHERE id_document = '11353' 06/07/2023 10:35:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11353' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 06/07/2023 10:56:07 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 10:56:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '106' , '2023-07-06' , '' , '690' , '0' , '4670873' , 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '42.00' , '42.00' , NOW() , NOW() ) 06/07/2023 10:56:07 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 = '86653' 06/07/2023 10:56:07 am >> DELETE FROM ps_document_detail WHERE id_document = '86653' 06/07/2023 10:56:07 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 ( '86653' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '4' , '0.18' , '0.18' , '0' , '5' , '34.20' ) 06/07/2023 10:56:07 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 ( '86653' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 06/07/2023 11:30:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 11:30:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2310' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '247.60' , '202.95' , NOW() , NOW() ) 06/07/2023 11:30:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86654' 06/07/2023 11:30:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86654' 06/07/2023 11:30:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86654' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '240' , '196.72131147541' , '22' , '0' , '240.00' ) 06/07/2023 11:30: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 ( '86654' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 06/07/2023 11:56:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 11:56:14 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' , '2311' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 06/07/2023 11:56:14 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 = '86655' 06/07/2023 11:56:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86655' 06/07/2023 11:56:14 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 ( '86655' , '5894' , 'LITURGIA DELLE ORE IV - FRANCESCANA' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 06/07/2023 12:04:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 12:04:10 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' , '2312' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 06/07/2023 12:04:10 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 = '86656' 06/07/2023 12:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '86656' 06/07/2023 12:04:10 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 ( '86656' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 06/07/2023 12:05:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3226' 06/07/2023 12:05:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3226' , '10' , '210' , '' , 'IANNONE' , 'DON PASQUALE' , 'via' , '' , '84100' , 'salerno' , '' , '' , '3478274631' , '' , '' , NOW() , NOW() ) 06/07/2023 12:05:22 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3226' 06/07/2023 12:08:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '73/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 12:08:15 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' , '73/A' , '2023-07-06' , 'A' , '3226' , '0' , '4679059' , 'via 84100 salerno' , '' , 'acconto € 80,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 06/07/2023 12:08:15 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 = '86657' 06/07/2023 12:08:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '86657' 06/07/2023 12:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86657' , '15680' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '600' , '491.80327868852' , '22' , '0' , '600.00' ) 06/07/2023 12:11:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 12:11:27 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' , '2313' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.50' , '42.21' , NOW() , NOW() ) 06/07/2023 12:11:27 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 = '86658' 06/07/2023 12:11:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '86658' 06/07/2023 12:11:27 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 ( '86658' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 06/07/2023 12:11:27 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 ( '86658' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 06/07/2023 12:30:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055764' AND id_product != '20816' AND ean13 != '' 06/07/2023 12:30:55 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788825055764', date_upd = NOW() WHERE id_product = '20816' 06/07/2023 12:30:55 pm >> UPDATE ps_product_lang SET name = 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO', description = '' WHERE id_product = '20816' 06/07/2023 12:30:55 pm >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '20816' 06/07/2023 12:30:55 pm >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20816' 06/07/2023 12:30:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20816' 06/07/2023 04:22:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023274660' , '2023-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '625.20' , '623.38' , NOW() , NOW() ) 06/07/2023 04:22:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86659' 06/07/2023 04:22:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '86659' 06/07/2023 04:22:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21296' , 'PIETRE DI GERUSALEMME' , '1' , '0' , '4' , '16.54' , '16.54' , '0' , '0' , '16.5400' ) 06/07/2023 04:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21296' AND id_supplier = '109' 06/07/2023 04:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21296' , '109' , '1' ) 06/07/2023 04:22:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21318' , 'TRAUMI DEUROPA' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21318' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21318' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21335' , 'AMARSI SEDUZIONE E DESIDERIO' , '1' , '0' , '4' , '28.35' , '28.35' , '0' , '0' , '28.3500' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21335' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21335' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21317' , 'GRANDE RACCONTO DI ROMA ANTICA' , '1' , '0' , '4' , '23.62' , '23.62' , '0' , '0' , '23.6200' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21317' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21317' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21337' , 'GRANDE RACCONTO DEL FAVOLOSO ORIENTE' , '1' , '0' , '4' , '28.35' , '28.35' , '0' , '0' , '28.3500' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21337' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21337' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21299' , 'DONNE DI DANTE' , '1' , '0' , '4' , '22.46' , '22.46' , '0' , '0' , '22.4600' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21299' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21299' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21324' , 'DONNA ROMANA' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21324' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21324' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21332' , 'GUERRIERO LOPLITA IL LEGIONARIO' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21332' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21332' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21303' , 'OLTREMARE' , '1' , '0' , '4' , '9.45' , '9.45' , '0' , '0' , '9.4500' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21303' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21303' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21336' , 'PARADISO VISTA INFERNO' , '1' , '0' , '4' , '22.46' , '22.46' , '0' , '0' , '22.4600' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21336' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21336' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21306' , 'FEDERICO II' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21306' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21306' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21304' , 'SICILIA MUSULMANA' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21304' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21304' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21320' , 'CONTRO UN NEMICO INVISIBILE' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21320' AND id_supplier = '109' 06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21320' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21319' , 'STORIA ECONOMICA DELLEUROPA' , '1' , '0' , '4' , '8.86' , '8.86' , '0' , '0' , '8.8600' ) 06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21319' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21319' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21327' , 'STORIA DEL REGNO DELLE DUE SICILIE' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21327' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21327' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21329' , 'MILITARI ITALIANI NEI LAGER NAZISTI' , '1' , '0' , '4' , '8.86' , '8.86' , '0' , '0' , '8.8600' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21329' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21329' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21313' , 'TEMPLARI' , '1' , '0' , '4' , '7.10' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21313' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21313' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21328' , 'RIBELLI CONTRO ROMA' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21328' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21328' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21312' , 'ERETICI ED ERESIE MEDIEVALI' , '1' , '0' , '4' , '7.10' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21312' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21312' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21307' , 'IN VIAGGIO NEL MEDIOEVO' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21307' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21307' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21322' , 'TERRASANTA PELLEGRINI ITALIANI' , '1' , '0' , '4' , '9.45' , '9.45' , '0' , '0' , '9.4500' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21322' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21322' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21305' , 'STORIA DI BISANZIO' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21305' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21305' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21302' , 'PERCHE IL SUD E RIMASTO INDIETRO' , '1' , '0' , '4' , '7.68' , '7.68' , '0' , '0' , '7.6800' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21302' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21302' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21300' , 'PREDOMINIO DELLOCCIDENTE' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21300' AND id_supplier = '109' 06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21300' , '109' , '1' ) 06/07/2023 04:22: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 ( '86659' , '21308' , 'COMUNISTI MANGIANO I BAMBINI' , '1' , '0' , '4' , '7.1' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21308' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21308' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21334' , 'RACCONTO DI ULISSE' , '1' , '0' , '4' , '32.49' , '32.49' , '0' , '0' , '32.4900' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21334' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21334' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21310' , 'GRANDE RACCONTO DELLE RELIGIONI' , '1' , '0' , '4' , '29.54' , '29.54' , '0' , '0' , '29.5400' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21310' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21310' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21333' , 'CROCIATE DEL NORD' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21333' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21333' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21301' , 'IMPERATORI DI BISANZIO' , '1' , '0' , '4' , '7.1' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21301' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21301' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21321' , 'SECOLO DEI GENOCIDI' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21321' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21321' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21326' , 'IL CAPO' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21326' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21326' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21298' , 'SEDUCENTI IMMAGINI' , '1' , '0' , '4' , '20.67' , '20.67' , '0' , '0' , '20.6700' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21298' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21298' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21309' , 'GRANDE RACCONTO DEI VIAGGI DESPLORAZIONE' , '1' , '0' , '4' , '28.35' , '28.35' , '0' , '0' , '28.3500' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21309' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21309' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21315' , 'SANTITA NEL MEDIOEVO' , '1' , '0' , '4' , '11.23' , '11.23' , '0' , '0' , '11.2300' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21315' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21315' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21311' , 'STORIA DELLA MASSONERIA ITALIANA' , '1' , '0' , '4' , '9.45' , '9.45' , '0' , '0' , '9.4500' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21311' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21311' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21314' , 'GRANDE RACCONTO DELLE CITTA ITALIANE' , '1' , '0' , '4' , '29.54' , '29.54' , '0' , '0' , '29.5400' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21314' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21314' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21331' , 'RAZZISMI DALLE CROCIATE AL XX SECOLO' , '1' , '0' , '4' , '12.99' , '12.99' , '0' , '0' , '12.9900' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21331' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21331' , '109' , '1' ) 06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21323' , 'ARABI E LEUROPA NEL MEDIO EVO' , '1' , '0' , '4' , '8.26' , '8.26' , '0' , '0' , '8.2600' ) 06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21323' AND id_supplier = '109' 06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21323' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21316' , 'ERETICI' , '1' , '0' , '4' , '7.1' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21316' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21316' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21297' , 'VINO E LA CARNE' , '1' , '0' , '4' , '7.1' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21297' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21297' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21325' , 'ITALIA FASCISTA E LA PERSECUZIONE' , '1' , '0' , '4' , '9.45' , '9.45' , '0' , '0' , '9.4500' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21325' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21325' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21330' , 'CROCIATE' , '1' , '0' , '4' , '7.10' , '7.1' , '0' , '0' , '7.1000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21330' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21330' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21295' , 'GUERRA SANTA - J. FLORI' , '1' , '0' , '1' , '8.26' , '6.7704918032787' , '22' , '0' , '10.0772' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21295' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21295' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21213' , 'Le exterae gentes in Valerio Massimo' , '1' , '0' , '4' , '18.2' , '18.2' , '0' , '0' , '18.2000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21213' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21213' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21214' , 'Migranti e lavoro qualificato nel mondo antico' , '1' , '0' , '4' , '16.8' , '16.8' , '0' , '0' , '16.8000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21214' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21214' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21218' , 'Tra mare e continente: lisola dEubea' , '1' , '0' , '4' , '15.6' , '15.6' , '0' , '0' , '15.6000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21218' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21218' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21221' , 'L «Onomasticon» di Giulio Polluce. Tra lessicografia e antiquaria' , '1' , '0' , '4' , '9.60' , '9.6' , '0' , '0' , '9.6000' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21221' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21221' , '109' , '1' ) 06/07/2023 04:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21212' , 'Erodiano. Tra crisi e trasformazione' , '1' , '0' , '4' , '15.01' , '15.01' , '0' , '0' , '15.0100' ) 06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21212' AND id_supplier = '109' 06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21212' , '109' , '1' ) 06/07/2023 04:31:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2314' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 04:31:14 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' , '2314' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 06/07/2023 04:31:14 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 = '86660' 06/07/2023 04:31:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86660' 06/07/2023 04:31:14 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 ( '86660' , '19855' , 'STOLA ROMANA S/MOIRE - 7606S' , '1' , '-1' , '1' , '390.00' , '319.67213114754' , '22' , '0' , '390.00' ) 06/07/2023 04:33:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 04:33: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' , '2315' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 06/07/2023 04:33: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 = '86661' 06/07/2023 04:33:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86661' 06/07/2023 04:33: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 ( '86661' , '14367' , 'CLERGY TESS. BOSTON - GRIGIO - MISTO ML 38' , '1' , '-1' , '1' , '44.1' , '36.147540983607' , '22' , '0' , '44.10' ) 06/07/2023 04:33: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 ( '86661' , '14380' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 38' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 06/07/2023 04:33: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 ( '86661' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 06/07/2023 04:33: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 ( '86661' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35.9' , '29.426229508197' , '22' , '0' , '35.90' ) 06/07/2023 04:39:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2315' AND id_document != '86661' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 04:39:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2315', document_date = '2023-07-06', 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 = '155.00', price_tax_excluded = '127.05', date_upd = NOW() WHERE id_document = '86661' 06/07/2023 04:39: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 = '86661' 06/07/2023 04:39:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86661' 06/07/2023 04:39:52 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 ( '86661' , '14367' , 'CLERGY TESS. BOSTON - GRIGIO - MISTO ML 38' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 06/07/2023 04:39:52 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 ( '86661' , '14380' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 38' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 06/07/2023 04:39:52 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 ( '86661' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '39.9' , '32.704918032787' , '22' , '0' , '39.90' ) 06/07/2023 04:39:52 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 ( '86661' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.1' , '12.377049180328' , '22' , '0' , '15.10' ) 06/07/2023 04:40:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1269' AND id_document != '82831' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-17') 06/07/2023 04:40:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1269', document_date = '2023-04-17', 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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '82831' 06/07/2023 04:40:46 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 = '82831' 06/07/2023 04:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82831' 06/07/2023 04:40:46 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 ( '82831' , '17005' , 'BIGLIETTO AUGURALE medio' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 06/07/2023 04:40:46 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 ( '82831' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 06/07/2023 04:43:20 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '6023274660', document_date = '2023-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = '', price_shipping = '19.2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '13', id_causal = '0', price_tax_included = '644.40', price_tax_excluded = '642.58', date_upd = NOW() WHERE id_document = '86659' 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86659' 06/07/2023 04:43:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '86659' 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21296' , 'PIETRE DI GERUSALEMME' , '1' , '0' , '4' , '16.5400' , '16.54' , '0' , '0' , '16.54' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21318' , 'TRAUMI DEUROPA' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21335' , 'AMARSI SEDUZIONE E DESIDERIO' , '1' , '0' , '4' , '28.3500' , '28.35' , '0' , '0' , '28.35' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21317' , 'GRANDE RACCONTO DI ROMA ANTICA' , '1' , '0' , '4' , '23.6200' , '23.62' , '0' , '0' , '23.62' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21337' , 'GRANDE RACCONTO DEL FAVOLOSO ORIENTE' , '1' , '0' , '4' , '28.3500' , '28.35' , '0' , '0' , '28.35' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21299' , 'DONNE DI DANTE' , '1' , '0' , '4' , '22.4600' , '22.46' , '0' , '0' , '22.46' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21324' , 'DONNA ROMANA' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21332' , 'GUERRIERO LOPLITA IL LEGIONARIO' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21303' , 'OLTREMARE' , '1' , '0' , '4' , '9.4500' , '9.45' , '0' , '0' , '9.45' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21336' , 'PARADISO VISTA INFERNO' , '1' , '0' , '4' , '22.4600' , '22.46' , '0' , '0' , '22.46' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21306' , 'FEDERICO II' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21304' , 'SICILIA MUSULMANA' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21320' , 'CONTRO UN NEMICO INVISIBILE' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21319' , 'STORIA ECONOMICA DELLEUROPA' , '1' , '0' , '4' , '8.8600' , '8.86' , '0' , '0' , '8.86' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21327' , 'STORIA DEL REGNO DELLE DUE SICILIE' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21329' , 'MILITARI ITALIANI NEI LAGER NAZISTI' , '1' , '0' , '4' , '8.8600' , '8.86' , '0' , '0' , '8.86' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21313' , 'TEMPLARI' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21328' , 'RIBELLI CONTRO ROMA' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21312' , 'ERETICI ED ERESIE MEDIEVALI' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21307' , 'IN VIAGGIO NEL MEDIOEVO' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21322' , 'TERRASANTA PELLEGRINI ITALIANI' , '1' , '0' , '4' , '9.4500' , '9.45' , '0' , '0' , '9.45' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21305' , 'STORIA DI BISANZIO' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21302' , 'PERCHE IL SUD E RIMASTO INDIETRO' , '1' , '0' , '4' , '7.6800' , '7.68' , '0' , '0' , '7.68' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21300' , 'PREDOMINIO DELLOCCIDENTE' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21308' , 'COMUNISTI MANGIANO I BAMBINI' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21334' , 'RACCONTO DI ULISSE' , '1' , '0' , '4' , '32.4900' , '32.49' , '0' , '0' , '32.49' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21310' , 'GRANDE RACCONTO DELLE RELIGIONI' , '1' , '0' , '4' , '29.5400' , '29.54' , '0' , '0' , '29.54' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21333' , 'CROCIATE DEL NORD' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21301' , 'IMPERATORI DI BISANZIO' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21321' , 'SECOLO DEI GENOCIDI' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21326' , 'IL CAPO' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21298' , 'SEDUCENTI IMMAGINI' , '1' , '0' , '4' , '20.6700' , '20.67' , '0' , '0' , '20.67' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21309' , 'GRANDE RACCONTO DEI VIAGGI DESPLORAZIONE' , '1' , '0' , '4' , '28.3500' , '28.35' , '0' , '0' , '28.35' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21315' , 'SANTITA NEL MEDIOEVO' , '1' , '0' , '4' , '11.2300' , '11.23' , '0' , '0' , '11.23' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21311' , 'STORIA DELLA MASSONERIA ITALIANA' , '1' , '0' , '4' , '9.4500' , '9.45' , '0' , '0' , '9.45' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21314' , 'GRANDE RACCONTO DELLE CITTA ITALIANE' , '1' , '0' , '4' , '29.5400' , '29.54' , '0' , '0' , '29.54' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21331' , 'RAZZISMI DALLE CROCIATE AL XX SECOLO' , '1' , '0' , '4' , '12.9900' , '12.99' , '0' , '0' , '12.99' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21323' , 'ARABI E LEUROPA NEL MEDIO EVO' , '1' , '0' , '4' , '8.2600' , '8.26' , '0' , '0' , '8.26' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21316' , 'ERETICI' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21297' , 'VINO E LA CARNE' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21325' , 'ITALIA FASCISTA E LA PERSECUZIONE' , '1' , '0' , '4' , '9.4500' , '9.45' , '0' , '0' , '9.45' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21330' , 'CROCIATE' , '1' , '0' , '4' , '7.1000' , '7.1' , '0' , '0' , '7.10' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21295' , 'GUERRA SANTA - J. FLORI' , '1' , '0' , '1' , '8.2600' , '6.7704918032787' , '22' , '0' , '10.08' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21213' , 'Le exterae gentes in Valerio Massimo' , '1' , '0' , '4' , '18.2000' , '18.2' , '0' , '0' , '18.20' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21214' , 'Migranti e lavoro qualificato nel mondo antico' , '1' , '0' , '4' , '16.8000' , '16.8' , '0' , '0' , '16.80' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21218' , 'Tra mare e continente: lisola dEubea' , '1' , '0' , '4' , '15.6000' , '15.6' , '0' , '0' , '15.60' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21221' , 'L «Onomasticon» di Giulio Polluce. Tra lessicografia e antiquaria' , '1' , '0' , '4' , '9.6000' , '9.6' , '0' , '0' , '9.60' ) 06/07/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86659' , '21212' , 'Erodiano. Tra crisi e trasformazione' , '1' , '0' , '4' , '15.0100' , '15.01' , '0' , '0' , '15.01' ) 06/07/2023 05:13:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 05:13:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2316' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 06/07/2023 05:13:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86662' 06/07/2023 05:13:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '86662' 06/07/2023 05:13:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86662' , '1369' , 'BROCCHETTE DECORATE RICAMBIO ART. 500 - 556' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 06/07/2023 05:22:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7054' 06/07/2023 05:22:50 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7054' , '10' , '173' , '' , 'Appetecchi' , 'Monica' , 'Via Galileo Galilei , 19/21/25' , '' , '55041' , 'Camaiore fraz. Lido di Camaiore' , '' , '' , '3398207911' , '' , '' , NOW() , NOW() ) 06/07/2023 05:22:50 pm >> UPDATE ps_customer SET email = 'monicaap@me.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7054' 06/07/2023 05:24:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7054' 06/07/2023 05:24:05 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7054' , '10' , '173' , '' , 'Appetecchi' , 'Monica' , 'Via Galileo Galilei , 19/21/25' , '' , '55041' , 'Camaiore fraz. Lido di Camaiore' , '' , '' , '3398207911' , '' , '' , NOW() , NOW() ) 06/07/2023 05:24:06 pm >> UPDATE ps_customer SET email = 'monicaap@me.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7054' 06/07/2023 05:28:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 05:28:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '35' , '2023-07-06' , '' , '7054' , '0' , '140021163' , 'Via Galileo Galilei , 19/21/25 55041 Camaiore fraz. Lido di Camaiore' , '' , '' , '6.90' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '43.91' , '43.91' , NOW() , NOW() ) 06/07/2023 05:28:18 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 = '11864' 06/07/2023 05:28:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '11864' 06/07/2023 05:28:18 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 ( '11864' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 06/07/2023 05:28:18 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 ( '11864' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/07/2023 05:28:18 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 ( '11864' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 06/07/2023 05:28:18 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 ( '11864' , '96' , 'LA PREGHIERA - MEDICINA DELL\'ANIMA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 06/07/2023 05:28:18 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 ( '11864' , '110' , 'SE MI AMI NON PIANGERE' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 06/07/2023 05:28:18 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 ( '11864' , '115' , 'SAN FRANCESCO D\'ASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 06/07/2023 05:28:18 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 ( '11864' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/07/2023 05:28:18 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 ( '11864' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/07/2023 05:28:18 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 ( '11864' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/07/2023 05:28:18 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 ( '11864' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 06/07/2023 05:28:18 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 ( '11864' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/07/2023 05:28:18 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 ( '11864' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/07/2023 05:28:18 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 ( '11864' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/07/2023 05:28:19 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 ( '11864' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 06/07/2023 05:30:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571351' AND id_product != '132' AND ean13 != '' 06/07/2023 05:30:56 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788899571351', date_upd = NOW() WHERE id_product = '132' 06/07/2023 05:30:56 pm >> UPDATE ps_product_lang SET name = 'MINISTRANTI IERI, OGGI, DOMANI', description = '

Per rendere solenne la liturgia eucaristica, la Chiesa chiama i ragazzi a renderla bella, dignitosa e solenne, tramite il loro servizio sull\'altare, ciascuno con un suo specifico ufficio o incarico.

Ad essi era dato il nome di \"chierichetti\", sostituito oggi con quello di \"ministranti\" che significa \"coloro che servono\':

' WHERE id_product = '132' 06/07/2023 05:30:56 pm >> UPDATE ps_product SET wholesale_price = '0.30', on_sale = '0', price = '2.50' WHERE id_product = '132' 06/07/2023 05:30:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.30', price = '2.50', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '132' 06/07/2023 05:30:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '132' 06/07/2023 05:30:56 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '132' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 06/07/2023 05:34:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 05:34:24 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 ( '23' , '32/E' , '2023-07-06' , 'E' , '2938' , '0' , '4678844' , 'VIA ARCIVESCOVATO 31 55100 LUCCA' , '' , '' , '10' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 06/07/2023 05:34:24 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 = '86663' 06/07/2023 05:34:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '86663' 06/07/2023 05:34:24 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 ( '86663' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '30' , '-30' , '4' , '10.00' , '10' , '0' , '40' , '180.00' ) 06/07/2023 06:13:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 06:13:17 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' , '2317' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 06/07/2023 06:13:17 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 = '86664' 06/07/2023 06:13:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '86664' 06/07/2023 06:13:17 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 ( '86664' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 06/07/2023 06:40:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 06:40:38 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' , '2318' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 06/07/2023 06:40:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86665' 06/07/2023 06:40:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86665' 06/07/2023 06:40:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86665' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 06/07/2023 06:44:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 06:44:12 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' , '2319' , '2023-07-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 06/07/2023 06:44:12 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 = '86666' 06/07/2023 06:44:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '86666' 06/07/2023 06:44:12 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 ( '86666' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 06/07/2023 06:49:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 06:49:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '36' , '2023-07-06' , '' , '3456' , '0' , '4670110' , 'VIA UNIONE SOVIETICA, 81 58100 GROSSETO' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 06/07/2023 06:49:48 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 = '11865' 06/07/2023 06:49:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '11865' 06/07/2023 06:49: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 ( '11865' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/07/2023 07:05:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/E' AND id_document != '86663' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06') 06/07/2023 07:05:13 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '32/E', document_date = '2023-07-06', document_letter = 'E', id_customer = '2938', id_supplier = '', id_address = '4678844', address1 = 'VIA ARCIVESCOVATO 31 55100 LUCCA', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '190.00', price_tax_excluded = '190.00', date_upd = NOW() WHERE id_document = '86663' 06/07/2023 07:05:13 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 = '86663' 06/07/2023 07:05:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86663' 06/07/2023 07:05:13 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 ( '86663' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '30' , '-30' , '4' , '10.0000' , '10' , '0' , '40' , '180.00' ) 06/07/2023 07:05:13 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 ( '86663' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 06/07/2023 07:36:00 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' , '6023274656' , '2023-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.82' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '60.96' , '60.96' , NOW() , NOW() ) 06/07/2023 07:36:00 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 = '86667' 06/07/2023 07:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86667' 06/07/2023 07:36:00 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 ( '86667' , '21160' , 'STORIA DELLA TEOLOGIA 1 - B. MONDIN' , '1' , '0' , '4' , '38.35' , '38.35' , '0' , '0' , '38.3500' ) 06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21160' AND id_supplier = '109' 06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21160' , '109' , '1' ) 06/07/2023 07:36:00 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 ( '86667' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '0' , '4' , '11.04' , '11.04' , '0' , '0' , '11.0400' ) 06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21338' AND id_supplier = '109' 06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21338' , '109' , '1' ) 06/07/2023 07:36:00 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 ( '86667' , '21343' , 'LETTERE DI GIOVANNI - G.I. GARGANO' , '1' , '0' , '4' , '9.75' , '9.75' , '0' , '0' , '9.7500' ) 06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21343' AND id_supplier = '109' 06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21343' , '109' , '1' )