10/01/2024 08:17:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358008198' AND id_product != '1631' AND ean13 != '' 10/01/2024 08:17:05 am >> UPDATE ps_product SET id_supplier = '31', reference = '', ean13 = '8002358008198', date_upd = NOW() WHERE id_product = '1631' 10/01/2024 08:17:05 am >> UPDATE ps_product_lang SET name = 'CANDELINE NON GOCCIOLANTI ', description = '' WHERE id_product = '1631' 10/01/2024 08:17:05 am >> UPDATE ps_product SET wholesale_price = '12.60', on_sale = '0', price = '24.59016393442623' WHERE id_product = '1631' 10/01/2024 08:17:05 am >> UPDATE ps_product_shop SET wholesale_price = '12.60', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '169', 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 = '1631' 10/01/2024 08:17:05 am >> DELETE FROM ps_specific_price WHERE id_product = '1631' 10/01/2024 08:26:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001912' AND id_product != '19147' AND ean13 != '' 10/01/2024 08:26:40 am >> UPDATE ps_product SET id_supplier = '73', reference = '', ean13 = '001912', date_upd = NOW() WHERE id_product = '19147' 10/01/2024 08:26:40 am >> UPDATE ps_product_lang SET name = 'CANDELINE NON GOCCIOLANTI GRECHE', description = '' WHERE id_product = '19147' 10/01/2024 08:26:41 am >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '14.6721' WHERE id_product = '19147' 10/01/2024 08:26:41 am >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '14.6721', id_tax_rules_group = '1', id_category_default = '227', 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 = '19147' 10/01/2024 08:26:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19147' 10/01/2024 09:07:05 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 09:07:05 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' , '92' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 10/01/2024 09:07:05 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 = '89883' 10/01/2024 09:07:05 am >> DELETE FROM ps_document_detail WHERE id_document = '89883' 10/01/2024 09:07:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89883' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 10/01/2024 09:47:25 am >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 09:47:25 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' , '93' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '43.27' , NOW() , NOW() ) 10/01/2024 09:47:25 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 = '89884' 10/01/2024 09:47:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89884' 10/01/2024 09:47: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 ( '89884' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 10/01/2024 09:47: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 ( '89884' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 10/01/2024 10:05:00 am >> SELECT document_num FROM ps_document WHERE document_num = '94' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 10:05: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' , '94' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 10/01/2024 10:05: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 = '89885' 10/01/2024 10:05:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89885' 10/01/2024 10:05: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 ( '89885' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/01/2024 10:05: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 ( '89885' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 10/01/2024 10:05:36 am >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 10:05:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '95' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/01/2024 10:05:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89886' 10/01/2024 10:05:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89886' 10/01/2024 10:05: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 ( '89886' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2024 10:08:20 am >> SELECT document_num FROM ps_document WHERE document_num = '96' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 10:08:21 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' , '96' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.40' , '29.07' , NOW() , NOW() ) 10/01/2024 10:08:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89887' 10/01/2024 10:08:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89887' 10/01/2024 10:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89887' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 10/01/2024 10:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89887' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 10/01/2024 10:08:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89887' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/01/2024 11:12:58 am >> SELECT document_num FROM ps_document WHERE document_num = '6/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:12: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 ( '24' , '6/A' , '2024-01-10' , 'A' , '188' , '0' , '4679150' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '21.15' , NOW() , NOW() ) 10/01/2024 11:12: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 = '89888' 10/01/2024 11:12:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89888' 10/01/2024 11:12: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 ( '89888' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/01/2024 11:12: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 ( '89888' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 10/01/2024 11:22:57 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:22: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' , '97' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 10/01/2024 11:22: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 = '89889' 10/01/2024 11:22:57 am >> DELETE FROM ps_document_detail WHERE id_document = '89889' 10/01/2024 11:22: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 ( '89889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 10/01/2024 11:23:29 am >> SELECT document_num FROM ps_document WHERE document_num = '98' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:23:29 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' , '98' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.48' , NOW() , NOW() ) 10/01/2024 11:23:29 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 = '89890' 10/01/2024 11:23:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89890' 10/01/2024 11:23:29 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 ( '89890' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 10/01/2024 11:23:29 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 ( '89890' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 10/01/2024 11:25:04 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '89889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:25:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '97', document_date = '2024-01-10', 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 = '22.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '89889' 10/01/2024 11:25:04 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 = '89889' 10/01/2024 11:25:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89889' 10/01/2024 11:25:04 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 ( '89889' , '14687' , 'CROCE DELLAMICIZIA IN ULIVO CM 18 - 2842' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 10/01/2024 11:42:44 am >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:42:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '99' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.40' , '90.45' , NOW() , NOW() ) 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89891' 10/01/2024 11:42:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89891' 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89891' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89891' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89891' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89891' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 10/01/2024 11:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 10/01/2024 11:43:10 am >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 11:43:10 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' , '100' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 10/01/2024 11:43:10 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 = '89892' 10/01/2024 11:43:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89892' 10/01/2024 11:43:10 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 ( '89892' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 10/01/2024 12:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 12:02:37 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' , '101' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 10/01/2024 12:02:37 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 = '89893' 10/01/2024 12:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89893' 10/01/2024 12:02: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 ( '89893' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/01/2024 12:08:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 12:08: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' , '102' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '20.67' , NOW() , NOW() ) 10/01/2024 12:08: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 = '89894' 10/01/2024 12:08:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89894' 10/01/2024 12:08: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 ( '89894' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 10/01/2024 12:08: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 ( '89894' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/01/2024 12:16:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 12:16: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' , '103' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 10/01/2024 12:16: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 = '89895' 10/01/2024 12:16:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89895' 10/01/2024 12:16: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 ( '89895' , '19432' , 'QUADRO DECORATO 35X25 - R35' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 10/01/2024 12:46:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 12:46:26 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' , '104' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 10/01/2024 12:46:26 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 = '89896' 10/01/2024 12:46:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89896' 10/01/2024 12:46:26 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 ( '89896' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '38' , '31.147540983607' , '22' , '0' , '190.00' ) 10/01/2024 12:46:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 12:46: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 ( '11' , '105' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 10/01/2024 12:46: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 = '89897' 10/01/2024 12:46:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89897' 10/01/2024 12:46: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 ( '89897' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 10/01/2024 12:49:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '56' AND id_document != '89835' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-05') 10/01/2024 12:49:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '56', document_date = '2024-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '275.10', price_tax_excluded = '228.05', date_upd = NOW() WHERE id_document = '89835' 10/01/2024 12:49:41 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 = '89835' 10/01/2024 12:49:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89835' 10/01/2024 12:49:41 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 ( '89835' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/01/2024 12:49:41 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 ( '89835' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/01/2024 12:49:41 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 ( '89835' , '14133' , 'NATIVITA DI GESU BAMBINO - 281' , '2' , '-2' , '1' , '3.5500' , '2.9098360655738' , '22' , '0' , '7.10' ) 10/01/2024 12:49:41 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 ( '89835' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 10/01/2024 12:49:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '89836' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-05') 10/01/2024 12:49:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '57', document_date = '2024-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '39.90', price_tax_excluded = '39.90', date_upd = NOW() WHERE id_document = '89836' 10/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89836' 10/01/2024 12:49:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89836' 10/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89836' , '22019' , 'NUOVO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '5' , '22.80' ) 10/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89836' , '22018' , 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 10/01/2024 03:04:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 03:04: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 ( '11' , '106' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.25' , '7.62' , NOW() , NOW() ) 10/01/2024 03:04: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 = '89898' 10/01/2024 03:04:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89898' 10/01/2024 03:04: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 ( '89898' , '21126' , 'CALENDARIO 2024 TOTUS TUUS' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/01/2024 03:04: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 ( '89898' , '21461' , 'PAROLA PER OGGI 2024' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 10/01/2024 03:44:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 03:44:26 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' , '107' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.30' , '20.16' , NOW() , NOW() ) 10/01/2024 03:44:26 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 = '89899' 10/01/2024 03:44:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89899' 10/01/2024 03:44:26 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 ( '89899' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 10/01/2024 03:44:26 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 ( '89899' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/01/2024 03:44:26 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 ( '89899' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/01/2024 05:37:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '7/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 05:37:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '7/A' , '2024-01-10' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.58' , NOW() , NOW() ) 10/01/2024 05:37:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89900' 10/01/2024 05:37:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89900' 10/01/2024 05:37:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/01/2024 05:37:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 10/01/2024 05:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 05:38: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 ( '11' , '108' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 10/01/2024 05:38: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 = '89901' 10/01/2024 05:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89901' 10/01/2024 05:38:15 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 ( '89901' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 10/01/2024 06:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-10') 10/01/2024 06:16:45 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' , '109' , '2024-01-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.66' , NOW() , NOW() ) 10/01/2024 06:16:45 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 = '89902' 10/01/2024 06:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89902' 10/01/2024 06:16:45 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 ( '89902' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 10/01/2024 06:16:45 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 ( '89902' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '3' , '-3' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '3.90' )