13/06/2023 08:35:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2039' AND id_document != '85814' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 13/06/2023 08:35:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2039', document_date = '2023-06-12', 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 = '31.80', price_tax_excluded = '30.72', date_upd = NOW() WHERE id_document = '85814' 13/06/2023 08:35:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85814' 13/06/2023 08:35:28 am >> DELETE FROM ps_document_detail WHERE id_document = '85814' 13/06/2023 08:35:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85814' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 13/06/2023 08:35:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85814' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.8' , '3.8' , '0' , '0' , '3.80' ) 13/06/2023 08:50:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '23FP00047' , '2023-01-25' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 13/06/2023 08:50:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85822' 13/06/2023 08:50:34 am >> DELETE FROM ps_document_detail WHERE id_document = '85822' 13/06/2023 08:50:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85822' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.5000' ) 13/06/2023 08:50:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 13/06/2023 08:50:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 13/06/2023 08:51:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '23FP00249' , '2023-04-07' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '196.00' , '196.00' , NOW() , NOW() ) 13/06/2023 08:51:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85823' 13/06/2023 08:51:41 am >> DELETE FROM ps_document_detail WHERE id_document = '85823' 13/06/2023 08:51:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85823' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '350' , '350' , '4' , '0.56' , '0.56' , '0' , '0' , '196.0000' ) 13/06/2023 08:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 13/06/2023 08:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 13/06/2023 08:54:35 am >> UPDATE ps_document SET id_document_type = '31', document_num = '128/23', document_date = '2023-04-26', document_letter = '23', id_customer = '0', id_supplier = '0', id_address = '4671003', 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 = '3', id_causal = '0', price_tax_included = '46.25', price_tax_excluded = '46.25', date_upd = NOW() WHERE id_document = '84083' 13/06/2023 08:54:35 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 = '84083' 13/06/2023 08:54:35 am >> DELETE FROM ps_document_detail WHERE id_document = '84083' 13/06/2023 08:54:35 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 ( '84083' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/06/2023 08:54:35 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 ( '84083' , '1077' , 'BERNADETTE' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:54:35 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 ( '84083' , '9394' , 'SAN BIAGIO - G.PESENTI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 13/06/2023 08:54:35 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 ( '84083' , '9517' , 'SAN VALENTINO - G. CASSIO' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 13/06/2023 08:54:35 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 ( '84083' , '9494' , 'SAN PASQUALE BAYLON - S.BRACCI' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 13/06/2023 08:54:35 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 ( '84083' , '9417' , 'SAN FILIPPO NERI - R.BRUNELLI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:54:35 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 ( '84083' , '15604' , 'LUIGI MARIA DA MONTFORT' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:54:35 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 ( '84083' , '21030' , 'MAGGIO CON MARIA' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 13/06/2023 08:54:35 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 ( '84083' , '9444' , 'SAN GIACOMO AP.- A.GOVERNALE' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 13/06/2023 08:54:36 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 ( '84083' , '21031' , 'MADONNA DEL ROSARIO - A. CAMPAGNA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:54:36 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 ( '84083' , '21032' , 'DON DOLINDO RUOTOLO - P. REA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> UPDATE ps_document SET id_document_type = '31', document_num = '128/23', document_date = '2023-04-26', document_letter = '23', 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 = '3', id_causal = '0', price_tax_included = '46.25', price_tax_excluded = '46.25', date_upd = NOW() WHERE id_document = '84083' 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84083' 13/06/2023 08:55:03 am >> DELETE FROM ps_document_detail WHERE id_document = '84083' 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19667' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19667' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '1077' , 'BERNADETTE' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1077' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1077' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '9394' , 'SAN BIAGIO - G.PESENTI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9394' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9394' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '9517' , 'SAN VALENTINO - G. CASSIO' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9517' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9517' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '9494' , 'SAN PASQUALE BAYLON - S.BRACCI' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9494' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9494' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '9417' , 'SAN FILIPPO NERI - R.BRUNELLI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9417' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9417' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '15604' , 'LUIGI MARIA DA MONTFORT' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '15604' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15604' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '21030' , 'MAGGIO CON MARIA' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21030' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21030' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '9444' , 'SAN GIACOMO AP.- A.GOVERNALE' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '9444' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9444' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '21031' , 'MADONNA DEL ROSARIO - A. CAMPAGNA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21031' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21031' , '17' , '1' ) 13/06/2023 08:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84083' , '21032' , 'DON DOLINDO RUOTOLO - P. REA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 13/06/2023 08:55:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21032' AND id_supplier = '17' 13/06/2023 08:55:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21032' , '17' , '1' ) 13/06/2023 09:04:27 am >> UPDATE ps_document SET id_document_type = '31', document_num = '13', document_date = '2023-02-07', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', address2 = '', note = '', price_shipping = '0.06', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '128.40', price_tax_excluded = '128.40', date_upd = NOW() WHERE id_document = '81283' 13/06/2023 09:04:27 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 = '81283' 13/06/2023 09:04:27 am >> DELETE FROM ps_document_detail WHERE id_document = '81283' 13/06/2023 09:04:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81283' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '4960' , '4960' , '4' , '0.0345' , '0.0345' , '0' , '25' , '128.34' ) 13/06/2023 09:04:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:04:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:08: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 ( '31' , '23LER210' , '2023-05-15' , '' , '0' , '81' , '2696' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '-0.06' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '128.40' , '128.40' , NOW() , NOW() ) 13/06/2023 09:08: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 = '85824' 13/06/2023 09:08:44 am >> DELETE FROM ps_document_detail WHERE id_document = '85824' 13/06/2023 09:08: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 ( '85824' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '4960' , '4960' , '4' , '0.0259' , '0.0259' , '0' , '0' , '128.4640' ) 13/06/2023 09:08:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:08:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:10:25 am >> UPDATE ps_document SET id_document_type = '31', document_num = '594', document_date = '2021-11-11', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', 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 = '161.80', price_tax_excluded = '161.80', date_upd = NOW() WHERE id_document = '45149' 13/06/2023 09:10: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 = '45149' 13/06/2023 09:10:25 am >> DELETE FROM ps_document_detail WHERE id_document = '45149' 13/06/2023 09:10: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 ( '45149' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '4080' , '4080' , '4' , '0.0300' , '0.03' , '0' , '25' , '91.80' ) 13/06/2023 09:10:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:10:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:10: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 ( '45149' , '16265' , 'MIE PREGHIERE' , '100' , '100' , '4' , '1.0000' , '1' , '0' , '30' , '70.00' ) 13/06/2023 09:10:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '16265' AND id_supplier = '81' 13/06/2023 09:10:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16265' , '81' , '1' ) 13/06/2023 09:10:37 am >> UPDATE ps_document SET id_document_type = '31', document_num = '360', document_date = '2021-07-23', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '88.20', price_tax_excluded = '88.20', date_upd = NOW() WHERE id_document = '30320' 13/06/2023 09:10:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '30320' 13/06/2023 09:10:37 am >> DELETE FROM ps_document_detail WHERE id_document = '30320' 13/06/2023 09:10:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '30320' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3920' , '3920' , '4' , '0.0300' , '0.03' , '0' , '25' , '88.20' ) 13/06/2023 09:10:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:10:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:10:54 am >> UPDATE ps_document SET id_document_type = '31', document_num = '192', document_date = '2021-04-28', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', 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 = '84.60', price_tax_excluded = '84.60', date_upd = NOW() WHERE id_document = '28418' 13/06/2023 09:10:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '28418' 13/06/2023 09:10:54 am >> DELETE FROM ps_document_detail WHERE id_document = '28418' 13/06/2023 09:10:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28418' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3760' , '3760' , '4' , '0.0300' , '0.03' , '0' , '25' , '84.60' ) 13/06/2023 09:10:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:10:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:11:09 am >> UPDATE ps_document SET id_document_type = '31', document_num = '21ler51', document_date = '2021-02-04', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', 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 = '72.00', price_tax_excluded = '72.00', date_upd = NOW() WHERE id_document = '27197' 13/06/2023 09:11: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 = '27197' 13/06/2023 09:11:09 am >> DELETE FROM ps_document_detail WHERE id_document = '27197' 13/06/2023 09:11: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 ( '27197' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3200' , '3200' , '4' , '0.0300' , '0.03' , '0' , '25' , '72.00' ) 13/06/2023 09:11:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 13/06/2023 09:11:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 13/06/2023 09:11:40 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11858' 13/06/2023 09:11:40 am >> UPDATE ps_stock_available SET quantity = quantity + '320' WHERE id_product = '11858' 13/06/2023 09:25:32 am >> UPDATE ps_document SET id_document_type = '31', document_num = '230', document_date = '2023-02-24', document_letter = '', id_customer = '0', id_supplier = '163', id_address = '4674530', address1 = 'VIA CORTI 29 24126 BERGAMO', 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 = '353.80', price_tax_excluded = '290.00', date_upd = NOW() WHERE id_document = '82096' 13/06/2023 09:25:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82096' 13/06/2023 09:25:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82096' 13/06/2023 09:25:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82096' , '20273' , 'CASULA IHS - 220' , '5' , '5' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '170.80' ) 13/06/2023 09:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20273' AND id_supplier = '163' 13/06/2023 09:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20273' , '163' , '1' ) 13/06/2023 09:25:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82096' , '20646' , 'STOLA DIACONALE - 881' , '1' , '1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '36.60' ) 13/06/2023 09:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20646' AND id_supplier = '163' 13/06/2023 09:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20646' , '163' , '1' ) 13/06/2023 09:25:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82096' , '11265' , 'COPRILEGGIO - 881' , '4' , '4' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '146.40' ) 13/06/2023 09:25:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '11265' AND id_supplier = '163' 13/06/2023 09:25:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11265' , '163' , '1' ) 13/06/2023 09:39:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 09:39:59 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' , '2047' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.10' , '10.74' , NOW() , NOW() ) 13/06/2023 09:39:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85825' 13/06/2023 09:39:59 am >> DELETE FROM ps_document_detail WHERE id_document = '85825' 13/06/2023 09:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85825' , '19560' , 'PERGAMENA 17X25' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 13/06/2023 09:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85825' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 13/06/2023 09:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85825' , '7403' , 'PADRE PIO TRA CIELO E TERRA' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '0' , '9.90' ) 13/06/2023 11:12:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 11:12:19 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' , '2048' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 13/06/2023 11:12:19 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 = '85826' 13/06/2023 11:12:19 am >> DELETE FROM ps_document_detail WHERE id_document = '85826' 13/06/2023 11:12:19 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 ( '85826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 13/06/2023 11:12:19 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 ( '85826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 13/06/2023 11:12:19 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 ( '85826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 13/06/2023 11:32:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 11:32:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2049' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 13/06/2023 11:32:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85827' 13/06/2023 11:32:01 am >> DELETE FROM ps_document_detail WHERE id_document = '85827' 13/06/2023 11:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85827' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '43' , '35.245901639344' , '22' , '0' , '86.00' ) 13/06/2023 11:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85827' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '44.5' , '36.475409836066' , '22' , '0' , '44.50' ) 13/06/2023 11:32:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85827' , '21150' , 'QUADRO 15X15' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 13/06/2023 11:42:12 am >> SELECT document_num FROM ps_document WHERE document_num = '95' AND id_document != '85541' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-25') 13/06/2023 11:42:12 am >> UPDATE ps_document SET id_document_type = '21', document_num = '95', document_date = '2023-05-25', document_letter = '', id_customer = '2762', id_supplier = '', id_address = '4679051', address1 = 'VIA G.B. GRASSI, 3 22069 ROVELLASCA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '98.79', price_tax_excluded = '98.79', date_upd = NOW() WHERE id_document = '85541' 13/06/2023 11:42:12 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 = '85541' 13/06/2023 11:42:12 am >> DELETE FROM ps_document_detail WHERE id_document = '85541' 13/06/2023 11:42:12 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 ( '85541' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '0' , '60.00' ) 13/06/2023 11:42:12 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 ( '85541' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '0' , '30.00' ) 13/06/2023 11:42:12 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 ( '85541' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '-4' , '4' , '2.0000' , '2' , '0' , '0' , '8.00' ) 13/06/2023 11:42:12 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 ( '85541' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.79' , '0.79' , '0' , '0' , '0.79' ) 13/06/2023 12:16:06 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/06/2023 12:16:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21157' , '1' , '' , 'nuovo-prodotto' ) 13/06/2023 12:16:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21157' , '1' , '1' , '2' , NOW() , NOW() ) 13/06/2023 12:16:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21157' , '0' , '1' , '0' , '0' ) 13/06/2023 12:16:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831190664' AND id_product != '21157' AND ean13 != '' 13/06/2023 12:16:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831190664', date_upd = NOW() WHERE id_product = '21157' 13/06/2023 12:16:51 pm >> UPDATE ps_product_lang SET name = 'opere di antonio rosmini', description = '' WHERE id_product = '21157' 13/06/2023 12:16:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '70' WHERE id_product = '21157' 13/06/2023 12:16:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '70', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21157' 13/06/2023 12:16:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21157' 13/06/2023 12:16:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21157' 13/06/2023 12:16:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21158' , '1' , '' , 'nuovo-prodotto' ) 13/06/2023 12:16:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21158' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21157' 13/06/2023 12:16:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21158' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21157' 13/06/2023 12:17:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868793135' AND id_product != '21158' AND ean13 != '' 13/06/2023 12:17:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868793135', date_upd = NOW() WHERE id_product = '21158' 13/06/2023 12:17:24 pm >> UPDATE ps_product_lang SET name = 'messaggio di santa caterina', description = '' WHERE id_product = '21158' 13/06/2023 12:17:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '33.55' WHERE id_product = '21158' 13/06/2023 12:17:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '33.55', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21158' 13/06/2023 12:17:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '21158' 13/06/2023 12:17:25 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21158' 13/06/2023 12:17:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21159' , '1' , '' , 'nuovo-prodotto' ) 13/06/2023 12:17:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21159' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21158' 13/06/2023 12:17:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21159' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21158' 13/06/2023 12:17:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254710593' AND id_product != '21159' AND ean13 != '' 13/06/2023 12:17:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791254710593', date_upd = NOW() WHERE id_product = '21159' 13/06/2023 12:17:53 pm >> UPDATE ps_product_lang SET name = 'don milani', description = '' WHERE id_product = '21159' 13/06/2023 12:17:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '21159' 13/06/2023 12:17:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21159' 13/06/2023 12:17:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '21159' 13/06/2023 12:17:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21159' 13/06/2023 12:17:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21160' , '1' , '' , 'nuovo-prodotto' ) 13/06/2023 12:17:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21160' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21159' 13/06/2023 12:17:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21160' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21159' 13/06/2023 12:18:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855450706' AND id_product != '21160' AND ean13 != '' 13/06/2023 12:18:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788855450706', date_upd = NOW() WHERE id_product = '21160' 13/06/2023 12:18:49 pm >> UPDATE ps_product_lang SET name = 'STORIA DELLA TEOLOGIA 1 - B. MONDIN', description = '' WHERE id_product = '21160' 13/06/2023 12:18:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '59' WHERE id_product = '21160' 13/06/2023 12:18:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '59', id_tax_rules_group = '4', id_category_default = '77', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21160' 13/06/2023 12:18:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '21160' 13/06/2023 12:18:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21160' 13/06/2023 12:18:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21161' , '1' , '' , 'nuovo-prodotto' ) 13/06/2023 12:18:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21161' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21160' 13/06/2023 12:18:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21161' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21160' 13/06/2023 12:20:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254710593' AND id_product != '21159' AND ean13 != '' 13/06/2023 12:20:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791254710593', date_upd = NOW() WHERE id_product = '21159' 13/06/2023 12:20:06 pm >> UPDATE ps_product_lang SET name = 'DON MILANI', description = '' WHERE id_product = '21159' 13/06/2023 12:20:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.0000' WHERE id_product = '21159' 13/06/2023 12:20:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.0000', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21159' 13/06/2023 12:20:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '21159' 13/06/2023 12:20:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868793135' AND id_product != '21158' AND ean13 != '' 13/06/2023 12:20:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868793135', date_upd = NOW() WHERE id_product = '21158' 13/06/2023 12:20:35 pm >> UPDATE ps_product_lang SET name = 'MESSAGGIO DI SANTA CATERINA', description = '' WHERE id_product = '21158' 13/06/2023 12:20:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '33.5500' WHERE id_product = '21158' 13/06/2023 12:20:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '33.5500', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21158' 13/06/2023 12:20:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21158' 13/06/2023 12:21:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831190664' AND id_product != '21157' AND ean13 != '' 13/06/2023 12:21:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831190664', date_upd = NOW() WHERE id_product = '21157' 13/06/2023 12:21:58 pm >> UPDATE ps_product_lang SET name = 'OPERE DI ANTONIO ROSMINI', description = '' WHERE id_product = '21157' 13/06/2023 12:21:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '70.0000' WHERE id_product = '21157' 13/06/2023 12:21:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '70.0000', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21157' 13/06/2023 12:21:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '21157' 13/06/2023 12:22: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 ( '33' , '988125' , '2023-06-12' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '205.05' , '205.05' , NOW() , NOW() ) 13/06/2023 12:22: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 = '85828' 13/06/2023 12:22:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '85828' 13/06/2023 12:22: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 ( '85828' , '21159' , 'DON MILANI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 13/06/2023 12:22:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21159' AND id_supplier = '109' 13/06/2023 12:22:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21159' , '109' , '1' ) 13/06/2023 12:22: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 ( '85828' , '21158' , 'MESSAGGIO DI SANTA CATERINA' , '1' , '1' , '4' , '33.55' , '33.55' , '0' , '0' , '33.55' ) 13/06/2023 12:22:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21158' AND id_supplier = '109' 13/06/2023 12:22:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21158' , '109' , '1' ) 13/06/2023 12:22: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 ( '85828' , '21160' , 'STORIA DELLA TEOLOGIA 1 - B. MONDIN' , '1' , '1' , '4' , '59.00' , '59' , '0' , '0' , '59.00' ) 13/06/2023 12:22:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21160' AND id_supplier = '109' 13/06/2023 12:22:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21160' , '109' , '1' ) 13/06/2023 12:22: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 ( '85828' , '13821' , 'SAN TOMMASO - G. CHESTERTON' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 13/06/2023 12:22:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13821' AND id_supplier = '109' 13/06/2023 12:22:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13821' , '109' , '1' ) 13/06/2023 12:22: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 ( '85828' , '21157' , 'OPERE DI ANTONIO ROSMINI' , '1' , '1' , '4' , '70.00' , '70' , '0' , '0' , '70.00' ) 13/06/2023 12:22:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21157' AND id_supplier = '109' 13/06/2023 12:22:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21157' , '109' , '1' ) 13/06/2023 12:22:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 13/06/2023 12:22:32 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '97.70', price_tax_excluded = '97.70', date_upd = NOW() WHERE id_document = '81317' 13/06/2023 12:22: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 = '81317' 13/06/2023 12:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 13/06/2023 12:22: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 ( '81317' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 13/06/2023 12:22: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 ( '81317' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 13/06/2023 12:22: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 ( '81317' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/06/2023 12:22: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 ( '81317' , '21067' , 'AMEN - AGO 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 13/06/2023 12:22: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 ( '81317' , '21077' , 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 13/06/2023 12:22: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 ( '81317' , '21115' , 'PAROLA E PREGHIERA - AGO. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/06/2023 12:22: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 ( '81317' , '21113' , 'VIVI PER QUALCOSA DI GRANDE - C. AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 13/06/2023 12:22: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 ( '81317' , '21125' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 13/06/2023 12:22: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 ( '81317' , '16528' , 'ANTONIO SEGRETO - N. VEGRO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 13/06/2023 12:22: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 ( '81317' , '21159' , 'DON MILANI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 13/06/2023 12:34:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 12:34:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2050' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.40' , '70.82' , NOW() , NOW() ) 13/06/2023 12:34:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85829' 13/06/2023 12:34:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '85829' 13/06/2023 12:34: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 ( '85829' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/06/2023 12:34: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 ( '85829' , '19874' , 'CROCE CM 25 BI/ORO - 7014/573' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 13/06/2023 12:37:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 12:37:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2051' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 13/06/2023 12:37:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85830' 13/06/2023 12:37:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '85830' 13/06/2023 12:37: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 ( '85830' , '21150' , 'QUADRO 15X15' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 13/06/2023 12:37: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 ( '85830' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 13/06/2023 02:43:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8013147480798' AND id_product != '7403' AND ean13 != '' 13/06/2023 02:43:15 pm >> UPDATE ps_product SET id_supplier = '7', reference = '1/6', ean13 = '8013147480798', date_upd = NOW() WHERE id_product = '7403' 13/06/2023 02:43:15 pm >> UPDATE ps_product_lang SET name = 'PADRE PIO TRA CIELO E TERRA', description = '' WHERE id_product = '7403' 13/06/2023 02:43:15 pm >> UPDATE ps_product SET wholesale_price = '6.08', on_sale = '0', price = '8.1148' WHERE id_product = '7403' 13/06/2023 02:43:15 pm >> UPDATE ps_product_shop SET wholesale_price = '6.08', price = '8.1148', id_tax_rules_group = '1', id_category_default = '30', id_argoment_default = '48', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7403' 13/06/2023 02:43:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '7403' 13/06/2023 03:43:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '67/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 03:43:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '67/A' , '2023-06-13' , 'A' , '1083' , '0' , '4674059' , 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 13/06/2023 03:43:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85831' 13/06/2023 03:43:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '85831' 13/06/2023 03:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85831' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 13/06/2023 04:40:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 04:40:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '26' , '2023-06-13' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , 'RESA AL FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '237.50' , '237.50' , NOW() , NOW() ) 13/06/2023 04:40:41 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 = '85832' 13/06/2023 04:40:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '85832' 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13369' , 'CRISTO, MARIA, LA CHIESA E I POPOLI - C.M. GALLI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13369' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13369' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13370' , 'CAMMINARE NELLAMORE - FUMAGALLI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13370' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13370' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13371' , 'VOLTI, GESTI E LUOGHI - L. CASULA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13371' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13371' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '18622' , 'FRATERNITA SEGNO DEI TEMPI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18622' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18622' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16719' , 'INTRODUZIONE ALLA FILOSOFIA - A. MELI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16719' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16719' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '19356' , 'SCIOGLIMENTO DEL MATRIMONIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19356' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19356' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '20578' , 'TOTUM AMORIS EST ' , '23' , '-23' , '4' , '2.00' , '2' , '0' , '0' , '46.00' ) 13/06/2023 04:40:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20578' AND id_supplier = '79' 13/06/2023 04:40:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20578' , '79' , '1' ) 13/06/2023 04:40:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16269' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16269' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16269' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17578' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17578' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '18514' , 'SOGNO DELLA FRATERNITA UNIVERSALE - E. SCOGNAMIGLIO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18514' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18514' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '4430' , 'GESÙ DI NAZARET: DALLINGRESSO IN GERUSALEMME... - BENEDETTO XVI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4430' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4430' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '5966' , 'LUCE DEL MONDO - BENEDETTO XVI ' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5966' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5966' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '17660' , 'PAPA FRANCESCO UN UOMO DI PAROLA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17660' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17660' , '79' , '1' ) 13/06/2023 04:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16715' , 'SACRAMENTO DELLA CONFESSIONE - R. MARTINELLI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 13/06/2023 04:40:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16715' AND id_supplier = '79' 13/06/2023 04:40:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16715' , '79' , '1' ) 13/06/2023 04:41:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 04:41:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '27' , '2023-06-13' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , 'RESO GUASTO AL FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 13/06/2023 04:41:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85833' 13/06/2023 04:41:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '85833' 13/06/2023 04:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85833' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 13/06/2023 04:41:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 13/06/2023 04:41:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 13/06/2023 04:59:47 pm >> DELETE FROM ps_document WHERE id_document = '84331' 13/06/2023 04:59:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '84331' 13/06/2023 05:12:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2052' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 05:12: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' , '2052' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 13/06/2023 05:12: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 = '85834' 13/06/2023 05:12:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '85834' 13/06/2023 05:12: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 ( '85834' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 13/06/2023 05:30:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2053' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 05:30:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2053' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 13/06/2023 05:30:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85835' 13/06/2023 05:30:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '85835' 13/06/2023 05:30:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85835' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/06/2023 05:35:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2054' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 13/06/2023 05:35: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' , '2054' , '2023-06-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.20' , '79.20' , NOW() , NOW() ) 13/06/2023 05:35: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 = '85836' 13/06/2023 05:35:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '85836' 13/06/2023 05:35: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 ( '85836' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '16.2' , '16.2' , '0' , '0' , '16.20' ) 13/06/2023 05:35: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 ( '85836' , '21157' , 'OPERE DI ANTONIO ROSMINI' , '1' , '-1' , '4' , '63' , '63' , '0' , '0' , '63.00' ) 13/06/2023 06:40:51 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7911' 13/06/2023 06:41:36 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7916' 13/06/2023 06:41:57 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7918'