09/09/2024 11:22:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:22:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2624' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 09/09/2024 11:22:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93052' 09/09/2024 11:22:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93052' 09/09/2024 11:22:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93052' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2024 11:22:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93052' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 09/09/2024 11:24:16 am >> SELECT document_num FROM ps_document WHERE document_num = '34/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:24:16 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 ( '23' , '34/E' , '2024-09-09' , 'E' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '936.00' , '767.21' , NOW() , NOW() ) 09/09/2024 11:24:16 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 = '93053' 09/09/2024 11:24:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93053' 09/09/2024 11:24: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 ( '93053' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 09/09/2024 11:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '107' 09/09/2024 11:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '107' , '1' ) 09/09/2024 11:24: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 ( '93053' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 09/09/2024 11:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '107' 09/09/2024 11:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '107' , '1' ) 09/09/2024 11:24: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 ( '93053' , '12849' , 'LIBRO DELLE SS. MESSE' , '30' , '-30' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '360.00' ) 09/09/2024 11:24:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12849' AND id_supplier = '107' 09/09/2024 11:24:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12849' , '107' , '1' ) 09/09/2024 11:25:02 am >> SELECT document_num FROM ps_document WHERE document_num = '34/E' AND id_document != '93053' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:25:02 am >> UPDATE ps_document SET id_document_type = '23', document_num = '34/E', document_date = '2024-09-09', document_letter = 'E', id_customer = '3000', id_supplier = '0', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '936.00', price_tax_excluded = '767.21', date_upd = NOW() WHERE id_document = '93053' 09/09/2024 11:25:02 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 = '93053' 09/09/2024 11:25:02 am >> DELETE FROM ps_document_detail WHERE id_document = '93053' 09/09/2024 11:25:02 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 ( '93053' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 09/09/2024 11:25:03 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 ( '93053' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 09/09/2024 11:25:03 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 ( '93053' , '12849' , 'LIBRO DELLE SS. MESSE' , '30' , '-30' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '360.00' ) 09/09/2024 11:28:00 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:28:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '22' , '2024-09-09' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '3' , '18488.00' , '18488.00' , NOW() , NOW() ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93054' 09/09/2024 11:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '93054' 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '9675' , 'SARETE MIEI TESTIMONI' , '600' , '-600' , '4' , '3.50' , '3.5' , '0' , '0' , '2100.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '50' , '-50' , '4' , '5.00' , '5' , '0' , '0' , '250.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '50' , '-50' , '4' , '5.00' , '5' , '0' , '0' , '250.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '68' , '-68' , '4' , '6.00' , '6' , '0' , '0' , '408.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '360' , '-360' , '4' , '1.00' , '1' , '0' , '0' , '360.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '5457' , 'IO SONO CON VOI 1 PARTE' , '3500' , '-3500' , '4' , '2.80' , '2.8' , '0' , '0' , '9800.00' ) 09/09/2024 11:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93054' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1900' , '-1900' , '4' , '2.80' , '2.8' , '0' , '0' , '5320.00' ) 09/09/2024 11:39:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:39:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2625' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.40' , '5.39' , NOW() , NOW() ) 09/09/2024 11:39:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93055' 09/09/2024 11:39:34 am >> DELETE FROM ps_document_detail WHERE id_document = '93055' 09/09/2024 11:39:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93055' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '2' , '-2' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '5.60' ) 09/09/2024 11:39:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93055' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 09/09/2024 11:51:13 am >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 11:51:13 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 ( '22' , '17/S' , '2024-09-09' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '74.00' , '74.00' , NOW() , NOW() ) 09/09/2024 11:51:13 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 = '14745' 09/09/2024 11:51:13 am >> DELETE FROM ps_document_detail WHERE id_document = '14745' 09/09/2024 11:51: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 ( '14745' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 09/09/2024 11:51: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 ( '14745' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '15' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '13.50' ) 09/09/2024 11:51: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 ( '14745' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '7' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '5.25' ) 09/09/2024 11:51: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 ( '14745' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 09/09/2024 11:51: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 ( '14745' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 09/09/2024 11:51: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 ( '14745' , '33' , '100 GIORNI CON LO SPIRITO' , '5' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '18.75' ) 09/09/2024 11:51: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 ( '14745' , '65' , 'LA FAMIGLIA, CHIESA DOMESTICA' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 09/09/2024 12:13:20 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/09/2024 12:13:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22860' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 12:13:20 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22860' , '1' , '1' , '2' , NOW() , NOW() ) 09/09/2024 12:13:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22860' , '0' , '1' , '0' , '0' ) 09/09/2024 12:14:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609027' AND id_product != '22860' AND ean13 != '' 09/09/2024 12:14:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788826609027', date_upd = NOW() WHERE id_product = '22860' 09/09/2024 12:14:17 pm >> UPDATE ps_product_lang SET name = 'ELOGIO DI UNA GUERRIERA - J. CHERON', description = '' WHERE id_product = '22860' 09/09/2024 12:14:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22860' 09/09/2024 12:14:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22860' 09/09/2024 12:14:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '22860' 09/09/2024 12:14:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22860' 09/09/2024 12:14:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22861' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 12:14:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22861' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22860' 09/09/2024 12:14:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22861' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22860' 09/09/2024 12:15:25 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 ( '33' , '2024-dl002722' , '2024-09-06' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.20' , '240.20' , NOW() , NOW() ) 09/09/2024 12:15:25 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 = '93056' 09/09/2024 12:15:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93056' 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '2' , '4' , '40.00' , '40' , '0' , '35' , '52.0000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '5' , '5' , '4' , '20.00' , '20' , '0' , '35' , '65.0000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '2' , '4' , '30.00' , '30' , '0' , '35' , '39.0000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '45' , '5.5000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '22860' , 'ELOGIO DI UNA GUERRIERA - J. CHERON' , '1' , '1' , '4' , '16.00' , '16' , '0' , '45' , '8.8000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22860' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22860' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '2' , '2' , '4' , '13.00' , '13' , '0' , '45' , '14.3000' ) 09/09/2024 12:15:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15024' AND id_supplier = '79' 09/09/2024 12:15:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15024' , '79' , '1' ) 09/09/2024 12:15:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93056' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '45' , '6.6000' ) 09/09/2024 12:15:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 09/09/2024 12:15:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 09/09/2024 12:22:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '14745' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:22:52 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '17/S', document_date = '2024-09-09', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO AGOSTO 2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '292.60', price_tax_excluded = '292.60', date_upd = NOW() WHERE id_document = '14745' 09/09/2024 12:22:52 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 = '14745' 09/09/2024 12:22:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '14745' 09/09/2024 12:22:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14745' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 09/09/2024 12:22:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14745' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '15' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '13.50' ) 09/09/2024 12:22: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 ( '14745' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '7' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '5.25' ) 09/09/2024 12:22: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 ( '14745' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 09/09/2024 12:22: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 ( '14745' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '20' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '25.00' ) 09/09/2024 12:22: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 ( '14745' , '33' , '100 GIORNI CON LO SPIRITO' , '5' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '18.75' ) 09/09/2024 12:22: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 ( '14745' , '65' , 'LA FAMIGLIA, CHIESA DOMESTICA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 09/09/2024 12:22: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 ( '14745' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '10' , '0' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 09/09/2024 12:22: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 ( '14745' , '88' , 'GESÙ È RISORTO' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 09/09/2024 12:22: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 ( '14745' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '7' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 09/09/2024 12:22: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 ( '14745' , '92' , 'LA PREGHIERA DEL ROSARIO' , '27' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 09/09/2024 12:22: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 ( '14745' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '7' , '0' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 09/09/2024 12:22: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 ( '14745' , '104' , 'TEMPO DI QUARESIMA' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 09/09/2024 12:22: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 ( '14745' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '27' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 09/09/2024 12:22: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 ( '14745' , '110' , 'SE MI AMI NON PIANGERE' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 09/09/2024 12:22: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 ( '14745' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 09/09/2024 12:22: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 ( '14745' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '40' , '0' , '4' , '4.00' , '4' , '0' , '50' , '80.00' ) 09/09/2024 12:22: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 ( '14745' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 09/09/2024 12:22: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 ( '14745' , '136' , 'ANGELO DI DIO N.E.' , '7' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 09/09/2024 12:22: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 ( '14745' , '126' , 'SACRAMENTO DEL PERDONO' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 09/09/2024 12:27:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:27: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 ( '25' , '18/S' , '2024-09-09' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA AGOSTO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.90' , '145.90' , NOW() , NOW() ) 09/09/2024 12:27: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 = '14746' 09/09/2024 12:27:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '14746' 09/09/2024 12:27: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 ( '14746' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '3' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 09/09/2024 12:27: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 ( '14746' , '20' , 'GIOVEDÌ SANTO' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '50' , '9.00' ) 09/09/2024 12:27: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 ( '14746' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '11' , '11' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '56' , 'MARIA LA MAMMA DI GESU' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '36' , '36' , '4' , '2.00' , '2' , '0' , '50' , '36.00' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '88' , 'GESÙ È RISORTO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '104' , 'TEMPO DI QUARESIMA' , '14' , '14' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '110' , 'SE MI AMI NON PIANGERE' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '117' , 'La preghiera delle cinque dita n.e.' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '139' , 'E NATO - n.e.' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '136' , 'ANGELO DI DIO N.E.' , '10' , '10' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 09/09/2024 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14746' , '137' , 'AVVENTO' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 09/09/2024 12:35:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2626' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:35:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2626' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '12.50' , NOW() , NOW() ) 09/09/2024 12:35:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93057' 09/09/2024 12:35:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '93057' 09/09/2024 12:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93057' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 09/09/2024 12:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93057' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/09/2024 12:37:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2627' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:37:33 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' , '2627' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 09/09/2024 12:37:33 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 = '93058' 09/09/2024 12:37:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93058' 09/09/2024 12:37:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93058' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/09/2024 12:37:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93058' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 09/09/2024 12:38:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2628' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:38: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' , '2628' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.30' , '11.72' , NOW() , NOW() ) 09/09/2024 12:38: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 = '93059' 09/09/2024 12:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '93059' 09/09/2024 12:38: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 ( '93059' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '11' , '-11' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '14.30' ) 09/09/2024 12:40:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 12:40: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' , '2629' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 09/09/2024 12:40: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 = '93060' 09/09/2024 12:40:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93060' 09/09/2024 12:40: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 ( '93060' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 09/09/2024 12:40: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 ( '93060' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 09/09/2024 12:40: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 ( '93060' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '3' , '-3' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '7.50' ) 09/09/2024 01:02:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '92874' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-26') 09/09/2024 01:02:48 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2024-08-26', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '68.70', price_tax_excluded = '56.31', date_upd = NOW() WHERE id_document = '92874' 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92874' 09/09/2024 01:02:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92874' 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92874' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92874' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '5' , '-5' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '37.50' ) 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92874' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92874' , '14773' , 'BRACCIALE RIGATO - 0825N' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 09/09/2024 01:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92874' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 09/09/2024 02:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2567' AND id_document != '92990' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-04') 09/09/2024 02:16:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2567', document_date = '2024-09-04', 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 = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '92990' 09/09/2024 02:16:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92990' 09/09/2024 02:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '92990' 09/09/2024 02:16:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92990' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 09/09/2024 02:16:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92990' , '18902' , 'TURIBOLO CM 24' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 09/09/2024 02:56:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 02:56:51 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' , '2630' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 09/09/2024 02:56:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93061' 09/09/2024 02:56:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93061' 09/09/2024 02:56:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93061' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '125' , '102.45901639344' , '22' , '0' , '125.00' ) 09/09/2024 03:13:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '409' , '2024-09-06' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '401.08' , '328.75' , NOW() , NOW() ) 09/09/2024 03:13:25 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 = '93062' 09/09/2024 03:13:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93062' 09/09/2024 03:13:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93062' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '2' , '2' , '1' , '54' , '44.262295081967' , '22' , '3' , '127.8072' ) 09/09/2024 03:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 09/09/2024 03:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 09/09/2024 03:13:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93062' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '2' , '2' , '1' , '78' , '63.934426229508' , '22' , '3' , '184.6104' ) 09/09/2024 03:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '118' 09/09/2024 03:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '118' , '1' ) 09/09/2024 03:13:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93062' , '17352' , 'STOLA MARIANA MISTO SETA - 1021 AM' , '1' , '1' , '1' , '61' , '50' , '22' , '3' , '72.1874' ) 09/09/2024 03:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17352' AND id_supplier = '118' 09/09/2024 03:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17352' , '118' , '1' ) 09/09/2024 03:14:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714487' AND id_product != '22861' AND ean13 != '' 09/09/2024 03:14:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714487', date_upd = NOW() WHERE id_product = '22861' 09/09/2024 03:14:31 pm >> UPDATE ps_product_lang SET name = 'E\' LA TUA PARTE 3 - 12/14 ANNI', description = '' WHERE id_product = '22861' 09/09/2024 03:14:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '22861' 09/09/2024 03:14:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22861' 09/09/2024 03:14:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22861' 09/09/2024 03:14:32 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22861' 09/09/2024 03:14:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22862' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:14:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22862' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22861' 09/09/2024 03:14:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22862' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22861' 09/09/2024 03:15:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714463' AND id_product != '22862' AND ean13 != '' 09/09/2024 03:15:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714463', date_upd = NOW() WHERE id_product = '22862' 09/09/2024 03:15:01 pm >> UPDATE ps_product_lang SET name = 'E\' LA TUA PARTE 1 - 6/8 ANNI', description = '' WHERE id_product = '22862' 09/09/2024 03:15:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '22862' 09/09/2024 03:15:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22862' 09/09/2024 03:15:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22862' 09/09/2024 03:15:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22862' 09/09/2024 03:15:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22863' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:15:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22863' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22862' 09/09/2024 03:15:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22863' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22862' 09/09/2024 03:15:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714456' AND id_product != '22863' AND ean13 != '' 09/09/2024 03:15:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714456', date_upd = NOW() WHERE id_product = '22863' 09/09/2024 03:15:26 pm >> UPDATE ps_product_lang SET name = 'E\' LA TUA PARTE - PICCOLISSIMI', description = '' WHERE id_product = '22863' 09/09/2024 03:15:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '22863' 09/09/2024 03:15:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22863' 09/09/2024 03:15:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22863' 09/09/2024 03:15:27 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22863' 09/09/2024 03:15:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22864' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:15:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22864' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22863' 09/09/2024 03:15:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22864' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22863' 09/09/2024 03:15:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714470' AND id_product != '22864' AND ean13 != '' 09/09/2024 03:15:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714470', date_upd = NOW() WHERE id_product = '22864' 09/09/2024 03:15:56 pm >> UPDATE ps_product_lang SET name = 'E\' LA TUA PARTE 2 - 9/11 ANNI', description = '' WHERE id_product = '22864' 09/09/2024 03:15:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.5' WHERE id_product = '22864' 09/09/2024 03:15:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22864' 09/09/2024 03:15:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22864' 09/09/2024 03:15:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22864' 09/09/2024 03:15:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22865' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:15:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22865' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22864' 09/09/2024 03:15:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22865' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22864' 09/09/2024 03:16:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254781456' AND id_product != '22865' AND ean13 != '' 09/09/2024 03:16:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9791254781456', date_upd = NOW() WHERE id_product = '22865' 09/09/2024 03:16:32 pm >> UPDATE ps_product_lang SET name = 'CATECHISMO MAGGIORE - SAN PIO X', description = '' WHERE id_product = '22865' 09/09/2024 03:16:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '22865' 09/09/2024 03:16:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22865' 09/09/2024 03:16:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22865' 09/09/2024 03:16:33 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22865' 09/09/2024 03:16:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22866' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:16:33 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22866' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22865' 09/09/2024 03:16:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22866' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22865' 09/09/2024 03:17:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259625175' AND id_product != '22866' AND ean13 != '' 09/09/2024 03:17:37 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791259625175', date_upd = NOW() WHERE id_product = '22866' 09/09/2024 03:17:37 pm >> UPDATE ps_product_lang SET name = 'PAROLA SACRAMENTO CARISMA - M. QUELLET', description = '' WHERE id_product = '22866' 09/09/2024 03:17:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23' WHERE id_product = '22866' 09/09/2024 03:17:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22866' 09/09/2024 03:17:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '22866' 09/09/2024 03:17:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22866' 09/09/2024 03:17:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22867' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:17:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22867' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22866' 09/09/2024 03:17:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22867' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22866' 09/09/2024 03:18:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714494' AND id_product != '22867' AND ean13 != '' 09/09/2024 03:18:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714494', date_upd = NOW() WHERE id_product = '22867' 09/09/2024 03:18:32 pm >> UPDATE ps_product_lang SET name = 'WORK IN PROGRESS', description = '' WHERE id_product = '22867' 09/09/2024 03:18:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '22867' 09/09/2024 03:18:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22867' 09/09/2024 03:18:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22867' 09/09/2024 03:18:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22867' 09/09/2024 03:18:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22868' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:18:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22868' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22867' 09/09/2024 03:18:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22868' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22867' 09/09/2024 03:19:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832714654' AND id_product != '22868' AND ean13 != '' 09/09/2024 03:19:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832714654', date_upd = NOW() WHERE id_product = '22868' 09/09/2024 03:19:10 pm >> UPDATE ps_product_lang SET name = 'DENTRO E ATTRAVERSO L\'ESISTENZA', description = '' WHERE id_product = '22868' 09/09/2024 03:19:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22868' 09/09/2024 03:19:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22868' 09/09/2024 03:19:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '22868' 09/09/2024 03:19:11 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22868' 09/09/2024 03:19:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22869' , '1' , '' , 'nuovo-prodotto' ) 09/09/2024 03:19:11 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22869' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22868' 09/09/2024 03:19:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22869' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22868' 09/09/2024 03:22:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '00243119' , '2024-09-06' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '256.00' , '256.00' , NOW() , NOW() ) 09/09/2024 03:22:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93063' 09/09/2024 03:22:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93063' 09/09/2024 03:22:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22866' , 'PAROLA SACRAMENTO CARISMA - M. QUELLET' , '1' , '1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 09/09/2024 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22866' AND id_supplier = '109' 09/09/2024 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22866' , '109' , '1' ) 09/09/2024 03:22:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22865' , 'CATECHISMO MAGGIORE - SAN PIO X' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 09/09/2024 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22865' AND id_supplier = '109' 09/09/2024 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22865' , '109' , '1' ) 09/09/2024 03:22:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '1' , '4' , '52.00' , '52' , '0' , '0' , '52.00' ) 09/09/2024 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 09/09/2024 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 09/09/2024 03:22:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22863' , 'E LA TUA PARTE - PICCOLISSIMI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.0000' ) 09/09/2024 03:22:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22863' AND id_supplier = '109' 09/09/2024 03:22:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22863' , '109' , '1' ) 09/09/2024 03:22:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22867' , 'WORK IN PROGRESS' , '2' , '2' , '4' , '7.00' , '7' , '0' , '0' , '14.0000' ) 09/09/2024 03:22:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22867' AND id_supplier = '109' 09/09/2024 03:22:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22867' , '109' , '1' ) 09/09/2024 03:22:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22868' , 'DENTRO E ATTRAVERSO LESISTENZA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 09/09/2024 03:22:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22868' AND id_supplier = '109' 09/09/2024 03:22:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22868' , '109' , '1' ) 09/09/2024 03:22:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22862' , 'E LA TUA PARTE 1 - 6/8 ANNI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.0000' ) 09/09/2024 03:22:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22862' AND id_supplier = '109' 09/09/2024 03:22:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22862' , '109' , '1' ) 09/09/2024 03:22:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.0000' ) 09/09/2024 03:22:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22861' AND id_supplier = '109' 09/09/2024 03:22:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22861' , '109' , '1' ) 09/09/2024 03:22:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93063' , '22864' , 'E LA TUA PARTE 2 - 9/11 ANNI' , '2' , '2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.0000' ) 09/09/2024 03:22:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22864' AND id_supplier = '109' 09/09/2024 03:22:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22864' , '109' , '1' ) 09/09/2024 04:11:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 04:11:36 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' , '2631' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.75' , '135.23' , NOW() , NOW() ) 09/09/2024 04:11:36 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 = '93064' 09/09/2024 04:11:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '93064' 09/09/2024 04:11:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93064' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '100.00' ) 09/09/2024 04:11:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93064' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 09/09/2024 04:11:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93064' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 09/09/2024 04:12:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 04:12:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2632' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.20' , NOW() , NOW() ) 09/09/2024 04:12:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93065' 09/09/2024 04:12:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93065' 09/09/2024 04:12:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93065' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '1' , '-1' , '1' , '2.60' , '2.1311475409836' , '22' , '0' , '2.60' ) 09/09/2024 04:12:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93065' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 09/09/2024 04:14:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 09/09/2024 04:14:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', 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 = '140.20', price_tax_excluded = '129.74', date_upd = NOW() WHERE id_document = '90734' 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90734' 09/09/2024 04:14:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '90734' 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 09/09/2024 04:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 09/09/2024 04:48:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001826' AND id_product != '18881' AND ean13 != '' 09/09/2024 04:48:24 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001826', date_upd = NOW() WHERE id_product = '18881' 09/09/2024 04:48:24 pm >> UPDATE ps_product_lang SET name = 'STOLA POLIESTERE - PST020', description = '' WHERE id_product = '18881' 09/09/2024 04:48:24 pm >> UPDATE ps_product SET wholesale_price = '8.20', on_sale = '0', price = '23.770491803278688' WHERE id_product = '18881' 09/09/2024 04:48:24 pm >> UPDATE ps_product_shop SET wholesale_price = '8.20', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '440', 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 = '18881' 09/09/2024 04:48:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '18881' 09/09/2024 04:49:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001310' AND id_product != '16405' AND ean13 != '' 09/09/2024 04:49:55 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001310', date_upd = NOW() WHERE id_product = '16405' 09/09/2024 04:49:55 pm >> UPDATE ps_product_lang SET name = 'CASULA MORELLO', description = '' WHERE id_product = '16405' 09/09/2024 04:49:55 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '67.21311475409836' WHERE id_product = '16405' 09/09/2024 04:49:55 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '67.21311475409836', id_tax_rules_group = '1', id_category_default = '440', 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 = '16405' 09/09/2024 04:49:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '16405' 09/09/2024 04:51:32 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 ( '33' , '777' , '2024-09-05' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '346.11' , '283.70' , NOW() , NOW() ) 09/09/2024 04:51: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 = '93066' 09/09/2024 04:51:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93066' 09/09/2024 04:51: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 ( '93066' , '14926' , 'VESTINA BATTESIMALE' , '30' , '30' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '76.8600' ) 09/09/2024 04:51:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '122' 09/09/2024 04:51:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '122' , '1' ) 09/09/2024 04:51: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 ( '93066' , '18881' , 'STOLA POLIESTERE - PST020' , '6' , '6' , '1' , '11.7' , '9.5901639344262' , '22' , '0' , '85.6440' ) 09/09/2024 04:51:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '122' 09/09/2024 04:51:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '122' , '1' ) 09/09/2024 04:51: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 ( '93066' , '16405' , 'CASULA MORELLO' , '2' , '2' , '1' , '33.5' , '27.459016393443' , '22' , '0' , '81.7400' ) 09/09/2024 04:51:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16405' AND id_supplier = '122' 09/09/2024 04:51:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16405' , '122' , '1' ) 09/09/2024 04:51: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 ( '93066' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 09/09/2024 04:51:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '122' 09/09/2024 04:51:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '122' , '1' ) 09/09/2024 04:51: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 ( '93066' , '15916' , 'CASULA - PCA033' , '1' , '1' , '1' , '33.5' , '27.459016393443' , '22' , '0' , '40.8700' ) 09/09/2024 04:51:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15916' AND id_supplier = '122' 09/09/2024 04:51:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15916' , '122' , '1' ) 09/09/2024 04:55:45 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '777', document_date = '2024-09-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669556', address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO', 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 = '346.11', price_tax_excluded = '283.70', date_upd = NOW() WHERE id_document = '93066' 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93066' 09/09/2024 04:55:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93066' 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93066' , '14926' , 'VESTINA BATTESIMALE' , '30' , '30' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '76.86' ) 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93066' , '20644' , 'STOLA - PST022' , '6' , '6' , '1' , '11.7' , '9.5901639344262' , '22' , '0' , '85.6440' ) 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93066' , '16405' , 'CASULA MORELLO' , '2' , '2' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '81.74' ) 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93066' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '61.00' ) 09/09/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93066' , '15916' , 'CASULA - PCA033' , '1' , '1' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '40.87' ) 09/09/2024 04:57:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002110' AND id_product != '20644' AND ean13 != '' 09/09/2024 04:57:04 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '002110', date_upd = NOW() WHERE id_product = '20644' 09/09/2024 04:57:04 pm >> UPDATE ps_product_lang SET name = 'STOLA - PST022', description = '' WHERE id_product = '20644' 09/09/2024 04:57:04 pm >> UPDATE ps_product SET wholesale_price = '11.70', on_sale = '0', price = '23.770491803278688' WHERE id_product = '20644' 09/09/2024 04:57:04 pm >> UPDATE ps_product_shop SET wholesale_price = '11.70', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '440', 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 = '20644' 09/09/2024 04:57:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '20644' 09/09/2024 05:01:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 05:01:42 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' , '2633' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 09/09/2024 05:01:42 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 = '93067' 09/09/2024 05:01:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '93067' 09/09/2024 05:01:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93067' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 09/09/2024 05:10:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 05:10:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2634' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 09/09/2024 05:10:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93068' 09/09/2024 05:10:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93068' 09/09/2024 05:10:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93068' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/09/2024 05:10:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93068' , '22753' , 'MESSA MEDITAZIONE - SETT/OTT 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/09/2024 06:38:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 06:38:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2635' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.51' , '80.34' , NOW() , NOW() ) 09/09/2024 06:38:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93069' 09/09/2024 06:38:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93069' 09/09/2024 06:38:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93069' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/09/2024 06:38:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93069' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.00' , '6' , '0' , '5' , '22.80' ) 09/09/2024 06:38:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93069' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/09/2024 06:38:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93069' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/09/2024 06:41:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 06:41:30 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' , '2636' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 09/09/2024 06:41: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 = '93070' 09/09/2024 06:41:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93070' 09/09/2024 06:41: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 ( '93070' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 09/09/2024 06:41: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 ( '93070' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/09/2024 07:20:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 09/09/2024 07:20:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2637' , '2024-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.70' , '10.91' , NOW() , NOW() ) 09/09/2024 07:20:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93071' 09/09/2024 07:20:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '93071' 09/09/2024 07:20:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93071' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '33' , '-33' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.90' ) 09/09/2024 07:20:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93071' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' )