18/02/2023 10:01:07 am >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '10793' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-14') 18/02/2023 10:01:07 am >> UPDATE ps_document SET id_document_type = '21', document_num = '8', document_date = '2023-02-14', document_letter = '', id_customer = '7036', id_supplier = '0', id_address = '126019525', address1 = 'Via Tivoli , 90 70022 ALTAMURA', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '149.90', price_tax_excluded = '149.90', date_upd = NOW() WHERE id_document = '10793' 18/02/2023 10:01:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '10793' 18/02/2023 10:01:07 am >> DELETE FROM ps_document_detail WHERE id_document = '10793' 18/02/2023 10:01:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10793' , '125' , 'MIE PREGHIERINE - N. E.' , '100' , '-100' , '4' , '1.4300' , '1.43' , '0' , '0' , '143.00' ) 18/02/2023 10:53:44 am >> SELECT document_num FROM ps_document WHERE document_num = '558' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 10:53: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' , '558' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 18/02/2023 10:53: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 = '81416' 18/02/2023 10:53:44 am >> DELETE FROM ps_document_detail WHERE id_document = '81416' 18/02/2023 10:53: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 ( '81416' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 18/02/2023 10:54:41 am >> SELECT document_num FROM ps_document WHERE document_num = '558' AND id_document != '81416' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 10:54:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '558', document_date = '2023-02-18', 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 = '52.25', price_tax_excluded = '52.25', date_upd = NOW() WHERE id_document = '81416' 18/02/2023 10:54: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 = '81416' 18/02/2023 10:54:41 am >> DELETE FROM ps_document_detail WHERE id_document = '81416' 18/02/2023 10:54: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 ( '81416' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '11' , '-11' , '4' , '5.0000' , '5' , '0' , '5' , '52.25' ) 18/02/2023 11:13:08 am >> SELECT document_num FROM ps_document WHERE document_num = '559' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:13:08 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' , '559' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '157.80' , '135.73' , NOW() , NOW() ) 18/02/2023 11:13:08 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 = '81417' 18/02/2023 11:13:08 am >> DELETE FROM ps_document_detail WHERE id_document = '81417' 18/02/2023 11:13:08 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 ( '81417' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 18/02/2023 11:13:08 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 ( '81417' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 18/02/2023 11:13:08 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 ( '81417' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/02/2023 11:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '560' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:18:38 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' , '560' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '196.72' , NOW() , NOW() ) 18/02/2023 11:18:38 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 = '81418' 18/02/2023 11:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '81418' 18/02/2023 11:18:38 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 ( '81418' , '15210' , 'CERO PASQUALE API 80X120' , '3' , '-3' , '1' , '80' , '65.573770491803' , '22' , '0' , '240.00' ) 18/02/2023 11:20:11 am >> SELECT document_num FROM ps_document WHERE document_num = '561' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:20:11 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' , '561' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 18/02/2023 11:20:11 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 = '81419' 18/02/2023 11:20:11 am >> DELETE FROM ps_document_detail WHERE id_document = '81419' 18/02/2023 11:20:11 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 ( '81419' , '18840' , 'CAPOCULLA ' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 18/02/2023 11:31:22 am >> SELECT document_num FROM ps_document WHERE document_num = '562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:31:22 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' , '562' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 18/02/2023 11:31:22 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 = '81420' 18/02/2023 11:31:22 am >> DELETE FROM ps_document_detail WHERE id_document = '81420' 18/02/2023 11:31:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81420' , '20617' , 'PASQUA - BENEDETTO XVI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 18/02/2023 11:36:28 am >> SELECT document_num FROM ps_document WHERE document_num = '563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:36: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' , '563' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 18/02/2023 11:36: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 = '81421' 18/02/2023 11:36:28 am >> DELETE FROM ps_document_detail WHERE id_document = '81421' 18/02/2023 11:36: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 ( '81421' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 18/02/2023 11:38:09 am >> SELECT document_num FROM ps_document WHERE document_num = '16/A' AND id_document != '81183' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-02') 18/02/2023 11:38:09 am >> UPDATE ps_document SET id_document_type = '24', document_num = '16/A', document_date = '2023-02-02', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', 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 = '17.75', price_tax_excluded = '17.75', date_upd = NOW() WHERE id_document = '81183' 18/02/2023 11:38:09 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 = '81183' 18/02/2023 11:38:09 am >> DELETE FROM ps_document_detail WHERE id_document = '81183' 18/02/2023 11:38:09 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 ( '81183' , '20674' , 'GESU VOLTO DI DIO - L. MONTI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 18/02/2023 11:38:09 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 ( '81183' , '' , 'RIMANENTE LIBRO PASQUA' , '1' , '-1' , '0' , '1.6' , '1.6' , '' , '0' , '1.60' ) 18/02/2023 11:52:15 am >> SELECT document_num FROM ps_document WHERE document_num = '564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 11:52:15 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' , '564' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.60' , '124.91' , NOW() , NOW() ) 18/02/2023 11:52:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81422' 18/02/2023 11:52:15 am >> DELETE FROM ps_document_detail WHERE id_document = '81422' 18/02/2023 11:52:16 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 ( '81422' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/02/2023 11:52:16 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 ( '81422' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/02/2023 11:52:16 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 ( '81422' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '100.00' , '81.967213114754' , '22' , '0' , '100.00' ) 18/02/2023 11:52:16 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 ( '81422' , '20751' , 'QUARESIMA OMELIE BENEDETTO XVI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 18/02/2023 11:52:16 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 ( '81422' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 18/02/2023 12:01:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 12:01: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' , '565' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 18/02/2023 12:01: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 = '81423' 18/02/2023 12:01:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '81423' 18/02/2023 12:01: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 ( '81423' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/02/2023 12:16:46 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '526/X', document_date = '2022-09-29', document_letter = 'X', id_customer = '0', id_supplier = '', id_address = '2668', address1 = 'VIA P. TRIBOLDI, 4 26015 SORESINA', address2 = '', note = '', price_shipping = '40.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '2370.70', price_tax_excluded = '1943.20', date_upd = NOW() WHERE id_document = '63024' 18/02/2023 12:16:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63024' 18/02/2023 12:16:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '63024' 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '24' , '24' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '190.32' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '32' , '32' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '1249.28' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '20026' , 'CANDELA VOTIVA 20X30' , '125' , '125' , '1' , '0.2560' , '0.20983606557377' , '22' , '0' , '39.04' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '20027' , 'CANDELA ALTARE 20X500' , '50' , '50' , '1' , '0.8400' , '0.68852459016393' , '22' , '0' , '51.24' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '20028' , 'CANDELA ALTARE 26X350' , '50' , '50' , '1' , '0.9840' , '0.80655737704918' , '22' , '0' , '60.02' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '20030' , 'CANDELE ALTARE 20X400' , '9' , '9' , '1' , '60' , '49.180327868852' , '22' , '0' , '658.8000' ) 18/02/2023 12:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63024' , '20030' , 'CANDELE ALTARE 20X400' , '70' , '70' , '1' , '0.8572' , '0.70262295081967' , '22' , '0' , '73.2049' ) 18/02/2023 12:18:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002031' AND id_product != '20030' AND ean13 != '' 18/02/2023 12:18:00 pm >> UPDATE ps_product SET id_supplier = '73', reference = '', ean13 = '002031', date_upd = NOW() WHERE id_product = '20030' 18/02/2023 12:18:00 pm >> UPDATE ps_product_lang SET name = 'CANDELE ALTARE 40x20', description = '' WHERE id_product = '20030' 18/02/2023 12:18:00 pm >> UPDATE ps_product SET wholesale_price = '60.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '20030' 18/02/2023 12:18:00 pm >> UPDATE ps_product_shop SET wholesale_price = '60.00', price = '1.639344262295082', 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 = '20030' 18/02/2023 12:18:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20030' 18/02/2023 12:18:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '565' AND id_document != '81423' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 12:18:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '565', document_date = '2023-02-18', 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 = '6.00', price_tax_excluded = '4.92', date_upd = NOW() WHERE id_document = '81423' 18/02/2023 12:18:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81423' 18/02/2023 12:18:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '81423' 18/02/2023 12:18:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81423' , '20030' , 'CANDELE ALTARE 40x20' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 18/02/2023 12:38:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-18') 18/02/2023 12:38:40 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' , '566' , '2023-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 18/02/2023 12:38:40 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 = '81424' 18/02/2023 12:38:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '81424' 18/02/2023 12:38: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 ( '81424' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' )