04/12/2023 09:09:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3809' AND id_document != '89241' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 04/12/2023 09:09:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3809', document_date = '2023-11-30', 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 = '47.25', price_tax_excluded = '47.25', date_upd = NOW() WHERE id_document = '89241' 04/12/2023 09:09:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89241' 04/12/2023 09:09:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89241' 04/12/2023 09:09: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 ( '89241' , '16911' , 'DIAVOLI CHI SONO - 8991' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/12/2023 09:09: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 ( '89241' , '19586' , 'UNA MAMMA PER TUTTI - NATUZZA EVOLO - 8072' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 04/12/2023 09:09: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 ( '89241' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.55' , '8.55' , '0' , '0' , '8.55' ) 04/12/2023 09:09: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 ( '89241' , '9993' , 'SIGNORE, DACCI OGGI...' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 04/12/2023 09:09: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 ( '89241' , '2756' , 'CORONA ANGELICA - 8197' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/12/2023 09:09: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 ( '89241' , '19585' , 'PREGHIERE AL SACRO CUORE - 8071' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 04/12/2023 09:09: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 ( '89241' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 04/12/2023 09:14:49 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Z8oL55iDHUstSrKu' , NOW() , NOW() ) 04/12/2023 09:14:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4063' , '1' ) 04/12/2023 09:14:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4063' , '2' ) 04/12/2023 09:14:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4063' , '3' ) 04/12/2023 09:16:03 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4063' 04/12/2023 09:16:03 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 ( '4063' , '10' , '231' , '' , 'BROGGIAN' , 'LORENZO' , 'VIA NEGRIN 2' , '' , '36043' , 'CAMISANO' , '' , '' , '3403885235' , '' , '' , NOW() , NOW() ) 04/12/2023 09:16:03 am >> UPDATE ps_customer SET email = 'donlorenz@hotmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4063' 04/12/2023 09:16:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 09:16:52 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' , '3851' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/12/2023 09:16:52 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 = '89300' 04/12/2023 09:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89300' 04/12/2023 09:16:52 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 ( '89300' , '17459' , 'VERSO LA GROTTA DI BETLEMME - G. RAVASI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 04/12/2023 09:18:47 am >> SELECT document_num FROM ps_document WHERE document_num = '306' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 09:18: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 ( '21' , '306' , '2023-12-04' , '' , '4063' , '0' , '4679208' , 'VIA NEGRIN 2 36043 CAMISANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '85.50' , '85.50' , NOW() , NOW() ) 04/12/2023 09:18: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 = '89301' 04/12/2023 09:18:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89301' 04/12/2023 09:18: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 ( '89301' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '5' , '85.50' ) 04/12/2023 09:59:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 09:59: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' , '3852' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.66' , '29.71' , NOW() , NOW() ) 04/12/2023 09:59: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 = '89302' 04/12/2023 09:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89302' 04/12/2023 09:59:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89302' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/12/2023 09:59:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89302' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 04/12/2023 09:59:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89302' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 04/12/2023 10:05:53 am >> UPDATE ps_document SET id_document_type = '31', document_num = '340-2023', document_date = '2023-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = 'ATTENZIONE NUMERO', 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 = '442.09', price_tax_excluded = '362.37', date_upd = NOW() WHERE id_document = '88907' 04/12/2023 10:05:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88907' 04/12/2023 10:05:53 am >> DELETE FROM ps_document_detail WHERE id_document = '88907' 04/12/2023 10:05:53 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 ( '88907' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '14' , '14' , '1' , '21.6300' , '17.729508196721' , '22' , '3' , '358.36' ) 04/12/2023 10:05:53 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 ( '88907' , '21801' , 'CORDONIERA ORO' , '1' , '1' , '1' , '16.7200' , '13.704918032787' , '22' , '3' , '19.79' ) 04/12/2023 10:05:53 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 ( '88907' , '17533' , 'CINGOLO ORO/COL - CING06' , '3' , '3' , '1' , '7.7600' , '6.3606557377049' , '22' , '3' , '27.55' ) 04/12/2023 10:05:53 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 ( '88907' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.1500' , '5.0409836065574' , '22' , '3' , '36.39' ) 04/12/2023 10:06:08 am >> UPDATE ps_document SET id_document_type = '31', document_num = '340-2023', document_date = '2023-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', 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 = '442.09', price_tax_excluded = '362.37', date_upd = NOW() WHERE id_document = '88907' 04/12/2023 10:06: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 = '88907' 04/12/2023 10:06:08 am >> DELETE FROM ps_document_detail WHERE id_document = '88907' 04/12/2023 10:06: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 ( '88907' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '14' , '14' , '1' , '21.6300' , '17.729508196721' , '22' , '3' , '358.36' ) 04/12/2023 10:06: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 ( '88907' , '21801' , 'CORDONIERA ORO' , '1' , '1' , '1' , '16.7200' , '13.704918032787' , '22' , '3' , '19.79' ) 04/12/2023 10:06: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 ( '88907' , '17533' , 'CINGOLO ORO/COL - CING06' , '3' , '3' , '1' , '7.7600' , '6.3606557377049' , '22' , '3' , '27.55' ) 04/12/2023 10:06: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 ( '88907' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.1500' , '5.0409836065574' , '22' , '3' , '36.39' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023293114' , '2023-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '8.22' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '296.37' , '296.37' , NOW() , NOW() ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89303' 04/12/2023 10:21:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89303' 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '9.8000' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '21554' , 'CATECHESI CREATIVA 2 - A. QUEIROLO' , '1' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '9.8000' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21554' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21554' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '3' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '29.4000' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '1' , '0' , '4' , '9.8' , '9.8' , '0' , '0' , '9.8000' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '5823' , 'LIBRO D\'ORO' , '50' , '0' , '4' , '0.4198' , '0.4198' , '0' , '0' , '20.9900' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '21770' , 'ALTA FREQUENZA - GIOVANI' , '1' , '0' , '4' , '3.5' , '3.5' , '0' , '0' , '3.5000' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21770' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21770' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '21733' , 'GUARIRE CON LE PARABOLE - R. CHEIAB' , '3' , '0' , '4' , '11.13' , '11.13' , '0' , '0' , '33.3900' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21733' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21733' , '109' , '1' ) 04/12/2023 10:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89303' , '20902' , 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI' , '1' , '0' , '4' , '11.21' , '11.21' , '0' , '0' , '11.2100' ) 04/12/2023 10:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20902' AND id_supplier = '109' 04/12/2023 10:21:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20902' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '2518' , 'COMMENTO AL VANGELO DI GIOVANNI - SANTAGOSTINO' , '1' , '0' , '4' , '20.65' , '20.65' , '0' , '0' , '20.6500' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '2518' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2518' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21870' , 'FIGLI DI NAGASAKI' , '1' , '0' , '4' , '11.89' , '11.89' , '0' , '0' , '11.8900' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21870' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21870' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '0' , '4' , '17.5' , '17.5' , '0' , '0' , '17.5000' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21773' , 'MERAVIGLIA DELLEVENTO CRISTIANO - G. BIFFI' , '1' , '0' , '4' , '18.2' , '18.2' , '0' , '0' , '18.2000' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21773' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21773' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21915' , 'CI SPOSIAMO? - N. E. - L. FAGGIOLI' , '1' , '0' , '4' , '6.99' , '6.99' , '0' , '0' , '6.9900' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21915' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21915' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21910' , 'ITALO CALVINO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21910' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21910' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21913' , 'VITA 3.0' , '1' , '0' , '4' , '20.47' , '20.47' , '0' , '0' , '20.4700' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21913' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21913' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '0' , '4' , '17.62' , '17.62' , '0' , '0' , '17.6200' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21914' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21914' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21912' , 'POETI ITALIANI' , '1' , '0' , '4' , '13.3' , '13.3' , '0' , '0' , '13.3000' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21912' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21912' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21911' , 'GEOPOLITICA UMANA' , '1' , '0' , '4' , '10.54' , '10.54' , '0' , '0' , '10.5400' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21911' AND id_supplier = '109' 04/12/2023 10:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21911' , '109' , '1' ) 04/12/2023 10:21:23 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 ( '89303' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '0' , '4' , '14' , '14' , '0' , '0' , '14.0000' ) 04/12/2023 10:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21699' AND id_supplier = '109' 04/12/2023 10:21:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21699' , '109' , '1' ) 04/12/2023 10:27: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 ( '32' , '6023293113' , '2023-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.66' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.97' , '88.97' , NOW() , NOW() ) 04/12/2023 10:27: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 = '89304' 04/12/2023 10:27:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89304' 04/12/2023 10:27: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 ( '89304' , '21773' , 'MERAVIGLIA DELLEVENTO CRISTIANO - G. BIFFI' , '1' , '0' , '4' , '16.9' , '16.9' , '0' , '0' , '16.9000' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21773' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21773' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21772' , 'UNA VOCE CI GUIDA - 3/6 ANNI' , '1' , '0' , '4' , '2.6' , '2.6' , '0' , '0' , '2.6000' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21772' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21772' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21771' , 'UNA VOCE CI GUIDA - 7/10 ANNI' , '1' , '0' , '4' , '2.6' , '2.6' , '0' , '0' , '2.6000' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21771' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21771' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21769' , 'UNA VOCE CI GUIDA - 11-14' , '1' , '0' , '4' , '2.6' , '2.6' , '0' , '0' , '2.6000' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21769' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21769' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21770' , 'ALTA FREQUENZA - GIOVANI' , '1' , '0' , '4' , '3.25' , '3.25' , '0' , '0' , '3.2500' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21770' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21770' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21774' , 'COME FRANCESCO INVENTO IL PRESEPE - A. FOLI' , '1' , '0' , '4' , '12.93' , '12.93' , '0' , '0' , '12.9300' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21774' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21774' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '0' , '4' , '16.25' , '16.25' , '0' , '0' , '16.2500' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21873' , 'IN TERRA SANTA - G. RAVASI' , '1' , '0' , '4' , '10.98' , '10.98' , '0' , '0' , '10.9800' ) 04/12/2023 10:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21873' AND id_supplier = '109' 04/12/2023 10:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21873' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 04/12/2023 10:27:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 04/12/2023 10:27:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 04/12/2023 10:27: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 ( '89304' , '21871' , '50 DOMANDE SULLA FEDE - R. MACCIONI' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 04/12/2023 10:27:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21871' AND id_supplier = '109' 04/12/2023 10:27:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21871' , '109' , '1' ) 04/12/2023 10:28:37 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 ( '32' , '6023293115' , '2023-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.32' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.66' , '10.66' , NOW() , NOW() ) 04/12/2023 10:28: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 = '89305' 04/12/2023 10:28:37 am >> DELETE FROM ps_document_detail WHERE id_document = '89305' 04/12/2023 10:28: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 ( '89305' , '21872' , 'TU SEI LA MIA ROVINA - A. MUSOLESI' , '1' , '0' , '4' , '10.34' , '10.34' , '0' , '0' , '10.3400' ) 04/12/2023 10:28:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21872' AND id_supplier = '109' 04/12/2023 10:28:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21872' , '109' , '1' ) 04/12/2023 10:31:36 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 ( '32' , '6023293116' , '2023-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '38.38' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1127.04' , '1127.04' , NOW() , NOW() ) 04/12/2023 10:31:36 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 = '89306' 04/12/2023 10:31:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89306' 04/12/2023 10:31: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 ( '89306' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '25' , '0' , '4' , '21.5576' , '21.5576' , '0' , '0' , '538.9400' ) 04/12/2023 10:31:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 04/12/2023 10:31:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 04/12/2023 10:31: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 ( '89306' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '3' , '0' , '4' , '23.826' , '23.826' , '0' , '0' , '71.4780' ) 04/12/2023 10:31:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1145' AND id_supplier = '109' 04/12/2023 10:31:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1145' , '109' , '1' ) 04/12/2023 10:31: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 ( '89306' , '11740' , 'BIBBIA DI GERUSALEMME - GIGANTE DA ALTARE' , '1' , '0' , '4' , '65.24' , '65.24' , '0' , '0' , '65.2400' ) 04/12/2023 10:31:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11740' AND id_supplier = '109' 04/12/2023 10:31:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11740' , '109' , '1' ) 04/12/2023 10:31: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 ( '89306' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '8' , '0' , '4' , '26.09625' , '26.09625' , '0' , '0' , '208.7700' ) 04/12/2023 10:31:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '109' 04/12/2023 10:31:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '109' , '1' ) 04/12/2023 10:31: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 ( '89306' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '8' , '0' , '4' , '25.52875' , '25.52875' , '0' , '0' , '204.2300' ) 04/12/2023 10:31:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1146' AND id_supplier = '109' 04/12/2023 10:31:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1146' , '109' , '1' ) 04/12/2023 10:33:23 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 ( '32' , '6023293112' , '2023-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.37' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.40' , '118.40' , NOW() , NOW() ) 04/12/2023 10:33:23 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 = '89307' 04/12/2023 10:33:23 am >> DELETE FROM ps_document_detail WHERE id_document = '89307' 04/12/2023 10:33:23 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 ( '89307' , '4149' , 'FENOMENO RELIGIOSO' , '1' , '0' , '4' , '12.63' , '12.63' , '0' , '0' , '12.6300' ) 04/12/2023 10:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '4149' AND id_supplier = '109' 04/12/2023 10:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4149' , '109' , '1' ) 04/12/2023 10:33:23 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 ( '89307' , '3590' , 'DIZIONARIO DEI CONCETTI BIBLICI DEL NUOVO TESTAMENTO' , '1' , '0' , '4' , '66.9' , '66.9' , '0' , '0' , '66.9000' ) 04/12/2023 10:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '3590' AND id_supplier = '109' 04/12/2023 10:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3590' , '109' , '1' ) 04/12/2023 10:33:23 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 ( '89307' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '0' , '4' , '35.5' , '35.5' , '0' , '' , '35.5000' ) 04/12/2023 10:33:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 04/12/2023 10:33:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 04/12/2023 10:37:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '88321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 04/12/2023 10:37:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3182', document_date = '2023-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.00', price_tax_excluded = '9.38', date_upd = NOW() WHERE id_document = '88321' 04/12/2023 10:37:45 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 = '88321' 04/12/2023 10:37:45 am >> DELETE FROM ps_document_detail WHERE id_document = '88321' 04/12/2023 10:37:45 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 ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 04/12/2023 10:37:45 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 ( '88321' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/12/2023 10:37:45 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 ( '88321' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 04/12/2023 10:38:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3208' AND id_document != '88358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 04/12/2023 10:38:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3208', document_date = '2023-10-18', 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 = '75.00', price_tax_excluded = '65.65', date_upd = NOW() WHERE id_document = '88358' 04/12/2023 10:38: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 = '88358' 04/12/2023 10:38:27 am >> DELETE FROM ps_document_detail WHERE id_document = '88358' 04/12/2023 10:38: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 ( '88358' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 04/12/2023 10:38: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 ( '88358' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '2' , '-2' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '5.80' ) 04/12/2023 10:38: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 ( '88358' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/12/2023 10:38: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 ( '88358' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/12/2023 10:38: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 ( '88358' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/12/2023 10:38: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 ( '88358' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '5' , '2.28' ) 04/12/2023 10:38: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 ( '88358' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 04/12/2023 10:38: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 ( '88358' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '5' , '-5' , '4' , '1.0000' , '1' , '0' , '0' , '5.00' ) 04/12/2023 10:38: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 ( '88358' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '5' , '1.81' ) 04/12/2023 10:38: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 ( '88358' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '1' , '-1' , '4' , '2.38' , '2.38' , '0' , '0' , '2.38' ) 04/12/2023 10:38: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 ( '88358' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/12/2023 10:38: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 ( '88358' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/12/2023 10:38: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 ( '88358' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/12/2023 10:38: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 ( '88358' , '20706' , 'ANGELO PENDENTE - AM' , '1' , '-1' , '1' , '13.8000' , '11.311475409836' , '22' , '0' , '13.80' ) 04/12/2023 10:38: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 ( '88358' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/12/2023 10:38: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 ( '88358' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '6.60' ) 04/12/2023 10:39:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3356' AND id_document != '88571' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-27') 04/12/2023 10:39:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3356', document_date = '2023-10-27', 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 = '21.95', price_tax_excluded = '21.05', date_upd = NOW() WHERE id_document = '88571' 04/12/2023 10:39:36 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 = '88571' 04/12/2023 10:39:36 am >> DELETE FROM ps_document_detail WHERE id_document = '88571' 04/12/2023 10:39: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 ( '88571' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 04/12/2023 10:39: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 ( '88571' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 04/12/2023 10:39: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 ( '88571' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '6.85' , '6.85' , '0' , '0' , '6.85' ) 04/12/2023 10:39: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 ( '88571' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 04/12/2023 10:39: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 ( '88571' , '16206' , 'INCONTRARE DIO NEL SILENZIO DEL CUORE - A. CANOPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/12/2023 10:39: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 ( '88571' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/12/2023 10:39: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 ( '88571' , '16144' , 'NATO ... IN PERIFERIA - RUCCIA/SCALERA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 04/12/2023 10:40:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3297' AND id_document != '88489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-24') 04/12/2023 10:40:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3297', document_date = '2023-10-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 = '7.25', price_tax_excluded = '7.25', date_upd = NOW() WHERE id_document = '88489' 04/12/2023 10:40:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88489' 04/12/2023 10:40:22 am >> DELETE FROM ps_document_detail WHERE id_document = '88489' 04/12/2023 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88489' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/12/2023 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88489' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 04/12/2023 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88489' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 04/12/2023 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88489' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 04/12/2023 10:41:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3468' AND id_document != '88741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-06') 04/12/2023 10:41:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3468', document_date = '2023-11-06', 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 = '7.90', price_tax_excluded = '7.90', date_upd = NOW() WHERE id_document = '88741' 04/12/2023 10:41:45 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 = '88741' 04/12/2023 10:41:45 am >> DELETE FROM ps_document_detail WHERE id_document = '88741' 04/12/2023 10:41:45 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 ( '88741' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 04/12/2023 10:41:45 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 ( '88741' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/12/2023 10:41:45 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 ( '88741' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 04/12/2023 10:42:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3478' AND id_document != '88763' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-06') 04/12/2023 10:42:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3478', document_date = '2023-11-06', 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 = '34.90', price_tax_excluded = '30.93', date_upd = NOW() WHERE id_document = '88763' 04/12/2023 10:42: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 = '88763' 04/12/2023 10:42:55 am >> DELETE FROM ps_document_detail WHERE id_document = '88763' 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '21810' , 'AMEN - FEB 2024' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 04/12/2023 10:42:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88763' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 04/12/2023 10:43:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3714' AND id_document != '89122' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 04/12/2023 10:43:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3714', document_date = '2023-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 = '13.00', price_tax_excluded = '13.00', date_upd = NOW() WHERE id_document = '89122' 04/12/2023 10:43: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 = '89122' 04/12/2023 10:43:37 am >> DELETE FROM ps_document_detail WHERE id_document = '89122' 04/12/2023 10:43: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 ( '89122' , '21740' , 'ILLUMINA IL CAMMINO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 04/12/2023 10:43: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 ( '89122' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 04/12/2023 10:43: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 ( '89122' , '21752' , 'PAROLA E PREGHIERA - GEN 2024' , '1' , '-1' , '4' , '2.16' , '2.16' , '0' , '0' , '2.16' ) 04/12/2023 10:44:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '89041' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 04/12/2023 10:44:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3664', document_date = '2023-11-20', 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 = '4.95', price_tax_excluded = '4.95', date_upd = NOW() WHERE id_document = '89041' 04/12/2023 10:44: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 = '89041' 04/12/2023 10:44:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89041' 04/12/2023 10:44: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 ( '89041' , '16362' , 'BIANCANEVE E I SETTE NANI' , '2' , '-2' , '4' , '0.9900' , '0.99' , '0' , '0' , '1.98' ) 04/12/2023 10:44: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 ( '89041' , '21880' , 'PAROLA E PREGHIERA - FEB 2024' , '1' , '-1' , '4' , '2.97' , '2.97' , '0' , '0' , '2.97' ) 04/12/2023 10:46:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '88952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 04/12/2023 10:46:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3605', document_date = '2023-11-14', 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 = '114.00', price_tax_excluded = '105.89', date_upd = NOW() WHERE id_document = '88952' 04/12/2023 10:46: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 = '88952' 04/12/2023 10:46:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88952' 04/12/2023 10:46: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 ( '88952' , '19997' , 'GESU\' BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/12/2023 10:46: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 ( '88952' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 04/12/2023 10:46: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 ( '88952' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/12/2023 10:46: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 ( '88952' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 04/12/2023 10:46: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 ( '88952' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 04/12/2023 10:46: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 ( '88952' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.35' , '5.35' , '0' , '0' , '5.35' ) 04/12/2023 10:59:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '5901821651837' AND id_product != '19757' AND ean13 != '' 04/12/2023 10:59:12 am >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '5901821651837', date_upd = NOW() WHERE id_product = '19757' 04/12/2023 10:59:12 am >> UPDATE ps_product_lang SET name = 'PIVIALE - KKP/024/02/20', description = '' WHERE id_product = '19757' 04/12/2023 10:59:12 am >> UPDATE ps_product SET wholesale_price = '138.01', on_sale = '0', price = '330.327868852459' WHERE id_product = '19757' 04/12/2023 10:59:12 am >> UPDATE ps_product_shop SET wholesale_price = '138.01', price = '330.327868852459', id_tax_rules_group = '1', id_category_default = '194', 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 = '19757' 04/12/2023 10:59:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19757' 04/12/2023 11:17:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3853' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:17: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 ( '11' , '3853' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 04/12/2023 11:17: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 = '89308' 04/12/2023 11:17:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89308' 04/12/2023 11:17: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 ( '89308' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 04/12/2023 11:17: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 ( '89308' , '16394' , 'GIOCA INSIEME AL BAMBINO GESU ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 04/12/2023 11:17:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:17:55 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' , '3854' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 04/12/2023 11:17:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89309' 04/12/2023 11:17:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89309' 04/12/2023 11:17:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89309' , '21798' , 'ENCICLICA DEI BAMBINI - FORTUNATO / CAGNOLI' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 04/12/2023 11:21:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:21:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3855' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '585.00' , '491.77' , NOW() , NOW() ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89310' 04/12/2023 11:21:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89310' 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '13751' , 'TUNICA SVASATA AVORIO - 191 TPA' , '10' , '-10' , '1' , '40' , '32.786885245902' , '22' , '0' , '400.00' ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 04/12/2023 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89310' , '21527' , 'MESSALINO FRANCESCANO' , '1' , '-1' , '4' , '32.6' , '32.6' , '0' , '' , '32.60' ) 04/12/2023 11:27:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:27:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3856' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '209.20' , '209.20' , NOW() , NOW() ) 04/12/2023 11:27:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89311' 04/12/2023 11:27:15 am >> DELETE FROM ps_document_detail WHERE id_document = '89311' 04/12/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89311' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '20' , '-20' , '4' , '5.50' , '5.5' , '0' , '5' , '104.60' ) 04/12/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89311' , '5444' , 'IO SONO CON VOI - CAT.' , '20' , '-20' , '4' , '5.50' , '5.5' , '0' , '5' , '104.60' ) 04/12/2023 11:31:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002127' AND id_product != '20863' AND ean13 != '' 04/12/2023 11:31:17 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002127', date_upd = NOW() WHERE id_product = '20863' 04/12/2023 11:31:17 am >> UPDATE ps_product_lang SET name = 'CASULA ACETATO/VISCOSA - 65/19246', description = '' WHERE id_product = '20863' 04/12/2023 11:31:17 am >> UPDATE ps_product SET wholesale_price = '475.30', on_sale = '0', price = '942.6230' WHERE id_product = '20863' 04/12/2023 11:31:17 am >> UPDATE ps_product_shop SET wholesale_price = '475.30', price = '942.6230', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20863' 04/12/2023 11:31:17 am >> DELETE FROM ps_specific_price WHERE id_product = '20863' 04/12/2023 11:36:19 am >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:36: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 ( '24' , '138/A' , '2023-12-04' , 'A' , '3892' , '0' , '4679145' , 'OGLIARA 84100 OGLIARA' , '' , 'ACCONTO € 250 IN 7 ASSEGNI TOTALE € 1750 RESTA A SALDO € 550' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2300.00' , '1885.25' , NOW() , NOW() ) 04/12/2023 11:36: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 = '89312' 04/12/2023 11:36:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89312' 04/12/2023 11:36: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 ( '89312' , '20863' , 'CASULA ACETATO/VISCOSA - 65/19246' , '2' , '-2' , '1' , '1150.00' , '942.62295081967' , '22' , '0' , '2300.00' ) 04/12/2023 11:43:47 am >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 04/12/2023 11:43:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '', id_address = '4674532', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO € 220, 00 - € 150+ €240', 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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 04/12/2023 11:43: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 = '87349' 04/12/2023 11:43:47 am >> DELETE FROM ps_document_detail WHERE id_document = '87349' 04/12/2023 11:43: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 ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 04/12/2023 11:43: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 ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 04/12/2023 11:43: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 ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 04/12/2023 11:43: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 ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 04/12/2023 11:43: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 ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 04/12/2023 11:43: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 ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '-1' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 04/12/2023 11:43: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 ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 04/12/2023 11:55:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 11:55:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3857' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.33' , NOW() , NOW() ) 04/12/2023 11:55: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 = '89313' 04/12/2023 11:55:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89313' 04/12/2023 11:55: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 ( '89313' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 04/12/2023 12:02:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3844' AND id_document != '89292' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 04/12/2023 12:02:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3844', document_date = '2023-12-02', 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 = '23.30', price_tax_excluded = '23.13', date_upd = NOW() WHERE id_document = '89292' 04/12/2023 12:02: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 = '89292' 04/12/2023 12:02:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89292' 04/12/2023 12:02: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 ( '89292' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '' , '2.85' ) 04/12/2023 12:02: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 ( '89292' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 04/12/2023 12:02: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 ( '89292' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 04/12/2023 12:04:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3843' AND id_document != '89291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 04/12/2023 12:04:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3843', document_date = '2023-12-02', 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 = '36.00', price_tax_excluded = '29.51', date_upd = NOW() WHERE id_document = '89291' 04/12/2023 12:04:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89291' 04/12/2023 12:04:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89291' 04/12/2023 12:04: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 ( '89291' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 04/12/2023 12:04: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 ( '89291' , '21689' , 'ANGELO PIEGHEVOLE CM 12' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/12/2023 12:07:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 12:07:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3858' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.80' , '32.43' , NOW() , NOW() ) 04/12/2023 12:07: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 = '89314' 04/12/2023 12:07:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '89314' 04/12/2023 12:07: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 ( '89314' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '4' , '4' , '0' , '0' , '8.00' ) 04/12/2023 12:07: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 ( '89314' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/12/2023 12:07: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 ( '89314' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 04/12/2023 12:20:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001469' AND id_product != '16767' AND ean13 != '' 04/12/2023 12:20:46 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001469', date_upd = NOW() WHERE id_product = '16767' 04/12/2023 12:20:46 pm >> UPDATE ps_product_lang SET name = 'COPPIA CANDELIERI DA PROCESSIONE - 2591', description = '' WHERE id_product = '16767' 04/12/2023 12:20:46 pm >> UPDATE ps_product SET wholesale_price = '82.18', on_sale = '0', price = '180.32786885245903' WHERE id_product = '16767' 04/12/2023 12:20:46 pm >> UPDATE ps_product_shop SET wholesale_price = '82.18', price = '180.32786885245903', 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 = '16767' 04/12/2023 12:20:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '16767' 04/12/2023 12:24:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/12/2023 12:24:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21932' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 12:24:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21932' , '1' , '1' , '2' , NOW() , NOW() ) 04/12/2023 12:24:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21932' , '0' , '1' , '0' , '0' ) 04/12/2023 12:25:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002213' AND id_product != '21932' AND ean13 != '' 04/12/2023 12:25:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002213', date_upd = NOW() WHERE id_product = '21932' 04/12/2023 12:25:20 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148', description = '' WHERE id_product = '21932' 04/12/2023 12:25:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.688524590163937' WHERE id_product = '21932' 04/12/2023 12:25:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.688524590163937', 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 = '21932' 04/12/2023 12:25:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21932' 04/12/2023 12:26:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 12:26: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' , '3859' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 04/12/2023 12:26: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 = '89315' 04/12/2023 12:26:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89315' 04/12/2023 12:26: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 ( '89315' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 04/12/2023 12:29:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000773' AND id_product != '8936' AND ean13 != '' 04/12/2023 12:29:16 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2017', ean13 = '000773', date_upd = NOW() WHERE id_product = '8936' 04/12/2023 12:29:16 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33', description = '' WHERE id_product = '8936' 04/12/2023 12:29:16 pm >> UPDATE ps_product SET wholesale_price = '17.10', on_sale = '0', price = '40.98360655737705' WHERE id_product = '8936' 04/12/2023 12:29:16 pm >> UPDATE ps_product_shop SET wholesale_price = '17.10', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8936' 04/12/2023 12:29:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '8936' 04/12/2023 12:37:19 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/12/2023 12:37:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21933' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 12:37:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21933' , '1' , '1' , '2' , NOW() , NOW() ) 04/12/2023 12:37:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21933' , '0' , '1' , '0' , '0' ) 04/12/2023 12:38:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000004182' AND id_product != '21933' AND ean13 != '' 04/12/2023 12:38:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000004182', date_upd = NOW() WHERE id_product = '21933' 04/12/2023 12:38:48 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA CON CARTUCCIA 8X30- 1493', description = '' WHERE id_product = '21933' 04/12/2023 12:38:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '21933' 04/12/2023 12:38:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', 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 = '21933' 04/12/2023 12:38:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21933' 04/12/2023 12:40:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000004182' AND id_product != '21933' AND ean13 != '' 04/12/2023 12:40:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000004182', date_upd = NOW() WHERE id_product = '21933' 04/12/2023 12:40:20 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA CON CARTUCCIA 8X30- 1180', description = '' WHERE id_product = '21933' 04/12/2023 12:40:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.8852' WHERE id_product = '21933' 04/12/2023 12:40:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.8852', 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 = '21933' 04/12/2023 12:40:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21933' 04/12/2023 12:43:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000019162' AND id_product != '15351' AND ean13 != '' 04/12/2023 12:43:54 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000019162', date_upd = NOW() WHERE id_product = '15351' 04/12/2023 12:43:54 pm >> UPDATE ps_product_lang SET name = 'PORTATECA A BUSTINA - 928', description = '' WHERE id_product = '15351' 04/12/2023 12:43:54 pm >> UPDATE ps_product SET wholesale_price = '21.85', on_sale = '0', price = '48.36065573770492' WHERE id_product = '15351' 04/12/2023 12:43:54 pm >> UPDATE ps_product_shop SET wholesale_price = '21.85', price = '48.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 = '15351' 04/12/2023 12:43:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '15351' 04/12/2023 12:47:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010473' AND id_product != '8935' AND ean13 != '' 04/12/2023 12:47:24 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '1000000010473', date_upd = NOW() WHERE id_product = '8935' 04/12/2023 12:47:24 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32', description = '' WHERE id_product = '8935' 04/12/2023 12:47:24 pm >> UPDATE ps_product SET wholesale_price = '17.58', on_sale = '0', price = '38.52459016393443' WHERE id_product = '8935' 04/12/2023 12:47:24 pm >> UPDATE ps_product_shop SET wholesale_price = '17.58', price = '38.52459016393443', 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 = '8935' 04/12/2023 12:47:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '8935' 04/12/2023 12:48:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001169' AND id_product != '15356' AND ean13 != '' 04/12/2023 12:48:32 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001169', date_upd = NOW() WHERE id_product = '15356' 04/12/2023 12:48:32 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO DORATE - 1511', description = '' WHERE id_product = '15356' 04/12/2023 12:48:32 pm >> UPDATE ps_product SET wholesale_price = '38.48', on_sale = '0', price = '86.06557377049181' WHERE id_product = '15356' 04/12/2023 12:48:32 pm >> UPDATE ps_product_shop SET wholesale_price = '38.48', price = '86.06557377049181', 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' 04/12/2023 12:48:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '15356' 04/12/2023 12:50:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000908' AND id_product != '539' AND ean13 != '' 04/12/2023 12:50:23 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000908', date_upd = NOW() WHERE id_product = '539' 04/12/2023 12:50:23 pm >> UPDATE ps_product_lang SET name = 'AMPOLLA RICAMBIO PER ART. 506 - 17', description = '' WHERE id_product = '539' 04/12/2023 12:50:23 pm >> UPDATE ps_product SET wholesale_price = '2.52', on_sale = '0', price = '6.147540983606557' WHERE id_product = '539' 04/12/2023 12:50:23 pm >> UPDATE ps_product_shop SET wholesale_price = '2.52', price = '6.147540983606557', 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 = '539' 04/12/2023 12:50:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '539' 04/12/2023 12:52:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001908' AND id_product != '19108' AND ean13 != '' 04/12/2023 12:52:24 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001908', date_upd = NOW() WHERE id_product = '19108' 04/12/2023 12:52:24 pm >> UPDATE ps_product_lang SET name = 'PORTATECA COMPLETA - 947', description = '' WHERE id_product = '19108' 04/12/2023 12:52:24 pm >> UPDATE ps_product SET wholesale_price = '19.00', on_sale = '0', price = '41.80327868852459' WHERE id_product = '19108' 04/12/2023 12:52:24 pm >> UPDATE ps_product_shop SET wholesale_price = '19.00', price = '41.80327868852459', 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 = '19108' 04/12/2023 12:52:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '19108' 04/12/2023 12:54:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000983' AND id_product != '12645' AND ean13 != '' 04/12/2023 12:54:03 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000983', date_upd = NOW() WHERE id_product = '12645' 04/12/2023 12:54:03 pm >> UPDATE ps_product_lang SET name = 'TORCIA PROCESSIONE DIAM. 3,2 - 90 CM - 486', description = '' WHERE id_product = '12645' 04/12/2023 12:54:03 pm >> UPDATE ps_product SET wholesale_price = '31.83', on_sale = '0', price = '77.8688524590164' WHERE id_product = '12645' 04/12/2023 12:54:03 pm >> UPDATE ps_product_shop SET wholesale_price = '31.83', 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 = '12645' 04/12/2023 12:54:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '12645' 04/12/2023 12:56:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000033' AND id_product != '5976' AND ean13 != '' 04/12/2023 12:56:43 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000033', date_upd = NOW() WHERE id_product = '5976' 04/12/2023 12:56:43 pm >> UPDATE ps_product_lang SET name = 'LUCERNA VETRO - 1493', description = '' WHERE id_product = '5976' 04/12/2023 12:56:43 pm >> UPDATE ps_product SET wholesale_price = '7.60', on_sale = '0', price = '17.21311475409836' WHERE id_product = '5976' 04/12/2023 12:56:43 pm >> UPDATE ps_product_shop SET wholesale_price = '7.60', price = '17.21311475409836', 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' 04/12/2023 12:56:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '5976' 04/12/2023 12:58: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 ( '31' , '3943' , '2023-12-01' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '688.60' , '564.43' , NOW() , NOW() ) 04/12/2023 12:58: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 = '89316' 04/12/2023 12:58:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89316' 04/12/2023 12:58: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 ( '89316' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '1' , '1' , '91' , '74.590163934426' , '22' , '5' , '105.4690' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16767' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16767' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '2' , '1' , '14.5' , '11.885245901639' , '22' , '5' , '33.6110' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21932' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21932' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8936' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8936' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '21933' , 'FINTA CANDELA CON CARTUCCIA 8X30- 1180' , '6' , '6' , '1' , '18.5' , '15.16393442623' , '22' , '5' , '128.6490' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21933' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21933' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '12' , '12' , '1' , '3' , '2.4590163934426' , '22' , '5' , '41.7240' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '15351' , 'PORTATECA A BUSTINA - 928' , '2' , '2' , '1' , '24' , '19.672131147541' , '22' , '5' , '55.6320' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15351' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15351' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 04/12/2023 12:58:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8936' AND id_supplier = '12' 04/12/2023 12:58:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8936' , '12' , '1' ) 04/12/2023 12:58: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 ( '89316' , '8935' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '2' , '1' , '19.5' , '15.983606557377' , '22' , '5' , '45.2010' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8935' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8935' , '12' , '1' ) 04/12/2023 12:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89316' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '42.5' , '34.83606557377' , '22' , '5' , '49.2575' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '12' , '1' ) 04/12/2023 12:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89316' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '2' , '2' , '1' , '3' , '2.4590163934426' , '22' , '5' , '6.9540' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '539' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '539' , '12' , '1' ) 04/12/2023 12:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89316' , '19108' , 'PORTATECA COMPLETA - 947' , '2' , '2' , '1' , '21' , '17.213114754098' , '22' , '5' , '48.6780' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19108' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19108' , '12' , '1' ) 04/12/2023 12:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89316' , '12645' , 'TORCIA PROCESSIONE DIAM. 3,2 - 90 CM - 486' , '2' , '2' , '1' , '39' , '31.967213114754' , '22' , '5' , '90.4020' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12645' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12645' , '12' , '1' ) 04/12/2023 12:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89316' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '2' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '19.7030' ) 04/12/2023 12:58:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5976' AND id_supplier = '12' 04/12/2023 12:58:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5976' , '12' , '1' ) 04/12/2023 02:30:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 02:30:20 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' , '139/A' , '2023-12-04' , 'A' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.00' , '114.00' , NOW() , NOW() ) 04/12/2023 02:30: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 = '89317' 04/12/2023 02:30:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89317' 04/12/2023 02:30: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 ( '89317' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '1' , '-1' , '0' , '7.00' , '7' , '' , '0' , '7.00' ) 04/12/2023 02:30: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 ( '89317' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '0' , '10.00' , '10' , '' , '0' , '20.00' ) 04/12/2023 02:30: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 ( '89317' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '0' , '87.00' , '87' , '' , '0' , '87.00' ) 04/12/2023 02:30:27 pm >> DELETE FROM ps_document WHERE id_document = '89317' 04/12/2023 02:30:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89317' 04/12/2023 02:30:41 pm >> DELETE FROM ps_document WHERE id_document = '88792' 04/12/2023 02:30:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '88792' 04/12/2023 02:30:48 pm >> DELETE FROM ps_document WHERE id_document = '88785' 04/12/2023 02:30:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88785' 04/12/2023 02:32:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 04/12/2023 02:32:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', 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 = '893.40', price_tax_excluded = '870.50', date_upd = NOW() WHERE id_document = '89079' 04/12/2023 02:32:11 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 = '89079' 04/12/2023 02:32:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '0' , '21.0000' , '21' , '0' , '0' , '21.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '0' , '34.0000' , '34' , '0' , '0' , '34.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '0' , '18.0000' , '18' , '0' , '0' , '36.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '0' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '0' , '12.9000' , '12.9' , '0' , '0' , '25.80' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'ANGELO 4232' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 04/12/2023 02:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '0' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '4' , '-4' , '0' , '6.0000' , '6' , '0' , '0' , '24.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '2' , '-2' , '0' , '4.8000' , '4.8' , '0' , '0' , '9.60' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20169' , 'croce corpo resina 30x21 - 671/3' , '1' , '-1' , '0' , '18.0000' , '18' , '0' , '0' , '18.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20168' , 'croce corpo resina 22x15 - 671/2' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB ***immacolata' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'QUADRO NUVOLA - QUADRI E QUADRI - € 15,00 CAD****' , '3' , '-3' , '0' , '20.0000' , '20' , '0' , '0' , '60.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13112' , 'SACRO CUORE BABY- 023 SH 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '5' , '-5' , '0' , '1.0000' , '1' , '0' , '0' , '5.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.5000' , '12.5' , '0' , '0' , '25.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.0000' , '5' , '0' , '0' , '10.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '3' , '-3' , '0' , '4.0000' , '4' , '0' , '0' , '12.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '4' , '-4' , '0' , '3.0000' , '3' , '0' , '0' , '12.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '' , '04/12/2023' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 04/12/2023 02:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '87.00' , '71.311475409836' , '22' , '0' , '87.00' ) 04/12/2023 02:35:20 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '3943', document_date = '2023-12-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '12.02', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '664.27', price_tax_excluded = '544.49', date_upd = NOW() WHERE id_document = '89316' 04/12/2023 02:35: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 = '89316' 04/12/2023 02:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89316' 04/12/2023 02:35: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 ( '89316' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '1' , '1' , '91.0000' , '74.590163934426' , '22' , '5' , '105.47' ) 04/12/2023 02:35: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 ( '89316' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '2' , '1' , '14.5000' , '11.885245901639' , '22' , '5' , '33.61' ) 04/12/2023 02:35: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 ( '89316' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '1' , '1' , '21.0000' , '17.213114754098' , '22' , '5' , '24.34' ) 04/12/2023 02:35: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 ( '89316' , '21933' , 'FINTA CANDELA CON CARTUCCIA 8X30- 1180' , '6' , '6' , '1' , '18.5000' , '15.16393442623' , '22' , '5' , '128.65' ) 04/12/2023 02:35: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 ( '89316' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '12' , '12' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '41.72' ) 04/12/2023 02:35: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 ( '89316' , '15351' , 'PORTATECA A BUSTINA - 928' , '2' , '2' , '1' , '24.0000' , '19.672131147541' , '22' , '5' , '55.63' ) 04/12/2023 02:35: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 ( '89316' , '8935' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '2' , '1' , '19.5000' , '15.983606557377' , '22' , '5' , '45.20' ) 04/12/2023 02:35: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 ( '89316' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '42.5000' , '34.83606557377' , '22' , '5' , '49.26' ) 04/12/2023 02:35: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 ( '89316' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '2' , '2' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '6.95' ) 04/12/2023 02:35: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 ( '89316' , '19108' , 'PORTATECA COMPLETA - 947' , '2' , '2' , '1' , '21.0000' , '17.213114754098' , '22' , '5' , '48.68' ) 04/12/2023 02:35: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 ( '89316' , '12645' , 'TORCIA PROCESSIONE DIAM. 3,2 - 90 CM - 486' , '2' , '2' , '1' , '39.0000' , '31.967213114754' , '22' , '5' , '90.40' ) 04/12/2023 02:35: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 ( '89316' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '2' , '1' , '8.5000' , '6.9672131147541' , '22' , '5' , '19.70' ) 04/12/2023 02:38: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 ( '32' , '2202307277' , '2023-11-30' , '' , '0' , '184' , '4679195' , 'VIALE DELLA NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '3795.79' , '3649.80' , NOW() , NOW() ) 04/12/2023 02:38: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 = '89318' 04/12/2023 02:38:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89318' 04/12/2023 02:38: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 ( '89318' , '21899' , 'SACRA BIBBIA cei/uelci ' , '600' , '0' , '3' , '6.083' , '5.8490384615385' , '4' , '0' , '3795.7920' ) 04/12/2023 02:38:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21899' AND id_supplier = '184' 04/12/2023 02:38:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21899' , '184' , '1' ) 04/12/2023 02:39:53 pm >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '183' 04/12/2023 02:39:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '183' 04/12/2023 02:45:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '88774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 04/12/2023 02:45:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3484', document_date = '2023-11-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '302.00', price_tax_excluded = '260.96', date_upd = NOW() WHERE id_document = '88774' 04/12/2023 02:45: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 = '88774' 04/12/2023 02:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88774' 04/12/2023 02:45: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 ( '88774' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.8' , '9.8' , '0' , '0' , '9.80' ) 04/12/2023 02:45: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 ( '88774' , '7962' , 'PETTINA ROMANA NERO - MISTO - 44' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 04/12/2023 02:45: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 ( '88774' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 04/12/2023 02:45: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 ( '88774' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 04/12/2023 02:45: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 ( '88774' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 04/12/2023 02:45: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 ( '88774' , '21439' , 'NATUZZA EVOLO COME BIBBIA - R.I. ZANINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 04/12/2023 02:45: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 ( '88774' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/12/2023 02:46:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3738' AND id_document != '89150' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 04/12/2023 02:46:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3738', document_date = '2023-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 = '29.50', price_tax_excluded = '27.07', date_upd = NOW() WHERE id_document = '89150' 04/12/2023 02:46:02 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 = '89150' 04/12/2023 02:46:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89150' 04/12/2023 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89150' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 04/12/2023 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89150' , '21783' , 'NATALE DEL CUORE - A.M. CANOPI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/12/2023 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89150' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 04/12/2023 02:46:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '89029' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-18') 04/12/2023 02:46:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3658', document_date = '2023-11-18', 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 = '26.00', price_tax_excluded = '26.00', date_upd = NOW() WHERE id_document = '89029' 04/12/2023 02:46:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89029' 04/12/2023 02:46:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89029' 04/12/2023 02:46: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 ( '89029' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.8' , '10.8' , '0' , '0' , '10.80' ) 04/12/2023 02:46: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 ( '89029' , '21882' , 'DIO DI GESU - P. CURTAZ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/12/2023 02:47:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3727' AND id_document != '89136' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 04/12/2023 02:47:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3727', document_date = '2023-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 = '100.00', price_tax_excluded = '94.12', date_upd = NOW() WHERE id_document = '89136' 04/12/2023 02:47:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89136' 04/12/2023 02:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89136' 04/12/2023 02:47: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 ( '89136' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 04/12/2023 02:47: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 ( '89136' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '24.00' ) 04/12/2023 02:47: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 ( '89136' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 04/12/2023 02:47: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 ( '89136' , '15497' , 'CROCE PLEX - 086' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/12/2023 02:47: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 ( '89136' , '21884' , 'ASCOLTARLO ERA RIMANERE - ANNO B - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 04/12/2023 02:48:00 pm >> DELETE FROM ps_document WHERE id_document = '81317' 04/12/2023 02:48:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 04/12/2023 03:03:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:03: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 ( '24' , '50' , '2023-12-04' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , 'RESO AL FORNITORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '360.00' , '295.08' , NOW() , NOW() ) 04/12/2023 03:03: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 = '89319' 04/12/2023 03:03:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89319' 04/12/2023 03:03: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 ( '89319' , '20321' , 'CASULA TESSUTO OPERATO - 65/023957' , '1' , '-1' , '1' , '360' , '295.08196721311' , '22' , '0' , '360.00' ) 04/12/2023 03:03:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20321' AND id_supplier = '143' 04/12/2023 03:03:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20321' , '143' , '1' ) 04/12/2023 03:04:47 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'v5wVPUIuFBzl8dZF' , NOW() , NOW() ) 04/12/2023 03:04:47 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4064' , '1' ) 04/12/2023 03:04:47 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4064' , '2' ) 04/12/2023 03:04:47 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4064' , '3' ) 04/12/2023 03:06:43 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4064' 04/12/2023 03:06:43 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4064' , '10' , '153' , 'PARROCCHIA SANTI PIETRO E PAOLO' , 'BORSARELLI' , 'DON CANDICO' , 'PIAZZA STEFANO FERRERI 2/B' , '' , '12080' , 'VICOFORTE' , '' , '' , '3338612991' , '' , '' , NOW() , NOW() ) 04/12/2023 03:06:43 pm >> UPDATE ps_customer SET email = 'candido.borsarelli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4064' 04/12/2023 03:12:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:12: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 ( '21' , '307' , '2023-12-04' , '' , '4064' , '0' , '4679209' , 'PIAZZA STEFANO FERRERI 2/B 12080 VICOFORTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.74' , '65.74' , NOW() , NOW() ) 04/12/2023 03:12: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 = '89320' 04/12/2023 03:12:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '89320' 04/12/2023 03:12: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 ( '89320' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '100' , '-100' , '0' , '0.50' , '0.5' , '' , '5' , '47.50' ) 04/12/2023 03:12: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 ( '89320' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 04/12/2023 03:12: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 ( '89320' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 04/12/2023 03:12: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 ( '89320' , '14499' , 'COMUNIONE AI MALATI' , '1' , '-1' , '0' , '0.30' , '0.3' , '' , '0' , '0.30' ) 04/12/2023 03:12: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 ( '89320' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '1' , '-1' , '0' , '0.30' , '0.3' , '' , '0' , '0.30' ) 04/12/2023 03:12: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 ( '89320' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 04/12/2023 03:12: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 ( '89320' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 04/12/2023 03:12: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 ( '89320' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 04/12/2023 03:12: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 ( '89320' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 04/12/2023 03:12: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 ( '89320' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/12/2023 03:12:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '89320' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:12:52 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '307', document_date = '2023-12-04', document_letter = '', id_customer = '4064', id_supplier = '', id_address = '4679209', address1 = 'PIAZZA STEFANO FERRERI 2/B 12080 VICOFORTE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '65.74', price_tax_excluded = '65.74', date_upd = NOW() WHERE id_document = '89320' 04/12/2023 03:12: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 = '89320' 04/12/2023 03:12:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '89320' 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '100' , '-100' , '0' , '0.5000' , '0.5' , '0' , '5' , '47.50' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '14499' , 'COMUNIONE AI MALATI' , '1' , '-1' , '0' , '0.3000' , '0.3' , '0' , '0' , '0.30' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '1' , '-1' , '0' , '0.3000' , '0.3' , '0' , '0' , '0.30' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/12/2023 03:12:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89320' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/12/2023 03:44:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:44:34 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' , '3860' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 04/12/2023 03:44:34 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 = '89321' 04/12/2023 03:44:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '89321' 04/12/2023 03:44:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89321' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 04/12/2023 03:50:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:50:08 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' , '3861' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '319.00' , '261.48' , NOW() , NOW() ) 04/12/2023 03:50:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89322' 04/12/2023 03:50:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89322' 04/12/2023 03:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89322' , '21933' , 'FINTA CANDELA CON CARTUCCIA 8X30- 1180' , '6' , '-6' , '1' , '40' , '32.786885245902' , '22' , '0' , '240.00' ) 04/12/2023 03:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89322' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 04/12/2023 03:55:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '89319' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 03:55:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '50', document_date = '2023-12-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', address2 = '', note = 'RESO AL FORNITORE', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89319' 04/12/2023 03:55: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 = '89319' 04/12/2023 03:55:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89319' 04/12/2023 03:55: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 ( '89319' , '20321' , 'CASULA TESSUTO OPERATO - 65/023957' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 04/12/2023 04:02:18 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ROOxw9Qa8nYhegeO' , NOW() , NOW() ) 04/12/2023 04:02:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4065' , '1' ) 04/12/2023 04:02:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4065' , '2' ) 04/12/2023 04:02:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4065' , '3' ) 04/12/2023 04:02:23 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 04/12/2023 04:02:23 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '186' , '1' ) 04/12/2023 04:02:23 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '186' , '1' ) 04/12/2023 04:02:23 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '186' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 04/12/2023 04:19:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 04:19: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' , '3862' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 04/12/2023 04:19: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 = '89323' 04/12/2023 04:19:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89323' 04/12/2023 04:19: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 ( '89323' , '10475' , 'TEALIGHTS X 50 ' , '10' , '-10' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '39.00' ) 04/12/2023 04:19: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 ( '89323' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '1' , '-1' , '1' , '7.2' , '5.9016393442623' , '22' , '0' , '7.20' ) 04/12/2023 04:19: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 ( '89323' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '6' , '-6' , '1' , '2.30' , '1.8852459016393' , '22' , '0' , '13.80' ) 04/12/2023 04:33:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '89320' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 04:33:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '307', document_date = '2023-12-04', document_letter = '', id_customer = '4064', id_supplier = '', id_address = '4679209', address1 = 'PIAZZA STEFANO FERRERI 2/B 12080 VICOFORTE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '113.24', price_tax_excluded = '113.24', date_upd = NOW() WHERE id_document = '89320' 04/12/2023 04:33:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89320' 04/12/2023 04:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89320' 04/12/2023 04:33: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 ( '89320' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '200' , '-200' , '0' , '0.5000' , '0.5' , '' , '5' , '95.00' ) 04/12/2023 04:33: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 ( '89320' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 04/12/2023 04:33: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 ( '89320' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 04/12/2023 04:33: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 ( '89320' , '14499' , 'COMUNIONE AI MALATI' , '1' , '-1' , '0' , '0.3000' , '0.3' , '0' , '0' , '0.30' ) 04/12/2023 04:33: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 ( '89320' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '1' , '-1' , '0' , '0.3000' , '0.3' , '0' , '0' , '0.30' ) 04/12/2023 04:33: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 ( '89320' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 04/12/2023 04:33: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 ( '89320' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 04/12/2023 04:33: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 ( '89320' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/12/2023 04:33: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 ( '89320' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/12/2023 04:33: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 ( '89320' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/12/2023 04:40:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 04:40:45 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' , '3863' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 04/12/2023 04:40: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 = '89324' 04/12/2023 04:40:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89324' 04/12/2023 04:40: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 ( '89324' , '21895' , 'MEDJUGORJE E LA SPERANZA - PADRE LIVIO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/12/2023 05:09:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 05:09:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3864' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 04/12/2023 05:09:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89325' 04/12/2023 05:09:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89325' 04/12/2023 05:09:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89325' , '14132' , 'SANTA BARBARA - 9' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 04/12/2023 05:33:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '114' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 05:33: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 ( '21' , '114' , '2023-12-04' , '' , '3501' , '0' , '4670217' , 'VIA CAPRILE, 45 80071 ANACAPRI' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 04/12/2023 05:33: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 = '13761' 04/12/2023 05:33:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '13761' 04/12/2023 05:33: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 ( '13761' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/12/2023 05:41:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 05:41: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' , '3865' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.30' , '8.40' , NOW() , NOW() ) 04/12/2023 05:41: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 = '89326' 04/12/2023 05:41:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89326' 04/12/2023 05:41: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 ( '89326' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 04/12/2023 05:41: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 ( '89326' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/12/2023 05:41: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 ( '89326' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 04/12/2023 06:10:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 06:10: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 ( '21' , '308' , '2023-12-04' , '' , '1237' , '0' , '4679207' , 'VIA MILANO 11 97019 VITTORIA' , '' , '' , '7.3' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '315.00' , '315.00' , NOW() , NOW() ) 04/12/2023 06:10: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 = '89327' 04/12/2023 06:10:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89327' 04/12/2023 06:10: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 ( '89327' , '3511' , 'DIO PARLA ALL\'UOMO' , '10' , '-10' , '4' , '12.00' , '12' , '0' , '15' , '102.00' ) 04/12/2023 06:10: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 ( '89327' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '10' , '-10' , '4' , '9.00' , '9' , '0' , '15' , '76.50' ) 04/12/2023 06:10: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 ( '89327' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '15' , '21.25' ) 04/12/2023 06:10: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 ( '89327' , '12253' , 'MIO LIBRO DI PREGHIERE' , '40' , '-40' , '4' , '2.80' , '2.8' , '0' , '15' , '95.20' ) 04/12/2023 06:10: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 ( '89327' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '50' , '-50' , '0' , '0.30' , '0.3' , '' , '15' , '12.75' ) 04/12/2023 06:24:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 06:24:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3866' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.21' , '26.31' , NOW() , NOW() ) 04/12/2023 06:24:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89328' 04/12/2023 06:24:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89328' 04/12/2023 06:24: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 ( '89328' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 04/12/2023 06:24: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 ( '89328' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 04/12/2023 06:24: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 ( '89328' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/12/2023 06:27:25 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/12/2023 06:27:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21934' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:27:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21934' , '1' , '1' , '2' , NOW() , NOW() ) 04/12/2023 06:27:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21934' , '0' , '1' , '0' , '0' ) 04/12/2023 06:29:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281368163' AND id_product != '21934' AND ean13 != '' 04/12/2023 06:29:16 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9791281368163', date_upd = NOW() WHERE id_product = '21934' 04/12/2023 06:29:16 pm >> UPDATE ps_product_lang SET name = 'TI VOGLIO BENE - PAPA FRANCESCO', description = '' WHERE id_product = '21934' 04/12/2023 06:29:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '21934' 04/12/2023 06:29:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '511', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21934' 04/12/2023 06:29:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '21934' 04/12/2023 06:29:20 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 = '21934' 04/12/2023 06:29:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21935' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:29:20 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 '21935' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21934' 04/12/2023 06:29:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21935' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21934' 04/12/2023 06:30:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-04') 04/12/2023 06:30:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3867' , '2023-12-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 04/12/2023 06:30:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89329' 04/12/2023 06:30:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89329' 04/12/2023 06:30:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89329' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17.5' , '17.5' , '0' , '0' , '17.50' ) 04/12/2023 06:33:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842832713' AND id_product != '21935' AND ean13 != '' 04/12/2023 06:33:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842832713', date_upd = NOW() WHERE id_product = '21935' 04/12/2023 06:33:44 pm >> UPDATE ps_product_lang SET name = 'MARIGOLD E ROSE', description = '' WHERE id_product = '21935' 04/12/2023 06:33:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21935' 04/12/2023 06:33:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '459', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21935' 04/12/2023 06:33:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '21935' 04/12/2023 06:33:45 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 = '21935' 04/12/2023 06:33:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21936' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:33:45 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 '21936' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21935' 04/12/2023 06:33:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21936' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21935' 04/12/2023 06:34:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807884603' AND id_product != '21936' AND ean13 != '' 04/12/2023 06:34:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807884603', date_upd = NOW() WHERE id_product = '21936' 04/12/2023 06:34:19 pm >> UPDATE ps_product_lang SET name = 'KITCHEN', description = '' WHERE id_product = '21936' 04/12/2023 06:34:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21936' 04/12/2023 06:34:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '359', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21936' 04/12/2023 06:34:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '21936' 04/12/2023 06:34:20 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 = '21936' 04/12/2023 06:34:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21937' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:34:20 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 '21937' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21936' 04/12/2023 06:34:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21937' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21936' 04/12/2023 06:35:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858152577' AND id_product != '21937' AND ean13 != '' 04/12/2023 06:35:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858152577', date_upd = NOW() WHERE id_product = '21937' 04/12/2023 06:35:15 pm >> UPDATE ps_product_lang SET name = 'ALL\'ARME ALL\'ARME I PRIORI FANNO CARNE!', description = '' WHERE id_product = '21937' 04/12/2023 06:35:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21937' 04/12/2023 06:35:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '350', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21937' 04/12/2023 06:35:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '21937' 04/12/2023 06:35:16 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 = '21937' 04/12/2023 06:35:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21938' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:35:16 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 '21938' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21937' 04/12/2023 06:35:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21938' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21937' 04/12/2023 06:35:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280229670' AND id_product != '21938' AND ean13 != '' 04/12/2023 06:35:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280229670', date_upd = NOW() WHERE id_product = '21938' 04/12/2023 06:35:47 pm >> UPDATE ps_product_lang SET name = 'DONNE CHE PENSANO TROPPO', description = '' WHERE id_product = '21938' 04/12/2023 06:35:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '21938' 04/12/2023 06:35:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '511', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21938' 04/12/2023 06:35:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '21938' 04/12/2023 06:35:48 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 = '21938' 04/12/2023 06:35:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21939' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:35:48 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 '21939' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21938' 04/12/2023 06:35:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21939' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21938' 04/12/2023 06:36:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845298752' AND id_product != '21939' AND ean13 != '' 04/12/2023 06:36:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845298752', date_upd = NOW() WHERE id_product = '21939' 04/12/2023 06:36:10 pm >> UPDATE ps_product_lang SET name = 'HOMO DEUS', description = '' WHERE id_product = '21939' 04/12/2023 06:36:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21939' 04/12/2023 06:36:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21939' 04/12/2023 06:36:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '21939' 04/12/2023 06:36:10 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 = '21939' 04/12/2023 06:36:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21940' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:36:10 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 '21940' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21939' 04/12/2023 06:36:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21940' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21939' 04/12/2023 06:36:48 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 04/12/2023 06:36:48 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '532' , '1' ) 04/12/2023 06:36:48 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '532' , '2' ) 04/12/2023 06:36:48 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '532' , '3' ) 04/12/2023 06:36:48 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '532' , '1' , 'NERI POZZA' , LOWER('NERI-POZZA') ) 04/12/2023 06:36:48 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '532' , '1' , '0' ) 04/12/2023 06:36:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788854523357' AND id_product != '21940' AND ean13 != '' 04/12/2023 06:36:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788854523357', date_upd = NOW() WHERE id_product = '21940' 04/12/2023 06:36:56 pm >> UPDATE ps_product_lang SET name = 'CARO PIER PAOLO', description = '' WHERE id_product = '21940' 04/12/2023 06:36:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21940' 04/12/2023 06:36:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '532', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21940' 04/12/2023 06:36:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '21940' 04/12/2023 06:36:57 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 = '21940' 04/12/2023 06:36:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21941' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:36:57 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 '21941' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21940' 04/12/2023 06:36:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21941' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21940' 04/12/2023 06:37:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806257644' AND id_product != '21941' AND ean13 != '' 04/12/2023 06:37:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806257644', date_upd = NOW() WHERE id_product = '21941' 04/12/2023 06:37:18 pm >> UPDATE ps_product_lang SET name = 'SACRO MINORE', description = '' WHERE id_product = '21941' 04/12/2023 06:37:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21941' 04/12/2023 06:37:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '278', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21941' 04/12/2023 06:37:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21941' 04/12/2023 06:37:19 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 = '21941' 04/12/2023 06:37:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21942' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:37:19 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 '21942' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21941' 04/12/2023 06:37:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21942' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21941' 04/12/2023 06:37:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845298318' AND id_product != '21942' AND ean13 != '' 04/12/2023 06:37:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845298318', date_upd = NOW() WHERE id_product = '21942' 04/12/2023 06:37:42 pm >> UPDATE ps_product_lang SET name = 'STORIA DELLA BELLEZZA', description = '' WHERE id_product = '21942' 04/12/2023 06:37:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21942' 04/12/2023 06:37:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21942' 04/12/2023 06:37:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '21942' 04/12/2023 06:37:43 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 = '21942' 04/12/2023 06:37:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21943' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:37:43 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 '21943' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21942' 04/12/2023 06:37:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21943' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21942' 04/12/2023 06:38:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845922855' AND id_product != '21943' AND ean13 != '' 04/12/2023 06:38:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845922855', date_upd = NOW() WHERE id_product = '21943' 04/12/2023 06:38:23 pm >> UPDATE ps_product_lang SET name = 'IL MARE NON BAGNA NAPOLI', description = '' WHERE id_product = '21943' 04/12/2023 06:38:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21943' 04/12/2023 06:38:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21943' 04/12/2023 06:38:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '21943' 04/12/2023 06:38:24 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 = '21943' 04/12/2023 06:38:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21944' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:38:24 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 '21944' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21943' 04/12/2023 06:38:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21944' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21943' 04/12/2023 06:38:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845936258' AND id_product != '21944' AND ean13 != '' 04/12/2023 06:38:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845936258', date_upd = NOW() WHERE id_product = '21944' 04/12/2023 06:38:47 pm >> UPDATE ps_product_lang SET name = 'APPUNTI 1942-1993', description = '' WHERE id_product = '21944' 04/12/2023 06:38:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21944' 04/12/2023 06:38:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21944' 04/12/2023 06:38:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '21944' 04/12/2023 06:38:48 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 = '21944' 04/12/2023 06:38:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21945' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:38:48 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 '21945' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21944' 04/12/2023 06:38:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21945' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21944' 04/12/2023 06:39:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806226237' AND id_product != '21945' AND ean13 != '' 04/12/2023 06:39:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806226237', date_upd = NOW() WHERE id_product = '21945' 04/12/2023 06:39:33 pm >> UPDATE ps_product_lang SET name = ' 1 Q 84 LIBRO 3', description = '' WHERE id_product = '21945' 04/12/2023 06:39:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.5' WHERE id_product = '21945' 04/12/2023 06:39:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.5', id_tax_rules_group = '4', id_category_default = '278', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21945' 04/12/2023 06:39:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '21945' 04/12/2023 06:39:34 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 = '21945' 04/12/2023 06:39:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21946' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:39:34 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 '21946' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21945' 04/12/2023 06:39:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21946' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21945' 04/12/2023 06:40:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842822783' AND id_product != '21946' AND ean13 != '' 04/12/2023 06:40:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842822783', date_upd = NOW() WHERE id_product = '21946' 04/12/2023 06:40:03 pm >> UPDATE ps_product_lang SET name = 'SALUTZ 1984-1986', description = '' WHERE id_product = '21946' 04/12/2023 06:40:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21946' 04/12/2023 06:40:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '459', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21946' 04/12/2023 06:40:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '21946' 04/12/2023 06:40:04 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 = '21946' 04/12/2023 06:40:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21947' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:40:05 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 '21947' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21946' 04/12/2023 06:40:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21947' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21946' 04/12/2023 06:40:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845911316' AND id_product != '21947' AND ean13 != '' 04/12/2023 06:40:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845911316', date_upd = NOW() WHERE id_product = '21947' 04/12/2023 06:40:29 pm >> UPDATE ps_product_lang SET name = 'IL GIOCO DEGLI OCCHI', description = '' WHERE id_product = '21947' 04/12/2023 06:40:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21947' 04/12/2023 06:40:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21947' 04/12/2023 06:40:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '21947' 04/12/2023 06:40:31 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 = '21947' 04/12/2023 06:40:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21948' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:40:31 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 '21948' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21947' 04/12/2023 06:40:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21948' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21947' 04/12/2023 06:40:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845937538' AND id_product != '21948' AND ean13 != '' 04/12/2023 06:40:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845937538', date_upd = NOW() WHERE id_product = '21948' 04/12/2023 06:40:59 pm >> UPDATE ps_product_lang SET name = 'BUCHI BIANCHI', description = '' WHERE id_product = '21948' 04/12/2023 06:41:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21948' 04/12/2023 06:41:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21948' 04/12/2023 06:41:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '21948' 04/12/2023 06:41:01 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 = '21948' 04/12/2023 06:41:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21949' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:41:01 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 '21949' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21948' 04/12/2023 06:41:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21949' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21948' 04/12/2023 06:41:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845924002' AND id_product != '21949' AND ean13 != '' 04/12/2023 06:41:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845924002', date_upd = NOW() WHERE id_product = '21949' 04/12/2023 06:41:18 pm >> UPDATE ps_product_lang SET name = 'LA GIOIA DI SCRIVERE', description = '' WHERE id_product = '21949' 04/12/2023 06:41:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21949' 04/12/2023 06:41:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21949' 04/12/2023 06:41:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21949' 04/12/2023 06:41:19 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 = '21949' 04/12/2023 06:41:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21950' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:41:19 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 '21950' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21949' 04/12/2023 06:41:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21950' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21949' 04/12/2023 06:41:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817140973' AND id_product != '21950' AND ean13 != '' 04/12/2023 06:41:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788817140973', date_upd = NOW() WHERE id_product = '21950' 04/12/2023 06:41:53 pm >> UPDATE ps_product_lang SET name = 'VITA MIA DACIA MARAINI', description = '' WHERE id_product = '21950' 04/12/2023 06:41:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21950' 04/12/2023 06:41:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '113', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21950' 04/12/2023 06:41:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '21950' 04/12/2023 06:41: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 = '21950' 04/12/2023 06:41:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21951' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:41: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 '21951' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21950' 04/12/2023 06:41:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21951' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21950' 04/12/2023 06:42:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807034817' AND id_product != '21951' AND ean13 != '' 04/12/2023 06:42:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807034817', date_upd = NOW() WHERE id_product = '21951' 04/12/2023 06:42:35 pm >> UPDATE ps_product_lang SET name = 'VERSO IL PARADISO', description = '' WHERE id_product = '21951' 04/12/2023 06:42:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '21951' 04/12/2023 06:42:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '359', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21951' 04/12/2023 06:42:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21951' 04/12/2023 06:42:36 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 = '21951' 04/12/2023 06:42:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21952' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:42:36 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 '21952' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21951' 04/12/2023 06:42:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21952' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21951' 04/12/2023 06:43:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845938023' AND id_product != '21952' AND ean13 != '' 04/12/2023 06:43:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845938023', date_upd = NOW() WHERE id_product = '21952' 04/12/2023 06:43:08 pm >> UPDATE ps_product_lang SET name = 'METAFISICA CONCRETA', description = '' WHERE id_product = '21952' 04/12/2023 06:43:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '21952' 04/12/2023 06:43:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21952' 04/12/2023 06:43:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '21952' 04/12/2023 06:43:09 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 = '21952' 04/12/2023 06:43:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21953' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:43:09 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 '21953' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21952' 04/12/2023 06:43:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21953' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21952' 04/12/2023 06:43:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804764878' AND id_product != '21953' AND ean13 != '' 04/12/2023 06:43:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804764878', date_upd = NOW() WHERE id_product = '21953' 04/12/2023 06:43:39 pm >> UPDATE ps_product_lang SET name = 'FA BENE O FA MALE?', description = '' WHERE id_product = '21953' 04/12/2023 06:43:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21953' 04/12/2023 06:43:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21953' 04/12/2023 06:43:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '21953' 04/12/2023 06:43:40 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 = '21953' 04/12/2023 06:43:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21954' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:43:40 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 '21954' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21953' 04/12/2023 06:43:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21954' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21953' 04/12/2023 06:44:39 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 04/12/2023 06:44:39 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '533' , '1' ) 04/12/2023 06:44:39 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '533' , '2' ) 04/12/2023 06:44:39 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '533' , '3' ) 04/12/2023 06:44:39 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '533' , '1' , 'HARPER COLLINS' , LOWER('HARPER-COLLINS') ) 04/12/2023 06:44:39 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '533' , '1' , '0' ) 04/12/2023 06:44:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259853103' AND id_product != '21954' AND ean13 != '' 04/12/2023 06:44:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259853103', date_upd = NOW() WHERE id_product = '21954' 04/12/2023 06:44:46 pm >> UPDATE ps_product_lang SET name = 'QUANDO ERAVAMO I PADRONI DEL MONDO', description = '' WHERE id_product = '21954' 04/12/2023 06:44:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21954' 04/12/2023 06:44:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '533', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21954' 04/12/2023 06:44:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '21954' 04/12/2023 06:44:47 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 = '21954' 04/12/2023 06:44:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21955' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:44:47 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 '21955' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21954' 04/12/2023 06:44:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21955' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21954' 04/12/2023 06:45:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804776444' AND id_product != '21955' AND ean13 != '' 04/12/2023 06:45:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804776444', date_upd = NOW() WHERE id_product = '21955' 04/12/2023 06:45:19 pm >> UPDATE ps_product_lang SET name = 'LA SPERANZA AFRICANA', description = '' WHERE id_product = '21955' 04/12/2023 06:45:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21955' 04/12/2023 06:45:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21955' 04/12/2023 06:45:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '21955' 04/12/2023 06:45:20 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 = '21955' 04/12/2023 06:45:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21956' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:45:20 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 '21956' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21955' 04/12/2023 06:45:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21956' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21955' 04/12/2023 06:45:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806216948' AND id_product != '21956' AND ean13 != '' 04/12/2023 06:45:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806216948', date_upd = NOW() WHERE id_product = '21956' 04/12/2023 06:45:48 pm >> UPDATE ps_product_lang SET name = 'KAFKA SULLA SPIAGGIA', description = '' WHERE id_product = '21956' 04/12/2023 06:45:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.5' WHERE id_product = '21956' 04/12/2023 06:45:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.5', id_tax_rules_group = '4', id_category_default = '278', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21956' 04/12/2023 06:45:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21956' 04/12/2023 06:45:49 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 = '21956' 04/12/2023 06:45:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21957' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:45:49 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 '21957' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21956' 04/12/2023 06:45:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21957' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21956' 04/12/2023 06:46:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845916250' AND id_product != '21957' AND ean13 != '' 04/12/2023 06:46:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845916250', date_upd = NOW() WHERE id_product = '21957' 04/12/2023 06:46:33 pm >> UPDATE ps_product_lang SET name = 'L\'UOMO CHE SCAMBIO\' SUA MOGLIE PER UN CAPPELLO', description = '' WHERE id_product = '21957' 04/12/2023 06:46:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21957' 04/12/2023 06:46:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21957' 04/12/2023 06:46:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '21957' 04/12/2023 06:46:33 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 = '21957' 04/12/2023 06:46:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21958' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:46:33 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 '21958' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21957' 04/12/2023 06:46:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21958' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21957' 04/12/2023 06:47:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804752950' AND id_product != '21958' AND ean13 != '' 04/12/2023 06:47:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804752950', date_upd = NOW() WHERE id_product = '21958' 04/12/2023 06:47:08 pm >> UPDATE ps_product_lang SET name = 'L\'ERA DELL\'INTELLIGENZA ARTIFICIALE', description = '' WHERE id_product = '21958' 04/12/2023 06:47:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21958' 04/12/2023 06:47:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21958' 04/12/2023 06:47:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '21958' 04/12/2023 06:47:09 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 = '21958' 04/12/2023 06:47:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21959' , '1' , '' , 'nuovo-prodotto' ) 04/12/2023 06:47:09 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 '21959' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21958' 04/12/2023 06:47:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21959' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21958'