13/10/2022 09:17:09 am >> SELECT document_num FROM ps_document WHERE document_num = '166' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 09:17:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '166' , '2022-10-13' , '' , '3907' , '0' , '4674901' , 'VIA DIOCLEZIANO 130 80124 NAPOLI' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '48.70' , '48.70' , NOW() , NOW() ) 13/10/2022 09:17:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66330' 13/10/2022 09:17:09 am >> DELETE FROM ps_document_detail WHERE id_document = '66330' 13/10/2022 09:17:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66330' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '30' , '-30' , '4' , '1.60' , '1.6' , '0' , '15' , '40.80' ) 13/10/2022 09:17:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66330' , '' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 13/10/2022 09:30:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '16314/00/2022' , '2022-10-11' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '126.00' , '126.00' , NOW() , NOW() ) 13/10/2022 09:30:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66331' 13/10/2022 09:30:08 am >> DELETE FROM ps_document_detail WHERE id_document = '66331' 13/10/2022 09:30: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 ( '66331' , '8248' , 'PREGATE, PREGATE, PREGATE - CART. - 8101' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8248' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8248' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '3' , '3' , '4' , '19.00' , '19' , '0' , '40' , '34.2000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '2' , '4' , '7.00' , '7' , '0' , '40' , '8.4000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19583' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19583' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '8339' , 'PREGHIERE AL CUORE IMMACOLATO DI MARIA - 8155' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8339' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8339' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '1' , '4' , '8.00' , '8' , '0' , '40' , '4.8000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '10' , '10' , '4' , '2.00' , '2' , '0' , '40' , '12.0000' ) 13/10/2022 09:30:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '38' 13/10/2022 09:30:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '38' , '1' ) 13/10/2022 09:30: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 ( '66331' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 13/10/2022 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '38' 13/10/2022 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '38' , '1' ) 13/10/2022 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66331' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '10' , '10' , '4' , '4.00' , '4' , '0' , '40' , '24.0000' ) 13/10/2022 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13830' AND id_supplier = '38' 13/10/2022 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13830' , '38' , '1' ) 13/10/2022 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66331' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '2' , '2' , '4' , '7.00' , '7' , '0' , '40' , '8.4000' ) 13/10/2022 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9647' AND id_supplier = '38' 13/10/2022 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9647' , '38' , '1' ) 13/10/2022 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66331' , '11881' , 'IO E TE - BIBBIA DEI PICCOLI - 8828' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 13/10/2022 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11881' AND id_supplier = '38' 13/10/2022 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11881' , '38' , '1' ) 13/10/2022 09:37:24 am >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 09:37:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '167' , '2022-10-13' , '' , '2787' , '0' , '4670997' , 'VIALE KENNEDY, 19 71013 S. GIOVANNI ROTONDO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.21' , '180.21' , NOW() , NOW() ) 13/10/2022 09:37:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66332' 13/10/2022 09:37:24 am >> DELETE FROM ps_document_detail WHERE id_document = '66332' 13/10/2022 09:37:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '80' , '-80' , '4' , '2.40' , '2.4' , '0' , '15' , '163.20' ) 13/10/2022 09:37:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '15' , '15.30' ) 13/10/2022 09:37:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 13/10/2022 10:00:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555234' AND id_product != '20043' AND ean13 != '' 13/10/2022 10:00:24 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/1', ean13 = '9788831555234', date_upd = NOW() WHERE id_product = '20043' 13/10/2022 10:00:24 am >> UPDATE ps_product_lang SET name = 'FOLLOWERS 2.0 - GUIDA', description = '' WHERE id_product = '20043' 13/10/2022 10:00:24 am >> UPDATE ps_product SET wholesale_price = '9.38', on_sale = '0', price = '14.0000' WHERE id_product = '20043' 13/10/2022 10:00:24 am >> UPDATE ps_product_shop SET wholesale_price = '9.38', price = '14.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20043' 13/10/2022 10:00:24 am >> DELETE FROM ps_specific_price WHERE id_product = '20043' 13/10/2022 10:01:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/10/2022 10:01:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20137' , '1' , '' , 'nuovo-prodotto' ) 13/10/2022 10:01:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20137' , '1' , '1' , '2' , NOW() , NOW() ) 13/10/2022 10:01:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20137' , '0' , '1' , '0' , '0' ) 13/10/2022 10:01:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555241' AND id_product != '20137' AND ean13 != '' 13/10/2022 10:01:46 am >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788831555241', date_upd = NOW() WHERE id_product = '20137' 13/10/2022 10:01:46 am >> UPDATE ps_product_lang SET name = 'FOLLOWERS 2.0 - quaderno', description = '' WHERE id_product = '20137' 13/10/2022 10:01:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '20137' 13/10/2022 10:01:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20137' 13/10/2022 10:01:46 am >> DELETE FROM ps_specific_price WHERE id_product = '20137' 13/10/2022 10:02:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555241' AND id_product != '20137' AND ean13 != '' 13/10/2022 10:02:16 am >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788831555241', date_upd = NOW() WHERE id_product = '20137' 13/10/2022 10:02:16 am >> UPDATE ps_product_lang SET name = 'FOLLOWERS 2.0 - QUADERNO', description = '' WHERE id_product = '20137' 13/10/2022 10:02:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.0000' WHERE id_product = '20137' 13/10/2022 10:02:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20137' 13/10/2022 10:02:16 am >> DELETE FROM ps_specific_price WHERE id_product = '20137' 13/10/2022 10:02:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '611085' , '2022-10-11' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '6.91' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '238.51' , '238.51' , NOW() , NOW() ) 13/10/2022 10:02:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66333' 13/10/2022 10:02:41 am >> DELETE FROM ps_document_detail WHERE id_document = '66333' 13/10/2022 10:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '12' , '12' , '4' , '5' , '5' , '0' , '35+7' , '36.2700' ) 13/10/2022 10:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 13/10/2022 10:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 13/10/2022 10:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 13/10/2022 10:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 13/10/2022 10:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '18448' , 'SCOPRIAMO INSIEME IL CREDO ' , '4' , '4' , '4' , '4.90' , '4.9' , '0' , '30' , '13.7200' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18448' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18448' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '1' , '4' , '4.00' , '4' , '0' , '33' , '2.6800' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '14642' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14642' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '11123' , 'VANGELO SECONDO GIOVANNI (CAP. 1-11)' , '1' , '1' , '4' , '22.00' , '22' , '0' , '30' , '15.4000' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '11123' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11123' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '1' , '4' , '34.00' , '34' , '0' , '33' , '22.7800' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17414' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17414' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '20016' , 'ALLELUJA - 2023' , '2' , '2' , '4' , '9.90' , '9.9' , '0' , '30' , '13.8600' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '20016' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20016' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '20054' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023' , '4' , '4' , '4' , '5.00' , '5' , '0' , '30' , '14.0000' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '17517' , 'SCOPRIAMO INSIEME GESU' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17517' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17517' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '18647' , 'SCOPRIAMO INSIEME LAVVENTO' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18647' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18647' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17242' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17242' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '19565' , 'SCOPRIAMO INSIEME SEGNI E SIMBOLI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 13/10/2022 10:02:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '7' 13/10/2022 10:02:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '7' , '1' ) 13/10/2022 10:02:42 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 ( '66333' , '19294' , 'SCOPRIAMO INSIEME IL VANGELO' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 13/10/2022 10:02:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19294' AND id_supplier = '7' 13/10/2022 10:02:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19294' , '7' , '1' ) 13/10/2022 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 13/10/2022 10:02:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '7' 13/10/2022 10:02:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '7' , '1' ) 13/10/2022 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35' , '15.6000' ) 13/10/2022 10:02:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '7' 13/10/2022 10:02:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '7' , '1' ) 13/10/2022 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '2' , '2' , '4' , '14.00' , '14' , '0' , '33' , '18.7600' ) 13/10/2022 10:02:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '7' 13/10/2022 10:02:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '7' , '1' ) 13/10/2022 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66333' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '5' , '5' , '4' , '8.00' , '8' , '0' , '33' , '26.8000' ) 13/10/2022 10:02:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20137' AND id_supplier = '7' 13/10/2022 10:02:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20137' , '7' , '1' ) 13/10/2022 10:34:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000065' AND id_product != '541' AND ean13 != '' 13/10/2022 10:34:51 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000065', date_upd = NOW() WHERE id_product = '541' 13/10/2022 10:34:51 am >> UPDATE ps_product_lang SET name = 'AMPOLLE ALTARE NIK - 503', description = '' WHERE id_product = '541' 13/10/2022 10:34:51 am >> UPDATE ps_product SET wholesale_price = '42.28', on_sale = '0', price = '97.1311475409836' WHERE id_product = '541' 13/10/2022 10:34:51 am >> UPDATE ps_product_shop SET wholesale_price = '42.28', price = '97.1311475409836', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '541' 13/10/2022 10:34:51 am >> DELETE FROM ps_specific_price WHERE id_product = '541' 13/10/2022 10:36:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000064' AND id_product != '544' AND ean13 != '' 13/10/2022 10:36:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000064', date_upd = NOW() WHERE id_product = '544' 13/10/2022 10:36:22 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MAGNETICHE NIK', description = '' WHERE id_product = '544' 13/10/2022 10:36:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '108.19672131147541' WHERE id_product = '544' 13/10/2022 10:36:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '108.19672131147541', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '544' 13/10/2022 10:36:22 am >> DELETE FROM ps_specific_price WHERE id_product = '544' 13/10/2022 10:38:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 10:38:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3032' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 13/10/2022 10:38:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66334' 13/10/2022 10:38:01 am >> DELETE FROM ps_document_detail WHERE id_document = '66334' 13/10/2022 10:38:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66334' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 13/10/2022 10:38:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/10/2022 10:38:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/10/2022 10:42:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000063' AND id_product != '543' AND ean13 != '' 13/10/2022 10:42:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000063', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:42:37 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MAGNETICHE DORATE', description = '' WHERE id_product = '543' 13/10/2022 10:42:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '141' WHERE id_product = '543' 13/10/2022 10:42:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '141', id_tax_rules_group = '0', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:42:37 am >> DELETE FROM ps_specific_price WHERE id_product = '543' 13/10/2022 10:43:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000063' AND id_product != '543' AND ean13 != '' 13/10/2022 10:43:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000063', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:43:32 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MAGNETICHE DORATE', description = '' WHERE id_product = '543' 13/10/2022 10:43:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '141' WHERE id_product = '543' 13/10/2022 10:43:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '141', id_tax_rules_group = '0', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:43:32 am >> DELETE FROM ps_specific_price WHERE id_product = '543' 13/10/2022 10:43:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000063' AND id_product != '543' AND ean13 != '' 13/10/2022 10:43:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000063', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:43:52 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MAGNETICHE DORATE', description = '' WHERE id_product = '543' 13/10/2022 10:43:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '115.57377049180329' WHERE id_product = '543' 13/10/2022 10:43:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '115.57377049180329', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '543' 13/10/2022 10:43:52 am >> DELETE FROM ps_specific_price WHERE id_product = '543' 13/10/2022 10:45:18 am >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 10:45: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 ( '21' , '168' , '2022-10-13' , '' , '1155' , '0' , '4672061' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '119.00' , NOW() , NOW() ) 13/10/2022 10:45: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 = '66335' 13/10/2022 10:45:18 am >> DELETE FROM ps_document_detail WHERE id_document = '66335' 13/10/2022 10:45: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 ( '66335' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '40' , '-40' , '4' , '3.50' , '3.5' , '0' , '15' , '119.00' ) 13/10/2022 10:48:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 10:48:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3033' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 13/10/2022 10:48:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66336' 13/10/2022 10:48:24 am >> DELETE FROM ps_document_detail WHERE id_document = '66336' 13/10/2022 10:48:25 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 ( '66336' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 13/10/2022 10:48:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/10/2022 10:48:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/10/2022 10:52:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2973' AND id_document != '65220' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 13/10/2022 10:52:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2973', document_date = '2022-10-08', 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 = '88.90', price_tax_excluded = '76.66', date_upd = NOW() WHERE id_document = '65220' 13/10/2022 10:52:53 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 = '65220' 13/10/2022 10:52:54 am >> DELETE FROM ps_document_detail WHERE id_document = '65220' 13/10/2022 10:52:54 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 ( '65220' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/10/2022 10:52:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/10/2022 10:52:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/10/2022 10:52:54 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 ( '65220' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '0' , '21.00' ) 13/10/2022 10:52:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/10/2022 10:52:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/10/2022 10:52:54 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 ( '65220' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/10/2022 10:52:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/10/2022 10:52:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/10/2022 10:52:54 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 ( '65220' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/10/2022 10:52:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 13/10/2022 10:52:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 13/10/2022 10:59:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 10:59:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3034' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.70' , '19.70' , NOW() , NOW() ) 13/10/2022 10:59:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66337' 13/10/2022 10:59:14 am >> DELETE FROM ps_document_detail WHERE id_document = '66337' 13/10/2022 10:59:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66337' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 13/10/2022 10:59:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 13/10/2022 10:59:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 13/10/2022 10:59:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66337' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 13/10/2022 10:59:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 13/10/2022 10:59:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 13/10/2022 11:01:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000078' AND id_product != '545' AND ean13 != '' 13/10/2022 11:01:01 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000078', date_upd = NOW() WHERE id_product = '545' 13/10/2022 11:01:01 am >> UPDATE ps_product_lang SET name = 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507', description = '' WHERE id_product = '545' 13/10/2022 11:01:01 am >> UPDATE ps_product SET wholesale_price = '27.12', on_sale = '0', price = '68.85245901639344' WHERE id_product = '545' 13/10/2022 11:01:01 am >> UPDATE ps_product_shop SET wholesale_price = '27.12', price = '68.85245901639344', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '545' 13/10/2022 11:01:01 am >> DELETE FROM ps_specific_price WHERE id_product = '545' 13/10/2022 11:04:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000064' AND id_product != '544' AND ean13 != '' 13/10/2022 11:04:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000064', date_upd = NOW() WHERE id_product = '544' 13/10/2022 11:04:01 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MAGNETICHE NIK', description = '' WHERE id_product = '544' 13/10/2022 11:04:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '106.55737704918033' WHERE id_product = '544' 13/10/2022 11:04:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '106.55737704918033', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '544' 13/10/2022 11:04:01 am >> DELETE FROM ps_specific_price WHERE id_product = '544' 13/10/2022 11:11:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000608' AND id_product != '540' AND ean13 != '' 13/10/2022 11:11:34 am >> UPDATE ps_product SET id_supplier = '12', reference = '2014', ean13 = '000608', date_upd = NOW() WHERE id_product = '540' 13/10/2022 11:11:34 am >> UPDATE ps_product_lang SET name = 'AMPOLLE ALTARE FUSIONE DORATA - 504 ', description = '' WHERE id_product = '540' 13/10/2022 11:11:34 am >> UPDATE ps_product SET wholesale_price = '44.18', on_sale = '0', price = '101.63934426229508' WHERE id_product = '540' 13/10/2022 11:11:34 am >> UPDATE ps_product_shop SET wholesale_price = '44.18', price = '101.63934426229508', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '540' 13/10/2022 11:11:34 am >> DELETE FROM ps_specific_price WHERE id_product = '540' 13/10/2022 11:15:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 11:15:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3035' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.69' , '25.33' , NOW() , NOW() ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66338' 13/10/2022 11:15:11 am >> DELETE FROM ps_document_detail WHERE id_document = '66338' 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '14322' , 'RELIGIOCANDO - SACRAMENTI E MIRACOLI' , '1' , '-1' , '4' , '8.60' , '8.6' , '0' , '5' , '8.17' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '14322' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14322' , '' , '1' ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.40' , '2.4' , '0' , '5' , '2.28' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '6' , '5.64' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 13/10/2022 11:15:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66338' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 13/10/2022 11:15:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 13/10/2022 11:15:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 13/10/2022 11:24:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001466' AND id_product != '16764' AND ean13 != '' 13/10/2022 11:24:30 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001466', date_upd = NOW() WHERE id_product = '16764' 13/10/2022 11:24:30 am >> UPDATE ps_product_lang SET name = 'AMPOLLE SU VASSOIO IN VETRO - 1521', description = '' WHERE id_product = '16764' 13/10/2022 11:24:30 am >> UPDATE ps_product SET wholesale_price = '18.53', on_sale = '0', price = '40.98360655737705' WHERE id_product = '16764' 13/10/2022 11:24:30 am >> UPDATE ps_product_shop SET wholesale_price = '18.53', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16764' 13/10/2022 11:24:30 am >> DELETE FROM ps_specific_price WHERE id_product = '16764' 13/10/2022 11:33:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001170' AND id_product != '15357' AND ean13 != '' 13/10/2022 11:33:37 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001170', date_upd = NOW() WHERE id_product = '15357' 13/10/2022 11:33:37 am >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO NIKEL - 1512', description = '' WHERE id_product = '15357' 13/10/2022 11:33:37 am >> UPDATE ps_product SET wholesale_price = '34.58', on_sale = '0', price = '78.68852459016394' WHERE id_product = '15357' 13/10/2022 11:33:37 am >> UPDATE ps_product_shop SET wholesale_price = '34.58', price = '78.68852459016394', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15357' 13/10/2022 11:33:37 am >> DELETE FROM ps_specific_price WHERE id_product = '15357' 13/10/2022 11:35:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001977' AND id_product != '19445' AND ean13 != '' 13/10/2022 11:35:01 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001977', date_upd = NOW() WHERE id_product = '19445' 13/10/2022 11:35:01 am >> UPDATE ps_product_lang SET name = 'AMPOLLE MARE SU VASSOIO DORATO - 1504', description = '' WHERE id_product = '19445' 13/10/2022 11:35:01 am >> UPDATE ps_product SET wholesale_price = '42.75', on_sale = '0', price = '98.3607' WHERE id_product = '19445' 13/10/2022 11:35:01 am >> UPDATE ps_product_shop SET wholesale_price = '42.75', price = '98.3607', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19445' 13/10/2022 11:35:01 am >> DELETE FROM ps_specific_price WHERE id_product = '19445' 13/10/2022 11:37:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 11:37:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3036' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 13/10/2022 11:37:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66339' 13/10/2022 11:37:43 am >> DELETE FROM ps_document_detail WHERE id_document = '66339' 13/10/2022 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66339' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/10/2022 11:37:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 13/10/2022 11:37:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 13/10/2022 12:07:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 13/10/2022 12:07:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', 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 = '224.59', price_tax_excluded = '211.48', date_upd = NOW() WHERE id_document = '61817' 13/10/2022 12:07: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 = '61817' 13/10/2022 12:07:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '61817' 13/10/2022 12:07: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 ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/10/2022 12:07:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 13/10/2022 12:07:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '' , '13/10/2022' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.56' , '0.56' , '0' , '0' , '28.00' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 13/10/2022 12:07:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 13/10/2022 12:07:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 13/10/2022 12:07:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 13/10/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 13/10/2022 12:07: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 ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 13/10/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 13/10/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 13/10/2022 12:07: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 ( '61817' , '' , 'LAMPADINE' , '47' , '-47' , '4' , '1.2' , '1.2' , '0' , '0' , '56.40' ) 13/10/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 13/10/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 13/10/2022 12:11:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '65775' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-10') 13/10/2022 12:11:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '76/A', document_date = '2022-10-10', document_letter = 'A', id_customer = '1854', id_supplier = '', id_address = '4671605', address1 = 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO', 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 = '395.30', price_tax_excluded = '372.22', date_upd = NOW() WHERE id_document = '65775' 13/10/2022 12:11: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 = '65775' 13/10/2022 12:11:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '65775' 13/10/2022 12:11: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 ( '65775' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 13/10/2022 12:11:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 13/10/2022 12:11:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 13/10/2022 12:11: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 ( '65775' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '8.91' , '8.91' , '0' , '' , '267.30' ) 13/10/2022 12:11:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '' 13/10/2022 12:11:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '' , '1' ) 13/10/2022 12:11: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 ( '65775' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 13/10/2022 12:11:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 13/10/2022 12:11:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 13/10/2022 12:12:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 12:12:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3037' , '2022-10-13' , '' , '' , '' , '' , 'PIAZZA S. GREGORIO 84020 SAN GREGORIO MAGNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '395.30' , '372.22' , NOW() , NOW() ) 13/10/2022 12:12:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66340' 13/10/2022 12:12:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '66340' 13/10/2022 12:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66340' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.459' , '22' , '0' , '90.00' ) 13/10/2022 12:12:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 13/10/2022 12:12:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 13/10/2022 12:12: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 ( '66340' , '1090' , 'BIBBIA' , '30' , '-30' , '4' , '8.9100' , '8.91' , '0' , '' , '267.30' ) 13/10/2022 12:12:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '' 13/10/2022 12:12:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '' , '1' ) 13/10/2022 12:12: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 ( '66340' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.7869' , '22' , '5' , '38.00' ) 13/10/2022 12:12:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 13/10/2022 12:12:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 13/10/2022 12:12:20 pm >> DELETE FROM ps_document WHERE id_document = '65775' 13/10/2022 12:12:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '65775' 13/10/2022 12:43:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 12:43:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3038' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.26' , NOW() , NOW() ) 13/10/2022 12:43:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66341' 13/10/2022 12:43:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '66341' 13/10/2022 12:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66341' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 13/10/2022 12:43:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/10/2022 12:43:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/10/2022 12:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66341' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 13/10/2022 12:43:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/10/2022 12:43:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/10/2022 12:43:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66341' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 13/10/2022 12:43:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/10/2022 12:43:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/10/2022 03:13:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 03:13:26 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' , '3039' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 13/10/2022 03:13:26 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 = '66342' 13/10/2022 03:13:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '66342' 13/10/2022 03:13:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66342' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/10/2022 03:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/10/2022 03:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/10/2022 03:39:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 13/10/2022 03:39:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', 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 = '2530.00', price_tax_excluded = '2073.77', date_upd = NOW() WHERE id_document = '56617' 13/10/2022 03:39: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 = '56617' 13/10/2022 03:39:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 13/10/2022 03:39: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 13/10/2022 03:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 13/10/2022 03:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 13/10/2022 03:39: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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 13/10/2022 03:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 03:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 03:43:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 13/10/2022 03:43:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - ', 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 = '2530.00', price_tax_excluded = '2073.77', date_upd = NOW() WHERE id_document = '56617' 13/10/2022 03:43:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56617' 13/10/2022 03:43:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 13/10/2022 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 13/10/2022 03:43:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 13/10/2022 03:43:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 13/10/2022 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 13/10/2022 03:43:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 03:43:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 03:45:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2931' AND id_document != '64648' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 13/10/2022 03:45:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2931', document_date = '2022-10-05', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '64648' 13/10/2022 03:45: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 = '64648' 13/10/2022 03:45:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '64648' 13/10/2022 03:45: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 ( '64648' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 13/10/2022 03:45:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20118' AND id_supplier = '' 13/10/2022 03:45:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20118' , '' , '1' ) 13/10/2022 03:47:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2963' AND id_document != '65204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 13/10/2022 03:47:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2963', document_date = '2022-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '48.50', price_tax_excluded = '44.33', date_upd = NOW() WHERE id_document = '65204' 13/10/2022 03:47: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 = '65204' 13/10/2022 03:47:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '65204' 13/10/2022 03:47: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 ( '65204' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.2' , '4.2' , '0' , '0' , '4.20' ) 13/10/2022 03:47:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/10/2022 03:47:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/10/2022 03:47: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 ( '65204' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/10/2022 03:47:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/10/2022 03:47:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/10/2022 03:47: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 ( '65204' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 13/10/2022 03:47:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 13/10/2022 03:47:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 13/10/2022 03:47: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 ( '65204' , '5538' , 'LACCIO MARRONE' , '20' , '-20' , '1' , '0.0500' , '0.040983606557377' , '22' , '0' , '1.00' ) 13/10/2022 03:47:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5538' AND id_supplier = '' 13/10/2022 03:47:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5538' , '' , '1' ) 13/10/2022 03:47: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 ( '65204' , '12897' , 'SIGNOR PARROCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 13/10/2022 03:47:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12897' AND id_supplier = '' 13/10/2022 03:47:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12897' , '' , '1' ) 13/10/2022 03:51:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2917' AND id_document != '64627' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 13/10/2022 03:51:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2917', document_date = '2022-10-05', 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 = '375.00', price_tax_excluded = '308.46', date_upd = NOW() WHERE id_document = '64627' 13/10/2022 03:51:28 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 = '64627' 13/10/2022 03:51:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '64627' 13/10/2022 03:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '19961' , 'AMITTO M/LANA - 099' , '10' , '-10' , '1' , '35' , '28.688524590164' , '22' , '0' , '350.00' ) 13/10/2022 03:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19961' AND id_supplier = '' 13/10/2022 03:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19961' , '' , '1' ) 13/10/2022 03:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 13/10/2022 03:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/10/2022 03:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/10/2022 03:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 13/10/2022 03:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/10/2022 03:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/10/2022 03:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/10/2022 03:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/10/2022 03:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/10/2022 03:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64627' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 13/10/2022 03:51:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 13/10/2022 03:51:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 13/10/2022 03:53:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 03:53:24 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' , '3040' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 13/10/2022 03:53:24 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 = '66343' 13/10/2022 03:53:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '66343' 13/10/2022 03:53:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66343' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 13/10/2022 03:53:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '' 13/10/2022 03:53:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '' , '1' ) 13/10/2022 03:55:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3014' AND id_document != '65799' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-12') 13/10/2022 03:55:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3014', document_date = '2022-10-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '887.30', price_tax_excluded = '727.30', date_upd = NOW() WHERE id_document = '65799' 13/10/2022 03:55: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 = '65799' 13/10/2022 03:55:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '65799' 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '1616' , 'CANDELABRO MOD. 700 - CM 30' , '2' , '-2' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '170.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1616' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1616' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '13036' , 'FINTA CANDELA 2,5x25 - 123' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13036' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13036' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11624' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11624' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11625' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11625' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '12.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11623' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11623' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11626' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11626' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18349' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18349' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '13954' , 'CALICE IN SILVERPLATE' , '1' , '-1' , '1' , '310.0000' , '254.09836065574' , '22' , '0' , '310.00' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13954' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13954' , '' , '1' ) 13/10/2022 03:55:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65799' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 13/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18237' AND id_supplier = '' 13/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18237' , '' , '1' ) 13/10/2022 03:55: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 ( '65799' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 13/10/2022 03:55:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '' 13/10/2022 03:55:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '' , '1' ) 13/10/2022 03:55: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 ( '65799' , '545' , 'AMPOLLE STYLE CON RICAMBIO - CC100 - 1507' , '1' , '-1' , '1' , '76.5000' , '62.704918032787' , '22' , '0' , '76.50' ) 13/10/2022 03:55:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '545' AND id_supplier = '' 13/10/2022 03:55:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '545' , '' , '1' ) 13/10/2022 03:55: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 ( '65799' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 13/10/2022 03:55:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19848' AND id_supplier = '' 13/10/2022 03:55:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19848' , '' , '1' ) 13/10/2022 04:03:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3040' AND id_document != '66343' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 04:03:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3040', document_date = '2022-10-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '66343' 13/10/2022 04:03:17 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 = '66343' 13/10/2022 04:03:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '66343' 13/10/2022 04:03:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66343' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '1' , '-1' , '1' , '225' , '184.4262295082' , '22' , '0' , '225.00' ) 13/10/2022 04:03:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '' 13/10/2022 04:03:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '' , '1' ) 13/10/2022 04:03:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66343' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 13/10/2022 04:03:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20118' AND id_supplier = '' 13/10/2022 04:03:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20118' , '' , '1' ) 13/10/2022 04:35:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 04:35:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3041' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 13/10/2022 04:35:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66344' 13/10/2022 04:35:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '66344' 13/10/2022 04:35:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66344' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/10/2022 04:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/10/2022 04:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/10/2022 04:36:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 04:36: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' , '3042' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 13/10/2022 04:36: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 = '66345' 13/10/2022 04:36:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '66345' 13/10/2022 04:36: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 ( '66345' , '16147' , 'SCOPRIAMO LA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 13/10/2022 04:36:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16147' AND id_supplier = '' 13/10/2022 04:36:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16147' , '' , '1' ) 13/10/2022 05:12:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2856' AND id_document != '61971' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 13/10/2022 05:12:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2856', document_date = '2022-09-28', 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 = '55.90', price_tax_excluded = '55.46', date_upd = NOW() WHERE id_document = '61971' 13/10/2022 05:12:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61971' 13/10/2022 05:12:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '61971' 13/10/2022 05:12:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61971' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 13/10/2022 05:12:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/10/2022 05:12:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/10/2022 05:12:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61971' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 13/10/2022 05:12:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/10/2022 05:12:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/10/2022 05:12:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61971' , '14259' , 'ARCA DI NOE - GIOCO' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 13/10/2022 05:12:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14259' AND id_supplier = '' 13/10/2022 05:12:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14259' , '' , '1' ) 13/10/2022 05:19:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '116' AND id_document != '61820' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-15') 13/10/2022 05:19:51 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '116', document_date = '2022-09-15', document_letter = '', id_customer = '3903', id_supplier = '', id_address = '4674893', address1 = 'VIA MONFALCONE 25 20092 CINISELLO BALSAMO', address2 = '', note = '', price_shipping = '5.47', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '53.50', price_tax_excluded = '53.50', date_upd = NOW() WHERE id_document = '61820' 13/10/2022 05:19:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61820' 13/10/2022 05:19:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '61820' 13/10/2022 05:19:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61820' , '5457' , 'IO SONO CON VOI 1 PARTE' , '19' , '-19' , '4' , '2.50' , '2.5' , '0' , '5' , '45.13' ) 13/10/2022 05:19:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/10/2022 05:19:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/10/2022 05:19:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61820' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/10/2022 05:19:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 05:19:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 05:23:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '61964' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 13/10/2022 05:23:50 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '127', document_date = '2022-09-27', document_letter = '', id_customer = '284', id_supplier = '', id_address = '4671723', address1 = 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '395.25', price_tax_excluded = '395.25', date_upd = NOW() WHERE id_document = '61964' 13/10/2022 05:23:50 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 = '61964' 13/10/2022 05:23:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '61964' 13/10/2022 05:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '15' , '17.00' ) 13/10/2022 05:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/10/2022 05:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/10/2022 05:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '5457' , 'IO SONO CON VOI 1 PARTE' , '80' , '-80' , '4' , '2.5000' , '2.5' , '0' , '15' , '170.00' ) 13/10/2022 05:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/10/2022 05:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/10/2022 05:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '11192' , 'VENITE CON ME 2 PARTE' , '80' , '-80' , '4' , '2.5000' , '2.5' , '0' , '15' , '170.00' ) 13/10/2022 05:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 13/10/2022 05:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 13/10/2022 05:23:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '5' , '-5' , '4' , '9.0000' , '9' , '0' , '15' , '38.25' ) 13/10/2022 05:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14223' AND id_supplier = '' 13/10/2022 05:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14223' , '' , '1' ) 13/10/2022 05:25:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '61968' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 13/10/2022 05:25:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '129', document_date = '2022-09-28', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 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 = '291.38', price_tax_excluded = '291.38', date_upd = NOW() WHERE id_document = '61968' 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61968' 13/10/2022 05:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '61968' 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '-13' , '4' , '2.5000' , '2.5' , '0' , '15' , '27.63' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '-6' , '4' , '2.5000' , '2.5' , '0' , '15' , '12.75' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11191' , 'VENITE CON ME 1 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11192' , 'VENITE CON ME 2 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '15020' , 'PREGARE OGNI GIORNO' , '9' , '-9' , '4' , '1.0000' , '1' , '0' , '15' , '7.65' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/10/2022 05:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/10/2022 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 13/10/2022 05:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/10/2022 05:25:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '9' , '-9' , '4' , '5.5000' , '5.5' , '0' , '10' , '44.55' ) 13/10/2022 05:25:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 13/10/2022 05:25:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5444' , 'IO SONO CON VOI - CAT.' , '10' , '-10' , '4' , '5.5000' , '5.5' , '0' , '10' , '49.50' ) 13/10/2022 05:25:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 13/10/2022 05:25:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '10' , '24.75' ) 13/10/2022 05:25:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 13/10/2022 05:25:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '15' , '21.25' ) 13/10/2022 05:25:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 13/10/2022 05:25:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '3.4000' , '3.4' , '0' , '0' , '6.80' ) 13/10/2022 05:25:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 13/10/2022 05:25:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 13/10/2022 05:27:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '62494' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 13/10/2022 05:27:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '132', document_date = '2022-09-28', document_letter = '', id_customer = '3912', id_supplier = '', id_address = '4675033', address1 = 'SALITA SAN GIUSEPPE 14 98055 LIPARI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '222.15', price_tax_excluded = '222.15', date_upd = NOW() WHERE id_document = '62494' 13/10/2022 05:27:26 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 = '62494' 13/10/2022 05:27:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '62494' 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '4154' , 'FESTA DEL PERDONO' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.4' , '3.4' , '0' , '0' , '3.40' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '17257' , 'IO TI BATTEZZO ' , '20' , '-20' , '4' , '1.8000' , '1.8' , '0' , '15' , '30.60' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '15020' , 'PREGARE OGNI GIORNO' , '25' , '-25' , '4' , '1.0000' , '1' , '0' , '5' , '23.75' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/10/2022 05:27:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9000' , '2.9' , '' , '0' , '2.90' ) 13/10/2022 05:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 05:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 05:29:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '62500' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-29') 13/10/2022 05:29:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '134', document_date = '2022-09-29', document_letter = '', id_customer = '3380', id_supplier = '', id_address = '4671703', address1 = 'P. ZZA SAN PIETRO, SNC 00039 ZAGAROLO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '388.63', price_tax_excluded = '388.63', date_upd = NOW() WHERE id_document = '62500' 13/10/2022 05:29:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62500' 13/10/2022 05:29:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '62500' 13/10/2022 05:29:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 13/10/2022 05:29:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 13/10/2022 05:29:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 13/10/2022 05:29:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '75' , '-75' , '4' , '3.5000' , '3.5' , '0' , '15' , '223.13' ) 13/10/2022 05:29:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '19693' , 'CALENDARIO LITURGICO 2023' , '10' , '-10' , '4' , '0.5000' , '0.5' , '0' , '5' , '4.75' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18527' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18527' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '15' , '5.95' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '17257' , 'IO TI BATTEZZO ' , '10' , '-10' , '4' , '1.8000' , '1.8' , '0' , '15' , '15.30' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '1' , '-1' , '4' , '2.1000' , '2.1' , '0' , '15' , '1.79' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2869' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2869' , '' , '1' ) 13/10/2022 05:29:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62500' , '5457' , 'IO SONO CON VOI 1 PARTE' , '12' , '-12' , '4' , '2.50' , '2.5' , '0' , '15' , '25.50' ) 13/10/2022 05:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/10/2022 05:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/10/2022 05:30:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '136' AND id_document != '63026' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-29') 13/10/2022 05:30:38 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '136', document_date = '2022-09-29', document_letter = '', id_customer = '3916', id_supplier = '', id_address = '4675163', address1 = 'PIAZZA SAN ROCCO 2 34070 VILLESSE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '75.10', price_tax_excluded = '75.10', date_upd = NOW() WHERE id_document = '63026' 13/10/2022 05:30: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 = '63026' 13/10/2022 05:30:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '63026' 13/10/2022 05:30: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 ( '63026' , '17257' , 'IO TI BATTEZZO ' , '20' , '-20' , '4' , '1.8000' , '1.8' , '0' , '5' , '34.20' ) 13/10/2022 05:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 13/10/2022 05:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 13/10/2022 05:30: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 ( '63026' , '15020' , 'PREGARE OGNI GIORNO' , '40' , '-40' , '4' , '1.0000' , '1' , '0' , '5' , '38.00' ) 13/10/2022 05:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/10/2022 05:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/10/2022 05:30: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 ( '63026' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9000' , '2.9' , '' , '0' , '2.90' ) 13/10/2022 05:30:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/10/2022 05:30:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/10/2022 05:35:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '61147' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-03') 13/10/2022 05:35:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '111', document_date = '2022-09-03', document_letter = '', id_customer = '3899', id_supplier = '', id_address = '4674768', address1 = 'VIA CARRACCIA 50 01030 CIVITA CASTELLANA', address2 = '', note = '', price_shipping = '2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '61147' 13/10/2022 05:35:08 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 = '61147' 13/10/2022 05:35:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '61147' 13/10/2022 05:35: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 ( '61147' , '5457' , 'IO SONO CON VOI 1 PARTE' , '8' , '-8' , '4' , '2.5000' , '2.5' , '0' , '5' , '19.00' ) 13/10/2022 05:35:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/10/2022 05:35:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/10/2022 05:35: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 ( '61147' , '5458' , 'IO SONO CON VOI 2 PARTE' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '5' , '19.00' ) 13/10/2022 05:35:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 13/10/2022 05:35:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 13/10/2022 06:01:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 13/10/2022 06:01:58 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' , '3043' , '2022-10-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '43.27' , NOW() , NOW() ) 13/10/2022 06:01:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66346' 13/10/2022 06:01:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '66346' 13/10/2022 06:01:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66346' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 13/10/2022 06:01:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/10/2022 06:01:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/10/2022 06:01:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66346' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/10/2022 06:01:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/10/2022 06:01:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' )