29/12/2022 09:00:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 09:00:20 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' , '4124' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 29/12/2022 09:00:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77584' 29/12/2022 09:00:20 am >> DELETE FROM ps_document_detail WHERE id_document = '77584' 29/12/2022 09:00:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77584' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '4' , '-4' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '24.00' ) 29/12/2022 09:00:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77584' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/12/2022 09:00:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77584' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 29/12/2022 09:03:13 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 29/12/2022 09:03:13 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '172' , '1' ) 29/12/2022 09:03:13 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '172' , '1' ) 29/12/2022 09:03:13 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '172' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 29/12/2022 09:05:27 am >> UPDATE ps_address SET id_state = '180', lastname = 'SOBRIETA\' SRL', address1 = 'VIA PIER LUIGI DA PALESTRINA 2', address2 = '', postcode = '20124', dni = '', vat_number = '12457880966', city = 'MILANO', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '172' 29/12/2022 09:05:27 am >> UPDATE ps_supplier SET email = '', name = 'SOBRIETA\' SRL', date_upd = NOW() WHERE id_supplier = '172' 29/12/2022 09:05:27 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = 'EX TANGARI' WHERE id_supplier = '172' 29/12/2022 09:05:51 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 29/12/2022 09:05:51 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '513' , '1' ) 29/12/2022 09:05:51 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '513' , '2' ) 29/12/2022 09:05:51 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '513' , '3' ) 29/12/2022 09:05:51 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '513' , '1' , 'SOBRIETA\'' , LOWER('SOBRIETA\'') ) 29/12/2022 09:05:51 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '513' , '1' , '0' ) 29/12/2022 09:46:29 am >> UPDATE ps_address SET id_state = '180', lastname = 'SOBRIETA\' SRL', address1 = 'VIA PIER LUIGI DA PALESTRINA 2', address2 = '', postcode = '20124', dni = '', vat_number = '12457880966', city = 'MILANO', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '172' 29/12/2022 09:46:29 am >> UPDATE ps_supplier SET email = 'sobrietasrl@gmail.com', name = 'SOBRIETA\' SRL', date_upd = NOW() WHERE id_supplier = '172' 29/12/2022 09:46:29 am >> UPDATE ps_supplier_lang SET description = '', meta_title = 'sede produttiva: S.P. 231 KM 34,00 - 70033 CORATO - BARI', meta_description = 'EX TANGARI' WHERE id_supplier = '172' 29/12/2022 10:08:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 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' , '4125' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 29/12/2022 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 = '77585' 29/12/2022 10:08:21 am >> DELETE FROM ps_document_detail WHERE id_document = '77585' 29/12/2022 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 ( '77585' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2022 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 ( '77585' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2022 10:31:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 10:31: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 ( '11' , '4126' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 29/12/2022 10:31: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 = '77586' 29/12/2022 10:31:30 am >> DELETE FROM ps_document_detail WHERE id_document = '77586' 29/12/2022 10:31: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 ( '77586' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 29/12/2022 10:53:32 am >> SELECT document_num FROM ps_document WHERE document_num = '4127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 10:53:32 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' , '4127' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.46' , '8.46' , NOW() , NOW() ) 29/12/2022 10:53:32 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 = '77587' 29/12/2022 10:53:32 am >> DELETE FROM ps_document_detail WHERE id_document = '77587' 29/12/2022 10:53:32 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 ( '77587' , '18776' , 'GESU A COLORI' , '1' , '-1' , '4' , '8.90' , '8.9' , '0' , '5' , '8.46' ) 29/12/2022 11:03:08 am >> SELECT document_num FROM ps_document WHERE document_num = '4128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 11:03: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' , '4128' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 29/12/2022 11:03: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 = '77588' 29/12/2022 11:03:08 am >> DELETE FROM ps_document_detail WHERE id_document = '77588' 29/12/2022 11:03: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 ( '77588' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/12/2022 11:22:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6' , '2022-12-28' , '' , '0' , '172' , '4677909' , 'VIA PIER LUIGI DA PALESTRINA 2 20124 MILANO' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '972.60' , '797.22' , NOW() , NOW() ) 29/12/2022 11:22:17 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 = '77589' 29/12/2022 11:22:17 am >> DELETE FROM ps_document_detail WHERE id_document = '77589' 29/12/2022 11:22:17 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 ( '77589' , '13160' , 'CASULA MOD. CRISTOGRAMMA' , '5' , '5' , '1' , '161.9' , '132.70491803279' , '22' , '3' , '957.9623' ) 29/12/2022 11:22:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '13160' AND id_supplier = '172' 29/12/2022 11:22:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13160' , '172' , '1' ) 29/12/2022 11:23:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'CS12271' AND id_product != '13160' AND ean13 != '' 29/12/2022 11:23:06 am >> UPDATE ps_product SET id_supplier = '101', reference = '', ean13 = 'CS12271', date_upd = NOW() WHERE id_product = '13160' 29/12/2022 11:23:06 am >> UPDATE ps_product_lang SET name = 'CASULA MOD. CRISTOGRAMMA - cs12271', description = '' WHERE id_product = '13160' 29/12/2022 11:23:06 am >> UPDATE ps_product SET wholesale_price = '157.04', on_sale = '0', price = '319.6721' WHERE id_product = '13160' 29/12/2022 11:23:06 am >> UPDATE ps_product_shop SET wholesale_price = '157.04', price = '319.6721', id_tax_rules_group = '1', id_category_default = '414', 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 = '13160' 29/12/2022 11:23:06 am >> DELETE FROM ps_specific_price WHERE id_product = '13160' 29/12/2022 11:23:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002109' AND id_product != '13160' AND ean13 != '' 29/12/2022 11:23:16 am >> UPDATE ps_product SET id_supplier = '101', reference = '', ean13 = '002109', date_upd = NOW() WHERE id_product = '13160' 29/12/2022 11:23:16 am >> UPDATE ps_product_lang SET name = 'CASULA MOD. CRISTOGRAMMA - cs12271', description = '' WHERE id_product = '13160' 29/12/2022 11:23:16 am >> UPDATE ps_product SET wholesale_price = '157.04', on_sale = '0', price = '319.6721' WHERE id_product = '13160' 29/12/2022 11:23:16 am >> UPDATE ps_product_shop SET wholesale_price = '157.04', price = '319.6721', id_tax_rules_group = '1', id_category_default = '414', 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 = '13160' 29/12/2022 11:23:16 am >> DELETE FROM ps_specific_price WHERE id_product = '13160' 29/12/2022 11:23:27 am >> UPDATE ps_document SET id_document_type = '31', document_num = '6', document_date = '2022-12-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4677909', address1 = 'VIA PIER LUIGI DA PALESTRINA 2 20124 MILANO', address2 = '', note = '', price_shipping = '12.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '972.60', price_tax_excluded = '797.21', date_upd = NOW() WHERE id_document = '77589' 29/12/2022 11:23:27 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 = '77589' 29/12/2022 11:23:27 am >> DELETE FROM ps_document_detail WHERE id_document = '77589' 29/12/2022 11:23:27 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 ( '77589' , '13160' , 'CASULA MOD. CRISTOGRAMMA' , '5' , '5' , '1' , '161.9000' , '132.70491803279' , '22' , '3' , '957.96' ) 29/12/2022 11:24:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002109' AND id_product != '13160' AND ean13 != '' 29/12/2022 11:24:19 am >> UPDATE ps_product SET id_supplier = '101', reference = '', ean13 = '002109', date_upd = NOW() WHERE id_product = '13160' 29/12/2022 11:24:19 am >> UPDATE ps_product_lang SET name = 'CASULA MOD. CRISTOGRAMMA - cs12271', description = '' WHERE id_product = '13160' 29/12/2022 11:24:19 am >> UPDATE ps_product SET wholesale_price = '157.04', on_sale = '0', price = '323.7704918032787' WHERE id_product = '13160' 29/12/2022 11:24:19 am >> UPDATE ps_product_shop SET wholesale_price = '157.04', price = '323.7704918032787', id_tax_rules_group = '1', id_category_default = '414', 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 = '13160' 29/12/2022 11:24:19 am >> DELETE FROM ps_specific_price WHERE id_product = '13160' 29/12/2022 11:30:41 am >> SELECT document_num FROM ps_document WHERE document_num = '338' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 11:30: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' , '338' , '2022-12-29' , '' , '1832' , '0' , '4670920' , 'C.DA PANTANO 85010 PIGNOLA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '36.45' , '36.45' , NOW() , NOW() ) 29/12/2022 11:30: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 = '77590' 29/12/2022 11:30:41 am >> DELETE FROM ps_document_detail WHERE id_document = '77590' 29/12/2022 11:30: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 ( '77590' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 29/12/2022 11:30: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 ( '77590' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '0' , '12.00' , '12' , '' , '15' , '10.20' ) 29/12/2022 11:41:14 am >> SELECT document_num FROM ps_document WHERE document_num = '4129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 11:41:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4129' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '24.20' , NOW() , NOW() ) 29/12/2022 11:41: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 = '77591' 29/12/2022 11:41:14 am >> DELETE FROM ps_document_detail WHERE id_document = '77591' 29/12/2022 11:41: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 ( '77591' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '10' , '-10' , '4' , '1.6' , '1.6' , '0' , '0' , '16.00' ) 29/12/2022 11:41: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 ( '77591' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/12/2022 11:43:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 11:43:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4130' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '101.21' , NOW() , NOW() ) 29/12/2022 11:43:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77592' 29/12/2022 11:43:24 am >> DELETE FROM ps_document_detail WHERE id_document = '77592' 29/12/2022 11:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77592' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '150' , '-150' , '4' , '0.56' , '0.56' , '0' , '0' , '84.00' ) 29/12/2022 11:43:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77592' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7' , '5.7377049180328' , '22' , '0' , '21.00' ) 29/12/2022 11:58:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 11:58:09 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' , '4131' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 29/12/2022 11:58: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 = '77593' 29/12/2022 11:58:09 am >> DELETE FROM ps_document_detail WHERE id_document = '77593' 29/12/2022 11:58: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 ( '77593' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/12/2022 12:20:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 12:20: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' , '4132' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 29/12/2022 12:20: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 = '77594' 29/12/2022 12:20:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '77594' 29/12/2022 12:20: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 ( '77594' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 29/12/2022 03:14:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '7144' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-11') 29/12/2022 03:14:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '93', document_date = '2022-10-11', document_letter = '', id_customer = '3424', id_supplier = '', id_address = '84014829', address1 = 'VIA LUCANA, 249 75100 MATERA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '124.30', price_tax_excluded = '124.30', date_upd = NOW() WHERE id_document = '7144' 29/12/2022 03:14: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 = '7144' 29/12/2022 03:14:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '7144' 29/12/2022 03:14: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 ( '7144' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '15' , '30.60' ) 29/12/2022 03:14: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 ( '7144' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 29/12/2022 03:14: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 ( '7144' , '50' , 'PERDONAMI SIGNORE' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '15' , '17.00' ) 29/12/2022 03:14: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 ( '7144' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 29/12/2022 03:25:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '7911' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-11') 29/12/2022 03:25:05 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '95', document_date = '2022-10-11', document_letter = '', id_customer = '6994', id_supplier = '', id_address = '88681999', address1 = 'P. ZZA S. MARIA DELLA FEDE 19 80141 NAPOLI', address2 = '', note = '', price_shipping = '4.84', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '28.50', price_tax_excluded = '28.50', date_upd = NOW() WHERE id_document = '7911' 29/12/2022 03:25:05 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 = '7911' 29/12/2022 03:25:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '7911' 29/12/2022 03:25: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 ( '7911' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 29/12/2022 03:25: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 ( '7911' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 29/12/2022 03:25: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 ( '7911' , '96' , 'LA PREGHIERA - MEDICINA DELL\'ANIMA' , '1' , '-1' , '4' , '0.86' , '0.86' , '0' , '0' , '0.86' ) 29/12/2022 03:41:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 03:41:47 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' , '4133' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '320.00' , '262.30' , NOW() , NOW() ) 29/12/2022 03:41:47 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 = '77595' 29/12/2022 03:41:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '77595' 29/12/2022 03:41: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 ( '77595' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 29/12/2022 03:41: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 ( '77595' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 29/12/2022 03:42:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 29/12/2022 03:42:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 50,00', 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 = '485.00', price_tax_excluded = '485.00', date_upd = NOW() WHERE id_document = '59768' 29/12/2022 03:42: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 = '59768' 29/12/2022 03:42:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768' 29/12/2022 03:42: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 ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 29/12/2022 03:52:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '4134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 03:52:35 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' , '4134' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '3.60' , NOW() , NOW() ) 29/12/2022 03:52:35 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 = '77596' 29/12/2022 03:52:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '77596' 29/12/2022 03:52:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77596' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 29/12/2022 03:52:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77596' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 29/12/2022 03:55:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '4135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 03:55: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' , '4135' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.76' , '4.76' , NOW() , NOW() ) 29/12/2022 03:55: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 = '77597' 29/12/2022 03:55:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '77597' 29/12/2022 03:55: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 ( '77597' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 29/12/2022 03:55: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 ( '77597' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/12/2022 04:21:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3399' AND id_document != '71490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-09') 29/12/2022 04:21:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3399', document_date = '2022-11-09', 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 = '245.00', price_tax_excluded = '207.16', date_upd = NOW() WHERE id_document = '71490' 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71490' 29/12/2022 04:21:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '71490' 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '19962' , 'MESSA MEDITAZIONE - NOV 2022' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '19963' , 'MESSA MEDITAZIONE - DIC 2022' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '6405' , 'MENSA DIAM 40X250 - M4025' , '28' , '-28' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '95.20' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '19150' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '60.00' ) 29/12/2022 04:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71490' , '15002' , 'GESU BAMBINO CM 20 - 27598' , '1' , '-1' , '1' , '16.15' , '13.237704918033' , '22' , '0' , '16.15' ) 29/12/2022 04:21:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3897' AND id_document != '77314' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 29/12/2022 04:21:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3897', document_date = '2022-12-16', 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 = '85.82', price_tax_excluded = '82.30', date_upd = NOW() WHERE id_document = '77314' 29/12/2022 04:21:32 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 = '77314' 29/12/2022 04:21:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77314' 29/12/2022 04:21: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 ( '77314' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/12/2022 04:21: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 ( '77314' , '19943' , 'PASTORI DENTRO - A. BAGNASCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 29/12/2022 04:21: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 ( '77314' , '15002' , 'GESU BAMBINO CM 20 - 27598' , '1' , '-1' , '1' , '19.5' , '15.983606557377' , '22' , '0' , '19.50' ) 29/12/2022 04:21: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 ( '77314' , '20248' , 'FORZA DELLO SPIRITO - C. MIRANTE' , '2' , '-2' , '4' , '12.9000' , '12.9' , '0' , '5' , '24.52' ) 29/12/2022 04:21: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 ( '77314' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 29/12/2022 04:22:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3809' AND id_document != '76687' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 29/12/2022 04:22:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3809', document_date = '2022-12-09', 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.90', price_tax_excluded = '5.66', date_upd = NOW() WHERE id_document = '76687' 29/12/2022 04:22:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76687' 29/12/2022 04:22:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '76687' 29/12/2022 04:22:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76687' , '6915' , 'NATIVITÀ DECORO LEGNO C/LUCE CM 15,5' , '1' , '-1' , '1' , '6.9' , '5.655737704918' , '22' , '0' , '6.90' ) 29/12/2022 04:25:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 29/12/2022 04:25:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 50,00', 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 = '590.00', price_tax_excluded = '590.00', date_upd = NOW() WHERE id_document = '59768' 29/12/2022 04:25:19 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 = '59768' 29/12/2022 04:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768' 29/12/2022 04:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 29/12/2022 04:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '' , 'GIGLIO DORATO DA SCONTARE IN C/ VISIONE' , '1' , '-1' , '0' , '105' , '105' , '' , '0' , '105.00' ) 29/12/2022 05:29:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 05:29: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' , '4136' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 29/12/2022 05:29: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 = '77598' 29/12/2022 05:29:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '77598' 29/12/2022 05:29: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 ( '77598' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 29/12/2022 05:29: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 ( '77598' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/12/2022 05:29: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 ( '77598' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/12/2022 05:34:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '9239' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-09') 29/12/2022 05:34:58 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '134', document_date = '2022-12-09', document_letter = '', id_customer = '7020', id_supplier = '', id_address = '107350746', address1 = 'VIA DE AMICIS 38 21050 BOLLATELLO DI CAIRATE', address2 = '', note = '', price_shipping = '6.82', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '70.00', date_upd = NOW() WHERE id_document = '9239' 29/12/2022 05:34:58 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 = '9239' 29/12/2022 05:34:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '9239' 29/12/2022 05:34:58 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 ( '9239' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 29/12/2022 05:34:58 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 ( '9239' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.33' , '7.33' , '0' , '0' , '7.33' ) 29/12/2022 05:34:58 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 ( '9239' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '5' , '23.75' ) 29/12/2022 05:34:58 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 ( '9239' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '0' , '15.00' ) 29/12/2022 06:51:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 29/12/2022 06:51:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12', 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 = '3395.00', price_tax_excluded = '2782.79', date_upd = NOW() WHERE id_document = '56617' 29/12/2022 06:51: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 = '56617' 29/12/2022 06:51:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 29/12/2022 06:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 29/12/2022 06:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 29/12/2022 06:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18984' , 'POLO FELPATO ML + cardigan' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 29/12/2022 06:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 29/12/2022 06:51:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3316' AND id_document != '70337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-03') 29/12/2022 06:51:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3316', document_date = '2022-11-03', 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 = '750.00', price_tax_excluded = '614.75', date_upd = NOW() WHERE id_document = '70337' 29/12/2022 06:51:30 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 = '70337' 29/12/2022 06:51:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '70337' 29/12/2022 06:51:30 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 ( '70337' , '19802' , 'CASULA CON PALLIO L-LAME - NUOVA PRIMAVERA - 8254C' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' ) 29/12/2022 06:55:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '4137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 06:55:57 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' , '4137' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 29/12/2022 06:55:57 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 = '77599' 29/12/2022 06:55:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '77599' 29/12/2022 06:55:57 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 ( '77599' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.85' , '3.9754098360656' , '22' , '0' , '9.70' ) 29/12/2022 06:55:57 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 ( '77599' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 29/12/2022 07:03:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3841' AND id_document != '77236' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 29/12/2022 07:03:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3841', document_date = '2022-12-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '77236' 29/12/2022 07:03: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 = '77236' 29/12/2022 07:03:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '77236' 29/12/2022 07:03: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 ( '77236' , '20044' , 'CASULA LANA S/MOIRE - ALBERO DELLA VITA - 8241' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 29/12/2022 07:04:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '75559' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-03') 29/12/2022 07:04:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '107/A', document_date = '2022-12-03', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'acconto € 200,00 - 27/12 € 350,00', 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 = '1000.00', price_tax_excluded = '819.67', date_upd = NOW() WHERE id_document = '75559' 29/12/2022 07:04:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75559' 29/12/2022 07:04:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '75559' 29/12/2022 07:04:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75559' , '20044' , 'CASULA LANA S/MOIRE - ALBERO DELLA VITA - 8241****' , '1' , '-1' , '1' , '1000.0000' , '819.67213114754' , '22' , '0' , '1000.00' ) 29/12/2022 07:05:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3569' AND id_document != '74818' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 29/12/2022 07:05:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3569', document_date = '2022-11-23', 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 = '340.00', price_tax_excluded = '278.69', date_upd = NOW() WHERE id_document = '74818' 29/12/2022 07:05:47 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 = '74818' 29/12/2022 07:05:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '74818' 29/12/2022 07:05: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 ( '74818' , '19865' , 'CASULA CROCE ELICA - CSL080V' , '2' , '-2' , '1' , '170' , '139.34426229508' , '22' , '0' , '340.00' ) 29/12/2022 07:06:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2190' AND id_document != '59070' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-06') 29/12/2022 07:06:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2190', document_date = '2022-07-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '450.00', price_tax_excluded = '368.85', date_upd = NOW() WHERE id_document = '59070' 29/12/2022 07:06:19 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 = '59070' 29/12/2022 07:06:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '59070' 29/12/2022 07:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59070' , '19865' , 'CASULA CROCE ELICA - CSL080V' , '2' , '-2' , '1' , '200' , '163.93442622951' , '22' , '0' , '400.00' ) 29/12/2022 07:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59070' , '16764' , 'AMPOLLE SU VASSOIO IN VETRO - 1521' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 29/12/2022 07:07:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2115' AND id_document != '58982' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 29/12/2022 07:07:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2115', document_date = '2022-06-30', 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 = '410.00', price_tax_excluded = '336.07', date_upd = NOW() WHERE id_document = '58982' 29/12/2022 07:07:19 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 = '58982' 29/12/2022 07:07:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58982' 29/12/2022 07:07:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 29/12/2022 07:07:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 29/12/2022 07:07:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '108.00' ) 29/12/2022 07:07:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '47' , '-47' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '141.00' ) 29/12/2022 07:07:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2807' AND id_document != '61902' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-22') 29/12/2022 07:07:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2807', document_date = '2022-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '278.80', price_tax_excluded = '233.72', date_upd = NOW() WHERE id_document = '61902' 29/12/2022 07:07: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 = '61902' 29/12/2022 07:07:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '61902' 29/12/2022 07:07: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 ( '61902' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 29/12/2022 07:07: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 ( '61902' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0300' , '0.03' , '0' , '0' , '28.80' ) 29/12/2022 07:07: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 ( '61902' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/12/2022 07:07: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 ( '61902' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '11.00' ) 29/12/2022 07:07: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 ( '61902' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/12/2022 07:07: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 ( '61902' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 29/12/2022 07:07: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 ( '61902' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '1' , '37.5' , '30.737704918033' , '22' , '0' , '75.00' ) 29/12/2022 07:08:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2962' AND id_document != '65203' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 29/12/2022 07:08:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2962', document_date = '2022-10-07', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '65203' 29/12/2022 07:08:30 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 = '65203' 29/12/2022 07:08:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '65203' 29/12/2022 07:08:30 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 ( '65203' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/12/2022 07:08:30 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 ( '65203' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/12/2022 07:08:30 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 ( '65203' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 29/12/2022 07:08:30 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 ( '65203' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 29/12/2022 07:09:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2995' AND id_document != '65764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 29/12/2022 07:09:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2995', document_date = '2022-10-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 = '21.50', price_tax_excluded = '17.62', date_upd = NOW() WHERE id_document = '65764' 29/12/2022 07:09: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 = '65764' 29/12/2022 07:09:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '65764' 29/12/2022 07:09:08 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 ( '65764' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 29/12/2022 07:09:08 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 ( '65764' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.75' , '2.2540983606557' , '22' , '0' , '5.50' ) 29/12/2022 07:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '4138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-29') 29/12/2022 07:09:35 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' , '4138' , '2022-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 29/12/2022 07:09:35 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 = '77600' 29/12/2022 07:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '77600' 29/12/2022 07:09:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77600' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2022 07:09:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77600' , '20592' , 'SULLA TUA PAROLA MAR/APR 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )