06/04/2023 08:40:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '5726/00/2023' , '2023-04-04' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '122.40' , '122.40' , NOW() , NOW() ) 06/04/2023 08:40:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82695' 06/04/2023 08:40:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82695' 06/04/2023 08:40:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82695' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '18' , '18' , '4' , '5.00' , '5' , '0' , '40' , '54.0000' ) 06/04/2023 08:40:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 06/04/2023 08:40:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 06/04/2023 08:40:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82695' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '10' , '10' , '4' , '3.00' , '3' , '0' , '40' , '18.0000' ) 06/04/2023 08:40:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '38' 06/04/2023 08:40:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '38' , '1' ) 06/04/2023 08:40:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82695' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '12' , '12' , '4' , '7.00' , '7' , '0' , '40' , '50.4000' ) 06/04/2023 08:40:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '7704' AND id_supplier = '38' 06/04/2023 08:40:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7704' , '38' , '1' ) 06/04/2023 08:46:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000004250' AND id_product != '20851' AND ean13 != '' 06/04/2023 08:46:52 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000004250', date_upd = NOW() WHERE id_product = '20851' 06/04/2023 08:46:52 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187', description = '' WHERE id_product = '20851' 06/04/2023 08:46:52 am >> UPDATE ps_product SET wholesale_price = '16.15', on_sale = '0', price = '33.60655737704918' WHERE id_product = '20851' 06/04/2023 08:46:52 am >> UPDATE ps_product_shop SET wholesale_price = '16.15', price = '33.60655737704918', id_tax_rules_group = '1', id_category_default = '147', 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 = '20851' 06/04/2023 08:46:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20851' 06/04/2023 08:47:04 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/04/2023 08:47:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20899' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 08:47:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20899' , '1' , '1' , '2' , NOW() , NOW() ) 06/04/2023 08:47:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20899' , '0' , '1' , '0' , '0' ) 06/04/2023 08:48:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000031263' AND id_product != '20899' AND ean13 != '' 06/04/2023 08:48:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000031263', date_upd = NOW() WHERE id_product = '20899' 06/04/2023 08:48:15 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188', description = '' WHERE id_product = '20899' 06/04/2023 08:48:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23.770491803278688' WHERE id_product = '20899' 06/04/2023 08:48:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '147', 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 = '20899' 06/04/2023 08:48:15 am >> DELETE FROM ps_specific_price WHERE id_product = '20899' 06/04/2023 08:48:18 am >> 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 = '20899' 06/04/2023 08:48:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20900' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 08:48:18 am >> 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 '20900' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20899' 06/04/2023 08:48:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20900' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20899' 06/04/2023 08:49:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000004250' AND id_product != '20851' AND ean13 != '' 06/04/2023 08:49:01 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000004250', date_upd = NOW() WHERE id_product = '20851' 06/04/2023 08:49:01 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187', description = '' WHERE id_product = '20851' 06/04/2023 08:49:01 am >> UPDATE ps_product SET wholesale_price = '16.15', on_sale = '0', price = '31.557377049180328' WHERE id_product = '20851' 06/04/2023 08:49:01 am >> UPDATE ps_product_shop SET wholesale_price = '16.15', price = '31.557377049180328', id_tax_rules_group = '1', id_category_default = '147', 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 = '20851' 06/04/2023 08:49:01 am >> DELETE FROM ps_specific_price WHERE id_product = '20851' 06/04/2023 08:54:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015935' AND id_product != '20900' AND ean13 != '' 06/04/2023 08:54:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015935', date_upd = NOW() WHERE id_product = '20900' 06/04/2023 08:54:31 am >> UPDATE ps_product_lang SET name = 'BACILE DORATO - 689', description = '' WHERE id_product = '20900' 06/04/2023 08:54:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '75' WHERE id_product = '20900' 06/04/2023 08:54:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '75', id_tax_rules_group = '1', id_category_default = '147', 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 = '20900' 06/04/2023 08:54:31 am >> DELETE FROM ps_specific_price WHERE id_product = '20900' 06/04/2023 08:55:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001674' AND id_product != '18068' AND ean13 != '' 06/04/2023 08:55:13 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001674', date_upd = NOW() WHERE id_product = '18068' 06/04/2023 08:55:13 am >> UPDATE ps_product_lang SET name = 'SACCO PORTA ELEMOSINA - 1751', description = '' WHERE id_product = '18068' 06/04/2023 08:55:13 am >> UPDATE ps_product SET wholesale_price = '14.25', on_sale = '0', price = '35.24590163934426' WHERE id_product = '18068' 06/04/2023 08:55:13 am >> UPDATE ps_product_shop SET wholesale_price = '14.25', price = '35.24590163934426', id_tax_rules_group = '1', id_category_default = '147', 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 = '18068' 06/04/2023 08:55:13 am >> DELETE FROM ps_specific_price WHERE id_product = '18068' 06/04/2023 09:01:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1240' , '2023-04-03' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '387.33' , '317.48' , NOW() , NOW() ) 06/04/2023 09:01:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82696' 06/04/2023 09:01:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82696' 06/04/2023 09:01:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '2' , '2' , '1' , '17' , '13.934426229508' , '22' , '5' , '39.4060' ) 06/04/2023 09:01:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20851' AND id_supplier = '12' 06/04/2023 09:01:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20851' , '12' , '1' ) 06/04/2023 09:01:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '20899' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 8X20 - 1188' , '2' , '2' , '1' , '11.8' , '9.672131147541' , '22' , '5' , '27.3524' ) 06/04/2023 09:01:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20899' AND id_supplier = '12' 06/04/2023 09:01:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20899' , '12' , '1' ) 06/04/2023 09:01:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '2' , '1' , '17.5' , '14.344262295082' , '22' , '5' , '40.5650' ) 06/04/2023 09:01:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 06/04/2023 09:01:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 06/04/2023 09:01:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '2' , '2' , '1' , '43' , '35.245901639344' , '22' , '5' , '99.6740' ) 06/04/2023 09:01:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = '12' 06/04/2023 09:01:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '12' , '1' ) 06/04/2023 09:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '3' , '3' , '1' , '5.5' , '4.5081967213115' , '22' , '5' , '19.1235' ) 06/04/2023 09:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '12' 06/04/2023 09:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '12' , '1' ) 06/04/2023 09:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '20900' , 'BACILE DORATO - 689' , '1' , '1' , '1' , '37.5' , '30.737704918033' , '22' , '5' , '43.4625' ) 06/04/2023 09:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20900' AND id_supplier = '12' 06/04/2023 09:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20900' , '12' , '1' ) 06/04/2023 09:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82696' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '5' , '5' , '1' , '18' , '14.754098360656' , '22' , '5' , '104.3100' ) 06/04/2023 09:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '18068' AND id_supplier = '12' 06/04/2023 09:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18068' , '12' , '1' ) 06/04/2023 09:06:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 09:06:26 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' , '1164' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 06/04/2023 09:06:26 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 = '82697' 06/04/2023 09:06:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82697' 06/04/2023 09:06:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82697' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '47.1' , '38.606557377049' , '22' , '0' , '47.10' ) 06/04/2023 09:06:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82697' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 06/04/2023 09:07:43 am >> SELECT document_num FROM ps_document WHERE document_num = '50/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 09:07:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '50/A' , '2023-04-06' , 'A' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '26.00' , NOW() , NOW() ) 06/04/2023 09:07:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82698' 06/04/2023 09:07:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82698' 06/04/2023 09:07:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82698' , '' , 'GRANI PER CERO PASQUALE' , '2' , '-2' , '0' , '13' , '13' , '' , '0' , '26.00' ) 06/04/2023 09:20:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/04/2023 09:20:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20901' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 09:20:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20901' , '1' , '1' , '2' , NOW() , NOW() ) 06/04/2023 09:20:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20901' , '0' , '1' , '0' , '0' ) 06/04/2023 09:25:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002128' AND id_product != '20901' AND ean13 != '' 06/04/2023 09:25:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002129' AND id_product != '20901' AND ean13 != '' 06/04/2023 09:25:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002129', date_upd = NOW() WHERE id_product = '20901' 06/04/2023 09:25:16 am >> UPDATE ps_product_lang SET name = 'CASULA P/LANA AGNUS DEI - 8219-8249L', description = '' WHERE id_product = '20901' 06/04/2023 09:25:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20901' 06/04/2023 09:25:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '448', 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 = '20901' 06/04/2023 09:25:16 am >> DELETE FROM ps_specific_price WHERE id_product = '20901' 06/04/2023 09:28:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 09:28:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1165' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 06/04/2023 09:28:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82699' 06/04/2023 09:28:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82699' 06/04/2023 09:28:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82699' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 06/04/2023 09:30:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002129' AND id_product != '20901' AND ean13 != '' 06/04/2023 09:30:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002129', date_upd = NOW() WHERE id_product = '20901' 06/04/2023 09:30:05 am >> UPDATE ps_product_lang SET name = 'CASULA P/LANA AGNUS DEI - 8219-8249L', description = '' WHERE id_product = '20901' 06/04/2023 09:30:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '815.5737704918033' WHERE id_product = '20901' 06/04/2023 09:30:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '815.5737704918033', id_tax_rules_group = '1', id_category_default = '448', 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 = '20901' 06/04/2023 09:30:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20901' 06/04/2023 09:33:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '67' , '2023-04-03' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 06/04/2023 09:33:49 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 = '82700' 06/04/2023 09:33:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82700' 06/04/2023 09:33:49 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 ( '82700' , '20901' , 'CASULA P/LANA AGNUS DEI - 8219-8249L' , '1' , '1' , '1' , '0.00' , '0' , '22' , '0' , '0.00' ) 06/04/2023 09:33:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20901' AND id_supplier = '126' 06/04/2023 09:33:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20901' , '126' , '1' ) 06/04/2023 09:33:49 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 ( '82700' , '16040' , 'STOLA ROMANA S/MOIRE\' - 7336S' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 06/04/2023 09:33:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16040' AND id_supplier = '126' 06/04/2023 09:33:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16040' , '126' , '1' ) 06/04/2023 09:33:49 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 ( '82700' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 06/04/2023 09:33:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18237' AND id_supplier = '126' 06/04/2023 09:33:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18237' , '126' , '1' ) 06/04/2023 09:35:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 09:35:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1166' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.41' , '28.41' , NOW() , NOW() ) 06/04/2023 09:35:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82701' 06/04/2023 09:35:28 am >> DELETE FROM ps_document_detail WHERE id_document = '82701' 06/04/2023 09:35:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82701' , '12937' , 'CATECHISMO DELLA CHIESA CATTOLICA' , '1' , '-1' , '4' , '29.90' , '29.9' , '0' , '5' , '28.41' ) 06/04/2023 09:44:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 09:44: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 ( '11' , '1167' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/04/2023 09:44: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 = '82702' 06/04/2023 09:44:13 am >> DELETE FROM ps_document_detail WHERE id_document = '82702' 06/04/2023 09:44:13 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 ( '82702' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/04/2023 10:06:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 10:06:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1168' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '35.69' , NOW() , NOW() ) 06/04/2023 10:06:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82703' 06/04/2023 10:06:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82703' 06/04/2023 10:06:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82703' , '19718' , 'CROCE CORPO IN RESINA - CL192' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 06/04/2023 10:06:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82703' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 06/04/2023 10:06:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1168' AND id_document != '82703' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 10:06:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1168', document_date = '2023-04-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.00', price_tax_excluded = '35.69', date_upd = NOW() WHERE id_document = '82703' 06/04/2023 10:06:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82703' 06/04/2023 10:06:58 am >> DELETE FROM ps_document_detail WHERE id_document = '82703' 06/04/2023 10:06:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82703' , '19718' , 'CROCE CORPO IN RESINA - CL192' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 06/04/2023 10:06:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82703' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 06/04/2023 10:35:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 10:35:40 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' , '1169' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 06/04/2023 10:35:40 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 = '82704' 06/04/2023 10:35:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82704' 06/04/2023 10:35:40 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 ( '82704' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 06/04/2023 10:44:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 10:44:07 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' , '1170' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 06/04/2023 10:44:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82705' 06/04/2023 10:44:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82705' 06/04/2023 10:44:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82705' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 06/04/2023 10:44:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82705' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 06/04/2023 10:44:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82705' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 06/04/2023 10:44:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82705' , '6402' , 'MENSA BIANCA 60X200 ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 06/04/2023 11:03:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 11:03:01 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' , '1171' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 06/04/2023 11:03:01 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 = '82706' 06/04/2023 11:03:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82706' 06/04/2023 11:03:01 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 ( '82706' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '3' , '-3' , '1' , '40' , '32.786885245902' , '22' , '0' , '120.00' ) 06/04/2023 11:18:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 11:18:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1172' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '296.19' , NOW() , NOW() ) 06/04/2023 11:18: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 = '82707' 06/04/2023 11:18:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82707' 06/04/2023 11:18: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 ( '82707' , '19476' , 'RISURREZIONE? - H. KESSLER' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 06/04/2023 11:18: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 ( '82707' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 06/04/2023 11:18: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 ( '82707' , '20819' , 'PREGARE ALLA SCUOLA DI GRANDI MAESTRI - E. BOLIS' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/04/2023 11:18: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 ( '82707' , '20869' , 'CARA MAMMA - TONINO BELLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 06/04/2023 11:18: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 ( '82707' , '14464' , 'GIOIA NELLA SPERANZA - W. KASPER' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/04/2023 11:18: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 ( '82707' , '19237' , 'PERCORSI DI FRATERNITA' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 06/04/2023 11:18: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 ( '82707' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 06/04/2023 11:18: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 ( '82707' , '20815' , 'FRATE FRANCESCO - R. MURANO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 06/04/2023 11:18: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 ( '82707' , '20882' , 'CREDO LA VITA ETERNA - BENEDETTO XVI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 06/04/2023 11:18: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 ( '82707' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/04/2023 11:18: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 ( '82707' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/04/2023 11:18: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 ( '82707' , '20886' , 'VIAGGIO NEL CIELO DELLANIMA CON TERESA DAVILA - R. TAVELLI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 06/04/2023 11:18: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 ( '82707' , '20530' , 'ULTIME PAROLE - TERESA DI GESU BAMBINO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 06/04/2023 11:18: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 ( '82707' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 06/04/2023 11:18: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 ( '82707' , '20820' , 'CUORE CI PARLA DI DIO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 06/04/2023 11:18: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 ( '82707' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '16.85' , '13.811475409836' , '22' , '0' , '16.85' ) 06/04/2023 11:18: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 ( '82707' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '3' , '10.00' , '9.6153846153846' , '4' , '0' , '20.00' ) 06/04/2023 11:20:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/04/2023 11:20:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20902' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 11:20:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20902' , '1' , '1' , '2' , NOW() , NOW() ) 06/04/2023 11:20:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20902' , '0' , '1' , '0' , '0' ) 06/04/2023 11:21:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868798512' AND id_product != '20902' AND ean13 != '' 06/04/2023 11:21:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868798512', date_upd = NOW() WHERE id_product = '20902' 06/04/2023 11:21:04 am >> UPDATE ps_product_lang SET name = 'scienziati dunque credenti - f. agnoli', description = '' WHERE id_product = '20902' 06/04/2023 11:21:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20902' 06/04/2023 11:21:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', 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 = '20902' 06/04/2023 11:21:04 am >> DELETE FROM ps_specific_price WHERE id_product = '20902' 06/04/2023 11:21:05 am >> 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 = '20902' 06/04/2023 11:21:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20903' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 11:21:05 am >> 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 '20903' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20902' 06/04/2023 11:21:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20903' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20902' 06/04/2023 11:24:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810977507' AND id_product != '20903' AND ean13 != '' 06/04/2023 11:24:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810977507', date_upd = NOW() WHERE id_product = '20903' 06/04/2023 11:24:06 am >> UPDATE ps_product_lang SET name = 'caritas spes fides - benedetto xvi', description = '' WHERE id_product = '20903' 06/04/2023 11:24:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20903' 06/04/2023 11:24:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20903' 06/04/2023 11:24:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20903' 06/04/2023 11:24:07 am >> 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 = '20903' 06/04/2023 11:24:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20904' , '1' , '' , 'nuovo-prodotto' ) 06/04/2023 11:24:07 am >> 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 '20904' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20903' 06/04/2023 11:24:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20904' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20903' 06/04/2023 11:25:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868798512' AND id_product != '20902' AND ean13 != '' 06/04/2023 11:25:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868798512', date_upd = NOW() WHERE id_product = '20902' 06/04/2023 11:25:37 am >> UPDATE ps_product_lang SET name = 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI', description = '' WHERE id_product = '20902' 06/04/2023 11:25:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '20902' 06/04/2023 11:25:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', 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 = '20902' 06/04/2023 11:25:37 am >> DELETE FROM ps_specific_price WHERE id_product = '20902' 06/04/2023 11:25:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810977507' AND id_product != '20903' AND ean13 != '' 06/04/2023 11:25:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810977507', date_upd = NOW() WHERE id_product = '20903' 06/04/2023 11:25:52 am >> UPDATE ps_product_lang SET name = 'CARITAS SPES FIDES - BENEDETTO XVI', description = '' WHERE id_product = '20903' 06/04/2023 11:25:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.0000' WHERE id_product = '20903' 06/04/2023 11:25:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20903' 06/04/2023 11:25:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20903' 06/04/2023 11:26:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '895182' , '2023-04-05' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 06/04/2023 11:26:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82708' 06/04/2023 11:26:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82708' 06/04/2023 11:26:05 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 ( '82708' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '2' , '2' , '4' , '25.00' , '25' , '0' , '0' , '50.0000' ) 06/04/2023 11:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 06/04/2023 11:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 06/04/2023 11:26:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82708' , '20902' , 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 06/04/2023 11:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20902' AND id_supplier = '109' 06/04/2023 11:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20902' , '109' , '1' ) 06/04/2023 11:26:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82708' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 06/04/2023 11:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20903' AND id_supplier = '109' 06/04/2023 11:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20903' , '109' , '1' ) 06/04/2023 12:21:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 12:21:53 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' , '1173' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.90' , '34.34' , NOW() , NOW() ) 06/04/2023 12:21:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82709' 06/04/2023 12:21:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82709' 06/04/2023 12:21: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 ( '82709' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '41.90' , '34.344262295082' , '22' , '0' , '41.90' ) 06/04/2023 12:35:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 12:35:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '51/A' , '2023-04-06' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '290.00' , NOW() , NOW() ) 06/04/2023 12:35:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82710' 06/04/2023 12:35:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82710' 06/04/2023 12:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '0' , '135.00' , '135' , '' , '0' , '135.00' ) 06/04/2023 12:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '0' , '22.00' , '22' , '' , '0' , '66.00' ) 06/04/2023 12:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '0' , '0.12' , '0.12' , '' , '0' , '60.00' ) 06/04/2023 12:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '0' , '29.00' , '29' , '' , '0' , '29.00' ) 06/04/2023 12:37:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '82710' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 12:37:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2023-04-06', 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 = '290.00', price_tax_excluded = '237.70', date_upd = NOW() WHERE id_document = '82710' 06/04/2023 12:37:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82710' 06/04/2023 12:37:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82710' 06/04/2023 12:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 06/04/2023 12:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '66.00' ) 06/04/2023 12:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.12' , '0.098360655737705' , '22' , '0' , '60.00' ) 06/04/2023 12:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 06/04/2023 12:40:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 12:40:21 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' , '1174' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 06/04/2023 12:40:21 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 = '82711' 06/04/2023 12:40:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82711' 06/04/2023 12:40:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82711' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 06/04/2023 12:46:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '882' AND id_document != '82348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-17') 06/04/2023 12:46:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '882', document_date = '2023-03-17', 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 = '68.80', price_tax_excluded = '56.39', date_upd = NOW() WHERE id_document = '82348' 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82348' 06/04/2023 12:46:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82348' 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82348' , '20757' , 'VIA CRUCIS - IMMAGINI 35X50' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82348' , '1041' , 'BENEDIZIONI' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82348' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '0.90' ) 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82348' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 06/04/2023 12:46:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82348' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 06/04/2023 12:49:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-06') 06/04/2023 12:49:34 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' , '1175' , '2023-04-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '5.98' , NOW() , NOW() ) 06/04/2023 12:49:34 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 = '82712' 06/04/2023 12:49:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82712' 06/04/2023 12:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82712' , '9102' , 'ROSARIO DIVINA MISERICORDIA - VETRO ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 06/04/2023 12:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82712' , '4485' , 'GESÙ MISERICORDIOSO- 781-4 TMD - OGGETTI' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' )