18/11/2024 09:19:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 09:19:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3515' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 18/11/2024 09:19:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94311' 18/11/2024 09:19:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94311' 18/11/2024 09:19:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94311' , '16244' , 'QUADRO 10X10' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 18/11/2024 09:21:41 am >> SELECT document_num FROM ps_document WHERE document_num = '238' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 09:21:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '238' , '2024-11-18' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.80' , '83.19' , NOW() , NOW() ) 18/11/2024 09:21:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94312' 18/11/2024 09:21:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94312' 18/11/2024 09:21:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94312' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 18/11/2024 09:21:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94312' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 18/11/2024 09:21:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94312' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 18/11/2024 09:21:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94312' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 18/11/2024 09:26:15 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/11/2024 09:26:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23221' , '1' , '' , 'nuovo-prodotto' ) 18/11/2024 09:26:15 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23221' , '1' , '1' , '2' , NOW() , NOW() ) 18/11/2024 09:26:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23221' , '0' , '1' , '0' , '0' ) 18/11/2024 09:37:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069297' AND id_product != '23221' AND ean13 != '' 18/11/2024 09:37:54 am >> UPDATE ps_product SET id_supplier = '', reference = '11/6', ean13 = '9788801069297', date_upd = NOW() WHERE id_product = '23221' 18/11/2024 09:37:54 am >> UPDATE ps_product_lang SET name = 'CHE BELLA STORIA QUELLA DI GESU\' - P. VILLANUEVA', description = '' WHERE id_product = '23221' 18/11/2024 09:37:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23221' 18/11/2024 09:37:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '181', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23221' 18/11/2024 09:37:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23221' 18/11/2024 09:39:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '681712' , '2024-11-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.92' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '97.82' , '97.82' , NOW() , NOW() ) 18/11/2024 09:39:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94313' 18/11/2024 09:39:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94313' 18/11/2024 09:39:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94313' , '23169' , 'DILEXIT NOS ' , '60' , '60' , '4' , '2.20' , '2.2' , '0' , '35' , '85.8000' ) 18/11/2024 09:39:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 18/11/2024 09:39:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 18/11/2024 09:39:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94313' , '23169' , 'DILEXIT NOS ' , '5' , '5' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 18/11/2024 09:39:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 18/11/2024 09:39:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 18/11/2024 09:39:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94313' , '23221' , 'CHE BELLA STORIA QUELLA DI GESU - P. VILLANUEVA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 18/11/2024 09:39:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23221' AND id_supplier = '7' 18/11/2024 09:39:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23221' , '7' , '1' ) 18/11/2024 10:16:47 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'dB4nZBN7WIaH95Xs' , NOW() , NOW() ) 18/11/2024 10:16:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4142' , '1' ) 18/11/2024 10:16:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4142' , '2' ) 18/11/2024 10:16:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4142' , '3' ) 18/11/2024 10:18:59 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4142' 18/11/2024 10:18:59 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4142' , '10' , '124' , '' , 'BELLO' , 'MARIANGELA ' , 'VIA RAINERI 10' , '' , '15122' , 'SPINETTA MARENGO' , '' , '' , '3299882002' , '' , '' , NOW() , NOW() ) 18/11/2024 10:18:59 am >> UPDATE ps_customer SET email = 'mariangela.bello@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4142' 18/11/2024 10:20:37 am >> SELECT document_num FROM ps_document WHERE document_num = '239' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 10:20:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '239' , '2024-11-18' , '' , '4142' , '0' , '4679426' , 'VIA RAINERI 10 15122 SPINETTA MARENGO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '47.56' , '47.56' , NOW() , NOW() ) 18/11/2024 10:20:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94314' 18/11/2024 10:20:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94314' 18/11/2024 10:20:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94314' , '11192' , 'VENITE CON ME 2 PARTE' , '16' , '-16' , '4' , '2.80' , '2.8' , '0' , '5' , '42.56' ) 18/11/2024 10:22:00 am >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 10:22: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 ( '24' , '125/A' , '2024-11-18' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.80' , '99.80' , NOW() , NOW() ) 18/11/2024 10:22: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 = '94315' 18/11/2024 10:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94315' 18/11/2024 10:22: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 ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 18/11/2024 10:22: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 ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 18/11/2024 10:22: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 ( '94315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346' , '4' , '0' , '4.30' ) 18/11/2024 10:22: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 ( '94315' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.459' , '22' , '0' , '90.00' ) 18/11/2024 10:22:03 am >> DELETE FROM ps_document WHERE id_document = '94312' 18/11/2024 10:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '94312' 18/11/2024 10:22:14 am >> SELECT document_num FROM ps_document WHERE document_num = '238' AND id_document != '94314' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 10:22:14 am >> UPDATE ps_document SET id_document_type = '21', document_num = '238', document_date = '2024-11-18', document_letter = '', id_customer = '4142', id_supplier = '', id_address = '4679426', address1 = 'VIA RAINERI 10 15122 SPINETTA MARENGO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '47.56', price_tax_excluded = '47.56', date_upd = NOW() WHERE id_document = '94314' 18/11/2024 10:22: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 = '94314' 18/11/2024 10:22:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94314' 18/11/2024 10:22: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 ( '94314' , '11192' , 'VENITE CON ME 2 PARTE' , '16' , '-16' , '4' , '2.8000' , '2.8' , '0' , '5' , '42.56' ) 18/11/2024 11:07:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:07: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' , '3516' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '593.00' , '486.07' , NOW() , NOW() ) 18/11/2024 11:07: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 = '94316' 18/11/2024 11:07:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94316' 18/11/2024 11:07: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 ( '94316' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '593' , '486.06557377049' , '22' , '0' , '593.00' ) 18/11/2024 11:26:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:26: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 ( '11' , '3517' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.56' , '90.58' , NOW() , NOW() ) 18/11/2024 11:26: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 = '94317' 18/11/2024 11:26:45 am >> DELETE FROM ps_document_detail WHERE id_document = '94317' 18/11/2024 11:26: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 ( '94317' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 18/11/2024 11:26: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 ( '94317' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 18/11/2024 11:26: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 ( '94317' , '23061' , 'PELLEGRINO IN CORSIA - G. MANGERI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 18/11/2024 11:26: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 ( '94317' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '42.00' ) 18/11/2024 11:26: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 ( '94317' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 18/11/2024 11:30:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:30:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3518' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 18/11/2024 11:30:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94318' 18/11/2024 11:30:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94318' 18/11/2024 11:30:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94318' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 18/11/2024 11:39:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3519' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:39: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' , '3519' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 18/11/2024 11:39: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 = '94319' 18/11/2024 11:39:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94319' 18/11/2024 11:39: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 ( '94319' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 18/11/2024 11:41:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:41:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3520' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.81' , '21.81' , NOW() , NOW() ) 18/11/2024 11:41:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94320' 18/11/2024 11:41:57 am >> DELETE FROM ps_document_detail WHERE id_document = '94320' 18/11/2024 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94320' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 18/11/2024 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94320' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.17' , '7.17' , '0' , '0' , '7.17' ) 18/11/2024 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94320' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 18/11/2024 11:42:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:42:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3521' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 18/11/2024 11:42:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94321' 18/11/2024 11:42:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94321' 18/11/2024 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94321' , '23088' , 'CAMPANA DEL GIUBILEO' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 18/11/2024 11:47:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 11:47:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3522' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.32' , '9.32' , NOW() , NOW() ) 18/11/2024 11:47:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94322' 18/11/2024 11:47:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94322' 18/11/2024 11:47:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94322' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/11/2024 11:47:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94322' , '2867' , 'CREDO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/11/2024 12:03:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '239' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 12:03:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '239' , '2024-11-18' , '' , '3496' , '0' , '4679247' , 'VIA ALLA BASILICA 1 23808 VERCURAGO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 18/11/2024 12:03: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 = '94323' 18/11/2024 12:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94323' 18/11/2024 12:03: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 ( '94323' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '100' , '0.00' ) 18/11/2024 12:03: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 ( '94323' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '100' , '0.00' ) 18/11/2024 12:09:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '42' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 12:09:23 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' , '42' , '2024-11-18' , '' , '7016' , '0' , '102683561' , 'PIAZZA SANTA MARIA 2 60027 OSIMO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '108.90' , '108.90' , NOW() , NOW() ) 18/11/2024 12:09:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14769' 18/11/2024 12:09:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '14769' 18/11/2024 12:09:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14769' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '15' , '-15' , '4' , '2.00' , '2' , '0' , '15' , '25.50' ) 18/11/2024 12:09:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14769' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '3' , '-3' , '4' , '30.00' , '30' , '0' , '15' , '76.50' ) 18/11/2024 12:12:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 12:12:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3523' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 18/11/2024 12:12:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94324' 18/11/2024 12:12:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94324' 18/11/2024 12:12:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94324' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/11/2024 12:12:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94324' , '16333' , 'NATIVITA\' ALBERO VETRO CM 16' , '4' , '-4' , '1' , '7' , '5.7377049180328' , '22' , '0' , '28.00' ) 18/11/2024 12:30:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 12:30:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3524' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.45' , '32.37' , NOW() , NOW() ) 18/11/2024 12:30:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94325' 18/11/2024 12:30:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94325' 18/11/2024 12:30:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94325' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '19.00' ) 18/11/2024 12:30:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94325' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/11/2024 12:30:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94325' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 18/11/2024 02:58:57 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/11/2024 02:58:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23222' , '1' , '' , 'nuovo-prodotto' ) 18/11/2024 02:58:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23222' , '1' , '1' , '2' , NOW() , NOW() ) 18/11/2024 02:58:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23222' , '0' , '1' , '0' , '0' ) 18/11/2024 03:00:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '015BIZ0575' AND id_product != '7730' AND ean13 != '' 18/11/2024 03:00:12 pm >> UPDATE ps_product SET id_supplier = '72', reference = '2013', ean13 = '015BIZ0575', date_upd = NOW() WHERE id_product = '7730' 18/11/2024 03:00:12 pm >> UPDATE ps_product_lang SET name = 'PATENA CM 15 IHS - 015BIZ0575', description = '' WHERE id_product = '7730' 18/11/2024 03:00:12 pm >> UPDATE ps_product SET wholesale_price = '19.96', on_sale = '0', price = '57.37704918032787' WHERE id_product = '7730' 18/11/2024 03:00:12 pm >> UPDATE ps_product_shop SET wholesale_price = '19.96', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '156', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7730' 18/11/2024 03:00:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '7730' 18/11/2024 03:00:44 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 ( '31' , '291/1' , '2024-11-15' , '1' , '0' , '72' , '2667' , 'VIA DELLA TECNICA 06053 DERUTA' , '' , '' , '16' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '203.97' , '167.19' , NOW() , NOW() ) 18/11/2024 03:00:44 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 = '94326' 18/11/2024 03:00:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94326' 18/11/2024 03:00:44 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 ( '94326' , '1515' , 'CALICE CM 15 INT.ORO IHS' , '1' , '1' , '1' , '56.37' , '46.204918032787' , '22' , '0' , '68.7714' ) 18/11/2024 03:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1515' AND id_supplier = '72' 18/11/2024 03:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1515' , '72' , '1' ) 18/11/2024 03:00:44 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 ( '94326' , '1251' , 'BOLO CM 14 INT. ORO IHS ' , '1' , '1' , '1' , '37.84' , '31.016393442623' , '22' , '0' , '46.1648' ) 18/11/2024 03:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1251' AND id_supplier = '72' 18/11/2024 03:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1251' , '72' , '1' ) 18/11/2024 03:00:44 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 ( '94326' , '7730' , 'PATENA CM 15 IHS - 015BIZ0575' , '2' , '2' , '1' , '28.49' , '23.352459016393' , '22' , '0' , '69.5156' ) 18/11/2024 03:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7730' AND id_supplier = '72' 18/11/2024 03:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7730' , '72' , '1' ) 18/11/2024 03:06:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '014BIZ0553' AND id_product != '1251' AND ean13 != '' 18/11/2024 03:06:08 pm >> UPDATE ps_product SET id_supplier = '72', reference = '2013', ean13 = '014BIZ0553', date_upd = NOW() WHERE id_product = '1251' 18/11/2024 03:06:08 pm >> UPDATE ps_product_lang SET name = 'BOLO CM 14 INT. ORO IHS ', description = '' WHERE id_product = '1251' 18/11/2024 03:06:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '76.22950819672131' WHERE id_product = '1251' 18/11/2024 03:06:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '76.22950819672131', id_tax_rules_group = '1', id_category_default = '156', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1251' 18/11/2024 03:06:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '1251' 18/11/2024 03:31:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 03:31: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 ( '21' , '240' , '2024-11-18' , '' , '65' , '0' , '4679378' , 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '111.44' , '111.44' , NOW() , NOW() ) 18/11/2024 03:31: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 = '94327' 18/11/2024 03:31:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94327' 18/11/2024 03:31: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 ( '94327' , '23043' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 18/11/2024 03:31: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 ( '94327' , '14953' , 'FAMIGLIA DI GESU - NOVENA - P. MANCA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 18/11/2024 03:31: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 ( '94327' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 18/11/2024 03:31: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 ( '94327' , '21659' , 'MARIA RITRATTO DI UNA DONNA ' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 18/11/2024 03:31: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 ( '94327' , '23156' , 'ACCOGLIAMO GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 18/11/2024 03:31: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 ( '94327' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.75' ) 18/11/2024 03:31: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 ( '94327' , '23051' , 'PREGHIERE A MARIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 18/11/2024 03:31: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 ( '94327' , '23200' , 'VANGELO AL CONTRARIO ANNO C- S. RESCA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/11/2024 03:31: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 ( '94327' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/11/2024 03:31: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 ( '94327' , '18740' , 'VENITE E PRONTO - ANNO C - A. VITALI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 18/11/2024 03:31: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 ( '94327' , '' , 'LETTURE DELLE DOMENICHE DI AVVENTO ANNO C' , '1' , '-1' , '4' , '11' , '11' , '0' , '5' , '10.45' ) 18/11/2024 03:31: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 ( '94327' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '0' , '10.00' , '10' , '' , '5' , '9.50' ) 18/11/2024 04:48:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 18/11/2024 04:48:49 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = 'ACCONTO € 165,00 / 25-10-2024 - € 100,00 07/11/2024', 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 = '688.16', price_tax_excluded = '581.46', date_upd = NOW() WHERE id_document = '90734' 18/11/2024 04:48:49 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 = '90734' 18/11/2024 04:48:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90734' 18/11/2024 04:48:49 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 ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 18/11/2024 04:48:49 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 ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '13086' , 'VENTI SABATI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '5' , '11.31' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '4' , '-4' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '32.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1515' , 'CALICE CM 15 INT.ORO IHS' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1251' , 'BOLO CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '8048' , 'PISSIDE CM 14 INT. ORO IHS ' , '1' , '-1' , '1' , '169.0000' , '138.52459016393' , '22' , '0' , '169.00' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/11/2024 04:48:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '7730' , 'PATENA CM 15 IHS - 015BIZ0575' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 18/11/2024 05:33:13 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 ( '34' , '6224916866' , '2024-11-15' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.02' , '12.02' , NOW() , NOW() ) 18/11/2024 05:33: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 = '94328' 18/11/2024 05:33:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94328' 18/11/2024 05:33: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 ( '94328' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '0' , '4' , '12.02' , '12.02' , '0' , '0' , '12.0200' ) 18/11/2024 05:33:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23006' AND id_supplier = '177' 18/11/2024 05:33:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23006' , '177' , '1' ) 18/11/2024 05:34:04 pm >> UPDATE ps_document SET id_document_type = '34', document_num = '6224916866', document_date = '2024-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679057', address1 = 'VIA G. VERDI 8 20057 ASSAGO', 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 = '12.02', price_tax_excluded = '12.02', date_upd = NOW() WHERE id_document = '94328' 18/11/2024 05:34:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94328' 18/11/2024 05:34:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94328' 18/11/2024 05:34:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94328' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0200' , '12.02' , '0' , '0' , '12.02' ) 18/11/2024 05:44:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '727' 18/11/2024 05:44:01 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 ( '727' , '10' , '210' , 'PARR. SAN GIOVANNI BATT.' , 'GUIDA' , 'DON FRANCO' , 'VIA SAN GIOVANNI BATTISTA, 2' , '' , '84082' , 'BRACIGLIANO' , '' , '' , '' , '' , '97000070652' , NOW() , NOW() ) 18/11/2024 05:44:01 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '727' 18/11/2024 05:44:47 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '727' 18/11/2024 05:44:47 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 ( '727' , '10' , '210' , 'PARR. SAN GIOVANNI BATT.' , 'GUIDA' , 'DON FRANCO' , 'VIA SAN GIOVANNI BATTISTA, 2' , '' , '84082' , 'BRACIGLIANO' , '' , '' , '3383641715' , '' , '97000070652' , NOW() , NOW() ) 18/11/2024 05:44:47 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '727' 18/11/2024 05:45:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '727' 18/11/2024 05:45:07 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 ( '727' , '10' , '210' , 'PARR. SAN GIOVANNI BATT.' , 'GUIDA' , 'DON FRANCO' , 'VIA SAN GIOVANNI BATTISTA, 2' , '' , '84082' , 'BRACIGLIANO' , '' , '' , '3383641715' , '' , '97000070652' , NOW() , NOW() ) 18/11/2024 05:45:07 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '727' 18/11/2024 06:24:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 06:24:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3525' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 18/11/2024 06:24:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94329' 18/11/2024 06:24:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94329' 18/11/2024 06:24:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94329' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/11/2024 07:17:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 07:17:31 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' , '3526' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 18/11/2024 07:17:31 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 = '94330' 18/11/2024 07:17:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94330' 18/11/2024 07:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94330' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 18/11/2024 07:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94330' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 18/11/2024 07:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94330' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 18/11/2024 07:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94330' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 18/11/2024 07:18:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-18') 18/11/2024 07:18:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3527' , '2024-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 18/11/2024 07:18:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94331' 18/11/2024 07:18:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94331' 18/11/2024 07:18:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94331' , '22873' , 'COME ESSERE CHIESA SINODALE MISSIONARIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' )