29/11/2022 09:26:54 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'GZaQcM0I9TWUgGWz' , NOW() , NOW() ) 29/11/2022 09:26:54 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7016' , '1' ) 29/11/2022 09:26:54 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7016' , '2' ) 29/11/2022 09:26:54 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7016' , '3' ) 29/11/2022 09:28:34 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7016' 29/11/2022 09:28:34 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 ( '7016' , '10' , '125' , 'PARROCCHIA SANTA MARIA REGINA DELLA PACE' , 'BRICCHI' , 'DON ERRICO' , 'PIAZZA SANTA MARIA 2' , '' , '60027' , 'OSIMO' , '' , '' , '3398333425' , '' , '93000760426' , NOW() , NOW() ) 29/11/2022 09:28:34 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7016' 29/11/2022 09:29:56 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7016' 29/11/2022 09:29:56 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 ( '7016' , '10' , '125' , 'PARROCCHIA SANTA MARIA REGINA DELLA PACE' , 'BRICCHI' , 'DON ERRICO' , 'PIAZZA SANTA MARIA 2' , '' , '60027' , 'OSIMO' , '' , '' , '3398333425' , '' , '93000760426' , NOW() , NOW() ) 29/11/2022 09:29:56 am >> UPDATE ps_customer SET email = 'stazioneabadia@diocesi.ancona.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7016' 29/11/2022 09:30:08 am >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/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 ( '21' , '128' , '2022-11-29' , '' , '7016' , '0' , '102683559' , 'PIAZZA SANTA MARIA 2 60027 OSIMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '323.00' , '323.00' , NOW() , NOW() ) 29/11/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 = '8975' 29/11/2022 09:30:08 am >> DELETE FROM ps_document_detail WHERE id_document = '8975' 29/11/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 ( '8975' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '40' , '-40' , '4' , '2.00' , '2' , '0' , '15' , '68.00' ) 29/11/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 ( '8975' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '10' , '-10' , '4' , '30.00' , '30' , '0' , '15' , '255.00' ) 29/11/2022 09:30:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7016' 29/11/2022 09:30:33 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 ( '7016' , '10' , '125' , 'PARROCCHIA SANTA MARIA REGINA DELLA PACE' , 'BRICCHI' , 'DON ERRICO' , 'PIAZZA SANTA MARIA 2' , '' , '60027' , 'OSIMO' , '' , '' , '3398333425' , '' , '93000760426' , NOW() , NOW() ) 29/11/2022 09:30:33 am >> UPDATE ps_customer SET email = 'stazioneabadia@diocesi.ancona.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7016' 29/11/2022 09:34:47 am >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '8975' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 09:34:47 am >> UPDATE ps_document SET id_document_type = '21', document_num = '128', document_date = '2022-11-29', document_letter = '', id_customer = '7016', id_supplier = '', id_address = '102683559', address1 = 'PIAZZA SANTA MARIA 2 60027 OSIMO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '323.00', price_tax_excluded = '323.00', date_upd = NOW() WHERE id_document = '8975' 29/11/2022 09:34:47 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 = '8975' 29/11/2022 09:34:47 am >> DELETE FROM ps_document_detail WHERE id_document = '8975' 29/11/2022 09:34:47 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 ( '8975' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '40' , '-40' , '4' , '2.0000' , '2' , '0' , '15' , '68.00' ) 29/11/2022 09:34:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '57' AND id_supplier = '' 29/11/2022 09:34:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '57' , '' , '1' ) 29/11/2022 09:34:47 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 ( '8975' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '10' , '-10' , '4' , '30.0000' , '30' , '0' , '15' , '255.00' ) 29/11/2022 09:34:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '58' AND id_supplier = '' 29/11/2022 09:34:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '58' , '' , '1' ) 29/11/2022 09:53:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001169' AND id_product != '15356' AND ean13 != '' 29/11/2022 09:53:43 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001169', date_upd = NOW() WHERE id_product = '15356' 29/11/2022 09:53:43 am >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO DORATE - 1511', description = '' WHERE id_product = '15356' 29/11/2022 09:53:43 am >> UPDATE ps_product SET wholesale_price = '35.15', on_sale = '0', price = '77.8688524590164' WHERE id_product = '15356' 29/11/2022 09:53:43 am >> UPDATE ps_product_shop SET wholesale_price = '35.15', price = '77.8688524590164', 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 = '15356' 29/11/2022 09:53:43 am >> DELETE FROM ps_specific_price WHERE id_product = '15356' 29/11/2022 10:09:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000609' AND id_product != '542' AND ean13 != '' 29/11/2022 10:09:42 am >> UPDATE ps_product SET id_supplier = '12', reference = '2014', ean13 = '000609', date_upd = NOW() WHERE id_product = '542' 29/11/2022 10:09:42 am >> UPDATE ps_product_lang SET name = 'AMPOLLE IN VASSOIO OTTONE - 523 ', description = '' WHERE id_product = '542' 29/11/2022 10:09:42 am >> UPDATE ps_product SET wholesale_price = '31.83', on_sale = '0', price = '73.77049180327869' WHERE id_product = '542' 29/11/2022 10:09:42 am >> UPDATE ps_product_shop SET wholesale_price = '31.83', price = '73.77049180327869', 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 = '542' 29/11/2022 10:09:42 am >> DELETE FROM ps_specific_price WHERE id_product = '542' 29/11/2022 10:10:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000609' AND id_product != '542' AND ean13 != '' 29/11/2022 10:10:28 am >> UPDATE ps_product SET id_supplier = '12', reference = '2014', ean13 = '000609', date_upd = NOW() WHERE id_product = '542' 29/11/2022 10:10:28 am >> UPDATE ps_product_lang SET name = 'AMPOLLE IN VASSOIO OTTONE - 523 ', description = '' WHERE id_product = '542' 29/11/2022 10:10:28 am >> UPDATE ps_product SET wholesale_price = '31.83', on_sale = '0', price = '73.36065573770492' WHERE id_product = '542' 29/11/2022 10:10:28 am >> UPDATE ps_product_shop SET wholesale_price = '31.83', price = '73.36065573770492', 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 = '542' 29/11/2022 10:10:28 am >> DELETE FROM ps_specific_price WHERE id_product = '542' 29/11/2022 10:14:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000675' AND id_product != '12582' AND ean13 != '' 29/11/2022 10:14:51 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000675', date_upd = NOW() WHERE id_product = '12582' 29/11/2022 10:14:51 am >> UPDATE ps_product_lang SET name = 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32', description = '' WHERE id_product = '12582' 29/11/2022 10:14:51 am >> UPDATE ps_product SET wholesale_price = '4.99', on_sale = '0', price = '12.295081967213115' WHERE id_product = '12582' 29/11/2022 10:14:51 am >> UPDATE ps_product_shop SET wholesale_price = '4.99', price = '12.295081967213115', 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 = '12582' 29/11/2022 10:14:51 am >> DELETE FROM ps_specific_price WHERE id_product = '12582' 29/11/2022 10:16:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001467' AND id_product != '16765' AND ean13 != '' 29/11/2022 10:16:28 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001467', date_upd = NOW() WHERE id_product = '16765' 29/11/2022 10:16:28 am >> UPDATE ps_product_lang SET name = 'MELOGRANO CON BASE OTTONE DORATO - 1021/B', description = '' WHERE id_product = '16765' 29/11/2022 10:16:28 am >> UPDATE ps_product SET wholesale_price = '16.63', on_sale = '0', price = '37.704918032786885' WHERE id_product = '16765' 29/11/2022 10:16:28 am >> UPDATE ps_product_shop SET wholesale_price = '16.63', price = '37.704918032786885', 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 = '16765' 29/11/2022 10:16:28 am >> DELETE FROM ps_specific_price WHERE id_product = '16765' 29/11/2022 10:29:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3801' , '2022-11-25' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '352.43' , '288.88' , NOW() , NOW() ) 29/11/2022 10:29:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75445' 29/11/2022 10:29:05 am >> DELETE FROM ps_document_detail WHERE id_document = '75445' 29/11/2022 10:29: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 ( '75445' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '40.5' , '33.196721311475' , '22' , '5' , '46.9395' ) 29/11/2022 10:29:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '12' 29/11/2022 10:29:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '3' , '3' , '1' , '13' , '10.655737704918' , '22' , '5' , '45.2010' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '1' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '7.5335' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16409' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16409' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '2' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '15.0670' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '1' , '1' , '51' , '41.803278688525' , '22' , '5' , '59.1090' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '540' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '540' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '542' , 'AMPOLLE IN VASSOIO OTTONE - 523 ' , '2' , '2' , '1' , '37' , '30.327868852459' , '22' , '5' , '85.7660' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '542' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '542' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '1' , '1' , '19' , '15.573770491803' , '22' , '5' , '22.0210' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16939' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16939' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '12582' , 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32' , '2' , '2' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '15.0670' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '12582' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12582' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '1' , '1' , '1' , '19' , '15.573770491803' , '22' , '5' , '22.0210' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '16765' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16765' , '12' , '1' ) 29/11/2022 10:29: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 ( '75445' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '1' , '1' , '17.5' , '14.344262295082' , '22' , '5' , '20.2825' ) 29/11/2022 10:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 29/11/2022 10:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 29/11/2022 10:33:08 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '61878' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 29/11/2022 10:33:08 am >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2022-09-20', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.80', price_tax_excluded = '77.09', date_upd = NOW() WHERE id_document = '61878' 29/11/2022 10:33: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 = '61878' 29/11/2022 10:33:08 am >> DELETE FROM ps_document_detail WHERE id_document = '61878' 29/11/2022 10:33: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 ( '61878' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '8.40' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '6019' , 'LUMINO ROSSO - 10B' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '0' , 'ritira diacono' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 29/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/11/2022 10:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/11/2022 10:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/11/2022 10:33:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 29/11/2022 10:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/11/2022 10:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/11/2022 10:33:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 29/11/2022 10:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/11/2022 10:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/11/2022 10:33:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '0' , 'ritira diacono lobello e paga lui' , '1' , '-1' , '3' , '0.0000' , '0' , '4' , '0' , '0.00' ) 29/11/2022 10:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/11/2022 10:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/11/2022 10:33:25 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '61878' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 29/11/2022 10:33:25 am >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2022-09-20', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.80', price_tax_excluded = '77.09', date_upd = NOW() WHERE id_document = '61878' 29/11/2022 10:33: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 = '61878' 29/11/2022 10:33:25 am >> DELETE FROM ps_document_detail WHERE id_document = '61878' 29/11/2022 10:33: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 ( '61878' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 29/11/2022 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 29/11/2022 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 29/11/2022 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 29/11/2022 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '8.40' ) 29/11/2022 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 29/11/2022 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 29/11/2022 10:33: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 ( '61878' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 29/11/2022 10:33:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 29/11/2022 10:33:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '6019' , 'LUMINO ROSSO - 10B' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '0' , 'ritira diacono' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/11/2022 10:33:26 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 ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 29/11/2022 10:33:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/11/2022 10:33:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/11/2022 10:34:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 10:34: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' , '3654' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.75' , NOW() , NOW() ) 29/11/2022 10:34: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 = '75446' 29/11/2022 10:34:11 am >> DELETE FROM ps_document_detail WHERE id_document = '75446' 29/11/2022 10:34: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 ( '75446' , '9711' , 'SCATOLA DORATA IHS - OGGETTI' , '1' , '-1' , '1' , '44' , '36.065573770492' , '22' , '0' , '44.00' ) 29/11/2022 10:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '9711' AND id_supplier = '' 29/11/2022 10:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9711' , '' , '1' ) 29/11/2022 10:34: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 ( '75446' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/11/2022 10:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 29/11/2022 10:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 29/11/2022 10:34: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 ( '75446' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 29/11/2022 10:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/11/2022 10:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/11/2022 10:57:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '74854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 29/11/2022 10:57:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3595', document_date = '2022-11-24', 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 = '12.20', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '74854' 29/11/2022 10:57:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74854' 29/11/2022 10:57:31 am >> DELETE FROM ps_document_detail WHERE id_document = '74854' 29/11/2022 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74854' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '2.20' ) 29/11/2022 10:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 10:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74854' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '28' , '-28' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '5.60' ) 29/11/2022 10:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 29/11/2022 10:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 29/11/2022 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74854' , '16989' , 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA' , '2' , '-2' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '4.20' ) 29/11/2022 10:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '16989' AND id_supplier = '' 29/11/2022 10:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16989' , '' , '1' ) 29/11/2022 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74854' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 29/11/2022 10:57:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '' 29/11/2022 10:57:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '' , '1' ) 29/11/2022 11:00:06 am >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 11:00:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '129' , '2022-11-29' , '' , '3442' , '0' , '4670084' , 'VIA DON MARCHISONE 8 10070 ROBASSOMERO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 29/11/2022 11:00:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8976' 29/11/2022 11:00:07 am >> DELETE FROM ps_document_detail WHERE id_document = '8976' 29/11/2022 11:00:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8976' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 29/11/2022 11:03:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'C102' AND id_product != '15339' AND ean13 != '' 29/11/2022 11:03:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'C102', date_upd = NOW() WHERE id_product = '15339' 29/11/2022 11:03:50 am >> UPDATE ps_product_lang SET name = 'CALICE IN OTTONE DORATO CON UVA', description = '' WHERE id_product = '15339' 29/11/2022 11:03:50 am >> UPDATE ps_product SET wholesale_price = '89.10', on_sale = '0', price = '196.7213' WHERE id_product = '15339' 29/11/2022 11:03:50 am >> UPDATE ps_product_shop SET wholesale_price = '89.10', price = '196.7213', id_tax_rules_group = '1', id_category_default = '184', 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 = '15339' 29/11/2022 11:03:50 am >> DELETE FROM ps_specific_price WHERE id_product = '15339' 29/11/2022 11:20:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 11:20:47 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' , '3655' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.74' , NOW() , NOW() ) 29/11/2022 11:20:47 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 = '75447' 29/11/2022 11:20:47 am >> DELETE FROM ps_document_detail WHERE id_document = '75447' 29/11/2022 11:20:47 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 ( '75447' , '4953' , 'IMMACOLATA CONCEZIONE - 151 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/11/2022 11:20:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4953' AND id_supplier = '' 29/11/2022 11:20:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4953' , '' , '1' ) 29/11/2022 11:20:47 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 ( '75447' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 29/11/2022 11:20:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '' 29/11/2022 11:20:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '' , '1' ) 29/11/2022 11:23:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 11:23: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' , '3656' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '317.00' , '266.52' , NOW() , NOW() ) 29/11/2022 11:23: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 = '75448' 29/11/2022 11:23:29 am >> DELETE FROM ps_document_detail WHERE id_document = '75448' 29/11/2022 11:23: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 ( '75448' , '15339' , 'CALICE IN OTTONE DORATO CON UVA' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 29/11/2022 11:23:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '15339' AND id_supplier = '' 29/11/2022 11:23:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15339' , '' , '1' ) 29/11/2022 11:23: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 ( '75448' , '13289' , 'NATIVITA 6 PZ CON LED CM 22,5' , '1' , '-1' , '1' , '79.95' , '65.532786885246' , '22' , '0' , '79.95' ) 29/11/2022 11:23:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '13289' AND id_supplier = '' 29/11/2022 11:23:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13289' , '' , '1' ) 29/11/2022 11:23: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 ( '75448' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 29/11/2022 11:23:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '' 29/11/2022 11:23:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '' , '1' ) 29/11/2022 11:32:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 11:32: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' , '3657' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 29/11/2022 11:32: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 = '75449' 29/11/2022 11:32:44 am >> DELETE FROM ps_document_detail WHERE id_document = '75449' 29/11/2022 11:32: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 ( '75449' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 29/11/2022 11:32:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '' 29/11/2022 11:32:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '' , '1' ) 29/11/2022 11:44:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 11:44: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 ( '11' , '3658' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.90' , '35.73' , NOW() , NOW() ) 29/11/2022 11:44: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 = '75450' 29/11/2022 11:44:09 am >> DELETE FROM ps_document_detail WHERE id_document = '75450' 29/11/2022 11:44: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 ( '75450' , '19452' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 29/11/2022 11:44:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19452' AND id_supplier = '' 29/11/2022 11:44:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19452' , '' , '1' ) 29/11/2022 11:44: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 ( '75450' , '19129' , 'BRUCIAINCENSO ALADINO - ALA' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 29/11/2022 11:44:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19129' AND id_supplier = '' 29/11/2022 11:44:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19129' , '' , '1' ) 29/11/2022 11:44: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 ( '75450' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/11/2022 11:44:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 11:44:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 11:56:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000243' AND id_product != '5975' AND ean13 != '' 29/11/2022 11:56:52 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000243', date_upd = NOW() WHERE id_product = '5975' 29/11/2022 11:56:52 am >> UPDATE ps_product_lang SET name = 'LUCERNA colorata - 1491', description = '' WHERE id_product = '5975' 29/11/2022 11:56:52 am >> UPDATE ps_product SET wholesale_price = '8.55', on_sale = '0', price = '17.6230' WHERE id_product = '5975' 29/11/2022 11:56:52 am >> UPDATE ps_product_shop SET wholesale_price = '8.55', price = '17.6230', 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 = '5975' 29/11/2022 11:56:52 am >> DELETE FROM ps_specific_price WHERE id_product = '5975' 29/11/2022 11:58:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000033' AND id_product != '5976' AND ean13 != '' 29/11/2022 11:58:24 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000033', date_upd = NOW() WHERE id_product = '5976' 29/11/2022 11:58:24 am >> UPDATE ps_product_lang SET name = 'LUCERNA vetro - 1493', description = '' WHERE id_product = '5976' 29/11/2022 11:58:24 am >> UPDATE ps_product SET wholesale_price = '7.60', on_sale = '0', price = '15.98360655737705' WHERE id_product = '5976' 29/11/2022 11:58:24 am >> UPDATE ps_product_shop SET wholesale_price = '7.60', price = '15.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 = '5976' 29/11/2022 11:58:24 am >> DELETE FROM ps_specific_price WHERE id_product = '5976' 29/11/2022 12:05:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000243' AND id_product != '5975' AND ean13 != '' 29/11/2022 12:05:42 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000243', date_upd = NOW() WHERE id_product = '5975' 29/11/2022 12:05:42 pm >> UPDATE ps_product_lang SET name = 'LUCERNA COLORATA - 1491', description = '' WHERE id_product = '5975' 29/11/2022 12:05:42 pm >> UPDATE ps_product SET wholesale_price = '8.55', on_sale = '0', price = '17.6230' WHERE id_product = '5975' 29/11/2022 12:05:42 pm >> UPDATE ps_product_shop SET wholesale_price = '8.55', price = '17.6230', 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 = '5975' 29/11/2022 12:05:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '5975' 29/11/2022 12:06:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000033' AND id_product != '5976' AND ean13 != '' 29/11/2022 12:06:28 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000033', date_upd = NOW() WHERE id_product = '5976' 29/11/2022 12:06:28 pm >> UPDATE ps_product_lang SET name = 'LUCERNA VETRO - 1493', description = '' WHERE id_product = '5976' 29/11/2022 12:06:28 pm >> UPDATE ps_product SET wholesale_price = '7.60', on_sale = '0', price = '15.9836' WHERE id_product = '5976' 29/11/2022 12:06:28 pm >> UPDATE ps_product_shop SET wholesale_price = '7.60', price = '15.9836', 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 = '5976' 29/11/2022 12:06:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '5976' 29/11/2022 12:10:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001909' AND id_product != '19109' AND ean13 != '' 29/11/2022 12:10:03 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001909', date_upd = NOW() WHERE id_product = '19109' 29/11/2022 12:10:03 pm >> UPDATE ps_product_lang SET name = 'LUCERNA IN VETRO TRASPARENTE - 1492', description = '' WHERE id_product = '19109' 29/11/2022 12:10:03 pm >> UPDATE ps_product SET wholesale_price = '6.18', on_sale = '0', price = '12.9508' WHERE id_product = '19109' 29/11/2022 12:10:03 pm >> UPDATE ps_product_shop SET wholesale_price = '6.18', price = '12.9508', 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 = '19109' 29/11/2022 12:10:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19109' 29/11/2022 12:11:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000831' AND id_product != '19910' AND ean13 != '' 29/11/2022 12:11:27 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000831', date_upd = NOW() WHERE id_product = '19910' 29/11/2022 12:11:27 pm >> UPDATE ps_product_lang SET name = 'LUCERNA COLORATA - 1490/KIT', description = '' WHERE id_product = '19910' 29/11/2022 12:11:27 pm >> UPDATE ps_product SET wholesale_price = '7.13', on_sale = '0', price = '14.3443' WHERE id_product = '19910' 29/11/2022 12:11:27 pm >> UPDATE ps_product_shop SET wholesale_price = '7.13', price = '14.3443', 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 = '19910' 29/11/2022 12:11:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19910' 29/11/2022 12:21:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 12:21:17 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' , '3659' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.30' , '19.04' , NOW() , NOW() ) 29/11/2022 12:21: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 = '75451' 29/11/2022 12:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '75451' 29/11/2022 12:21: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 ( '75451' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/11/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 29/11/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 29/11/2022 12:21: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 ( '75451' , '16253' , 'ASPETTANDO NATALE' , '2' , '-2' , '4' , '7.00' , '7' , '0' , '5' , '13.30' ) 29/11/2022 12:21:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16253' AND id_supplier = '' 29/11/2022 12:21:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16253' , '' , '1' ) 29/11/2022 12:24:48 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '3801', document_date = '2022-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '11.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '463.12', price_tax_excluded = '379.61', date_upd = NOW() WHERE id_document = '75445' 29/11/2022 12:24:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75445' 29/11/2022 12:24:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '75445' 29/11/2022 12:24: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 ( '75445' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '40.5000' , '33.196721311475' , '22' , '5' , '46.94' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '3' , '3' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '45.20' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '1' , '1' , '6.5000' , '5.327868852459' , '22' , '5' , '7.53' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16409' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16409' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '2' , '1' , '6.5000' , '5.327868852459' , '22' , '5' , '15.07' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '540' , 'AMPOLLE ALTARE FUSIONE DORATA - 504 ' , '1' , '1' , '1' , '51.0000' , '41.803278688525' , '22' , '5' , '59.11' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '540' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '540' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '542' , 'AMPOLLE IN VASSOIO OTTONE - 523 ' , '2' , '2' , '1' , '37.0000' , '30.327868852459' , '22' , '5' , '85.77' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '542' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '542' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '1' , '1' , '19.0000' , '15.573770491803' , '22' , '5' , '22.02' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16939' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16939' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '12582' , 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32' , '2' , '2' , '1' , '6.5000' , '5.327868852459' , '22' , '5' , '15.07' ) 29/11/2022 12:24:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12582' AND id_supplier = '' 29/11/2022 12:24:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12582' , '' , '1' ) 29/11/2022 12:24: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 ( '75445' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '1' , '1' , '1' , '19.0000' , '15.573770491803' , '22' , '5' , '22.02' ) 29/11/2022 12:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16765' AND id_supplier = '' 29/11/2022 12:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16765' , '' , '1' ) 29/11/2022 12:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75445' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '1' , '1' , '17.5000' , '14.344262295082' , '22' , '5' , '20.28' ) 29/11/2022 12:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '' 29/11/2022 12:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '' , '1' ) 29/11/2022 12:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75445' , '19910' , 'LUCERNA COLORATA - 1490/KIT' , '3' , '3' , '1' , '6.875' , '5.6352459016393' , '22' , '5' , '23.9044' ) 29/11/2022 12:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19910' AND id_supplier = '' 29/11/2022 12:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19910' , '' , '1' ) 29/11/2022 12:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75445' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '1' , '1' , '1' , '6.88' , '5.6393442622951' , '22' , '5' , '7.9739' ) 29/11/2022 12:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 29/11/2022 12:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 29/11/2022 12:24:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75445' , '5975' , 'LUCERNA COLORATA - 1491' , '8' , '8' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '78.8120' ) 29/11/2022 12:24:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5975' AND id_supplier = '' 29/11/2022 12:24:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5975' , '' , '1' ) 29/11/2022 12:26:27 pm >> DELETE FROM ps_product WHERE id_product = '9080' 29/11/2022 12:26:27 pm >> DELETE FROM ps_product_shop WHERE id_product = '9080' 29/11/2022 12:26:27 pm >> DELETE FROM ps_product_lang WHERE id_product = '9080' 29/11/2022 12:26:27 pm >> DELETE FROM ps_stock_available WHERE id_product = '9080' 29/11/2022 12:42:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 12:42:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3660' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 29/11/2022 12:42:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75452' 29/11/2022 12:42:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '75452' 29/11/2022 12:42:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75452' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 29/11/2022 12:42:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 29/11/2022 12:42:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 29/11/2022 02:43:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '75447' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 02:43:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3655', document_date = '2022-11-29', 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 = '9.00', price_tax_excluded = '7.74', date_upd = NOW() WHERE id_document = '75447' 29/11/2022 02:43:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75447' 29/11/2022 02:43:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '75447' 29/11/2022 02:43:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75447' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/11/2022 02:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 29/11/2022 02:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 29/11/2022 02:43:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75447' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 29/11/2022 02:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '' 29/11/2022 02:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '' , '1' ) 29/11/2022 02:44:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '74881' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 29/11/2022 02:44:45 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '315', document_date = '2022-11-25', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4677540', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '352.34', price_tax_excluded = '352.34', date_upd = NOW() WHERE id_document = '74881' 29/11/2022 02:44:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74881' 29/11/2022 02:44:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '74881' 29/11/2022 02:44:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 29/11/2022 02:44:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 29/11/2022 02:44:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 29/11/2022 02:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '9675' , 'SARETE MIEI TESTIMONI' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' ) 29/11/2022 02:44:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 29/11/2022 02:44:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 29/11/2022 04:01:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 04:01: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' , '130' , '2022-11-29' , '' , '6872' , '0' , '9340217' , 'VIA I MAGGIO, 60 88900 CROTONE' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 29/11/2022 04:01: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 = '8977' 29/11/2022 04:01:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '8977' 29/11/2022 04:01: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 ( '8977' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 29/11/2022 04:31:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 04:31:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3661' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '58.48' , NOW() , NOW() ) 29/11/2022 04:31:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75453' 29/11/2022 04:31:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '75453' 29/11/2022 04:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 29/11/2022 04:31:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 29/11/2022 04:31:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 29/11/2022 04:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 29/11/2022 04:31:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 04:31:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 04:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 29/11/2022 04:31:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 04:31:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 04:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.8' , '4.7540983606557' , '22' , '0' , '5.80' ) 29/11/2022 04:31:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 04:31:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 04:38:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 04:38:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3662' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '48.04' , NOW() , NOW() ) 29/11/2022 04:38:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75454' 29/11/2022 04:38:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '75454' 29/11/2022 04:38:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '9.95' , '8.155737704918' , '22' , '0' , '9.95' ) 29/11/2022 04:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 29/11/2022 04:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 29/11/2022 04:38:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' ) 29/11/2022 04:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/11/2022 04:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/11/2022 04:38:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3' , '2.8846153846154' , '4' , '0' , '9.00' ) 29/11/2022 04:38:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/11/2022 04:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/11/2022 04:38:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 29/11/2022 04:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/11/2022 04:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/11/2022 04:38:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/11/2022 04:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 29/11/2022 04:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 29/11/2022 04:38:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75454' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/11/2022 04:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 29/11/2022 04:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 29/11/2022 04:44:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 04:44:09 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' , '3663' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.96' , '23.98' , NOW() , NOW() ) 29/11/2022 04:44: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 = '75455' 29/11/2022 04:44:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '75455' 29/11/2022 04:44: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 ( '75455' , '18131' , 'TAU MEDIO CM3 - T6' , '11' , '-11' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '11.00' ) 29/11/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 29/11/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 29/11/2022 04:44: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 ( '75455' , '11151' , 'LIBRI' , '11' , '-11' , '4' , '1.36' , '1.36' , '0' , '0' , '14.96' ) 29/11/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 29/11/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 29/11/2022 04:47:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 04:47:03 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' , '3664' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.62' , '109.62' , NOW() , NOW() ) 29/11/2022 04:47:03 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 = '75456' 29/11/2022 04:47:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '75456' 29/11/2022 04:47:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '20192' , 'VI CHIEDO IN NOME DI DIO' , '1' , '-1' , '4' , '15.21' , '15.21' , '0' , '0' , '15.21' ) 29/11/2022 04:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20192' AND id_supplier = '' 29/11/2022 04:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20192' , '' , '1' ) 29/11/2022 04:47:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.3' , '15.3' , '0' , '0' , '15.30' ) 29/11/2022 04:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '' 29/11/2022 04:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '' , '1' ) 29/11/2022 04:47:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '1178' , 'BIBBIA PER I RAGAZZI - ECON.' , '1' , '-1' , '4' , '5.4' , '5.4' , '0' , '0' , '5.40' ) 29/11/2022 04:47:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1178' AND id_supplier = '' 29/11/2022 04:47:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1178' , '' , '1' ) 29/11/2022 04:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '20449' , 'PREGHIERA DI SEMPLICITA - A. GASPARINO' , '1' , '-1' , '4' , '8.10' , '8.1' , '0' , '0' , '8.10' ) 29/11/2022 04:47:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20449' AND id_supplier = '' 29/11/2022 04:47:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20449' , '' , '1' ) 29/11/2022 04:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '-1' , '4' , '54' , '54' , '0' , '0' , '54.00' ) 29/11/2022 04:47:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '' 29/11/2022 04:47:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '' , '1' ) 29/11/2022 04:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75456' , '20248' , 'FORZA DELLO SPIRITO - C. MIRANTE' , '1' , '-1' , '4' , '11.61' , '11.61' , '0' , '0' , '11.61' ) 29/11/2022 04:47:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20248' AND id_supplier = '' 29/11/2022 04:47:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20248' , '' , '1' ) 29/11/2022 05:06:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 05:06:03 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' , '3665' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 29/11/2022 05:06:03 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 = '75457' 29/11/2022 05:06:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '75457' 29/11/2022 05:06:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75457' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 29/11/2022 05:06:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 29/11/2022 05:06:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 29/11/2022 05:15:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 05:15:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3666' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '12.50' , NOW() , NOW() ) 29/11/2022 05:15:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75458' 29/11/2022 05:15:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '75458' 29/11/2022 05:15:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75458' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 29/11/2022 05:15:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 29/11/2022 05:15:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 29/11/2022 05:15:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75458' , '16254' , 'STORIE DI NATALE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 29/11/2022 05:15:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16254' AND id_supplier = '' 29/11/2022 05:15:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16254' , '' , '1' ) 29/11/2022 05:33:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '74897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 29/11/2022 05:33:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3628', document_date = '2022-11-25', 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 = '215.00', price_tax_excluded = '176.23', date_upd = NOW() WHERE id_document = '74897' 29/11/2022 05:33: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 = '74897' 29/11/2022 05:33:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '74897' 29/11/2022 05:33: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 ( '74897' , '13506' , 'SANTO ROSARIO' , '60' , '-60' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '18.00' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 29/11/2022 05:33: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 ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 05:33: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 ( '74897' , '13363' , 'CORONA MM 6 ' , '60' , '-60' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '174.00' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 29/11/2022 05:33: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 ( '74897' , '13365' , 'SCATOLA 6x4' , '60' , '-60' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '15.00' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13365' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13365' , '' , '1' ) 29/11/2022 05:33: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 ( '74897' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20089' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20089' , '' , '1' ) 29/11/2022 05:33: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 ( '74897' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/11/2022 05:33:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18135' AND id_supplier = '' 29/11/2022 05:33:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18135' , '' , '1' ) 29/11/2022 05:38:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 05:38:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3667' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '143.44' , NOW() , NOW() ) 29/11/2022 05:38:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75459' 29/11/2022 05:38:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '75459' 29/11/2022 05:38:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75459' , '15530' , 'TUNICA SVASATA COLLO ROTONDO - PTA001B00' , '5' , '-5' , '1' , '35' , '28.688524590164' , '22' , '0' , '175.00' ) 29/11/2022 05:38:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15530' AND id_supplier = '' 29/11/2022 05:38:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15530' , '' , '1' ) 29/11/2022 06:21:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 06:21:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '14/L' , '2022-11-29' , 'L' , '204' , '' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALIERA \"G. DA PROCIDA\"' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '359.90' , '295.00' , NOW() , NOW() ) 29/11/2022 06:21: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 = '75460' 29/11/2022 06:21:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '75460' 29/11/2022 06:21: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 ( '75460' , '19748' , 'CORONA D\'AVVENTO STELLE' , '1' , '-1' , '1' , '24.0000' , '19.6721' , '22' , '0' , '24.00' ) 29/11/2022 06:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19748' AND id_supplier = '' 29/11/2022 06:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19748' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.5000' , '5.3279' , '22' , '0' , '26.00' ) 29/11/2022 06:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 29/11/2022 06:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 29/11/2022 06:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/11/2022 06:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.5000' , '6.9672' , '22' , '0' , '25.50' ) 29/11/2022 06:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/11/2022 06:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '30' , '-30' , '1' , '2.5000' , '2.0492' , '22' , '0' , '75.00' ) 29/11/2022 06:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18846' AND id_supplier = '' 29/11/2022 06:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18846' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '18847' , 'QUADRETTO NATIVITA ORO A CALDO - P662' , '30' , '-30' , '1' , '2.7000' , '2.2131' , '22' , '0' , '81.00' ) 29/11/2022 06:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18847' AND id_supplier = '' 29/11/2022 06:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18847' , '' , '1' ) 29/11/2022 06:21: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 ( '75460' , '14835' , 'STELLA COMETA - P581' , '30' , '-30' , '1' , '2.4000' , '1.9672' , '22' , '0' , '72.00' ) 29/11/2022 06:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 29/11/2022 06:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 29/11/2022 06:21:46 pm >> DELETE FROM ps_document WHERE id_document = '74269' 29/11/2022 06:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '74269' 29/11/2022 06:25:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 06:25:43 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 ( '23' , '15/L' , '2022-11-29' , 'L' , '204' , '' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALE BATTIPAGLIA' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '231.10' , '213.84' , NOW() , NOW() ) 29/11/2022 06:25: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 = '75461' 29/11/2022 06:25:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '75461' 29/11/2022 06:25: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 ( '75461' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269' , '4' , '0' , '1.90' ) 29/11/2022 06:25:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/11/2022 06:25:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/11/2022 06:25: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 ( '75461' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 29/11/2022 06:25:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 29/11/2022 06:25:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 29/11/2022 06:25: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 ( '75461' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 29/11/2022 06:25:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 29/11/2022 06:25:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '0' , 'PREGHIERA DELL\'AMMALATO' , '300' , '-300' , '0' , '0.1000' , '0.1' , '' , '5' , '28.50' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '1914' , 'CERA DELLA LITURGIA' , '14' , '-14' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '65.80' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '0' , 'LAMPADINE RICAMBIO' , '50' , '-50' , '4' , '1.2000' , '1.2' , '0' , '0' , '60.00' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '5658' , 'LEGGIO PLEXIGLAS 26X36 ' , '1' , '-1' , '1' , '28.0000' , '22.9508' , '22' , '0' , '28.00' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5658' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5658' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '16140' , 'NOVENA DELLIMMACOLATA - L. DABBRACCIO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16140' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16140' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 29/11/2022 06:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75461' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/11/2022 06:25:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 29/11/2022 06:25:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 29/11/2022 06:26:03 pm >> DELETE FROM ps_document WHERE id_document = '59691' 29/11/2022 06:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59691' 29/11/2022 06:28:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 06:28:35 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 ( '23' , '16/L' , '2022-11-29' , 'L' , '3812' , '' , '4672633' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '527.30' , '456.45' , NOW() , NOW() ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75462' 29/11/2022 06:28:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '75462' 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '7311' , 'OSTIA SOTTILE 74MM' , '11' , '-11' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '20.90' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3654' , '4' , '0' , '35.00' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '1914' , 'CERA DELLA LITURGIA' , '72' , '-72' , '1' , '4.5000' , '3.6885' , '22' , '0' , '324.00' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '5' , '85.50' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 29/11/2022 06:28:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '' 29/11/2022 06:28:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' ) 29/11/2022 06:28:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75462' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' ) 29/11/2022 06:28:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13523' AND id_supplier = '' 29/11/2022 06:28:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13523' , '' , '1' ) 29/11/2022 06:28:57 pm >> DELETE FROM ps_document WHERE id_document = '68619' 29/11/2022 06:28:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '68619' 29/11/2022 06:30:14 pm >> DELETE FROM ps_document WHERE id_document = '65209' 29/11/2022 06:30:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '65209' 29/11/2022 06:32:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 06:32:29 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' , '3668' , '2022-11-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 29/11/2022 06:32:29 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 = '75463' 29/11/2022 06:32:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '75463' 29/11/2022 06:32:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75463' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 29/11/2022 06:32:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/11/2022 06:32:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/11/2022 06:32:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75463' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 29/11/2022 06:32:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 06:32:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 06:59:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '75459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 29/11/2022 06:59:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3667', document_date = '2022-11-29', 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 = '175.00', price_tax_excluded = '143.44', date_upd = NOW() WHERE id_document = '75459' 29/11/2022 06:59:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75459' 29/11/2022 06:59:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '75459' 29/11/2022 06:59:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75459' , '15530' , 'TUNICA SVASATA COLLO ROTONDO - PTA001B00' , '4' , '-4' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '140.00' ) 29/11/2022 06:59:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15530' AND id_supplier = '' 29/11/2022 06:59:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15530' , '' , '1' ) 29/11/2022 06:59:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75459' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 29/11/2022 06:59:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/11/2022 06:59:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/11/2022 07:01:56 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '233888', document_date = '2020-10-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '619.00', price_tax_excluded = '619.00', date_upd = NOW() WHERE id_document = '25577' 29/11/2022 07:01: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 = '25577' 29/11/2022 07:01:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '25577' 29/11/2022 07:01: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 ( '25577' , '17354' , 'ASCOLTATE OGGI - 2021' , '3' , '3' , '4' , '10.0000' , '10' , '0' , '0' , '30.00' ) 29/11/2022 07:01:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17354' AND id_supplier = '' 29/11/2022 07:01:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17354' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '17351' , 'PERLA E IL CAMPO - ANNO B - R. GIUE' , '1' , '1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17351' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17351' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '17355' , 'IN OGNI COSA RENDETE GRAZIE ' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17355' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17355' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '13999' , 'ENCHIRIDION SYMBOLORUM - DENZINGER' , '2' , '2' , '4' , '110.0000' , '110' , '0' , '0' , '220.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13999' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13999' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '5' , '5' , '4' , '42.0000' , '42' , '0' , '0' , '210.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1146' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1146' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '2' , '2' , '4' , '44.0000' , '44' , '0' , '0' , '88.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '16253' , 'APETTANDO NATALE' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16253' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16253' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '17356' , 'STORIE DI NATALE ILLUSTRATO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17356' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17356' , '' , '1' ) 29/11/2022 07:01:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '25577' , '16254' , 'STORIE DI NATALE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 29/11/2022 07:01:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16254' AND id_supplier = '' 29/11/2022 07:01:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16254' , '' , '1' ) 29/11/2022 07:02:59 pm >> DELETE FROM ps_document WHERE id_document = '71446' 29/11/2022 07:02:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '71446' 29/11/2022 07:03:20 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '259/22', document_date = '2022-09-16', document_letter = '22', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '61966' 29/11/2022 07:03:20 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 = '61966' 29/11/2022 07:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '61966' 29/11/2022 07:03: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 ( '61966' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 29/11/2022 07:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '17' 29/11/2022 07:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '17' , '1' ) 29/11/2022 07:03: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 ( '61966' , '9555' , 'SANTA ELISABETTA DUNGHERIA - L. CAVAGNA' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 29/11/2022 07:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9555' AND id_supplier = '17' 29/11/2022 07:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9555' , '17' , '1' ) 29/11/2022 07:03: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 ( '61966' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 29/11/2022 07:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '17' 29/11/2022 07:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '17' , '1' ) 29/11/2022 07:03: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 ( '61966' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/11/2022 07:03:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9479' AND id_supplier = '17' 29/11/2022 07:03:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9479' , '17' , '1' ) 29/11/2022 07:03:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 29/11/2022 07:03:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9438' AND id_supplier = '17' 29/11/2022 07:03:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9438' , '17' , '1' ) 29/11/2022 07:03:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/11/2022 07:03:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9593' AND id_supplier = '17' 29/11/2022 07:03:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9593' , '17' , '1' ) 29/11/2022 07:03:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 29/11/2022 07:03:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19666' AND id_supplier = '17' 29/11/2022 07:03:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19666' , '17' , '1' ) 29/11/2022 07:03:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '19964' , 'SANTA MARIA GORETTI - G. ALBERTI' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '3.50' ) 29/11/2022 07:03:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19964' AND id_supplier = '17' 29/11/2022 07:03:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19964' , '17' , '1' ) 29/11/2022 07:03:32 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '323/22', document_date = '2022-11-08', document_letter = '22', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '46.00', price_tax_excluded = '46.00', date_upd = NOW() WHERE id_document = '73156' 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73156' 29/11/2022 07:03:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '73156' 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '9490' , 'SAN NICOLA - A. DURSO' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9479' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9479' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19666' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19666' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '19964' , 'SANTA MARIA GORETTI - G. ALBERTI' , '2' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '7.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19964' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19964' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '20319' , 'SAN NICOLA DA TOLENTINO - R. PICCOLOMINI' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20319' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20319' , '17' , '1' ) 29/11/2022 07:03:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73156' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '5' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '10.00' ) 29/11/2022 07:03:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '17' 29/11/2022 07:03:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '17' , '1' ) 29/11/2022 07:05:07 pm >> DELETE FROM ps_document WHERE id_document = '73719' 29/11/2022 07:05:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '73719' 29/11/2022 07:18:27 pm >> DELETE FROM ps_product WHERE id_product = '9913' 29/11/2022 07:18:27 pm >> DELETE FROM ps_product_shop WHERE id_product = '9913' 29/11/2022 07:18:27 pm >> DELETE FROM ps_product_lang WHERE id_product = '9913' 29/11/2022 07:18:27 pm >> DELETE FROM ps_stock_available WHERE id_product = '9913' 29/11/2022 07:18:49 pm >> DELETE FROM ps_product WHERE id_product = '709' 29/11/2022 07:18:49 pm >> DELETE FROM ps_product_shop WHERE id_product = '709' 29/11/2022 07:18:49 pm >> DELETE FROM ps_product_lang WHERE id_product = '709' 29/11/2022 07:18:49 pm >> DELETE FROM ps_stock_available WHERE id_product = '709' 29/11/2022 07:19:27 pm >> DELETE FROM ps_product WHERE id_product = '1947' 29/11/2022 07:19:27 pm >> DELETE FROM ps_product_shop WHERE id_product = '1947' 29/11/2022 07:19:27 pm >> DELETE FROM ps_product_lang WHERE id_product = '1947' 29/11/2022 07:19:27 pm >> DELETE FROM ps_stock_available WHERE id_product = '1947'