17/10/2023 08:59:46 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/10/2023 08:59:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21679' , '1' , '' , 'nuovo-prodotto' ) 17/10/2023 08:59:46 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21679' , '1' , '1' , '2' , NOW() , NOW() ) 17/10/2023 08:59:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21679' , '0' , '1' , '0' , '0' ) 17/10/2023 09:00:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048899' AND id_product != '21679' AND ean13 != '' 17/10/2023 09:00:35 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788884048899', date_upd = NOW() WHERE id_product = '21679' 17/10/2023 09:00:35 am >> UPDATE ps_product_lang SET name = 'LAUDATE DEUM - 8583', description = '' WHERE id_product = '21679' 17/10/2023 09:00:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1' WHERE id_product = '21679' 17/10/2023 09:00:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21679' 17/10/2023 09:00:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21679' 17/10/2023 09:01:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '16067/00/2023' , '2023-10-13' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '180.00' , '180.00' , NOW() , NOW() ) 17/10/2023 09:01:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88328' 17/10/2023 09:01:15 am >> DELETE FROM ps_document_detail WHERE id_document = '88328' 17/10/2023 09:01:15 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 ( '88328' , '21679' , 'LAUDATE DEUM - 8583' , '300' , '300' , '4' , '1.00' , '1' , '0' , '40' , '180.0000' ) 17/10/2023 09:01:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '21679' AND id_supplier = '38' 17/10/2023 09:01:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21679' , '38' , '1' ) 17/10/2023 09:48:43 am >> DELETE FROM ps_product WHERE id_product = '5714' 17/10/2023 09:48:43 am >> DELETE FROM ps_product_shop WHERE id_product = '5714' 17/10/2023 09:48:43 am >> DELETE FROM ps_product_lang WHERE id_product = '5714' 17/10/2023 09:48:43 am >> DELETE FROM ps_stock_available WHERE id_product = '5714' 17/10/2023 09:52:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3183' AND id_document != '88323' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 17/10/2023 09:52:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3183', document_date = '2023-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.00', price_tax_excluded = '8.00', date_upd = NOW() WHERE id_document = '88323' 17/10/2023 09:52:55 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 = '88323' 17/10/2023 09:52:55 am >> DELETE FROM ps_document_detail WHERE id_document = '88323' 17/10/2023 09:52:55 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 ( '88323' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '4' , '4' , '0' , '0' , '8.00' ) 17/10/2023 09:59:29 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '19110' 17/10/2023 09:59:29 am >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '19110' 17/10/2023 10:23:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:23:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3186' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 17/10/2023 10:23:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88329' 17/10/2023 10:23:32 am >> DELETE FROM ps_document_detail WHERE id_document = '88329' 17/10/2023 10:23:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88329' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 17/10/2023 10:26:04 am >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:26:04 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' , '43' , '2023-10-17' , '' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '9' , '359.00' , '359.00' , NOW() , NOW() ) 17/10/2023 10:26:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88330' 17/10/2023 10:26:04 am >> DELETE FROM ps_document_detail WHERE id_document = '88330' 17/10/2023 10:26:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '21037' , 'SULLA TUA PAROLA - LUG/AGO 23' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '0' , '50.00' ) 17/10/2023 10:26:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '21037' AND id_supplier = '38' 17/10/2023 10:26:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21037' , '38' , '1' ) 17/10/2023 10:26:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '0' , '45.00' ) 17/10/2023 10:26:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 17/10/2023 10:26:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 17/10/2023 10:26:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '0' , '10.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20592' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20592' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '19115' , 'NOTTE DI PASSIONE - 8051' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '0' , '6.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19115' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19115' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20276' , 'CONCILIO VATICANO II - VOL. 1 - 701' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20276' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20276' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20562' , 'RIVELAZIONE COME PAROLA DI DIO - VOL. 2 - 702' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20562' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20562' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20563' , 'TRADIZIONE - VOL. 3 - 703' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20563' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20563' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20564' , 'ISPIRAZIONE - VOL. 4 - 704' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20564' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20564' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20565' , 'SACRA SCRITTURA NELLA VITA.. VOL. 5 - 705' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20565' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20565' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20566' , 'LITURGIA NEL MISTERO... - VOL. 6 - 706' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20566' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20566' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20567' , 'SACRA SCRITTURA NELLA LITURGIA - VOL. 7 - 707' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20567' AND id_supplier = '38' 17/10/2023 10:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20567' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20568' , 'VIVERE LA LITURGIA IN PARROCCHIA - VOL. 8 - 708' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20568' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20568' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20569' , 'MISTERO EUCARISTICO - VOL. 9 - 709' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20569' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20569' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20570' , 'LITURGIA DELLE ORE - VOL. 10 - 710' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20570' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20570' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20571' , 'SACRAMENTI - VOL. 11 - 711' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20571' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20571' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20572' , 'DOMENICA - VOL. 12 - 712' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20572' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20572' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20573' , 'TEMPI FORTI DELLANNO LITURGICO - VOL. 13 - 713' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20573' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20573' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20574' , 'MUSICA NELLA LITURGIA - VOL. 14 - 714' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20574' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20574' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20575' , 'BELLEZZA DELLA LITURGIA - VOL. 15 - 715' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20575' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20575' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20576' , 'MISTERO DELLA CHIESA - VOL. 16 - 716' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20576' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20576' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20577' , 'IMMAGINI DELLA CHIESA - VOL. 17 - 717' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20577' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20577' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20712' , 'POPOLO DI DIO - 718' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20712' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20712' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20593' , 'CHIESA E PER LAVANGELIZZAZIONE - 19' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20593' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20593' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20713' , 'PAPA I VESCOVI I SACERDOTI ... - 720' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20713' AND id_supplier = '38' 17/10/2023 10:26:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20713' , '38' , '1' ) 17/10/2023 10: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 ( '88330' , '20594' , 'LAICI - 21' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20594' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20594' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20714' , 'VITA CONSACRATA - 722' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20714' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20714' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20595' , 'SANTITA UNA VOCAZIONE - 23' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20595' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20595' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20715' , 'CHIESA PELLEGRINA - 724' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20715' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20715' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20596' , 'MARIA LA PRIMA DI CREDENTI - 725' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20596' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20596' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20597' , 'CHIESA NEL MONDO DI OGGI - 26' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20597' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20597' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20598' , 'GRANDE TEMA DEL SENSO DELLA VITA - 27' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20598' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20598' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20599' , 'SOCIETA DEGLI UOMINI - 28' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20599' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20599' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20600' , 'AUTONOMIA E SERVIZIO - 29' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20600' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20600' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20601' , 'FAMIGLIA -30' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20601' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20601' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20602' , 'CULTURA - 31' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20602' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20602' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20716' , 'ECONOMIA E FINANZA - 732' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20716' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20716' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20604' , 'POLITICA - 33' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20604' AND id_supplier = '38' 17/10/2023 10:26:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20604' , '38' , '1' ) 17/10/2023 10:26: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 ( '88330' , '20605' , 'DIALOGO COME STRUMENTO - 34' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '20605' AND id_supplier = '38' 17/10/2023 10:26:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20605' , '38' , '1' ) 17/10/2023 10:26:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20606' , 'PACE - 35' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/10/2023 10:26:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '20606' AND id_supplier = '38' 17/10/2023 10:26:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20606' , '38' , '1' ) 17/10/2023 10:32:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3187' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:32: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' , '3187' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 17/10/2023 10:32: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 = '88331' 17/10/2023 10:32:00 am >> DELETE FROM ps_document_detail WHERE id_document = '88331' 17/10/2023 10:32: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 ( '88331' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '4' , '-4' , '1' , '20' , '16.393442622951' , '22' , '0' , '80.00' ) 17/10/2023 10:32: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 ( '88331' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/10/2023 10:32: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 ( '88331' , '21098' , 'BRACCIALE DECINA PIETRA - BC1885' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/10/2023 10:40:59 am >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '88315' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 17/10/2023 10:40:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '161', document_date = '2023-10-16', document_letter = '', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'da pagare', 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 = '354.46', price_tax_excluded = '354.46', date_upd = NOW() WHERE id_document = '88315' 17/10/2023 10:40:59 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 = '88315' 17/10/2023 10:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88315' 17/10/2023 10:40:59 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 ( '88315' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 17/10/2023 10:40:59 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 ( '88315' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 17/10/2023 10:40:59 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 ( '88315' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '37' , '-37' , '4' , '3.5000' , '3.5' , '0' , '15' , '110.08' ) 17/10/2023 10:40:59 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 ( '88315' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 17/10/2023 10:40:59 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 ( '88315' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 17/10/2023 10:40:59 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 ( '88315' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 17/10/2023 10:42:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:42:31 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' , '3188' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.50' , '94.67' , NOW() , NOW() ) 17/10/2023 10:42:31 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 = '88332' 17/10/2023 10:42:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88332' 17/10/2023 10:42:31 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 ( '88332' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '-1' , '1' , '51.50' , '42.213114754098' , '22' , '0' , '51.50' ) 17/10/2023 10:42:31 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 ( '88332' , '9780' , 'SECCHIELLO PER ASPERGES IN ACCIAIO - 695' , '1' , '-1' , '1' , '64.00' , '52.459016393443' , '22' , '0' , '64.00' ) 17/10/2023 10:45:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:45:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3189' , '2023-10-17' , '' , '0' , '0' , '0' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '325.00' , '266.39' , NOW() , NOW() ) 17/10/2023 10:45:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88333' 17/10/2023 10:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '88333' 17/10/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88333' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '2' , '-2' , '1' , '60.0000' , '49.1803' , '22' , '0' , '120.00' ) 17/10/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88333' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '1' , '65.0000' , '53.2787' , '22' , '0' , '65.00' ) 17/10/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88333' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.0000' , '53.2787' , '22' , '0' , '65.00' ) 17/10/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88333' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' , '75.0000' , '61.4754' , '22' , '0' , '75.00' ) 17/10/2023 10:48:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 10:48:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3190' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.80' , '11.31' , NOW() , NOW() ) 17/10/2023 10:48: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 = '88334' 17/10/2023 10:48:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88334' 17/10/2023 10:48: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 ( '88334' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '13.80' ) 17/10/2023 11:44:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 11:44:18 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' , '3191' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.40' , '50.33' , NOW() , NOW() ) 17/10/2023 11:44:18 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 = '88335' 17/10/2023 11:44:18 am >> DELETE FROM ps_document_detail WHERE id_document = '88335' 17/10/2023 11:44:18 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 ( '88335' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/10/2023 11:44:18 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 ( '88335' , '6014' , 'LUMINO BIANCO - 10B' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 17/10/2023 12:23:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934062772' AND id_product != '17569' AND ean13 != '' 17/10/2023 12:23:56 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934062772', date_upd = NOW() WHERE id_product = '17569' 17/10/2023 12:23:56 pm >> UPDATE ps_product_lang SET name = 'BAMBINO IN RESINA - PB6277', description = '' WHERE id_product = '17569' 17/10/2023 12:23:56 pm >> UPDATE ps_product SET wholesale_price = '4.14', on_sale = '0', price = '11.065573770491804' WHERE id_product = '17569' 17/10/2023 12:23:56 pm >> UPDATE ps_product_shop SET wholesale_price = '4.14', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '458', 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 = '17569' 17/10/2023 12:23:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '17569' 17/10/2023 12:31:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 12:31:04 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' , '3192' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.00' , '143.84' , NOW() , NOW() ) 17/10/2023 12:31:04 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 = '88336' 17/10/2023 12:31:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88336' 17/10/2023 12:31:04 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 ( '88336' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '2' , '-2' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '118.00' ) 17/10/2023 12:31:04 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 ( '88336' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 17/10/2023 12:31:04 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 ( '88336' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4' , '3.8461538461538' , '4' , '0' , '4.00' ) 17/10/2023 12:31:04 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 ( '88336' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 17/10/2023 12:34:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 12:34:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '93' , '2023-10-17' , '' , '4696' , '0' , '149355607' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.83' , '58.83' , NOW() , NOW() ) 17/10/2023 12:34:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13219' 17/10/2023 12:34:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '13219' 17/10/2023 12:34: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 ( '13219' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '15' , '53.13' ) 17/10/2023 12:34: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 ( '13219' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 17/10/2023 12:34:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 12:34:52 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 ( '21' , '167' , '2023-10-17' , '' , '1155' , '0' , '4672061' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.15' , '84.15' , NOW() , NOW() ) 17/10/2023 12:34: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 = '88337' 17/10/2023 12:34:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '88337' 17/10/2023 12:34: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 ( '88337' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 17/10/2023 12:34: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 ( '88337' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 17/10/2023 12:34: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 ( '88337' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 17/10/2023 12:38:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 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' , '3193' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 17/10/2023 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 = '88338' 17/10/2023 12:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '88338' 17/10/2023 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 ( '88338' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/10/2023 12:51:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3194' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 12:51: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' , '3194' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '430.00' , '362.32' , NOW() , NOW() ) 17/10/2023 12:51: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 = '88339' 17/10/2023 12:51:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88339' 17/10/2023 12:51: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 ( '88339' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 17/10/2023 12:51: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 ( '88339' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/10/2023 12:51: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 ( '88339' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 17/10/2023 12:51: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 ( '88339' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35' , '35' , '0' , '0' , '35.00' ) 17/10/2023 12:51: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 ( '88339' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/10/2023 12:51: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 ( '88339' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 17/10/2023 12:52:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3195' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 12:52:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3195' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '23.20' , NOW() , NOW() ) 17/10/2023 12:52:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88340' 17/10/2023 12:52:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '88340' 17/10/2023 12:52:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88340' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/10/2023 12:52:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88340' , '21196' , 'CALENDARIO LITURGICO 2024' , '30' , '-30' , '4' , '0.50' , '0.5' , '0' , '0' , '15.00' ) 17/10/2023 01:03:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 01:03: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 ( '21' , '168' , '2023-10-17' , '' , '249' , '0' , '4676358' , 'VIA N. PETROSINO, 33 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.31' , '24.31' , NOW() , NOW() ) 17/10/2023 01:03: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 = '88341' 17/10/2023 01:03:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '88341' 17/10/2023 01:03: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 ( '88341' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '-5' , '4' , '2.40' , '2.4' , '0' , '15' , '10.20' ) 17/10/2023 01:03: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 ( '88341' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 17/10/2023 01:03: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 ( '88341' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 17/10/2023 01:03: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 ( '88341' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 17/10/2023 01:03: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 ( '88341' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 17/10/2023 01:04:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 01:04:01 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' , '3196' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.02' , '153.02' , NOW() , NOW() ) 17/10/2023 01:04:01 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 = '88342' 17/10/2023 01:04:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88342' 17/10/2023 01:04:01 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 ( '88342' , '11193' , 'VENITE CON ME CAT.' , '8' , '-8' , '4' , '5.50' , '5.5' , '0' , '5' , '41.84' ) 17/10/2023 01:04:01 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 ( '88342' , '5444' , 'IO SONO CON VOI - CAT.' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '5' , '31.38' ) 17/10/2023 01:04:01 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 ( '88342' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 17/10/2023 01:04:01 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 ( '88342' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 17/10/2023 01:04:01 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 ( '88342' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 17/10/2023 01:04:01 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 ( '88342' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 17/10/2023 01:06:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 01:06:49 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' , '3197' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.00' , '126.00' , NOW() , NOW() ) 17/10/2023 01:06:49 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 = '88343' 17/10/2023 01:06:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '88343' 17/10/2023 01:06:49 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 ( '88343' , '5929' , 'LODI E VESPRI' , '30' , '-30' , '4' , '4.2' , '4.2' , '0' , '' , '126.00' ) 17/10/2023 01:13:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 01:13: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' , '3198' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 17/10/2023 01:13: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 = '88344' 17/10/2023 01:13:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88344' 17/10/2023 01:13: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 ( '88344' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 17/10/2023 02:20:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '88337' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 02:20:56 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '167', document_date = '2023-10-17', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '84.15', price_tax_excluded = '84.15', date_upd = NOW() WHERE id_document = '88337' 17/10/2023 02:20:56 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 = '88337' 17/10/2023 02:20:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '88337' 17/10/2023 02:20:56 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 ( '88337' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 17/10/2023 02:20:56 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 ( '88337' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 17/10/2023 02:20:56 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 ( '88337' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 17/10/2023 02:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '88341' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 02:21:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '168', document_date = '2023-10-17', document_letter = '', id_customer = '249', id_supplier = '', id_address = '4676358', address1 = 'VIA N. PETROSINO, 33 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '24.31', price_tax_excluded = '24.31', date_upd = NOW() WHERE id_document = '88341' 17/10/2023 02:21:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88341' 17/10/2023 02:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '88341' 17/10/2023 02:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88341' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '-5' , '4' , '2.4000' , '2.4' , '0' , '15' , '10.20' ) 17/10/2023 02:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88341' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 17/10/2023 02:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88341' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '15' , '2.38' ) 17/10/2023 02:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88341' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '15' , '2.38' ) 17/10/2023 02:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88341' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 17/10/2023 02:27:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '13219' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 02:27:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '93', document_date = '2023-10-17', document_letter = '', id_customer = '4696', id_supplier = '', id_address = '149355607', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '58.83', price_tax_excluded = '58.83', date_upd = NOW() WHERE id_document = '13219' 17/10/2023 02:27:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13219' 17/10/2023 02:27:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '13219' 17/10/2023 02:27: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 ( '13219' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 17/10/2023 02:27: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 ( '13219' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 17/10/2023 02:58:02 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/10/2023 02:58:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21680' , '1' , '' , 'nuovo-prodotto' ) 17/10/2023 02:58:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21680' , '1' , '1' , '2' , NOW() , NOW() ) 17/10/2023 02:58:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21680' , '0' , '1' , '0' , '0' ) 17/10/2023 02:58:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002183' AND id_product != '21680' AND ean13 != '' 17/10/2023 02:58:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002183', date_upd = NOW() WHERE id_product = '21680' 17/10/2023 02:58:55 pm >> UPDATE ps_product_lang SET name = 'CASULA - 65-019416', description = '' WHERE id_product = '21680' 17/10/2023 02:58:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '301.6393442622951' WHERE id_product = '21680' 17/10/2023 02:58:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '301.6393442622951', id_tax_rules_group = '1', id_category_default = '468', 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 = '21680' 17/10/2023 02:58:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '21680' 17/10/2023 02:59:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002183' AND id_product != '21680' AND ean13 != '' 17/10/2023 02:59:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002183', date_upd = NOW() WHERE id_product = '21680' 17/10/2023 02:59:14 pm >> UPDATE ps_product_lang SET name = 'CASULA - 65-019416', description = '' WHERE id_product = '21680' 17/10/2023 02:59:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '696.7213114754098' WHERE id_product = '21680' 17/10/2023 02:59:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '696.7213114754098', id_tax_rules_group = '1', id_category_default = '468', 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 = '21680' 17/10/2023 02:59:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '21680' 17/10/2023 02:59: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 ( '33' , '1055' , '2023-10-13' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , 'CONTO VISIONE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '448.96' , '368.00' , NOW() , NOW() ) 17/10/2023 02:59: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 = '88345' 17/10/2023 02:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '88345' 17/10/2023 02:59: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 ( '88345' , '21680' , 'CASULA - 65-019416' , '1' , '1' , '1' , '368' , '301.6393442623' , '22' , '0' , '448.9600' ) 17/10/2023 02:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21680' AND id_supplier = '143' 17/10/2023 02:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21680' , '143' , '1' ) 17/10/2023 03:03:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863664058' AND id_product != '21607' AND ean13 != '' 17/10/2023 03:03:20 pm >> UPDATE ps_product SET id_supplier = '47', reference = '6/6', ean13 = '9788863664058', date_upd = NOW() WHERE id_product = '21607' 17/10/2023 03:03:20 pm >> UPDATE ps_product_lang SET name = 'O GESU\' MI ABBANDONO A TE - DOLINDO RUOTOLO', description = '' WHERE id_product = '21607' 17/10/2023 03:03:20 pm >> UPDATE ps_product SET wholesale_price = '6.65', on_sale = '0', price = '9.5000' WHERE id_product = '21607' 17/10/2023 03:03:20 pm >> UPDATE ps_product_shop SET wholesale_price = '6.65', price = '9.5000', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21607' 17/10/2023 03:03:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21607' 17/10/2023 03:03:21 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 = '21607' 17/10/2023 03:03:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21681' , '1' , '' , 'nuovo-prodotto' ) 17/10/2023 03:03:21 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 '21681' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21607' 17/10/2023 03:03:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21681' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21607' 17/10/2023 03:09:33 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '1055', document_date = '2023-10-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', address2 = '', note = 'CONTO VISIONE', 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 = '449.69', price_tax_excluded = '368.60', date_upd = NOW() WHERE id_document = '88345' 17/10/2023 03:09: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 = '88345' 17/10/2023 03:09:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '88345' 17/10/2023 03:09: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 ( '88345' , '21680' , 'CASULA - 65-019416' , '1' , '1' , '1' , '380' , '311.47540983607' , '22' , '3' , '449.6920' ) 17/10/2023 03:09:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002183' AND id_product != '21680' AND ean13 != '' 17/10/2023 03:09:57 pm >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002183', date_upd = NOW() WHERE id_product = '21680' 17/10/2023 03:09:57 pm >> UPDATE ps_product_lang SET name = 'CASULA - 65-019416', description = '' WHERE id_product = '21680' 17/10/2023 03:09:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '717.2131147540983' WHERE id_product = '21680' 17/10/2023 03:09:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '717.2131147540983', id_tax_rules_group = '1', id_category_default = '468', 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 = '21680' 17/10/2023 03:09:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '21680' 17/10/2023 03:10:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247568' AND id_product != '19891' AND ean13 != '' 17/10/2023 03:10:59 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788884247568', date_upd = NOW() WHERE id_product = '19891' 17/10/2023 03:10:59 pm >> UPDATE ps_product_lang SET name = 'FATTI PER L\'ETERNITA\' - F. SHEEN', description = '' WHERE id_product = '19891' 17/10/2023 03:10:59 pm >> UPDATE ps_product SET wholesale_price = '9.80', on_sale = '0', price = '14.0000' WHERE id_product = '19891' 17/10/2023 03:10:59 pm >> UPDATE ps_product_shop SET wholesale_price = '9.80', price = '14.0000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19891' 17/10/2023 03:10:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '19891' 17/10/2023 03:50:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 03:50: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' , '3199' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 17/10/2023 03:50: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 = '88346' 17/10/2023 03:50:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88346' 17/10/2023 03:50: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 ( '88346' , '10445' , 'TAPPO - RICAMBIO' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/10/2023 05:31:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 05:31:14 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' , '3200' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 17/10/2023 05:31:14 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 = '88347' 17/10/2023 05:31:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '88347' 17/10/2023 05:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88347' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/10/2023 05:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88347' , '21153' , 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 17/10/2023 05:53:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 05:53:46 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' , '3201' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.10' , '17.92' , NOW() , NOW() ) 17/10/2023 05:53:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88348' 17/10/2023 05:53:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88348' 17/10/2023 05:53: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 ( '88348' , '21564' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 17/10/2023 05:53: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 ( '88348' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/10/2023 06:03:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 06:03:19 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' , '3202' , '2023-10-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.80' , '11.46' , NOW() , NOW() ) 17/10/2023 06:03:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88349' 17/10/2023 06:03:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '88349' 17/10/2023 06:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88349' , '17884' , 'CROCE MOGANO CORPO MET. CM 25 - 168M' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 17/10/2023 06:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88349' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 17/10/2023 07:33:25 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fkVMk9x1WD08Mt1z' , NOW() , NOW() ) 17/10/2023 07:33:25 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4040' , '1' ) 17/10/2023 07:33:25 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4040' , '2' ) 17/10/2023 07:33:25 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4040' , '3' ) 17/10/2023 07:36:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4040' 17/10/2023 07:36:04 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4040' , '10' , '150' , 'PARR. MARIA MADRE DELLA CHIESA' , '' , '' , 'CONTRADA CORSETTO - AREA URBANA ROSSANO' , '' , '87064' , 'CORIGLIANO ROSSANO' , 'ORDINA: Nilo Cosentino Cell. 3383285127 - nilo.cosentino.73@gmail.com' , '' , '' , '' , '97000300786' , NOW() , NOW() ) 17/10/2023 07:36:04 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4040' 17/10/2023 07:37:20 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4040' 17/10/2023 07:37:20 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4040' , '10' , '150' , 'PARR. MARIA MADRE DELLA CHIESA' , '' , '' , 'CONTRADA CORSETTO - AREA URBANA ROSSANO' , '' , '87064' , 'CORIGLIANO ROSSANO' , 'ORDINA: Nilo Cosentino Cell. 3383285127 - \r\nSPEDIZIONE: Cosentino Nilo - C/O Yogurt King - Via Nazionale, 144 (Area Urbana Rossano) - 87064 Corigliano Rossano (CS)\r\n' , '' , '' , '' , '97000300786' , NOW() , NOW() ) 17/10/2023 07:37:20 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4040' 17/10/2023 07:38:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '169' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-17') 17/10/2023 07:38:12 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 ( '21' , '169' , '2023-10-17' , '' , '4040' , '0' , '4679138' , 'CONTRADA CORSETTO - AREA URBANA ROSSANO 87064 CORIGLIANO ROSSANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '82.38' , '82.38' , NOW() , NOW() ) 17/10/2023 07:38:12 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 = '88350' 17/10/2023 07:38:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '88350' 17/10/2023 07:38:12 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 ( '88350' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 17/10/2023 07:38:12 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 ( '88350' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 17/10/2023 07:38:12 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 ( '88350' , '' , 'CONTRASSEGNOI' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 17/10/2023 07:49:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4040' 17/10/2023 07:49:41 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4040' , '10' , '150' , 'PARR. MARIA MADRE DELLA CHIESA' , '' , '' , 'CONTRADA CORSETTO - AREA URBANA ROSSANO' , '' , '87064' , 'CORIGLIANO ROSSANO' , 'ORDINA: Nilo Cosentino Cell. 3383285127 - \r\nSPEDIZIONE: Cosentino Nilo - C/O Yogurt King - Via Nazionale, 144 (Area Urbana Rossano) - 87064 Corigliano Rossano (CS)\r\n' , '' , '' , '' , '97000300786' , NOW() , NOW() ) 17/10/2023 07:49:41 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4040'