30/09/2024 09:39:08 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4118' 30/09/2024 09:39:08 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 ( '4118' , '10' , '126' , '' , 'DARBAZ' , 'ENRICA' , 'VIA GIARDINI 37' , '' , '11029' , 'VERRES' , '' , '' , '3482933941' , '' , '' , NOW() , NOW() ) 30/09/2024 09:39:08 am >> UPDATE ps_customer SET email = 'saraja80@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4118' 30/09/2024 10:49:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 10:49:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2840' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 30/09/2024 10:49:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93348' 30/09/2024 10:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93348' 30/09/2024 10:49:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93348' , '20515' , 'DECINA ULIVO - 04/7-D' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 30/09/2024 10:55:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2356' AND id_document != '92734' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 30/09/2024 10:55:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2356', document_date = '2024-07-26', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '92734' 30/09/2024 10:55:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92734' 30/09/2024 10:55:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92734' 30/09/2024 10:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92734' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 30/09/2024 10:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92734' , '16312' , 'DECINA LEGNO CHIARO' , '5' , '-5' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.50' ) 30/09/2024 10:55:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2632' AND id_document != '93065' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 30/09/2024 10:55:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2632', document_date = '2024-09-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.90', price_tax_excluded = '3.20', date_upd = NOW() WHERE id_document = '93065' 30/09/2024 10:55:26 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 = '93065' 30/09/2024 10:55:26 am >> DELETE FROM ps_document_detail WHERE id_document = '93065' 30/09/2024 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93065' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '1' , '-1' , '1' , '2.6000' , '2.1311475409836' , '22' , '0' , '2.60' ) 30/09/2024 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93065' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 30/09/2024 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93065' , '16312' , 'DECINA LEGNO CHIARO' , '2' , '-2' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '1.20' ) 30/09/2024 10:56:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2757' AND id_document != '93233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 30/09/2024 10:56:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2757', document_date = '2024-09-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 = '5.50', price_tax_excluded = '4.51', date_upd = NOW() WHERE id_document = '93233' 30/09/2024 10:56:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93233' 30/09/2024 10:56:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93233' 30/09/2024 10:56: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 ( '93233' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/09/2024 10:56: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 ( '93233' , '16312' , 'DECINA LEGNO CHIARO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 30/09/2024 11:08:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 11:08:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2841' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.55' , '28.22' , NOW() , NOW() ) 30/09/2024 11:08:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93349' 30/09/2024 11:08:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93349' 30/09/2024 11:08: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 ( '93349' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 30/09/2024 11:08: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 ( '93349' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/09/2024 11:35:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 11:35:27 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' , '2842' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.00' , '143.22' , NOW() , NOW() ) 30/09/2024 11:35: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 = '93350' 30/09/2024 11:35:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93350' 30/09/2024 11:35: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 ( '93350' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '3' , '-3' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '39.00' ) 30/09/2024 11:35: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 ( '93350' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/09/2024 11:35: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 ( '93350' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '100' , '-100' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '70.00' ) 30/09/2024 11:35:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93350' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 30/09/2024 11:35:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93350' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 30/09/2024 11:39:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 11:39:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2843' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '14.65' , NOW() , NOW() ) 30/09/2024 11:39:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93351' 30/09/2024 11:39:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93351' 30/09/2024 11:39:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93351' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 30/09/2024 11:39:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93351' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 30/09/2024 11:59:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 11:59:32 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' , '2844' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 30/09/2024 11:59:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93352' 30/09/2024 11:59:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93352' 30/09/2024 11:59:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93352' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 30/09/2024 12:14:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 30/09/2024 12:14:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.30', price_tax_excluded = '4.30', date_upd = NOW() WHERE id_document = '89846' 30/09/2024 12:14:44 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 = '89846' 30/09/2024 12:14:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 30/09/2024 12:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/09/2024 12:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 30/09/2024 12:16:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2361' AND id_document != '92741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 30/09/2024 12:16:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2361', document_date = '2024-07-26', 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.75', price_tax_excluded = '23.75', date_upd = NOW() WHERE id_document = '92741' 30/09/2024 12:16:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92741' 30/09/2024 12:16:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92741' 30/09/2024 12:16:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92741' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.55' , '0.55' , '0' , '0' , '1.10' ) 30/09/2024 12:16:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92741' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 30/09/2024 12:16:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92741' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/09/2024 12:17:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '92752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 30/09/2024 12:17:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2370', document_date = '2024-07-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '255.00', price_tax_excluded = '212.79', date_upd = NOW() WHERE id_document = '92752' 30/09/2024 12:17:00 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 = '92752' 30/09/2024 12:17:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92752' 30/09/2024 12:17:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '54.00' ) 30/09/2024 12:17:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 30/09/2024 12:17:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140.1000' , '114.83606557377' , '22' , '0' , '140.10' ) 30/09/2024 12:17:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/09/2024 12:17:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 30/09/2024 12:17:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92752' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 30/09/2024 12:45:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 12:45: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 ( '11' , '2845' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 30/09/2024 12:45: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 = '93353' 30/09/2024 12:45:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93353' 30/09/2024 12:45: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 ( '93353' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '6' , '-6' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '40.20' ) 30/09/2024 12:45: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 ( '93353' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '23.40' ) 30/09/2024 12:45: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 ( '93353' , '21853' , 'CROCE MOGANO CON BASE - CLB263ARG ' , '1' , '-1' , '1' , '32.50' , '26.639344262295' , '22' , '0' , '32.50' ) 30/09/2024 12:45: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 ( '93353' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/09/2024 12:45: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 ( '93353' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 30/09/2024 12:45: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 ( '93353' , '19733' , 'S. GIUDA TADDEO BABY - 023SDT9' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 30/09/2024 12:49:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 12:49: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' , '2846' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.10' , '4.10' , NOW() , NOW() ) 30/09/2024 12:49: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 = '93354' 30/09/2024 12:49:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '93354' 30/09/2024 12:49: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 ( '93354' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 30/09/2024 12:49: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 ( '93354' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 30/09/2024 12:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 12:57:55 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' , '2847' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.12' , '16.12' , NOW() , NOW() ) 30/09/2024 12:57:55 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 = '93355' 30/09/2024 12:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93355' 30/09/2024 12:57:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93355' , '7442' , 'PANE QUOTIDIANO' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 30/09/2024 12:57:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93355' , '21008' , 'GIONA E LA BALENA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 30/09/2024 12:57:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93355' , '21009' , 'DANIELE E I LEONI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 30/09/2024 12:57:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93355' , '22388' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 30/09/2024 02:59:07 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/09/2024 02:59:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22972' , '1' , '' , 'nuovo-prodotto' ) 30/09/2024 02:59:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22972' , '1' , '1' , '2' , NOW() , NOW() ) 30/09/2024 02:59:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22972' , '0' , '1' , '0' , '0' ) 30/09/2024 02:59:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253490' AND id_product != '22972' AND ean13 != '' 30/09/2024 02:59:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791281253490', date_upd = NOW() WHERE id_product = '22972' 30/09/2024 03:00:00 pm >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025', description = '' WHERE id_product = '22972' 30/09/2024 03:00:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '22972' 30/09/2024 03:00:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22972' 30/09/2024 03:00:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '22972' 30/09/2024 03:00:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2847' AND id_document != '93355' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 03:00:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2847', document_date = '2024-09-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 = '16.12', price_tax_excluded = '16.12', date_upd = NOW() WHERE id_document = '93355' 30/09/2024 03:00: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 = '93355' 30/09/2024 03:00:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93355' 30/09/2024 03:00: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 ( '93355' , '7442' , 'PANE QUOTIDIANO' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 30/09/2024 03:00: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 ( '93355' , '21008' , 'GIONA E LA BALENA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 30/09/2024 03:00: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 ( '93355' , '21009' , 'DANIELE E I LEONI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 30/09/2024 03:00: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 ( '93355' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 30/09/2024 03:00:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/09/2024 03:00:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22973' , '1' , '' , 'nuovo-prodotto' ) 30/09/2024 03:00:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22973' , '1' , '1' , '2' , NOW() , NOW() ) 30/09/2024 03:00:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22973' , '0' , '1' , '0' , '0' ) 30/09/2024 03:01:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827005033' AND id_product != '22973' AND ean13 != '' 30/09/2024 03:01:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788827005033', date_upd = NOW() WHERE id_product = '22973' 30/09/2024 03:01:13 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE DELLA FRATERNITA\'', description = '' WHERE id_product = '22973' 30/09/2024 03:01:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '22973' 30/09/2024 03:01:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '186', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22973' 30/09/2024 03:01:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22973' 30/09/2024 03:01:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827005033' AND id_product != '22973' AND ean13 != '' 30/09/2024 03:01:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788827005033', date_upd = NOW() WHERE id_product = '22973' 30/09/2024 03:01:48 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE DELLA FRATERNITA\'', description = '' WHERE id_product = '22973' 30/09/2024 03:01:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '22973' 30/09/2024 03:01:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '186', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22973' 30/09/2024 03:01:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22973' 30/09/2024 03:01: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 = '22973' 30/09/2024 03:01:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22974' , '1' , '' , 'nuovo-prodotto' ) 30/09/2024 03:01: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 '22974' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22973' 30/09/2024 03:01:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22974' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22973' 30/09/2024 03:03:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831502030' AND id_product != '2048' AND ean13 != '' 30/09/2024 03:03:15 pm >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788831502030', date_upd = NOW() WHERE id_product = '2048' 30/09/2024 03:03:15 pm >> UPDATE ps_product_lang SET name = 'CHRISTIFIDELES LAICI', description = '' WHERE id_product = '2048' 30/09/2024 03:03:15 pm >> UPDATE ps_product SET wholesale_price = '2.35', on_sale = '0', price = '4' WHERE id_product = '2048' 30/09/2024 03:03:15 pm >> UPDATE ps_product_shop SET wholesale_price = '2.35', price = '4', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2048' 30/09/2024 03:03:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '2048' 30/09/2024 03:04:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247575' AND id_product != '8327' AND ean13 != '' 30/09/2024 03:04:53 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/5', ean13 = '9788884247575', date_upd = NOW() WHERE id_product = '8327' 30/09/2024 03:04:53 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE A CARATTERI GRANDI', description = '' WHERE id_product = '8327' 30/09/2024 03:04:53 pm >> UPDATE ps_product SET wholesale_price = '3.49', on_sale = '0', price = '7' WHERE id_product = '8327' 30/09/2024 03:04:53 pm >> UPDATE ps_product_shop SET wholesale_price = '3.49', price = '7', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8327' 30/09/2024 03:04:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '8327' 30/09/2024 03:06:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 30/09/2024 03:06:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.30', price_tax_excluded = '18.30', date_upd = NOW() WHERE id_document = '89846' 30/09/2024 03:06: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 = '89846' 30/09/2024 03:06:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 30/09/2024 03:06: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 ( '89846' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/09/2024 03:06: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 30/09/2024 03:06: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 ( '89846' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '2' , '-2' , '4' , '7.00' , '7' , '0' , '0' , '14.00' ) 30/09/2024 03:09:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '675379' , '2024-09-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.51' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '129.50' , '129.50' , NOW() , NOW() ) 30/09/2024 03:09: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 = '93356' 30/09/2024 03:09:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93356' 30/09/2024 03:09: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 ( '93356' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '12' , '12' , '4' , '6.00' , '6' , '0' , '30' , '50.4000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22972' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22972' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '1' , '4' , '6.00' , '6' , '0' , '100' , '0.0000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22972' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22972' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '22973' , 'PREGHIERE DELLA FRATERNITA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '30' , '4.2000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22973' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22973' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '2048' , 'CHRISTIFIDELES LAICI' , '1' , '1' , '4' , '4.00' , '4' , '0' , '30' , '2.8000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '8327' , 'PREGHIERE A CARATTERI GRANDI' , '2' , '2' , '4' , '7.00' , '7' , '0' , '30' , '9.8000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8327' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8327' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '3' , '3' , '4' , '7.00' , '7' , '0' , '30' , '14.7000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10794' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10794' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22881' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22881' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '22564' , 'PAOLO E LEVANGELO DELLA SPERANZA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22564' AND id_supplier = '7' 30/09/2024 03:09:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22564' , '7' , '1' ) 30/09/2024 03:09: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 ( '93356' , '22905' , 'DESTINATI ALLA VITA - V. PAGLIA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 30/09/2024 03:09:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22905' AND id_supplier = '7' 30/09/2024 03:09:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22905' , '7' , '1' ) 30/09/2024 03:09:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93356' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '30' , '5.4600' ) 30/09/2024 03:09:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22813' AND id_supplier = '7' 30/09/2024 03:09:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22813' , '7' , '1' ) 30/09/2024 03:09:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93356' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '3' , '3' , '4' , '1.00' , '1' , '0' , '30' , '2.1000' ) 30/09/2024 03:09:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22893' AND id_supplier = '7' 30/09/2024 03:09:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22893' , '7' , '1' ) 30/09/2024 03:39:12 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' , '2024-FV001435' , '2024-09-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '29.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3511.68' , '3511.68' , NOW() , NOW() ) 30/09/2024 03:39:12 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 = '93357' 30/09/2024 03:39:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93357' 30/09/2024 03:39: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 ( '93357' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 30/09/2024 03:39:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 30/09/2024 03:39:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 30/09/2024 03:39: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 ( '93357' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 30/09/2024 03:39:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 30/09/2024 03:39:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 30/09/2024 03:39: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 ( '93357' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 30/09/2024 03:39:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 30/09/2024 03:39:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 30/09/2024 03:39: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 ( '93357' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '5' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '65.00' ) 30/09/2024 03:39:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 30/09/2024 03:39:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '22860' , 'ELOGIO DI UNA GUERRIERA - J. CHERON' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '45' , '8.80' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22860' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22860' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '2' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '14.30' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15024' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15024' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '26.00' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '2' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '14.30' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15024' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15024' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '4.68' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22192' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22192' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '5444' , 'IO SONO CON VOI - CAT.' , '250' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '962.50' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 30/09/2024 03:39:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '11193' , 'VENITE CON ME CAT.' , '350' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '1347.50' ) 30/09/2024 03:39:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 30/09/2024 03:39:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '0' , '4' , '130.0000' , '130' , '0' , '30' , '91.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17330' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17330' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '21.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 30/09/2024 03:39:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93357' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 30/09/2024 03:39:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 30/09/2024 03:39:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 30/09/2024 04:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 04:31: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 ( '11' , '2848' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 30/09/2024 04:31: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 = '93358' 30/09/2024 04:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93358' 30/09/2024 04:31: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 ( '93358' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 30/09/2024 04:31: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 ( '93358' , '20646' , 'STOLA DIACONALE - 881D' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 30/09/2024 04:31: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 ( '93358' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/09/2024 05:34:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 05:34:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2849' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.70' , '4.70' , NOW() , NOW() ) 30/09/2024 05:34: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 = '93359' 30/09/2024 05:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93359' 30/09/2024 05:34: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 ( '93359' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 30/09/2024 05:34: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 ( '93359' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 30/09/2024 05:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 05:46: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' , '2850' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.65' , '112.65' , NOW() , NOW() ) 30/09/2024 05:46: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 = '93360' 30/09/2024 05:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93360' 30/09/2024 05:46: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 ( '93360' , '22915' , 'CINQUE PANI DORZO 2025' , '15' , '-15' , '4' , '7.90' , '7.9' , '0' , '5' , '112.65' ) 30/09/2024 05:50:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 05:50:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2851' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.25' , '7.62' , NOW() , NOW() ) 30/09/2024 05:50:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93361' 30/09/2024 05:50:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93361' 30/09/2024 05:50:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93361' , '22551' , 'VOTIVE 16X300 - ART. 500 - 1630' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 30/09/2024 05:50:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93361' , '13632' , 'SAN GIUSEPPE DA COPERTINO. IL SANTO DELLE MERAVIGLIE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/09/2024 05:55:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 05:55:44 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' , '2852' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.90' , '18.90' , NOW() , NOW() ) 30/09/2024 05:55:44 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 = '93362' 30/09/2024 05:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93362' 30/09/2024 05:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93362' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 30/09/2024 05:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93362' , '2528' , 'COMPIETA' , '10' , '-10' , '4' , '1.30' , '1.3' , '0' , '5' , '12.40' ) 30/09/2024 05:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93362' , '22507' , 'SPES NON CONFUNDIT' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 30/09/2024 06:03:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821578816' AND id_product != '2528' AND ean13 != '' 30/09/2024 06:03:05 pm >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788821578816', date_upd = NOW() WHERE id_product = '2528' 30/09/2024 06:03:05 pm >> UPDATE ps_product_lang SET name = 'COMPIETA', description = '' WHERE id_product = '2528' 30/09/2024 06:03:05 pm >> UPDATE ps_product SET wholesale_price = '0.87', on_sale = '0', price = '1.9' WHERE id_product = '2528' 30/09/2024 06:03:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.87', price = '1.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2528' 30/09/2024 06:03:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '2528' 30/09/2024 06:29:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 06:29: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' , '2853' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 30/09/2024 06:29: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 = '93363' 30/09/2024 06:29:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93363' 30/09/2024 06:29: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 ( '93363' , '15125' , 'MESSA DI PRIMA COMUNIONE - 8338' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/09/2024 06:29: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 ( '93363' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 30/09/2024 06:29: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 ( '93363' , '8855' , 'REGISTRO DEL CATECHISTA' , '2' , '-2' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '1.50' ) 30/09/2024 06:35:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 30/09/2024 06:35:55 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' , '2854' , '2024-09-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.75' , '0.61' , NOW() , NOW() ) 30/09/2024 06:35:55 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 = '93364' 30/09/2024 06:35:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93364' 30/09/2024 06:35:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93364' , '8855' , 'REGISTRO DEL CATECHISTA' , '1' , '-1' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '0.75' )