10/05/2022 08:48:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1100107400006' AND id_product != '4998' AND ean13 != '' 10/05/2022 08:48:29 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '1100107400006', date_upd = NOW() WHERE id_product = '4998' 10/05/2022 08:48:29 am >> UPDATE ps_product_lang SET name = 'IMMAGINE SANTA RITA ', description = '' WHERE id_product = '4998' 10/05/2022 08:48:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5738' WHERE id_product = '4998' 10/05/2022 08:48:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5738', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4998' 10/05/2022 08:48:29 am >> DELETE FROM ps_specific_price WHERE id_product = '4998' 10/05/2022 11:14:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 11:14:00 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' , '1474' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 10/05/2022 11:14:00 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 = '56685' 10/05/2022 11:14:00 am >> DELETE FROM ps_document_detail WHERE id_document = '56685' 10/05/2022 11:14:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56685' , '18951' , 'ECCO TUA MADRE - A. PIGNA' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 10/05/2022 11:14:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18951' AND id_supplier = '' 10/05/2022 11:14:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18951' , '' , '1' ) 10/05/2022 11:14:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56685' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/05/2022 11:14:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '' 10/05/2022 11:14:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '' , '1' ) 10/05/2022 11:44:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 11:44:45 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' , '1475' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '644.60' , '528.36' , NOW() , NOW() ) 10/05/2022 11:44:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56686' 10/05/2022 11:44:45 am >> DELETE FROM ps_document_detail WHERE id_document = '56686' 10/05/2022 11:44:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56686' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '15' , '32.30' ) 10/05/2022 11:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 10/05/2022 11:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 10/05/2022 11:44:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56686' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '15' , '32.30' ) 10/05/2022 11:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '12815' AND id_supplier = '' 10/05/2022 11:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12815' , '' , '1' ) 10/05/2022 11:44:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56686' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 10/05/2022 11:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 10/05/2022 11:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 10/05/2022 11:44:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56686' , '18185' , 'CASULA P/LANA MARIANA' , '1' , '-1' , '1' , '530' , '434.4262295082' , '22' , '0' , '530.00' ) 10/05/2022 11:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18185' AND id_supplier = '' 10/05/2022 11:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18185' , '' , '1' ) 10/05/2022 11:50:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1296' AND id_document != '56474' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-28') 10/05/2022 11:50:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1296', document_date = '2022-04-28', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '56474' 10/05/2022 11:50: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 = '56474' 10/05/2022 11:50:51 am >> DELETE FROM ps_document_detail WHERE id_document = '56474' 10/05/2022 11:50: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 ( '56474' , '15652' , 'CLERGY BLU - 100% - 40 - 160/10' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 10/05/2022 11:50:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '15652' AND id_supplier = '' 10/05/2022 11:50:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15652' , '' , '1' ) 10/05/2022 11:55:34 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 11:55:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '16' , '2022-05-10' , '' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA CURTERI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.90' , '137.25' , NOW() , NOW() ) 10/05/2022 11:55:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56687' 10/05/2022 11:55:34 am >> DELETE FROM ps_document_detail WHERE id_document = '56687' 10/05/2022 11:55:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56687' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 10/05/2022 11:55:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56687' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/05/2022 11:55:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56687' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 10/05/2022 11:55:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56687' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 10/05/2022 11:55:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56687' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 10/05/2022 12:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1476' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 12:01:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1476' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.62' , '49.68' , NOW() , NOW() ) 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56688' 10/05/2022 12:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '56688' 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 10/05/2022 12:01:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/05/2022 12:01:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 10/05/2022 12:01:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 10/05/2022 12:01:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '18123' , 'MASCHERINA PRIMA COMUNIONE' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 10/05/2022 12:01:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18123' AND id_supplier = '' 10/05/2022 12:01:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18123' , '' , '1' ) 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 10/05/2022 12:01:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19312' AND id_supplier = '' 10/05/2022 12:01:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19312' , '' , '1' ) 10/05/2022 12:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '9230' , 'SANTA RITA DA CASCIA - 10 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9230' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9230' , '' , '1' ) 10/05/2022 12:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '9490' , 'SAN NICOLA - A.DURSO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '' , '1' ) 10/05/2022 12:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '9459' , 'SAN GIUDA TADDEO - M. SIGNORONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9459' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9459' , '' , '1' ) 10/05/2022 12:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9479' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9479' , '' , '1' ) 10/05/2022 12:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '9522' , 'SANT ANDREA AP. - A.GOVERNALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9522' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9522' , '' , '1' ) 10/05/2022 12:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56688' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/05/2022 12:01:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '' 10/05/2022 12:01:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '' , '1' ) 10/05/2022 12:05:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '36/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 12:05:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '36/A' , '2022-05-10' , 'A' , '232' , '0' , '4671450' , 'VIA V. LASPRO, 8/A 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.71' , '106.76' , NOW() , NOW() ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56689' 10/05/2022 12:05:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56689' 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '15345' , 'EUCARISTIA - CUORE DELLA CHIESA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '5' , '15.11' ) 10/05/2022 12:05:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56689' , '17899' , 'ROSARIO GIROCOLLO QUADRATO NERO ARG.' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 10/05/2022 12:39:21 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3514' 10/05/2022 12:39: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 ( '3514' , '10' , '210' , 'PARROCCHIA SANTA CROCE E SAN FELICE' , 'ROMANO' , 'DON ANTONIO ' , 'VIA A. SALERNITANA, 41' , '' , '84127' , 'SALERNO' , '' , '3493428807' , '' , '' , '95022120653' , NOW() , NOW() ) 10/05/2022 12:39:21 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3514' 10/05/2022 12:42:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '79' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 12:42:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '79' , '2022-05-10' , '' , '3514' , '0' , '4674062' , 'VIA A. SALERNITANA, 41 84127 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '177.65' , '177.65' , NOW() , NOW() ) 10/05/2022 12:42:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56690' 10/05/2022 12:42:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '56690' 10/05/2022 12:42:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56690' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '110' , '-110' , '4' , '1.90' , '1.9' , '0' , '15' , '177.65' ) 10/05/2022 12:53:48 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' , '132676' , '2022-05-09' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '179.00' , '179.00' , NOW() , NOW() ) 10/05/2022 12:53:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56691' 10/05/2022 12:53:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '56691' 10/05/2022 12:53:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56691' , '822' , 'ATTI DEGLI APOSTOLI - S. FAUSTI' , '1' , '1' , '4' , '58.00' , '58' , '0' , '0' , '58.00' ) 10/05/2022 12:53:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '822' AND id_supplier = '109' 10/05/2022 12:53:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '822' , '109' , '1' ) 10/05/2022 12:53:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56691' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '1' , '4' , '63.00' , '63' , '0' , '0' , '63.00' ) 10/05/2022 12:53:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10915' AND id_supplier = '109' 10/05/2022 12:53:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10915' , '109' , '1' ) 10/05/2022 12:53:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56691' , '822' , 'ATTI DEGLI APOSTOLI - S. FAUSTI' , '1' , '1' , '4' , '58.00' , '58' , '0' , '0' , '58.00' ) 10/05/2022 12:53:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '822' AND id_supplier = '109' 10/05/2022 12:53:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '822' , '109' , '1' ) 10/05/2022 12:55:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '56600' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-04') 10/05/2022 12:55:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '33/A', document_date = '2022-05-04', document_letter = 'A', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.', 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 = '263.15', price_tax_excluded = '263.15', date_upd = NOW() WHERE id_document = '56600' 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56600' 10/05/2022 12:55:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '56600' 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56600' , '10916' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MARCO' , '1' , '-1' , '4' , '57.0000' , '57' , '0' , '5' , '54.15' ) 10/05/2022 12:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10916' AND id_supplier = '' 10/05/2022 12:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10916' , '' , '1' ) 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56600' , '10917' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MATTEO' , '1' , '-1' , '4' , '51.0000' , '51' , '0' , '5' , '48.45' ) 10/05/2022 12:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10917' AND id_supplier = '' 10/05/2022 12:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10917' , '' , '1' ) 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56600' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '-1' , '4' , '63.0000' , '63' , '0' , '5' , '59.85' ) 10/05/2022 12:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10915' AND id_supplier = '' 10/05/2022 12:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10915' , '' , '1' ) 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56600' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '5' , '45.60' ) 10/05/2022 12:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10914' AND id_supplier = '' 10/05/2022 12:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10914' , '' , '1' ) 10/05/2022 12:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56600' , '822' , 'ATTI DEGLI APOSTOLI - S. FAUSTI' , '1' , '-1' , '4' , '58.00' , '58' , '0' , '5' , '55.10' ) 10/05/2022 12:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '822' AND id_supplier = '' 10/05/2022 12:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '822' , '' , '1' ) 10/05/2022 12:59:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1477' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 12:59:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1477' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.00' , '133.00' , NOW() , NOW() ) 10/05/2022 12:59:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56692' 10/05/2022 12:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56692' 10/05/2022 12:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56692' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/05/2022 12:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '' 10/05/2022 12:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '' , '1' ) 10/05/2022 12:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56692' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/05/2022 12:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '' 10/05/2022 12:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '' , '1' ) 10/05/2022 12:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56692' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/05/2022 12:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '' 10/05/2022 12:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '' , '1' ) 10/05/2022 12:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56692' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 10/05/2022 12:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 10/05/2022 12:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 10/05/2022 03:04:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '56492' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 10/05/2022 03:04:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1311', document_date = '2022-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '201.19', price_tax_excluded = '174.27', date_upd = NOW() WHERE id_document = '56492' 10/05/2022 03:04:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56492' 10/05/2022 03:04:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '56492' 10/05/2022 03:04:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 10/05/2022 03:04:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '' 10/05/2022 03:04:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' ) 10/05/2022 03:04:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '42.00' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '5' , '7.24' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '4.80' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 10/05/2022 03:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 10/05/2022 03:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 10/05/2022 03:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 10/05/2022 03:04: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 ( '56492' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/05/2022 03:04:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/05/2022 03:04:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/05/2022 03:04: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 ( '56492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 10/05/2022 03:04:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 10/05/2022 03:04:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 10/05/2022 03:04: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 ( '56492' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 10/05/2022 03:04:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 10/05/2022 03:04:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 10/05/2022 03:04: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 ( '56492' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/05/2022 03:04:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 10/05/2022 03:04:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 10/05/2022 03:07:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 03:07:01 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' , '1478' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 10/05/2022 03:07:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56693' 10/05/2022 03:07:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '56693' 10/05/2022 03:07: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 ( '56693' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 10/05/2022 03:07:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 10/05/2022 03:07:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 10/05/2022 03:10:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1479' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 03:10:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1479' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 10/05/2022 03:10: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 = '56694' 10/05/2022 03:10:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '56694' 10/05/2022 03:10: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 ( '56694' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 10/05/2022 03:10:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 10/05/2022 03:10:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 10/05/2022 03:56:36 pm >> DELETE FROM ps_document WHERE id_document = '56524' 10/05/2022 03:56:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56524' 10/05/2022 03:57:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001267' AND id_product != '16070' AND ean13 != '' 10/05/2022 03:57:23 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001267', date_upd = NOW() WHERE id_product = '16070' 10/05/2022 03:57:23 pm >> UPDATE ps_product_lang SET name = 'CASULA - PCA020', description = '' WHERE id_product = '16070' 10/05/2022 03:57:23 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '59.01639344262295' WHERE id_product = '16070' 10/05/2022 03:57:23 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '59.01639344262295', id_tax_rules_group = '1', id_category_default = '440', 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 = '16070' 10/05/2022 03:57:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '16070' 10/05/2022 03:57:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '715' AND id_document != '53198' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-10') 10/05/2022 03:57:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '715', document_date = '2022-03-10', 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 = '66.50', price_tax_excluded = '54.51', date_upd = NOW() WHERE id_document = '53198' 10/05/2022 03:57: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 = '53198' 10/05/2022 03:57:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '53198' 10/05/2022 03:57: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 ( '53198' , '11684' , 'BRACCIALE TAU' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 10/05/2022 03:57:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11684' AND id_supplier = '' 10/05/2022 03:57:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11684' , '' , '1' ) 10/05/2022 03:57: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 ( '53198' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 10/05/2022 03:57:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '' 10/05/2022 03:57:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '' , '1' ) 10/05/2022 04:07:57 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7407' 10/05/2022 04:07:57 pm >> UPDATE ps_stock_available SET quantity = quantity + '13' WHERE id_product = '7407' 10/05/2022 04:14:30 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '79', document_date = '2018-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2648', address1 = 'VIA SAN LEONARDO, 120 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '5480.80', price_tax_excluded = '5270.00', date_upd = NOW() WHERE id_document = '7206' 10/05/2022 04:14: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 = '7206' 10/05/2022 04:14:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '7206' 10/05/2022 04: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 ( '7206' , '12255' , 'IN CAMMINO CON GESU\'' , '2000' , '2000' , '3' , '0.7800' , '0.75' , '4' , '' , '1622.40' ) 10/05/2022 04:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12255' AND id_supplier = '' 10/05/2022 04:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12255' , '' , '1' ) 10/05/2022 04: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 ( '7206' , '12253' , 'MIO LIBRO DI PREGHIERE' , '2000' , '2000' , '3' , '0.3800' , '0.36538461538462' , '4' , '0' , '790.40' ) 10/05/2022 04:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = '' 10/05/2022 04:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' ) 10/05/2022 04:14:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7206' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '500' , '500' , '3' , '0.5900' , '0.56730769230769' , '4' , '0' , '306.80' ) 10/05/2022 04:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 10/05/2022 04:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 10/05/2022 04:14:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7206' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '3500' , '3500' , '3' , '0.5900' , '0.56730769230769' , '4' , '0' , '2147.6000' ) 10/05/2022 04:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 10/05/2022 04:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 10/05/2022 04:14:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7206' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1000' , '1000' , '3' , '0.59' , '0.56730769230769' , '4' , '0' , '613.6000' ) 10/05/2022 04:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 10/05/2022 04:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' ) 10/05/2022 05:53:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1480' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 05:53: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 ( '11' , '1480' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 10/05/2022 05:53: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 = '56695' 10/05/2022 05:53:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '56695' 10/05/2022 05:53: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 ( '56695' , '18222' , 'ROSARIO COLORATO - R316' , '50' , '-50' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '35.00' ) 10/05/2022 05:53:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 10/05/2022 05:53:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 10/05/2022 05:58:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 05:58:16 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' , '1481' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 10/05/2022 05:58:16 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 = '56696' 10/05/2022 05:58:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '56696' 10/05/2022 05:58:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56696' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 10/05/2022 05:58:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 10/05/2022 05:58:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 10/05/2022 06:23:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1482' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 06:23:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1482' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 10/05/2022 06:23:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56697' 10/05/2022 06:23:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '56697' 10/05/2022 06:23:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56697' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 10/05/2022 06:23:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/05/2022 06:23:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/05/2022 06:33:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 06:33:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1483' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 10/05/2022 06:33:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56698' 10/05/2022 06:33:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '56698' 10/05/2022 06:33:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56698' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '2.40' ) 10/05/2022 06:33:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 10/05/2022 06:33:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 10/05/2022 06:33:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56698' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 10/05/2022 06:33:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 10/05/2022 06:33:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 10/05/2022 06:33: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 ( '56698' , '19253' , 'bruciaincenso cm 9' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 10/05/2022 06:33:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19253' AND id_supplier = '' 10/05/2022 06:33:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19253' , '' , '1' ) 10/05/2022 06:33: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 ( '56698' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '' , '0' , '0' , '0' , '0.00' ) 10/05/2022 06:33:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/05/2022 06:33:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/05/2022 06:33: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 ( '56698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/05/2022 06:33:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/05/2022 06:33:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/05/2022 06:49:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 06:49:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1484' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '57.38' , NOW() , NOW() ) 10/05/2022 06:49: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 = '56699' 10/05/2022 06:49:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '56699' 10/05/2022 06:49: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 ( '56699' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '50' , '50' , '0' , '0' , '50.00' ) 10/05/2022 06:49:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/05/2022 06:49:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/05/2022 06:49: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 ( '56699' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 10/05/2022 06:49:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/05/2022 06:49:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/05/2022 07:45:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 07:45:31 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' , '1485' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 10/05/2022 07:45:31 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 = '56700' 10/05/2022 07:45:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '56700' 10/05/2022 07:45:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56700' , '13751' , 'TUNICA SVASATA AVORIO ' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 10/05/2022 07:45:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13751' AND id_supplier = '' 10/05/2022 07:45:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13751' , '' , '1' ) 10/05/2022 07:49:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-10') 10/05/2022 07:49:49 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' , '1486' , '2022-05-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.80' , '9.67' , NOW() , NOW() ) 10/05/2022 07:49:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56701' 10/05/2022 07:49:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '56701' 10/05/2022 07:49:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56701' , '9195' , 'ROSARO LEGNO CORDA - RG 03 ' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 10/05/2022 07:49:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9195' AND id_supplier = '' 10/05/2022 07:49:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9195' , '' , '1' ) 10/05/2022 07:49:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56701' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 10/05/2022 07:49:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/05/2022 07:49:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/05/2022 07:49:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56701' , '9127' , 'ROSARIO LACCATO' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 10/05/2022 07:49:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9127' AND id_supplier = '' 10/05/2022 07:49:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9127' , '' , '1' ) 10/05/2022 07:49:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56701' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '5' , '-5' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '3.00' ) 10/05/2022 07:49:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6339' AND id_supplier = '' 10/05/2022 07:49:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6339' , '' , '1' )