09/06/2022 08:32:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810106693' AND id_product != '1905' AND ean13 != '' 09/06/2022 08:32:02 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788810106693', date_upd = NOW() WHERE id_product = '1905' 09/06/2022 08:32:02 am >> UPDATE ps_product_lang SET name = 'CENTESIMUS ANNUS - GIOV. PAOLO II', description = '' WHERE id_product = '1905' 09/06/2022 08:32:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5000' WHERE id_product = '1905' 09/06/2022 08:32:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1905' 09/06/2022 08:32:03 am >> DELETE FROM ps_specific_price WHERE id_product = '1905' 09/06/2022 08:36:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '282' 09/06/2022 08:36:48 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '282' , '10' , '210' , 'PARR. S. ANDREA AP.' , 'GIORDANO' , 'DON GIUSEPPE ' , 'VIA S. ANDREA, 6' , '' , '84081' , 'BARONISSI' , '' , '' , '' , '' , '09633951000' , NOW() , NOW() ) 09/06/2022 08:36:48 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '282' 09/06/2022 08:37:03 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '58543' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-01') 09/06/2022 08:37:03 am >> UPDATE ps_document SET id_document_type = '21', document_num = '92', document_date = '2022-06-01', document_letter = '', id_customer = '282', id_supplier = '', id_address = '4674402', address1 = 'VIA S. ANDREA, 6 84081 BARONISSI', 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 = '27.20', price_tax_excluded = '27.20', date_upd = NOW() WHERE id_document = '58543' 09/06/2022 08:37:03 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 = '58543' 09/06/2022 08:37:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58543' 09/06/2022 08:37:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58543' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '20' , '-20' , '4' , '1.6000' , '1.6' , '0' , '15' , '27.20' ) 09/06/2022 08:37:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 09/06/2022 08:37:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 09/06/2022 08:56:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 08:56:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1841' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '8.90' , NOW() , NOW() ) 09/06/2022 08:56:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58673' 09/06/2022 08:56:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58673' 09/06/2022 08:56:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58673' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.9' , '8.9' , '0' , '0' , '8.90' ) 09/06/2022 08:56:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 08:56:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 09:07:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 09:07:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1842' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '14.28' , NOW() , NOW() ) 09/06/2022 09:07:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58674' 09/06/2022 09:07:40 am >> DELETE FROM ps_document_detail WHERE id_document = '58674' 09/06/2022 09:07:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58674' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '14' , '-14' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '14.00' ) 09/06/2022 09:07:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 09/06/2022 09:07:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 09/06/2022 09:07:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58674' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 09/06/2022 09:07:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 09:07:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 09:17:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/06/2022 09:17:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19636' , '1' , '' , 'nuovo-prodotto' ) 09/06/2022 09:17:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19636' , '1' , '1' , '2' , NOW() , NOW() ) 09/06/2022 09:17:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19636' , '0' , '1' , '0' , '0' ) 09/06/2022 09:18:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228528' AND id_product != '19636' AND ean13 != '' 09/06/2022 09:18:24 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788892228528', date_upd = NOW() WHERE id_product = '19636' 09/06/2022 09:18:24 am >> UPDATE ps_product_lang SET name = 'preghiamo con i salmi ', description = '' WHERE id_product = '19636' 09/06/2022 09:18:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.9' WHERE id_product = '19636' 09/06/2022 09:18:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19636' 09/06/2022 09:18:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19636' 09/06/2022 09:18:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228528' AND id_product != '19636' AND ean13 != '' 09/06/2022 09:18:41 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788892228528', date_upd = NOW() WHERE id_product = '19636' 09/06/2022 09:18:41 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON I SALMI', description = '' WHERE id_product = '19636' 09/06/2022 09:18:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.9000' WHERE id_product = '19636' 09/06/2022 09:18:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19636' 09/06/2022 09:18:41 am >> DELETE FROM ps_specific_price WHERE id_product = '19636' 09/06/2022 09:19:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '601758' , '2022-06-07' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.1' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '175.95' , '175.95' , NOW() , NOW() ) 09/06/2022 09:19:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58675' 09/06/2022 09:19:04 am >> DELETE FROM ps_document_detail WHERE id_document = '58675' 09/06/2022 09:19:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '24' , '24' , '4' , '1.90' , '1.9' , '0' , '35' , '29.6400' ) 09/06/2022 09:19:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '2' , '2' , '4' , '1.90' , '1.9' , '0' , '100' , '0.0000' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '7302' , 'OSSESSIONI - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7302' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7302' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17554' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17554' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '17553' , 'GRANDI SANTE AMICHE DI GESU' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17553' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17553' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '10430' , 'TABOR' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '30' , '12.5300' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '19608' , 'GIOPRONET - AAVV' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19608' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19608' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '19613' , 'AMICI CON LAUREOLA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19613' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19613' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '12' , '12' , '4' , '3.90' , '3.9' , '0' , '33' , '31.3560' ) 09/06/2022 09:19:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '7' 09/06/2022 09:19:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '7' , '1' ) 09/06/2022 09:19:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 09/06/2022 09:19:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '7' 09/06/2022 09:19:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '7' , '1' ) 09/06/2022 09:19:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58675' , '19636' , 'PREGHIAMO CON I SALMI' , '10' , '10' , '4' , '5.90' , '5.9' , '0' , '33' , '39.5300' ) 09/06/2022 09:19:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19636' AND id_supplier = '7' 09/06/2022 09:19:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19636' , '7' , '1' ) 09/06/2022 09:21:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 09:21:29 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' , '1843' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 09/06/2022 09:21:29 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 = '58676' 09/06/2022 09:21:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58676' 09/06/2022 09:21:29 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 ( '58676' , '9539' , 'SANTANTONIO DA PADOVA - 41' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 09/06/2022 09:21:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '9539' AND id_supplier = '' 09/06/2022 09:21:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9539' , '' , '1' ) 09/06/2022 09:26:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '58602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 09/06/2022 09:26:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1783', document_date = '2022-06-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '939.42', price_tax_excluded = '925.35', date_upd = NOW() WHERE id_document = '58602' 09/06/2022 09:26:25 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 = '58602' 09/06/2022 09:26:25 am >> DELETE FROM ps_document_detail WHERE id_document = '58602' 09/06/2022 09:26: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 ( '58602' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 09/06/2022 09:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 09/06/2022 09:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 09/06/2022 09:26: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 ( '58602' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '49' , '-49' , '4' , '18.5000' , '18.5' , '0' , '5' , '861.42' ) 09/06/2022 09:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 09/06/2022 09:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 09/06/2022 09:26: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 ( '58602' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 09/06/2022 09:26:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 09/06/2022 09:26:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 09/06/2022 10:05:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1047' AND id_document != '54648' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-08') 09/06/2022 10:05:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1047', document_date = '2022-04-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 = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '54648' 09/06/2022 10:05: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 = '54648' 09/06/2022 10:05:18 am >> DELETE FROM ps_document_detail WHERE id_document = '54648' 09/06/2022 10:05: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 ( '54648' , '9331' , 'SACRO CUORE CM 20 - 023 SH20/A' , '1' , '-1' , '1' , '23.50' , '19.262295081967' , '22' , '0' , '23.50' ) 09/06/2022 10:05:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '9331' AND id_supplier = '' 09/06/2022 10:05:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9331' , '' , '1' ) 09/06/2022 10:05: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 ( '54648' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 09/06/2022 10:05:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7940' AND id_supplier = '' 09/06/2022 10:05:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7940' , '' , '1' ) 09/06/2022 11:02:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:02:38 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' , '1844' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.20' , '19.84' , NOW() , NOW() ) 09/06/2022 11:02:38 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 = '58677' 09/06/2022 11:02:38 am >> DELETE FROM ps_document_detail WHERE id_document = '58677' 09/06/2022 11:02:38 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 ( '58677' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '11' , '-11' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '24.20' ) 09/06/2022 11:02:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18318' AND id_supplier = '' 09/06/2022 11:02:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18318' , '' , '1' ) 09/06/2022 11:30:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:30:54 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' , '1845' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '14.80' , NOW() , NOW() ) 09/06/2022 11:30:54 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 = '58678' 09/06/2022 11:30:54 am >> DELETE FROM ps_document_detail WHERE id_document = '58678' 09/06/2022 11:30: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 ( '58678' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 09/06/2022 11:30:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 09/06/2022 11:30:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 09/06/2022 11:30: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 ( '58678' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/06/2022 11:30:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 09/06/2022 11:30:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 09/06/2022 11:30: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 ( '58678' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 09/06/2022 11:30:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 09/06/2022 11:30:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 09/06/2022 11:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:35:22 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' , '1846' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 09/06/2022 11:35:22 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 = '58679' 09/06/2022 11:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '58679' 09/06/2022 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58679' , '12047' , 'MAXI CARD - M0107/K131' , '8' , '-8' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '9.60' ) 09/06/2022 11:35:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '12047' AND id_supplier = '' 09/06/2022 11:35:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12047' , '' , '1' ) 09/06/2022 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58679' , '7202' , 'ARTICOLI RELIGIOSI' , '6' , '-6' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '7.20' ) 09/06/2022 11:35:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/06/2022 11:35:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/06/2022 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58679' , '9719' , 'SCATOLINA CON PERGAMENA IN POLIMERO - COMUNIONE - 2301 ' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 09/06/2022 11:35:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '9719' AND id_supplier = '' 09/06/2022 11:35:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9719' , '' , '1' ) 09/06/2022 11:36:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:36:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1847' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '14.50' , NOW() , NOW() ) 09/06/2022 11:36:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58680' 09/06/2022 11:36:34 am >> DELETE FROM ps_document_detail WHERE id_document = '58680' 09/06/2022 11:36:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58680' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '' , '14.50' ) 09/06/2022 11:36:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '' 09/06/2022 11:36:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '' , '1' ) 09/06/2022 11:39:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:39:25 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' , '1848' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.63' , NOW() , NOW() ) 09/06/2022 11:39:25 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 = '58681' 09/06/2022 11:39:25 am >> DELETE FROM ps_document_detail WHERE id_document = '58681' 09/06/2022 11:39: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 ( '58681' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.8' , '3.8' , '0' , '0' , '3.80' ) 09/06/2022 11:39:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 11:39:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 11:39: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 ( '58681' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 09/06/2022 11:39:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 09/06/2022 11:39:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 09/06/2022 11:40:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 11:40:44 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' , '1849' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.60' , '27.54' , NOW() , NOW() ) 09/06/2022 11:40:44 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 = '58682' 09/06/2022 11:40:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58682' 09/06/2022 11:40:44 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 ( '58682' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '12' , '-12' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '33.60' ) 09/06/2022 11:40:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19315' AND id_supplier = '' 09/06/2022 11:40:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19315' , '' , '1' ) 09/06/2022 12:03:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607108' AND id_product != '19604' AND ean13 != '' 09/06/2022 12:03:34 pm >> UPDATE ps_product SET id_supplier = '79', reference = '13/6', ean13 = '9788826607108', date_upd = NOW() WHERE id_product = '19604' 09/06/2022 12:03:34 pm >> UPDATE ps_product_lang SET name = 'QUALE DIACONIA? - E. PETROLINO', description = '' WHERE id_product = '19604' 09/06/2022 12:03:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19604' 09/06/2022 12:03:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19604' 09/06/2022 12:03:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '19604' 09/06/2022 12:03:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '969' , '2022-05-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '21' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '483.45' , '483.45' , NOW() , NOW() ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58683' 09/06/2022 12:03:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58683' 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '19553' , 'UN PADRE COME CUSTODE - PAPA FRANCESCO' , '1' , '0' , '4' , '11.0000' , '11' , '0' , '45' , '6.05' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19553' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19553' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '19422' , 'TESTIMONI NON FUNZIONARI - F. BUSTILLO' , '3' , '0' , '4' , '16.0000' , '16' , '0' , '45' , '26.40' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19422' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19422' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '30' , '18.90' ) 09/06/2022 12:03:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 09/06/2022 12:03:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 09/06/2022 12:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58683' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 09/06/2022 12:03: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 ( '58683' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '16.25' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 09/06/2022 12:03: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 ( '58683' , '19604' , 'QUALE DIACONIA? - E. PETROLINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '45' , '13.7500' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19604' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19604' , '79' , '1' ) 09/06/2022 12:03: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 ( '58683' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 09/06/2022 12:03: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 ( '58683' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 09/06/2022 12:03: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 ( '58683' , '19620' , 'PRAEDICATE EVANGELIUM' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '45' , '6.60' ) 09/06/2022 12:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19620' AND id_supplier = '79' 09/06/2022 12:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19620' , '79' , '1' ) 09/06/2022 12:07:38 pm >> DELETE FROM ps_document WHERE id_document = '58525' 09/06/2022 12:07:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '58525' 09/06/2022 12:45:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G291-ANT' AND id_product != '6334' AND ean13 != '' 09/06/2022 12:45:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = 'G291-ANT', date_upd = NOW() WHERE id_product = '6334' 09/06/2022 12:45:38 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA OVALE DECORATA - S. ANTONIO - G291-D', description = '' WHERE id_product = '6334' 09/06/2022 12:45:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '6334' 09/06/2022 12:45:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '151', 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 = '6334' 09/06/2022 12:45:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '6334' 09/06/2022 02:53:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 02:53: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' , '1850' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 09/06/2022 02:53: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 = '58684' 09/06/2022 02:53:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '58684' 09/06/2022 02:53: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 ( '58684' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 09/06/2022 02:53:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 02:53:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 03:33:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 09/06/2022 03:33:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '114.50', price_tax_excluded = '114.50', date_upd = NOW() WHERE id_document = '50074' 09/06/2022 03:33:09 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 = '50074' 09/06/2022 03:33:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '50074' 09/06/2022 03:33:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 09/06/2022 03:33:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 09/06/2022 03:33:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 09/06/2022 03:33:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 09/06/2022 03:33:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 09/06/2022 03:33:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 09/06/2022 03:33:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19498' , 'VANGELI' , '1' , '-1' , '4' , '69.0000' , '69' , '0' , '0' , '69.00' ) 09/06/2022 03:33:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19498' AND id_supplier = '' 09/06/2022 03:33:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19498' , '' , '1' ) 09/06/2022 03:33:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 09/06/2022 03:33:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 09/06/2022 03:33:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 09/06/2022 03:33:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 09/06/2022 03:33:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 09/06/2022 03:33:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 09/06/2022 03:33:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19630' , 'bernardette - a. maggi' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 09/06/2022 03:33:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19630' AND id_supplier = '' 09/06/2022 03:33:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19630' , '' , '1' ) 09/06/2022 03:33:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19636' , 'PREGHIAMO CON I SALMI' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '0' , '5.90' ) 09/06/2022 03:33:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19636' AND id_supplier = '' 09/06/2022 03:33:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19636' , '' , '1' ) 09/06/2022 04:20:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 04:20:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1851' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '249.58' , NOW() , NOW() ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58685' 09/06/2022 04:20:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58685' 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '12270' , 'NUOVO ABC DEL CATECHISTA' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12270' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12270' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '16019' , 'MARTA, MARIA E LAZZARO - L.M. EPICOCO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14163' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14163' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 09/06/2022 04:20:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58685' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '3.5' , '3.5' , '0' , '0' , '35.00' ) 09/06/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 04:20:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 04:20: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 ( '58685' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.12' , '13.213114754098' , '22' , '0' , '16.12' ) 09/06/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/06/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/06/2022 05:04:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:04:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '99' , '2022-06-09' , '' , '2332' , '0' , '4670946' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.13' , '104.13' , NOW() , NOW() ) 09/06/2022 05:04: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 = '58686' 09/06/2022 05:04:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58686' 09/06/2022 05:04: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 ( '58686' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 09/06/2022 05:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:06:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1852' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '50.16' , NOW() , NOW() ) 09/06/2022 05:06: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 = '58687' 09/06/2022 05:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58687' 09/06/2022 05:06: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 ( '58687' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '70' , '-70' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '35.00' ) 09/06/2022 05:06:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 09/06/2022 05:06:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 09/06/2022 05:06: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 ( '58687' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 09/06/2022 05:06:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/06/2022 05:06:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/06/2022 05:06: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 ( '58687' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 09/06/2022 05:06:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/06/2022 05:06:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/06/2022 05:14:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:14: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' , '1853' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.73' , '52.73' , NOW() , NOW() ) 09/06/2022 05:14: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 = '58688' 09/06/2022 05:14:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58688' 09/06/2022 05:14: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 ( '58688' , '11100' , 'VANGELO E ATTI DEGLI APOSTOLI - CARATTERI GRANDI' , '2' , '-2' , '4' , '26.00' , '26' , '0' , '5' , '49.40' ) 09/06/2022 05:14:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11100' AND id_supplier = '' 09/06/2022 05:14:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11100' , '' , '1' ) 09/06/2022 05:14: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 ( '58688' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 09/06/2022 05:14:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '' 09/06/2022 05:14:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '' , '1' ) 09/06/2022 05:28:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:28:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1854' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 09/06/2022 05:28: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 = '58689' 09/06/2022 05:28:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58689' 09/06/2022 05:28: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 ( '58689' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 09/06/2022 05:28:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 09/06/2022 05:28:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 09/06/2022 05:28: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 ( '58689' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 09/06/2022 05:28:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 09/06/2022 05:28:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 09/06/2022 05:29:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:29: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' , '1855' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 09/06/2022 05:29: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 = '58690' 09/06/2022 05:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58690' 09/06/2022 05:29: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 ( '58690' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 09/06/2022 05:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 09/06/2022 05:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 09/06/2022 05:29: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 ( '58690' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/06/2022 05:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 09/06/2022 05:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 09/06/2022 05:29:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 05:29:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1856' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.13' , NOW() , NOW() ) 09/06/2022 05:29:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58691' 09/06/2022 05:29:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58691' 09/06/2022 05:29:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58691' , '19042' , 'HA VINTO IL TUO AMORE - SPARTITO' , '1' , '-1' , '3' , '10.00' , '9.6153846153846' , '4' , '5' , '9.50' ) 09/06/2022 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19042' AND id_supplier = '' 09/06/2022 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19042' , '' , '1' ) 09/06/2022 06:02:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 06:02:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '44/A' , '2022-06-09' , 'A' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 09/06/2022 06:02:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58692' 09/06/2022 06:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58692' 09/06/2022 06:22:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1855' AND id_document != '58690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 06:22:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1855', document_date = '2022-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '58690' 09/06/2022 06:22: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 = '58690' 09/06/2022 06:22:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58690' 09/06/2022 06:22: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 ( '58690' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 09/06/2022 06:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 09/06/2022 06:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 09/06/2022 06:22: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 ( '58690' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 09/06/2022 06:22:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 09/06/2022 06:22:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 09/06/2022 06:33:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 09/06/2022 06:33:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1857' , '2022-06-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 09/06/2022 06:33:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58693' 09/06/2022 06:33:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '58693' 09/06/2022 06:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58693' , '7302' , 'OSSESSIONI - V. M. FERNANDEZ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 09/06/2022 06:33:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7302' AND id_supplier = '' 09/06/2022 06:33:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7302' , '' , '1' )