26/09/2024 08:44:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7107' 26/09/2024 08:44:18 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 ( '7107' , '10' , '221' , '' , 'VICENSI' , 'MADDALENA' , 'FRAZ. CASAL 4' , '' , '38047' , 'SEGONZANO' , '' , '' , '3396858772' , '' , '' , NOW() , NOW() ) 26/09/2024 08:44:18 am >> UPDATE ps_customer SET email = 'maddavic@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7107' 26/09/2024 10:20:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 10:20:43 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' , '2795' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '67.63' , NOW() , NOW() ) 26/09/2024 10:20:43 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 = '93292' 26/09/2024 10:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '93292' 26/09/2024 10:20:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93292' , '22417' , 'CROCE TAU ARG. CM 25' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 26/09/2024 10:20:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93292' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 26/09/2024 10:20:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93292' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 26/09/2024 10:20:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93292' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 26/09/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93292' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 26/09/2024 10:57:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 10:57: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' , '2796' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 26/09/2024 10:57: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 = '93293' 26/09/2024 10:57:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93293' 26/09/2024 10:57:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93293' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 26/09/2024 11:03:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:03:51 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' , '2797' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 26/09/2024 11:03:51 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 = '93294' 26/09/2024 11:03:51 am >> DELETE FROM ps_document_detail WHERE id_document = '93294' 26/09/2024 11:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93294' , '9948' , 'SFERA DIAMETRO MM 100' , '5' , '-5' , '1' , '6' , '4.9180327868852' , '22' , '0' , '30.00' ) 26/09/2024 11:06:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:06:03 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' , '2798' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 26/09/2024 11:06:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93295' 26/09/2024 11:06:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93295' 26/09/2024 11:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93295' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 26/09/2024 11:07:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:07:10 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' , '2799' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.90' , NOW() , NOW() ) 26/09/2024 11:07:10 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 = '93296' 26/09/2024 11:07:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93296' 26/09/2024 11:07:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93296' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 26/09/2024 11:07:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93296' , '22949' , 'IL GIUBILEO DEI RAGAZZI - L. PELLEGRINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 26/09/2024 11:07:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93296' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 26/09/2024 11:51:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:51:18 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' , '2800' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '54.65' , NOW() , NOW() ) 26/09/2024 11:51:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93297' 26/09/2024 11:51:18 am >> DELETE FROM ps_document_detail WHERE id_document = '93297' 26/09/2024 11:51:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '17005' , 'BIGLIETTO AUGURALE medio' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 26/09/2024 11:51:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '10' , '-10' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '8.00' ) 26/09/2024 11:51:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '8983' , 'RINNEGARE SE STESSO PER VIVERE IN CRISTO - 8461' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 26/09/2024 11:51:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '44.4' , '36.393442622951' , '22' , '0' , '44.40' ) 26/09/2024 11:55:55 am >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:55:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '128' , '2024-09-26' , '' , '4045' , '0' , '4679361' , 'VIA ROMOLO BALZANI 74 00177 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '142.80' , '142.80' , NOW() , NOW() ) 26/09/2024 11:55:56 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 = '93298' 26/09/2024 11:55:56 am >> DELETE FROM ps_document_detail WHERE id_document = '93298' 26/09/2024 11:55:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93298' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '60' , '-60' , '4' , '2.80' , '2.8' , '0' , '15' , '142.80' ) 26/09/2024 11:56:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 11:56:43 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' , '2801' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 26/09/2024 11:56:43 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 = '93299' 26/09/2024 11:56:43 am >> DELETE FROM ps_document_detail WHERE id_document = '93299' 26/09/2024 11:56:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93299' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/09/2024 12:14:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 12:14:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2802' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/09/2024 12:14: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 = '93300' 26/09/2024 12:14:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93300' 26/09/2024 12:14:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93300' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/09/2024 12:50:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 12:50:54 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' , '2803' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 26/09/2024 12:50:54 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 = '93301' 26/09/2024 12:50:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93301' 26/09/2024 12:50:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93301' , '18402' , 'CAMICE CON TRAMEZZO - 419TPACQ' , '1' , '-1' , '1' , '155.00' , '127.04918032787' , '22' , '0' , '155.00' ) 26/09/2024 12:53:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000673' AND id_product != '5095' AND ean13 != '' 26/09/2024 12:53:43 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2015', ean13 = '000673', date_upd = NOW() WHERE id_product = '5095' 26/09/2024 12:53:43 pm >> UPDATE ps_product_lang SET name = 'IMMAGINI ASSORTITE X 100', description = '' WHERE id_product = '5095' 26/09/2024 12:53:43 pm >> UPDATE ps_product SET wholesale_price = '3.75', on_sale = '0', price = '6.557377049180328' WHERE id_product = '5095' 26/09/2024 12:53:43 pm >> UPDATE ps_product_shop SET wholesale_price = '3.75', price = '6.557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5095' 26/09/2024 12:53:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '5095' 26/09/2024 12:54:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000673' AND id_product != '5095' AND ean13 != '' 26/09/2024 12:54:02 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2015', ean13 = '000673', date_upd = NOW() WHERE id_product = '5095' 26/09/2024 12:54:02 pm >> UPDATE ps_product_lang SET name = 'IMMAGINI ISONZO ASSORTITE X 100', description = '' WHERE id_product = '5095' 26/09/2024 12:54:02 pm >> UPDATE ps_product SET wholesale_price = '3.75', on_sale = '0', price = '6.5574' WHERE id_product = '5095' 26/09/2024 12:54:02 pm >> UPDATE ps_product_shop SET wholesale_price = '3.75', price = '6.5574', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '91', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5095' 26/09/2024 12:54:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '5095' 26/09/2024 12:55:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '92738' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 26/09/2024 12:55:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2360', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '92738' 26/09/2024 12:55:18 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 = '92738' 26/09/2024 12:55:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92738' 26/09/2024 12:55:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92738' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 26/09/2024 12:55:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92738' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 26/09/2024 12:55:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92738' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '2' , '-2' , '1' , '7' , '5.7377049180328' , '22' , '0' , '14.00' ) 26/09/2024 02:03:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL002900' , '2024-09-25' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.50' , '195.50' , NOW() , NOW() ) 26/09/2024 02:03:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93302' 26/09/2024 02:03:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93302' 26/09/2024 02:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93302' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '5' , '4' , '6.00' , '6' , '0' , '30' , '21.0000' ) 26/09/2024 02:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 26/09/2024 02:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 26/09/2024 02:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93302' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 26/09/2024 02:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 26/09/2024 02:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 26/09/2024 02:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93302' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '35' , '58.5000' ) 26/09/2024 02:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 26/09/2024 02:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 26/09/2024 02:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93302' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 26/09/2024 02:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 26/09/2024 02:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 26/09/2024 02:06: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 ( '31' , '898/2024' , '2024-09-24' , '2024' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '355.46' , '291.36' , NOW() , NOW() ) 26/09/2024 02:06: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 = '93303' 26/09/2024 02:06:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93303' 26/09/2024 02:06: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 ( '93303' , '17617' , 'IMMAGINI ISONZO X 100' , '153' , '153' , '1' , '2.3' , '1.8852459016393' , '22' , '30+10' , '270.4703' ) 26/09/2024 02:06:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 26/09/2024 02:06:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 26/09/2024 02:06: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 ( '93303' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '10' , '10' , '1' , '5.5' , '4.5081967213115' , '22' , '30+10' , '42.2730' ) 26/09/2024 02:06:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5095' AND id_supplier = '23' 26/09/2024 02:06:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5095' , '23' , '1' ) 26/09/2024 02:06: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 ( '93303' , '20758' , 'SEGNALIBRO 5X15' , '300' , '300' , '1' , '0.09' , '0.073770491803279' , '22' , '30+10' , '20.7522' ) 26/09/2024 02:06:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20758' AND id_supplier = '23' 26/09/2024 02:06:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20758' , '23' , '1' ) 26/09/2024 02:10:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1/2444' , '2024-09-16' , '2444' , '0' , '131' , '4670575' , 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '59.10' , '48.44' , NOW() , NOW() ) 26/09/2024 02:10:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93304' 26/09/2024 02:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93304' 26/09/2024 02:10: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 ( '93304' , '15801' , 'ARGENTO A PESO' , '26.5' , '26.5' , '1' , '1.8279' , '1.4982786885246' , '22' , '0' , '59.0960' ) 26/09/2024 02:10:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15801' AND id_supplier = '131' 26/09/2024 02:10:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15801' , '131' , '1' ) 26/09/2024 02:13:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/09/2024 02:13:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22962' , '1' , '' , 'nuovo-prodotto' ) 26/09/2024 02:13:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22962' , '1' , '1' , '2' , NOW() , NOW() ) 26/09/2024 02:13:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22962' , '0' , '1' , '0' , '0' ) 26/09/2024 02:14:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657135104' AND id_product != '22962' AND ean13 != '' 26/09/2024 02:14:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8006657135104', date_upd = NOW() WHERE id_product = '22962' 26/09/2024 02:14:56 pm >> UPDATE ps_product_lang SET name = 'VINO BIANCO DOLCE MIGNON', description = '' WHERE id_product = '22962' 26/09/2024 02:14:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22962' 26/09/2024 02:14:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '376', 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 = '22962' 26/09/2024 02:14:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22962' 26/09/2024 02:14:58 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 = '22962' 26/09/2024 02:14:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22963' , '1' , '' , 'nuovo-prodotto' ) 26/09/2024 02:14:58 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 '22963' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22962' 26/09/2024 02:14:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22963' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22962' 26/09/2024 02:17:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657235101' AND id_product != '22963' AND ean13 != '' 26/09/2024 02:17:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8006657235101', date_upd = NOW() WHERE id_product = '22963' 26/09/2024 02:17:10 pm >> UPDATE ps_product_lang SET name = 'VINO ROSSO DOLCE MIGNON', description = '' WHERE id_product = '22963' 26/09/2024 02:17:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22963' 26/09/2024 02:17:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '376', 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 = '22963' 26/09/2024 02:17:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '22963' 26/09/2024 02:17: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 = '22963' 26/09/2024 02:17:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22964' , '1' , '' , 'nuovo-prodotto' ) 26/09/2024 02:17: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 '22964' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22963' 26/09/2024 02:17:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22964' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22963' 26/09/2024 02:19:18 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' , '1328' , '2024-09-20' , '' , '0' , '48' , '2643' , 'VIA MAZARA, 209 91025 MARSALA' , '' , '' , '-0.32' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '2578.68' , '2113.61' , NOW() , NOW() ) 26/09/2024 02:19:18 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 = '93305' 26/09/2024 02:19:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '93305' 26/09/2024 02:19:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93305' , '11389' , 'VINO ROSSO DOLCE - 103' , '72' , '72' , '1' , '4.3755' , '3.5864754098361' , '22' , '0' , '384.3439' ) 26/09/2024 02:19:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '48' 26/09/2024 02:19:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '48' , '1' ) 26/09/2024 02:19:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93305' , '11384' , 'VINO BIANCO DOLCE - 102' , '408' , '408' , '1' , '4.1293' , '3.3846721311475' , '22' , '0' , '2055.4004' ) 26/09/2024 02:19:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '48' 26/09/2024 02:19:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '48' , '1' ) 26/09/2024 02:19:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93305' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '48' , '48' , '1' , '1.5855' , '1.2995901639344' , '22' , '0' , '92.8469' ) 26/09/2024 02:19:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22962' AND id_supplier = '48' 26/09/2024 02:19:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22962' , '48' , '1' ) 26/09/2024 02:19:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93305' , '22963' , 'VINO ROSSO DOLCE MIGNON' , '24' , '24' , '1' , '1.5850' , '1.2991803278689' , '22' , '0' , '46.4088' ) 26/09/2024 02:19:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22963' AND id_supplier = '48' 26/09/2024 02:19:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22963' , '48' , '1' ) 26/09/2024 02:21:17 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '335', document_date = '2024-09-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = '', price_shipping = '10.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '397.94', price_tax_excluded = '326.18', date_upd = NOW() WHERE id_document = '93284' 26/09/2024 02:21:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93284' 26/09/2024 02:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93284' 26/09/2024 02:21:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '21447' , 'FAZZOLETTO TULLE ' , '1' , '1' , '1' , '24.8000' , '20.327868852459' , '22' , '3' , '29.35' ) 26/09/2024 02:21:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.3300' , '5.1885245901639' , '22' , '3' , '37.45' ) 26/09/2024 02:21:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '15893' , 'CINGOLO - CING17' , '11' , '11' , '1' , '19.4600' , '15.950819672131' , '22' , '3' , '253.32' ) 26/09/2024 02:21:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '14114' , 'CINGOLO ORO - CING08ORO' , '4' , '4' , '1' , '13.86' , '11.360655737705' , '22' , '3' , '65.6077' ) 26/09/2024 02:21:52 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '335', document_date = '2024-09-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = 'CONTROLLARE NUMERO', price_shipping = '10.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '397.94', price_tax_excluded = '326.18', date_upd = NOW() WHERE id_document = '93284' 26/09/2024 02:21: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 = '93284' 26/09/2024 02:21:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93284' 26/09/2024 02:21:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '21447' , 'FAZZOLETTO TULLE ' , '1' , '1' , '1' , '24.8000' , '20.327868852459' , '22' , '3' , '29.35' ) 26/09/2024 02:21:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.3300' , '5.1885245901639' , '22' , '3' , '37.45' ) 26/09/2024 02:21:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '15893' , 'CINGOLO - CING17' , '11' , '11' , '1' , '19.4600' , '15.950819672131' , '22' , '3' , '253.32' ) 26/09/2024 02:21:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93284' , '14114' , 'CINGOLO ORO - CING08ORO' , '4' , '4' , '1' , '13.8600' , '11.360655737705' , '22' , '3' , '65.61' ) 26/09/2024 02:23:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657135104' AND id_product != '22962' AND ean13 != '' 26/09/2024 02:23:28 pm >> UPDATE ps_product SET id_supplier = '48', reference = '', ean13 = '8006657135104', date_upd = NOW() WHERE id_product = '22962' 26/09/2024 02:23:28 pm >> UPDATE ps_product_lang SET name = 'VINO BIANCO DOLCE MIGNON', description = '' WHERE id_product = '22962' 26/09/2024 02:23:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '22962' 26/09/2024 02:23:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '376', 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 = '22962' 26/09/2024 02:23:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22962' 26/09/2024 02:23:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8006657235101' AND id_product != '22963' AND ean13 != '' 26/09/2024 02:23:46 pm >> UPDATE ps_product SET id_supplier = '48', reference = '', ean13 = '8006657235101', date_upd = NOW() WHERE id_product = '22963' 26/09/2024 02:23:46 pm >> UPDATE ps_product_lang SET name = 'VINO ROSSO DOLCE MIGNON', description = '' WHERE id_product = '22963' 26/09/2024 02:23:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '22963' 26/09/2024 02:23:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '376', 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 = '22963' 26/09/2024 02:23:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22963' 26/09/2024 02:29:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 26/09/2024 02:29:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 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 = '20.50', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '92691' 26/09/2024 02:29:19 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 = '92691' 26/09/2024 02:29:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 26/09/2024 02:29:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 26/09/2024 02:29:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 26/09/2024 02:29:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/09/2024 02:29:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 26/09/2024 02:30:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2784' AND id_document != '93272' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 26/09/2024 02:30:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2784', document_date = '2024-09-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 = '600.00', price_tax_excluded = '491.80', date_upd = NOW() WHERE id_document = '93272' 26/09/2024 02:30:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93272' 26/09/2024 02:30:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '93272' 26/09/2024 02:30:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93272' , '22928' , 'CANDELABRO CM 40 - 621' , '2' , '-2' , '1' , '200' , '163.93442622951' , '22' , '0' , '400.00' ) 26/09/2024 02:30:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93272' , '22929' , 'CANDELABRO CM 30 - 622' , '2' , '-2' , '1' , '100' , '81.967213114754' , '22' , '0' , '200.00' ) 26/09/2024 02:31:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 02:31:33 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' , '2804' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 26/09/2024 02:31:33 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 = '93306' 26/09/2024 02:31:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93306' 26/09/2024 02:31:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93306' , '22930' , 'CANDELABRO CM 20 - 645' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 26/09/2024 02:31:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93306' , '22931' , ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 26/09/2024 02:32:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2671' AND id_document != '93120' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-13') 26/09/2024 02:32:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2671', document_date = '2024-09-13', 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 = '78.00', price_tax_excluded = '63.93', date_upd = NOW() WHERE id_document = '93120' 26/09/2024 02:32:28 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 = '93120' 26/09/2024 02:32:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93120' 26/09/2024 02:32:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93120' , '22931' , ' FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131' , '4' , '-4' , '1' , '19.5' , '15.983606557377' , '22' , '0' , '78.00' ) 26/09/2024 02:32:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2710' AND id_document != '93172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 26/09/2024 02:32:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2710', document_date = '2024-09-17', 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 = '246.20', price_tax_excluded = '233.94', date_upd = NOW() WHERE id_document = '93172' 26/09/2024 02:32:57 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 = '93172' 26/09/2024 02:32:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '93172' 26/09/2024 02:32:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '3' , '-3' , '4' , '12.6000' , '12.6' , '0' , '0' , '37.80' ) 26/09/2024 02:32:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22704' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 26/09/2024 02:32:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '2' , '-2' , '4' , '12.6000' , '12.6' , '0' , '0' , '25.20' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '3' , '-3' , '4' , '12.6000' , '12.6' , '0' , '0' , '37.80' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '0' , '18.00' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22708' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '4' , '-4' , '4' , '12.6000' , '12.6' , '0' , '0' , '50.40' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 26/09/2024 02:32:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '13521' , 'CANDELIERE 3 FIAMME BASSO - 519' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 26/09/2024 02:50:21 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7107' 26/09/2024 02:50:21 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 ( '7107' , '10' , '221' , '' , 'VICENZI' , 'MADDALENA' , 'FRAZ. CASAL 4' , '' , '38047' , 'SEGONZANO' , '' , '' , '3396858772' , '' , '' , NOW() , NOW() ) 26/09/2024 02:50:21 pm >> UPDATE ps_customer SET email = 'maddavic@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7107' 26/09/2024 02:50:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '14749' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-25') 26/09/2024 02:50:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '33', document_date = '2024-09-25', document_letter = '', id_customer = '7107', id_supplier = '0', id_address = '177359045', address1 = 'FRAZ. CASAL 4 38047 SEGONZANO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '37.30', price_tax_excluded = '37.30', date_upd = NOW() WHERE id_document = '14749' 26/09/2024 02:50: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 = '14749' 26/09/2024 02:50:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '14749' 26/09/2024 02:50: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 ( '14749' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 26/09/2024 02:50: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 ( '14749' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 26/09/2024 02:51:53 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'P1o9SVngxgygubkE' , NOW() , NOW() ) 26/09/2024 02:51:53 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7108' , '1' ) 26/09/2024 02:51:53 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7108' , '2' ) 26/09/2024 02:51:53 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7108' , '3' ) 26/09/2024 02:54:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7108' 26/09/2024 02:54:05 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 ( '7108' , '10' , '229' , 'LIBRERIA PAOLINE VERONA' , '' , '' , 'VIA STELLA 19' , '' , '37121' , 'VERONA' , '' , '0458000774' , '' , '' , '' , NOW() , NOW() ) 26/09/2024 02:54:05 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7108' 26/09/2024 02:54:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7108' 26/09/2024 02:54:22 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 ( '7108' , '10' , '229' , 'LIBRERIA PAOLINE VERONA' , '' , '' , 'VIA STELLA 19' , '' , '37121' , 'VERONA' , '' , '0458000774' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 02:54:22 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7108' 26/09/2024 02:56:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 02:56: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 ( '23' , '19/S' , '2024-09-26' , 'S' , '7108' , '0' , '177359047' , 'VIA STELLA 19 37121 VERONA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 26/09/2024 02:56: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 = '14750' 26/09/2024 02:56:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '14750' 26/09/2024 02:56: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 ( '14750' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.80' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 02:56: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 ( '14750' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 02:56: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 ( '14750' , '' , 'SPESE CONTRASSEGNO' , '1' , '-1' , '4' , '2.87' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 03:26:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7108' 26/09/2024 03:26:46 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 ( '7108' , '10' , '229' , 'LIBRERIA PAOLINE VERONA' , '' , '' , 'VIA STELLA 19' , '' , '37121' , 'VERONA' , '' , '0458000774' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 03:26:46 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7108' 26/09/2024 03:28:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2793' AND id_document != '93288' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-25') 26/09/2024 03:28:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2793', document_date = '2024-09-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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '93288' 26/09/2024 03:28:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93288' 26/09/2024 03:28:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93288' 26/09/2024 03:28:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93288' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 26/09/2024 03:33:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 03: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 ( '11' , '2805' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.90' , '0.90' , NOW() , NOW() ) 26/09/2024 03: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 = '93307' 26/09/2024 03:33:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93307' 26/09/2024 03: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 ( '93307' , '11129' , 'VANGELO SECONDO LUCA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 26/09/2024 03:41:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '93264' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 26/09/2024 03:41:50 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2024-09-24', document_letter = '', id_customer = '351', id_supplier = '', id_address = '4673707', address1 = 'VIA MASSARENTI, 418 40138 BOLOGNA', 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 = '82.39', price_tax_excluded = '76.35', date_upd = NOW() WHERE id_document = '93264' 26/09/2024 03:41:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93264' 26/09/2024 03:41:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '93264' 26/09/2024 03:41:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '4' , '0.6700' , '0.67' , '0' , '0' , '33.50' ) 26/09/2024 03:41:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '50' , '-50' , '1' , '0.67' , '0.54918032786885' , '22' , '0' , '33.50' ) 26/09/2024 03:41:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '17257' , 'IO TI BATTEZZO ' , '9' , '-9' , '4' , '1.7100' , '1.71' , '0' , '0' , '15.39' ) 26/09/2024 03:42:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '93264' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 26/09/2024 03:42:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2024-09-24', document_letter = '', id_customer = '351', id_supplier = '', id_address = '4673707', address1 = 'VIA MASSARENTI, 418 40138 BOLOGNA', 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 = '82.39', price_tax_excluded = '76.35', date_upd = NOW() WHERE id_document = '93264' 26/09/2024 03:42: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 = '93264' 26/09/2024 03:42:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93264' 26/09/2024 03:42: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 ( '93264' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '4' , '0.6700' , '0.67' , '0' , '0' , '33.50' ) 26/09/2024 03:42: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 ( '93264' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '50' , '-50' , '1' , '0.6700' , '0.54918032786885' , '22' , '0' , '33.50' ) 26/09/2024 03:42: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 ( '93264' , '17257' , 'IO TI BATTEZZO ' , '9' , '-9' , '4' , '1.7100' , '1.71' , '0' , '0' , '15.39' ) 26/09/2024 03:43:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '93264' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 26/09/2024 03:43:24 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2024-09-24', document_letter = '', id_customer = '351', id_supplier = '', id_address = '4673707', address1 = 'VIA MASSARENTI, 418 40138 BOLOGNA', 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 = '82.39', price_tax_excluded = '82.39', date_upd = NOW() WHERE id_document = '93264' 26/09/2024 03:43:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93264' 26/09/2024 03:43:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93264' 26/09/2024 03:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '4' , '0.6700' , '0.67' , '0' , '0' , '33.50' ) 26/09/2024 03:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '50' , '-50' , '4' , '0.6700' , '0.67' , '0' , '0' , '33.50' ) 26/09/2024 03:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '17257' , 'IO TI BATTEZZO ' , '9' , '-9' , '4' , '1.7100' , '1.71' , '0' , '0' , '15.39' ) 26/09/2024 03:54:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7108' 26/09/2024 03:54:52 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 ( '7108' , '10' , '229' , 'LIBRERIA PAOLINE VERONA' , '' , '' , 'VIA STELLA 19' , '' , '37121' , 'VERONA' , '' , '0458000774' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 03:54:52 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7108' 26/09/2024 03:59:55 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'DubwG4VAqhnjR4SF' , NOW() , NOW() ) 26/09/2024 03:59:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7109' , '1' ) 26/09/2024 03:59:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7109' , '2' ) 26/09/2024 03:59:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7109' , '3' ) 26/09/2024 04:02:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7109' 26/09/2024 04:02:23 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 ( '7109' , '10' , '208' , 'IST. PIA SOC. FIGLIE DI S. PAOLO' , '' , '' , 'VIA ANTONINO PIO 75' , '' , '00145' , 'ROMA' , 'LIBRERIA PAOLINE VERONA' , '' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 04:02:23 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7109' 26/09/2024 04:02:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7109' 26/09/2024 04:02:58 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 ( '7109' , '10' , '208' , 'IST. PIA SOC. FIGLIE DI S. PAOLO' , '' , '' , 'VIA ANTONINO PIO 75' , '' , '00145' , 'ROMA' , 'LIBRERIA PAOLINE VERONA TEL 0458000774' , '' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 04:02:58 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7109' 26/09/2024 04:03:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '14750' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:03:33 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/S', document_date = '2024-09-26', document_letter = 'S', id_customer = '6200', id_supplier = '0', id_address = '4673065', address1 = 'VIA STELLA 19 37121 VERONA', 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 = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '14750' 26/09/2024 04:03:33 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 = '14750' 26/09/2024 04:03:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '14750' 26/09/2024 04:03: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 ( '14750' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:03: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 ( '14750' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:03: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 ( '14750' , '0' , 'SPESE CONTRASSEGNO' , '1' , '-1' , '4' , '2.8700' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:04:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '14750' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:04:15 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/S', document_date = '2024-09-26', document_letter = 'S', id_customer = '6200', id_supplier = '', id_address = '4673065', address1 = 'VIA STELLA 19 37121 VERONA', address2 = 'LIBRERIA PAOLINE VERONA', note = 'LIBRERIA PAOLINE VERONA', 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 = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '14750' 26/09/2024 04:04:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14750' 26/09/2024 04:04:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '14750' 26/09/2024 04:04:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14750' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:04:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14750' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:04:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14750' , '0' , 'SPESE CONTRASSEGNO' , '1' , '-1' , '4' , '2.8700' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:05:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7109' 26/09/2024 04:05:44 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 ( '7109' , '10' , '208' , 'IST. PIA SOC. FIGLIE DI S. PAOLO' , '' , '' , 'VIA ANTONINO PIO 75' , '' , '00145' , 'ROMA' , 'LIBRERIA PAOLINE VERONA TEL 0458000774' , '' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 04:05:44 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7109' 26/09/2024 04:06:10 pm >> DELETE FROM ps_document WHERE id_document = '14750' 26/09/2024 04:06:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '14750' 26/09/2024 04:07:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:07:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '19/S' , '2024-09-26' , 'S' , '6200' , '0' , '4673065' , 'VIA ANTONINO PIO, 75 00145 ROMA' , 'LIBRERIA PAOLINE VERONA\r\nVIA STELLA 19\r\n37121 VERONA VR' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 26/09/2024 04:07: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 = '14751' 26/09/2024 04:07:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '14751' 26/09/2024 04:07: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 ( '14751' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:07: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 ( '14751' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:07: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 ( '14751' , '0' , 'SPESE CONTRASSEGNO' , '1' , '-1' , '4' , '2.8700' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:09:48 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7109' 26/09/2024 04:09:48 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 ( '7109' , '10' , '208' , 'IST. PIA SOC. FIGLIE DI S. PAOLO' , '' , '' , 'VIA ANTONINO PIO 75' , '' , '00145' , 'ROMA' , 'LIBRERIA PAOLINE VERONA TEL 0458000774' , '' , '' , '00891451007' , '' , NOW() , NOW() ) 26/09/2024 04:09:48 pm >> UPDATE ps_customer SET email = '', sdi = 'T04ZHR3', pec = '', date_upd = NOW() WHERE id_customer = '7109' 26/09/2024 04:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:10:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2806' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 26/09/2024 04:10:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93308' 26/09/2024 04:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93308' 26/09/2024 04:10: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 ( '93308' , '20758' , 'SEGNALIBRO 5X15' , '100' , '-100' , '1' , '0.18' , '0.14754098360656' , '22' , '0' , '18.00' ) 26/09/2024 04:10:53 pm >> DELETE FROM ps_document WHERE id_document = '14751' 26/09/2024 04:10:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '14751' 26/09/2024 04:12:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:12: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 ( '23' , '19/S' , '2024-09-26' , 'S' , '6200' , '0' , '4673065' , 'VIA ANTONINO PIO, 75 00145 ROMA' , 'LIBRERIA PAOLINE VIA STELLA 19 37121 VERONA VR' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 26/09/2024 04:12: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 = '14752' 26/09/2024 04:12:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '14752' 26/09/2024 04:12: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 ( '14752' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:12: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 ( '14752' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.80' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:12: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 ( '14752' , '' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.87' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:14:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '14752' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:14:46 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/S', document_date = '2024-09-26', document_letter = 'S', id_customer = '6200', id_supplier = '0', id_address = '4673065', address1 = 'VIA ANTONINO PIO, 75 00145 ROMA', address2 = '', note = 'LIBRERIA PAOLINE VERONA', 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 = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '14752' 26/09/2024 04:14: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 = '14752' 26/09/2024 04:14:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '14752' 26/09/2024 04:14: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 ( '14752' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:14: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 ( '14752' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:14: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 ( '14752' , '0' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.8700' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:15:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '14752' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 04:15:59 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/S', document_date = '2024-09-26', document_letter = 'S', id_customer = '7108', id_supplier = '0', id_address = '177359049', address1 = 'VIA ANTONINO PIO, 75 00145 ROMA', address2 = '', note = 'LIBRERIA PAOLINE VERONA', 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 = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '14752' 26/09/2024 04:15:59 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 = '14752' 26/09/2024 04:15:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '14752' 26/09/2024 04:15:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14752' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '5' , '59.38' ) 26/09/2024 04:15:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14752' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.8000' , '1.8' , '0' , '5' , '42.75' ) 26/09/2024 04:15:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14752' , '0' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.8700' , '2.87' , '0' , '0' , '2.87' ) 26/09/2024 04:32:20 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7107' 26/09/2024 04:32:20 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 ( '7107' , '10' , '221' , '' , 'VICENZI' , 'MADDALENA' , 'FRAZ. CASAL 4' , '' , '38047' , 'SEGONZANO' , '' , '' , '3396858772' , '' , '' , NOW() , NOW() ) 26/09/2024 04:32:20 pm >> UPDATE ps_customer SET email = 'maddavic@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7107' 26/09/2024 06:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 06:14:40 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' , '2807' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 26/09/2024 06:14:40 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 = '93309' 26/09/2024 06:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93309' 26/09/2024 06:14: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 ( '93309' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '5' , '-5' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '40.00' ) 26/09/2024 06:20:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 06:20:02 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' , '2808' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 26/09/2024 06:20: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 = '93310' 26/09/2024 06:20:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '93310' 26/09/2024 06:20: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 ( '93310' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 26/09/2024 06:20: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 ( '93310' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 26/09/2024 07:23:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2432' AND id_document != '92828' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 26/09/2024 07:23:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2432', document_date = '2024-08-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 = '18.90', price_tax_excluded = '15.49', date_upd = NOW() WHERE id_document = '92828' 26/09/2024 07:23:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92828' 26/09/2024 07:23:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92828' 26/09/2024 07:23: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 ( '92828' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '6' , '-6' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '8.40' ) 26/09/2024 07:23: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 ( '92828' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/09/2024 07:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92828' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 26/09/2024 07:23:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2148' AND id_document != '92490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 26/09/2024 07:23:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2148', document_date = '2024-07-01', 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 = '123.50', price_tax_excluded = '101.23', date_upd = NOW() WHERE id_document = '92490' 26/09/2024 07:23: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 = '92490' 26/09/2024 07:23:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92490' 26/09/2024 07:23: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 ( '92490' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 26/09/2024 07:23: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 ( '92490' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 26/09/2024 07:23: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 ( '92490' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 26/09/2024 07:23: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 ( '92490' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 26/09/2024 07:23: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 ( '92490' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 26/09/2024 07:24:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 26/09/2024 07:24:30 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' , '2809' , '2024-09-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 26/09/2024 07:24:30 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 = '93311' 26/09/2024 07:24:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93311' 26/09/2024 07:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93311' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' )