30/04/2022 08:57:01 am >> SELECT document_num FROM ps_document WHERE document_num = '74' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 08:57:02 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' , '74' , '2022-04-30' , '' , '2332' , '0' , '4670946' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '142.80' , '142.80' , NOW() , NOW() ) 30/04/2022 08:57:02 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 = '56513' 30/04/2022 08:57:02 am >> DELETE FROM ps_document_detail WHERE id_document = '56513' 30/04/2022 08:57:02 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 ( '56513' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '70' , '-70' , '4' , '2.40' , '2.4' , '0' , '15' , '142.80' ) 30/04/2022 08:59:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 08:59:04 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' , '1331' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.28' , '159.42' , NOW() , NOW() ) 30/04/2022 08:59:04 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 = '56514' 30/04/2022 08:59:04 am >> DELETE FROM ps_document_detail WHERE id_document = '56514' 30/04/2022 08:59:04 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 ( '56514' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2' , '1.6393442622951' , '22' , '0' , '80.00' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '52.00' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '11693' , 'BRACCIALE DECINA CAUCCIU PIETRA - 805/23' , '15' , '-15' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '22.50' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11693' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11693' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '18194' , 'UN MESE CON MARIA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '18194' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18194' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '19478' , 'MARIA Canto di speranza - francesco' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19478' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19478' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '19473' , 'MARIA MODELLO DI SANTITA - M.E. PATRIZI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19473' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19473' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '6263' , 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '6263' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6263' , '' , '1' ) 30/04/2022 08:59:05 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 ( '56514' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/04/2022 08:59:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '' 30/04/2022 08:59:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '' , '1' ) 30/04/2022 09:21:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 09:21:35 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' , '1332' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 30/04/2022 09:21:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56515' 30/04/2022 09:21:35 am >> DELETE FROM ps_document_detail WHERE id_document = '56515' 30/04/2022 09:21: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 ( '56515' , '19028' , 'STOLA MISTO LA/SE - 1010/46' , '1' , '-1' , '1' , '125.00' , '102.45901639344' , '22' , '0' , '125.00' ) 30/04/2022 09:21:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19028' AND id_supplier = '' 30/04/2022 09:21:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19028' , '' , '1' ) 30/04/2022 09:35:34 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1319' 30/04/2022 09:35:34 am >> UPDATE ps_stock_available SET quantity = quantity + '-12' WHERE id_product = '1319' 30/04/2022 09:42:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1270' AND id_document != '56443' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-27') 30/04/2022 09:42:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1270', document_date = '2022-04-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.50', price_tax_excluded = '18.50', date_upd = NOW() WHERE id_document = '56443' 30/04/2022 09:42:49 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 = '56443' 30/04/2022 09:42:49 am >> DELETE FROM ps_document_detail WHERE id_document = '56443' 30/04/2022 09:42:49 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 ( '56443' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 30/04/2022 09:42:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 09:42:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 09:42:49 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 ( '56443' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '4.25' , '4.25' , '0' , '0' , '4.25' ) 30/04/2022 09:42:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 30/04/2022 09:42:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 30/04/2022 09:45:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '54697' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-11') 30/04/2022 09:45:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1091', document_date = '2022-04-11', 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 = '377.00', price_tax_excluded = '311.36', date_upd = NOW() WHERE id_document = '54697' 30/04/2022 09:45:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54697' 30/04/2022 09:45:40 am >> DELETE FROM ps_document_detail WHERE id_document = '54697' 30/04/2022 09:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '15330' , 'CERO PASQUALE 80X120 - DECORI PARTICOLARI' , '1' , '-1' , '1' , '169.0000' , '138.52459016393' , '22' , '0' , '169.00' ) 30/04/2022 09:45:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '15330' AND id_supplier = '' 30/04/2022 09:45:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15330' , '' , '1' ) 30/04/2022 09:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.25' , '8.25' , '0' , '0' , '8.25' ) 30/04/2022 09:45:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/04/2022 09:45:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/04/2022 09:45:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 30/04/2022 09:45:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 30/04/2022 09:45:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 30/04/2022 09:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '17745' , 'DALMATICA CROCE - PDA001' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 30/04/2022 09:45:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17745' AND id_supplier = '' 30/04/2022 09:45:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17745' , '' , '1' ) 30/04/2022 09:45:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/04/2022 09:45:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 30/04/2022 09:45:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 30/04/2022 09:59:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554886' AND id_product != '19478' AND ean13 != '' 30/04/2022 09:59:58 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/5', ean13 = '9788831554886', date_upd = NOW() WHERE id_product = '19478' 30/04/2022 09:59:58 am >> UPDATE ps_product_lang SET name = 'MARIA CANTO DI SPERANZA - FRANCESCO', description = '' WHERE id_product = '19478' 30/04/2022 09:59:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5000' WHERE id_product = '19478' 30/04/2022 09:59:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19478' 30/04/2022 09:59:58 am >> DELETE FROM ps_specific_price WHERE id_product = '19478' 30/04/2022 10:03:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1326' AND id_document != '56508' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 30/04/2022 10:03:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1326', 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 = '5.00', price_tax_excluded = '4.10', date_upd = NOW() WHERE id_document = '56508' 30/04/2022 10:03: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 = '56508' 30/04/2022 10:03:34 am >> DELETE FROM ps_document_detail WHERE id_document = '56508' 30/04/2022 10:03: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 ( '56508' , '9148' , 'ROSARIO LEGNO S. BENEDETTO ' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/04/2022 10:03:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '9148' AND id_supplier = '' 30/04/2022 10:03:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9148' , '' , '1' ) 30/04/2022 10:04:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1185' AND id_document != '55320' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-20') 30/04/2022 10:04:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1185', document_date = '2022-04-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '55320' 30/04/2022 10:04:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55320' 30/04/2022 10:04:52 am >> DELETE FROM ps_document_detail WHERE id_document = '55320' 30/04/2022 10:04:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55320' , '11693' , 'BRACCIALE DECINA CAUCCIU PIETRA - 805/23' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 30/04/2022 10:04:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11693' AND id_supplier = '' 30/04/2022 10:04:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11693' , '' , '1' ) 30/04/2022 10:05:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1134' AND id_document != '55264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-14') 30/04/2022 10:05:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1134', document_date = '2022-04-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '56.00', price_tax_excluded = '46.99', date_upd = NOW() WHERE id_document = '55264' 30/04/2022 10:05:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55264' 30/04/2022 10:05:15 am >> DELETE FROM ps_document_detail WHERE id_document = '55264' 30/04/2022 10:05:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55264' , '13182' , 'CLERGY SLIM GRIGIO - MISTO ML 40' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 30/04/2022 10:05:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '13182' AND id_supplier = '' 30/04/2022 10:05:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13182' , '' , '1' ) 30/04/2022 10:05:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55264' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 30/04/2022 10:05:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 30/04/2022 10:05:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 30/04/2022 10:05:16 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 ( '55264' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '0.6000' , '0.6' , '0' , '0' , '1.80' ) 30/04/2022 10:05:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 30/04/2022 10:05:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 30/04/2022 10:05:16 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 ( '55264' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 30/04/2022 10:05:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 30/04/2022 10:05:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 30/04/2022 10:05:16 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 ( '55264' , '11693' , 'BRACCIALE DECINA CAUCCIU PIETRA - 805/23' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 30/04/2022 10:05:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '11693' AND id_supplier = '' 30/04/2022 10:05:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11693' , '' , '1' ) 30/04/2022 10:06:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1321' AND id_document != '56503' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 30/04/2022 10:06:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1321', 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 = '10.50', price_tax_excluded = '8.61', date_upd = NOW() WHERE id_document = '56503' 30/04/2022 10:06:58 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 = '56503' 30/04/2022 10:06:58 am >> DELETE FROM ps_document_detail WHERE id_document = '56503' 30/04/2022 10:06:58 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 ( '56503' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 30/04/2022 10:06:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 30/04/2022 10:06:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 30/04/2022 10:13:48 am >> 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') 30/04/2022 10:13:48 am >> 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 = '200.89', price_tax_excluded = '174.02', date_upd = NOW() WHERE id_document = '56492' 30/04/2022 10:13:49 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 = '56492' 30/04/2022 10:13:49 am >> DELETE FROM ps_document_detail WHERE id_document = '56492' 30/04/2022 10:13:49 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 ( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '42.00' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '5' , '-5' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '11.00' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '5' , '7.24' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '4.80' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 30/04/2022 10:13:49 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 ( '56492' , '7919' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. C' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '7.20' ) 30/04/2022 10:13:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7919' AND id_supplier = '' 30/04/2022 10:13:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7919' , '' , '1' ) 30/04/2022 10:13:50 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 ( '56492' , '7202' , 'ARTICOLI RELIGIOSI' , '60' , '-60' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '60.00' ) 30/04/2022 10:13:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/04/2022 10:13:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/04/2022 10:18:41 am >> 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') 30/04/2022 10:18:41 am >> 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 = '200.89', price_tax_excluded = '174.02', date_upd = NOW() WHERE id_document = '56492' 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56492' 30/04/2022 10:18:41 am >> DELETE FROM ps_document_detail WHERE id_document = '56492' 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '42.00' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 30/04/2022 10:18:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 30/04/2022 10:18:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 30/04/2022 10:18:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '5' , '7.24' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '4.80' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '7919' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. C' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '7.20' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7919' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7919' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '7202' , 'ARTICOLI RELIGIOSI' , '60' , '-60' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '60.00' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/04/2022 10:18:42 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 ( '56492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '2.20' ) 30/04/2022 10:18:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 30/04/2022 10:18:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 30/04/2022 10:27:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1231' AND id_document != '55887' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 30/04/2022 10:27:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1231', document_date = '2022-04-23', 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 = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '55887' 30/04/2022 10:27:06 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 = '55887' 30/04/2022 10:27:06 am >> DELETE FROM ps_document_detail WHERE id_document = '55887' 30/04/2022 10:27:06 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 ( '55887' , '5999' , 'LUME VETRO SOFFIATO MELOGRANO - 1021' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 30/04/2022 10:27:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5999' AND id_supplier = '' 30/04/2022 10:27:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5999' , '' , '1' ) 30/04/2022 10:27:26 am >> SELECT document_num FROM ps_document WHERE document_num = '996' AND id_document != '54593' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-06') 30/04/2022 10:27:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '996', document_date = '2022-04-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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '54593' 30/04/2022 10:27:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54593' 30/04/2022 10:27:26 am >> DELETE FROM ps_document_detail WHERE id_document = '54593' 30/04/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 30/04/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 30/04/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 30/04/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 30/04/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '1631' AND id_supplier = '' 30/04/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1631' , '' , '1' ) 30/04/2022 10:27:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '4961' , 'IMMAGINE DOMENICA DELLE PALME - 207' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 30/04/2022 10:27:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '4961' AND id_supplier = '' 30/04/2022 10:27:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4961' , '' , '1' ) 30/04/2022 10:27:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 30/04/2022 10:27:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 30/04/2022 10:27:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 30/04/2022 10:27:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '7932' , 'PERGAMENE - CRESIMA MOD. D' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '7.50' ) 30/04/2022 10:27:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7932' AND id_supplier = '' 30/04/2022 10:27:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7932' , '' , '1' ) 30/04/2022 10:27:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54593' , '7922' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '4' , '-4' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.00' ) 30/04/2022 10:27:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7922' AND id_supplier = '' 30/04/2022 10:27:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7922' , '' , '1' ) 30/04/2022 10:35:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1151' AND id_document != '55281' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-15') 30/04/2022 10:35:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1151', document_date = '2022-04-15', 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 = '33.00', price_tax_excluded = '27.05', date_upd = NOW() WHERE id_document = '55281' 30/04/2022 10:35:05 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 = '55281' 30/04/2022 10:35:05 am >> DELETE FROM ps_document_detail WHERE id_document = '55281' 30/04/2022 10:35:05 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 ( '55281' , '2171' , 'CLERGY CELESTE MISTO MM - 3XL' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 30/04/2022 10:35:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '2171' AND id_supplier = '' 30/04/2022 10:35:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2171' , '' , '1' ) 30/04/2022 10:38:00 am >> SELECT document_num FROM ps_document WHERE document_num = '982' AND id_document != '54575' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-05') 30/04/2022 10:38:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '982', document_date = '2022-04-05', 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 = '3', id_causal = '0', price_tax_included = '213.00', price_tax_excluded = '194.97', date_upd = NOW() WHERE id_document = '54575' 30/04/2022 10:38: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 = '54575' 30/04/2022 10:38:00 am >> DELETE FROM ps_document_detail WHERE id_document = '54575' 30/04/2022 10:38: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 ( '54575' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '3.00' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19.1600' , '15.704918032787' , '22' , '0' , '19.16' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '29.1800' , '23.918032786885' , '22' , '0' , '29.18' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.4' , '3.4' , '0' , '0' , '3.40' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/04/2022 10:38: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 ( '54575' , '12096' , 'BIBBIA DI GERUSALEMME ' , '2' , '-2' , '4' , '29.0000' , '29' , '0' , '5' , '55.10' ) 30/04/2022 10:38:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '12096' AND id_supplier = '' 30/04/2022 10:38:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12096' , '' , '1' ) 30/04/2022 10:38:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54575' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/04/2022 10:38:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 10:38:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 10:38:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54575' , '18646' , 'NOE E LARCA' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 30/04/2022 10:38:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18646' AND id_supplier = '' 30/04/2022 10:38:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18646' , '' , '1' ) 30/04/2022 10:38:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54575' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 30/04/2022 10:38:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 10:38:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 10:38:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 10:38: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' , '1333' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '7.20' , NOW() , NOW() ) 30/04/2022 10:38: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 = '56516' 30/04/2022 10:38:18 am >> DELETE FROM ps_document_detail WHERE id_document = '56516' 30/04/2022 10:38: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 ( '56516' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.03' , '0.03' , '0' , '0' , '7.20' ) 30/04/2022 10:38:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 30/04/2022 10:38:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 30/04/2022 10:55:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 10:55:46 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' , '1334' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.40' , '21.64' , NOW() , NOW() ) 30/04/2022 10:55:46 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 = '56517' 30/04/2022 10:55:46 am >> DELETE FROM ps_document_detail WHERE id_document = '56517' 30/04/2022 10:55: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 ( '56517' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '22' , '-22' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '26.40' ) 30/04/2022 10:55:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 30/04/2022 10:55:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 30/04/2022 10:56:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 10:56:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1335' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 30/04/2022 10:56:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56518' 30/04/2022 10:56:36 am >> DELETE FROM ps_document_detail WHERE id_document = '56518' 30/04/2022 10:56:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56518' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 30/04/2022 10:56:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 10:56:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 11:10:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1336' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:10: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' , '1336' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '3.52' , NOW() , NOW() ) 30/04/2022 11:10: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 = '56519' 30/04/2022 11:10:18 am >> DELETE FROM ps_document_detail WHERE id_document = '56519' 30/04/2022 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56519' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/04/2022 11:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '14773' AND id_supplier = '' 30/04/2022 11:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14773' , '' , '1' ) 30/04/2022 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56519' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 30/04/2022 11:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 30/04/2022 11:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 30/04/2022 11:10:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:10: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' , '1337' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '68.52' , NOW() , NOW() ) 30/04/2022 11:10: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 = '56520' 30/04/2022 11:10:45 am >> DELETE FROM ps_document_detail WHERE id_document = '56520' 30/04/2022 11:10: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 ( '56520' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 30/04/2022 11:10:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 30/04/2022 11:10:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 30/04/2022 11:10: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 ( '56520' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/04/2022 11:10:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/04/2022 11:10:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/04/2022 11:10: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 ( '56520' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.00' , '2.8846153846154' , '4' , '0' , '6.00' ) 30/04/2022 11:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/04/2022 11:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/04/2022 11:10: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 ( '56520' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/04/2022 11:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/04/2022 11:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/04/2022 11:10: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 ( '56520' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 30/04/2022 11:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/04/2022 11:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/04/2022 11:11:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '56520' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:11:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1337', document_date = '2022-04-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.00', price_tax_excluded = '68.52', date_upd = NOW() WHERE id_document = '56520' 30/04/2022 11:11:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56520' 30/04/2022 11:11:01 am >> DELETE FROM ps_document_detail WHERE id_document = '56520' 30/04/2022 11:11:02 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 ( '56520' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 30/04/2022 11:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 30/04/2022 11:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 30/04/2022 11:11:02 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 ( '56520' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/04/2022 11:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/04/2022 11:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/04/2022 11:11:02 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 ( '56520' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 30/04/2022 11:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/04/2022 11:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/04/2022 11:11:02 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 ( '56520' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/04/2022 11:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/04/2022 11:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/04/2022 11:11:02 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 ( '56520' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 30/04/2022 11:11:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/04/2022 11:11:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/04/2022 11:23:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:23: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' , '1338' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.20' , '25.57' , NOW() , NOW() ) 30/04/2022 11:23: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 = '56521' 30/04/2022 11:23:45 am >> DELETE FROM ps_document_detail WHERE id_document = '56521' 30/04/2022 11:23: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 ( '56521' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/04/2022 11:23:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14114' AND id_supplier = '' 30/04/2022 11:23:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14114' , '' , '1' ) 30/04/2022 11:23: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 ( '56521' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 30/04/2022 11:23:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 30/04/2022 11:23:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 30/04/2022 11:32:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:32:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1339' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 30/04/2022 11:32:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56522' 30/04/2022 11:32:44 am >> DELETE FROM ps_document_detail WHERE id_document = '56522' 30/04/2022 11:32: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 ( '56522' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 30/04/2022 11:32:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 30/04/2022 11:32:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 30/04/2022 11:34:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:34:17 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' , '1340' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.70' , '10.07' , NOW() , NOW() ) 30/04/2022 11:34:17 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 = '56523' 30/04/2022 11:34:17 am >> DELETE FROM ps_document_detail WHERE id_document = '56523' 30/04/2022 11:34:17 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 ( '56523' , '10742' , 'TROPPO FORTE - 3/ IL VOLO + CD' , '1' , '-1' , '4' , '7.2' , '7.2' , '0' , '0' , '7.20' ) 30/04/2022 11:34:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '10742' AND id_supplier = '' 30/04/2022 11:34:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10742' , '' , '1' ) 30/04/2022 11:34:17 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 ( '56523' , '4404' , 'GESÙ CONFIDO IN TE - 296' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 30/04/2022 11:34:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '4404' AND id_supplier = '' 30/04/2022 11:34:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4404' , '' , '1' ) 30/04/2022 11:54:43 am >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:54: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 ( '24' , '32/A' , '2022-04-30' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1237.00' , '1224.02' , NOW() , NOW() ) 30/04/2022 11:54: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 = '56524' 30/04/2022 11:54:43 am >> DELETE FROM ps_document_detail WHERE id_document = '56524' 30/04/2022 11:54: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 ( '56524' , '1833' , 'CLERGY' , '1' , '-1' , '4' , '40' , '40' , '0' , '0' , '40.00' ) 30/04/2022 11:54: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 ( '56524' , '' , 'CAMICE' , '1' , '-1' , '4' , '115' , '115' , '0' , '0' , '115.00' ) 30/04/2022 11:54: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 ( '56524' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 30/04/2022 11:54: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 ( '56524' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 30/04/2022 11:54: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 ( '56524' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '150' , '-150' , '4' , '3.00' , '3' , '0' , '0' , '450.00' ) 30/04/2022 11:56:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:56:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1341' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.80' , '103.50' , NOW() , NOW() ) 30/04/2022 11:56:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56525' 30/04/2022 11:56:19 am >> DELETE FROM ps_document_detail WHERE id_document = '56525' 30/04/2022 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56525' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '9.00' ) 30/04/2022 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/04/2022 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/04/2022 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56525' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '2.8' , '2.6923076923077' , '4' , '0' , '16.80' ) 30/04/2022 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/04/2022 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/04/2022 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56525' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4' , '3.2786885245902' , '22' , '0' , '96.00' ) 30/04/2022 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 30/04/2022 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 30/04/2022 11:57:47 am >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '56524' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 11:57:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '32/A', document_date = '2022-04-30', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '402.00', price_tax_excluded = '389.02', date_upd = NOW() WHERE id_document = '56524' 30/04/2022 11:57:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56524' 30/04/2022 11:57:47 am >> DELETE FROM ps_document_detail WHERE id_document = '56524' 30/04/2022 11:57:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56524' , '1833' , 'CLERGY' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '0' , '40.00' ) 30/04/2022 11:57:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1833' AND id_supplier = '' 30/04/2022 11:57:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1833' , '' , '1' ) 30/04/2022 11:57:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56524' , '0' , 'CAMICE' , '1' , '-1' , '4' , '115.0000' , '115' , '0' , '0' , '115.00' ) 30/04/2022 11:57:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/04/2022 11:57:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/04/2022 11:57:48 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 ( '56524' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' , '72.0000' , '59.016393442623' , '22' , '0' , '72.00' ) 30/04/2022 11:57:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '' 30/04/2022 11:57:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '' , '1' ) 30/04/2022 11:57:48 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 ( '56524' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '0' , '175.00' ) 30/04/2022 11:57:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '12812' AND id_supplier = '' 30/04/2022 11:57:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12812' , '' , '1' ) 30/04/2022 12:10:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 12:10: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' , '1342' , '2022-04-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.50' , '46.39' , NOW() , NOW() ) 30/04/2022 12:10: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 = '56526' 30/04/2022 12:10:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '56526' 30/04/2022 12:10: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 ( '56526' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 30/04/2022 12:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 30/04/2022 12:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 30/04/2022 12:10: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 ( '56526' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '31' , '-31' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.50' ) 30/04/2022 12:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 30/04/2022 12:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 30/04/2022 12:10: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 ( '56526' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 30/04/2022 12:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 30/04/2022 12:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 30/04/2022 12:10: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 ( '56526' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 30/04/2022 12:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/04/2022 12:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/04/2022 12:13:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1342' AND id_document != '56526' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 30/04/2022 12:13:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1342', document_date = '2022-04-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.50', price_tax_excluded = '46.39', date_upd = NOW() WHERE id_document = '56526' 30/04/2022 12:13:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56526' 30/04/2022 12:13:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '56526' 30/04/2022 12:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56526' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 30/04/2022 12:13:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 30/04/2022 12:13:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 30/04/2022 12:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56526' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '31' , '-31' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.50' ) 30/04/2022 12:13:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 30/04/2022 12:13:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 30/04/2022 12:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56526' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '20.00' ) 30/04/2022 12:13:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 30/04/2022 12:13:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 30/04/2022 12:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56526' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 30/04/2022 12:13:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 30/04/2022 12:13:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 30/04/2022 12:14:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '54697' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-11') 30/04/2022 12:14:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1091', document_date = '2022-04-11', 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 = '377.00', price_tax_excluded = '311.36', date_upd = NOW() WHERE id_document = '54697' 30/04/2022 12:14:22 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 = '54697' 30/04/2022 12:14:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '54697' 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '15330' , 'CERO PASQUALE 80X120 - DECORI PARTICOLARI' , '1' , '-1' , '1' , '169.0000' , '138.52459016393' , '22' , '0' , '169.00' ) 30/04/2022 12:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15330' AND id_supplier = '' 30/04/2022 12:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15330' , '' , '1' ) 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '16842' , 'BOTTIGLIE PER ACQUA BENEDETTA - 100PZ ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 30/04/2022 12:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16842' AND id_supplier = '' 30/04/2022 12:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16842' , '' , '1' ) 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '17745' , 'DALMATICA CROCE - PDA001' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 30/04/2022 12:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17745' AND id_supplier = '' 30/04/2022 12:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17745' , '' , '1' ) 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/04/2022 12:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 30/04/2022 12:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '19275' , 'AMEN - MAG. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/04/2022 12:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 30/04/2022 12:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 30/04/2022 12:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54697' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/04/2022 12:14:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 30/04/2022 12:14:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 30/04/2022 12:14: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 ( '54697' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.83' , '0.83' , '0' , '0' , '0.83' ) 30/04/2022 12:14:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 30/04/2022 12:14:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 30/04/2022 12:16:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '200' , '2022-04-29' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.90' , '95.00' , NOW() , NOW() ) 30/04/2022 12:16:35 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 = '56527' 30/04/2022 12:16:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '56527' 30/04/2022 12:16:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56527' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '0' , '1' , '30.0000' , '24.5902' , '22' , '0' , '36.60' ) 30/04/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14919' AND id_supplier = '122' 30/04/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14919' , '122' , '1' ) 30/04/2022 12:16:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56527' , '19453' , 'COTTA BIANCA - AECO06B00' , '2' , '0' , '1' , '32.5000' , '26.6393' , '22' , '0' , '79.30' ) 30/04/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19453' AND id_supplier = '122' 30/04/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19453' , '122' , '1' )