05/04/2023 08:45:13 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/04/2023 08:45:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20895' , '1' , '' , 'nuovo-prodotto' ) 05/04/2023 08:45:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20895' , '1' , '1' , '2' , NOW() , NOW() ) 05/04/2023 08:45:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20895' , '0' , '1' , '0' , '0' ) 05/04/2023 08:46:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048523' AND id_product != '20895' AND ean13 != '' 05/04/2023 08:46:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048523', date_upd = NOW() WHERE id_product = '20895' 05/04/2023 08:46:16 am >> UPDATE ps_product_lang SET name = 'NOVE MARTEDI\' DELL\'ANGELO CUSTODE - 8458', description = '' WHERE id_product = '20895' 05/04/2023 08:46:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20895' 05/04/2023 08:46:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20895' 05/04/2023 08:46:16 am >> DELETE FROM ps_specific_price WHERE id_product = '20895' 05/04/2023 08:46:17 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20895' 05/04/2023 08:46:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20896' , '1' , '' , 'nuovo-prodotto' ) 05/04/2023 08:46:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20896' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20895' 05/04/2023 08:46:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20896' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20895' 05/04/2023 08:47:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048509' AND id_product != '20896' AND ean13 != '' 05/04/2023 08:47:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048509', date_upd = NOW() WHERE id_product = '20896' 05/04/2023 08:47:20 am >> UPDATE ps_product_lang SET name = 'SANTI DEL MESSALINO. MONICA LA VITA 8467', description = '' WHERE id_product = '20896' 05/04/2023 08:47:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20896' 05/04/2023 08:47:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20896' 05/04/2023 08:47:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20896' 05/04/2023 08:47:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20896' 05/04/2023 08:47:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20897' , '1' , '' , 'nuovo-prodotto' ) 05/04/2023 08:47:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20897' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20896' 05/04/2023 08:47:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20897' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20896' 05/04/2023 08:48:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048592' AND id_product != '20897' AND ean13 != '' 05/04/2023 08:48:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048592', date_upd = NOW() WHERE id_product = '20897' 05/04/2023 08:48:05 am >> UPDATE ps_product_lang SET name = 'ELISE BISSCHOP - 8470', description = '' WHERE id_product = '20897' 05/04/2023 08:48:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20897' 05/04/2023 08:48:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', 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 = '20897' 05/04/2023 08:48:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20897' 05/04/2023 08:48:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20897' 05/04/2023 08:48:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20898' , '1' , '' , 'nuovo-prodotto' ) 05/04/2023 08:48:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20898' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20897' 05/04/2023 08:48:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20898' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20897' 05/04/2023 08:48:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '5550/00/2023' , '2023-03-31' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '121.20' , '121.20' , NOW() , NOW() ) 05/04/2023 08:48: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 = '82664' 05/04/2023 08:48:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82664' 05/04/2023 08:48: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 ( '82664' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '3' , '3' , '4' , '10.00' , '10' , '0' , '40' , '18.0000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '2' , '2' , '4' , '9.00' , '9' , '0' , '40' , '10.8000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '10712' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10712' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20895' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20895' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '8219' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8219' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '20896' , 'SANTI DEL MESSALINO. MONICA LA VITA 8467' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20896' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20896' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '20897' , 'ELISE BISSCHOP - 8470' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20897' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20897' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '6' , '6' , '4' , '7.00' , '7' , '0' , '40' , '25.2000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '7704' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7704' , '38' , '1' ) 05/04/2023 08:48: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 ( '82664' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 05/04/2023 08:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '13034' AND id_supplier = '38' 05/04/2023 08:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13034' , '38' , '1' ) 05/04/2023 09:10:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 09:10: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' , '1142' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.10' , '45.94' , NOW() , NOW() ) 05/04/2023 09:10: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 = '82665' 05/04/2023 09:10:44 am >> DELETE FROM ps_document_detail WHERE id_document = '82665' 05/04/2023 09:10: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 ( '82665' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 05/04/2023 09:10: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 ( '82665' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 05/04/2023 09:10: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 ( '82665' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 05/04/2023 10:31:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1143' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:31:48 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' , '1143' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.26' , NOW() , NOW() ) 05/04/2023 10:31:48 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 = '82666' 05/04/2023 10:31:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82666' 05/04/2023 10:31: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 ( '82666' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/04/2023 10:31: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 ( '82666' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/04/2023 10:31: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 ( '82666' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 05/04/2023 10:32:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1144' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:32:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1144' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/04/2023 10:32:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82667' 05/04/2023 10:32:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82667' 05/04/2023 10:32:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82667' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 10:35:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:35:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1145' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.00' , '131.81' , NOW() , NOW() ) 05/04/2023 10:35:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82668' 05/04/2023 10:35:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82668' 05/04/2023 10:35:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82668' , '20077' , 'BRACCIALE ARGENTO' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 05/04/2023 10:35:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82668' , '14198' , 'CIONDOLO IN ACCIAIO CON CAT.' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 05/04/2023 10:35:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82668' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '5' , '85.50' ) 05/04/2023 10:37:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:37:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1146' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 05/04/2023 10:37:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82669' 05/04/2023 10:37:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82669' 05/04/2023 10:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82669' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 05/04/2023 10:40:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:40:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1147' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.90' , '26.97' , NOW() , NOW() ) 05/04/2023 10:40:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82670' 05/04/2023 10:40:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82670' 05/04/2023 10:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82670' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 05/04/2023 10:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82670' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 05/04/2023 10:44:09 am >> SELECT document_num FROM ps_document WHERE document_num = '47/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:44:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '47/A' , '2023-04-05' , 'A' , '1192' , '0' , '1192' , 'VIA ROMA 84020 RICIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.00' , '195.00' , NOW() , NOW() ) 05/04/2023 10:44:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82671' 05/04/2023 10:44:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82671' 05/04/2023 10:44:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82671' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140' , '140' , '0' , '5' , '133.00' ) 05/04/2023 10:44:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82671' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 05/04/2023 10:44:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82671' , '' , 'adesivi cero pasquale' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 05/04/2023 10:51:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 10:51:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1148' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 05/04/2023 10:51:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82672' 05/04/2023 10:51:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82672' 05/04/2023 10:51:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82672' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 05/04/2023 10:51:38 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '82478' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-27') 05/04/2023 10:51:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2023-03-27', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '82478' 05/04/2023 10:51:39 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 = '82478' 05/04/2023 10:51:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82478' 05/04/2023 10:51:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82478' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '32.00' ) 05/04/2023 11:02:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 11:02:58 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' , '1149' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.00' , '102.16' , NOW() , NOW() ) 05/04/2023 11:02: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 = '82673' 05/04/2023 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '82673' 05/04/2023 11:02: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 ( '82673' , '19158' , 'SETTIMANA SANTA - N.E.' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '10' , '9.00' ) 05/04/2023 11:02: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 ( '82673' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 05/04/2023 11:02: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 ( '82673' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 11:02: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 ( '82673' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 05/04/2023 11:11:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 11:11:59 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' , '1150' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.80' , '7.21' , NOW() , NOW() ) 05/04/2023 11:11:59 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 = '82674' 05/04/2023 11:11:59 am >> DELETE FROM ps_document_detail WHERE id_document = '82674' 05/04/2023 11:11:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82674' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/04/2023 11:11:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82674' , '15334' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 05/04/2023 11:11:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82674' , '7941' , 'PERGAMENE - OCCASIONI MOD. A' , '20' , '-20' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.00' ) 05/04/2023 11:12:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 11:12:39 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' , '1151' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 05/04/2023 11:12:39 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 = '82675' 05/04/2023 11:12:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82675' 05/04/2023 11:12:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82675' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/04/2023 11:59:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 11:59:06 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' , '1152' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 05/04/2023 11:59: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 = '82676' 05/04/2023 11:59:06 am >> DELETE FROM ps_document_detail WHERE id_document = '82676' 05/04/2023 11:59: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 ( '82676' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 05/04/2023 11:59: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 ( '82676' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '4' , '-4' , '1' , '13' , '10.655737704918' , '22' , '0' , '52.00' ) 05/04/2023 03:39:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 03:39:05 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' , '1153' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 05/04/2023 03:39:05 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 = '82677' 05/04/2023 03:39:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82677' 05/04/2023 03:39:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82677' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '21.00' ) 05/04/2023 03:57:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 03:57:13 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' , '1154' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.00' , '81.15' , NOW() , NOW() ) 05/04/2023 03:57:13 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 = '82678' 05/04/2023 03:57:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82678' 05/04/2023 03:57:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82678' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 05/04/2023 04:20:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 04:20:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1155' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/04/2023 04:20:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82679' 05/04/2023 04:20:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '82679' 05/04/2023 04:20:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82679' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 04:23:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 04:23:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1156' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/04/2023 04:23:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82680' 05/04/2023 04:23:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82680' 05/04/2023 04:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82680' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 04:54:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 04:54:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1157' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.65' , '25.92' , NOW() , NOW() ) 05/04/2023 04:54:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82681' 05/04/2023 04:54:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82681' 05/04/2023 04:54:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82681' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 05/04/2023 04:54:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82681' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '3' , '-3' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '9.60' ) 05/04/2023 04:54:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82681' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/04/2023 05:03:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '70/23' , '2023-03-31' , '23' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '832.00' , '800.00' , NOW() , NOW() ) 05/04/2023 05:03:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82682' 05/04/2023 05:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82682' 05/04/2023 05:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82682' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '600' , '0' , '3' , '0.8' , '0.76923076923077' , '4' , '0' , '499.2000' ) 05/04/2023 05:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20785' AND id_supplier = '145' 05/04/2023 05:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20785' , '145' , '1' ) 05/04/2023 05:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82682' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '400' , '0' , '3' , '0.8' , '0.76923076923077' , '4' , '0' , '332.8000' ) 05/04/2023 05:03:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20785' AND id_supplier = '145' 05/04/2023 05:03:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20785' , '145' , '1' ) 05/04/2023 05:03:50 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '000110', document_date = '2023-03-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', address2 = '', note = 'INVIATE A BYBLOS', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '82365' 05/04/2023 05:03:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82365' 05/04/2023 05:03:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82365' 05/04/2023 05:03:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82365' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '600' , '600' , '4' , '0.0000' , '0' , '0' , '0' , '0.0000' ) 05/04/2023 05:04:19 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '70/23', document_date = '2023-03-31', document_letter = '23', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '10', id_causal = '0', price_tax_included = '832.00', price_tax_excluded = '800.00', date_upd = NOW() WHERE id_document = '82682' 05/04/2023 05:04:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82682' 05/04/2023 05:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82682' 05/04/2023 05:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82682' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '600' , '0' , '3' , '0.8000' , '0.76923076923077' , '4' , '0' , '499.20' ) 05/04/2023 05:04:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82682' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '400' , '0' , '3' , '0.8000' , '0.76923076923077' , '4' , '0' , '332.80' ) 05/04/2023 05:20:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 05/04/2023 05:20:27 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 50,00+100 2/2/23 + 50,00 24/02 + 50,00 15/3/22+ 50,00 22/3/23+ 50,00 5/4/23', 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 = '485.00', price_tax_excluded = '485.00', date_upd = NOW() WHERE id_document = '59768' 05/04/2023 05:20:27 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 = '59768' 05/04/2023 05:20:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768' 05/04/2023 05:20:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 05/04/2023 05:21:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 05/04/2023 05:21:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 100,00 5/4/23', 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 = '1460.00', price_tax_excluded = '1196.72', date_upd = NOW() WHERE id_document = '56617' 05/04/2023 05:21:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56617' 05/04/2023 05:21:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 05/04/2023 05:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 05/04/2023 05:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 05/04/2023 05:23:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 05:23:06 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' , '1158' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '186.95' , '156.84' , NOW() , NOW() ) 05/04/2023 05:23:06 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 = '82683' 05/04/2023 05:23:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82683' 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.00' , '7' , '0' , '5' , '19.95' ) 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 05/04/2023 05:23:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 05/04/2023 05:25:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 05:25: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 ( '24' , '48/A' , '2023-04-05' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 05/04/2023 05:25: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 = '82684' 05/04/2023 05:25:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82684' 05/04/2023 05:25: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 05/04/2023 05:56:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 05:56:57 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' , '1159' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 05/04/2023 05:56:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82685' 05/04/2023 05:56:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82685' 05/04/2023 05:56:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82685' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/04/2023 05:57:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '164/2023' , '2023-03-20' , '2023' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '239.12' , '196.00' , NOW() , NOW() ) 05/04/2023 05:57:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82686' 05/04/2023 05:57:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82686' 05/04/2023 05:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82686' , '16771' , 'QUADRO DECORATO' , '30' , '30' , '1' , '6.2' , '5.0819672131148' , '22' , '0' , '226.9200' ) 05/04/2023 05:57:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16771' AND id_supplier = '50' 05/04/2023 05:57:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16771' , '50' , '1' ) 05/04/2023 06:25:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 06:25:24 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' , '1160' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 05/04/2023 06:25:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82687' 05/04/2023 06:25:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82687' 05/04/2023 06:25:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82687' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023222229' , '2023-03-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '37.85' , '37.85' , NOW() , NOW() ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82688' 05/04/2023 06:45:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82688' 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20829' , 'SOSTARE CON TE 2' , '1' , '0' , '4' , '7.03' , '7.03' , '0' , '0' , '7.0300' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20829' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20829' , '109' , '1' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20832' , 'BONTA\' DELLA FEDE - S. TARDANI' , '1' , '0' , '4' , '10.72' , '10.72' , '0' , '0' , '10.7200' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20832' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20832' , '109' , '1' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20831' , 'TRA SGUARDI DI SPERANZA ' , '1' , '0' , '4' , '2.68' , '2.68' , '0' , '0' , '2.6800' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20831' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20831' , '109' , '1' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20830' , 'TRA SGUARDI DI SPERANZA! ' , '1' , '0' , '4' , '2.68' , '2.68' , '0' , '0' , '2.6800' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20830' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20830' , '109' , '1' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20834' , 'SALMI - M. VERSACI ' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20834' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20834' , '109' , '1' ) 05/04/2023 06:45:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82688' , '20828' , 'DEVOZIONE AI PIEDI DI GESU\' - G. LAMBERTO' , '1' , '0' , '4' , '5.36' , '5.36' , '0' , '0' , '5.3600' ) 05/04/2023 06:45:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20828' AND id_supplier = '109' 05/04/2023 06:45:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20828' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023222227' , '2023-03-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '90.52' , '90.52' , NOW() , NOW() ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82689' 05/04/2023 06:48:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82689' 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20827' , 'DANTE E GRANDI QUESTIONI ESCATOLOGICHE - L. AZZETTA' , '1' , '0' , '4' , '19.25' , '19.25' , '0' , '0' , '19.2500' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20827' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20827' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '0' , '4' , '18' , '18' , '0' , '0' , '18.0000' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20641' , 'ENCICLICA SULLA PACE IN UCRAINA ' , '1' , '0' , '4' , '10.8' , '10.8' , '0' , '0' , '10.8000' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20641' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20641' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20588' , 'FELICITA\' DEL CUORE - F. SHEEN' , '1' , '0' , '4' , '15.84' , '15.84' , '0' , '0' , '15.8400' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20588' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20588' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' , '10.08' , '10.08' , '0' , '0' , '10.0800' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 05/04/2023 06:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82689' , '20024' , 'PER L\'ETERNITA\' - R. SARAH' , '1' , '0' , '4' , '16.55' , '16.55' , '0' , '0' , '16.5500' ) 05/04/2023 06:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '109' 05/04/2023 06:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '109' , '1' ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '815' , '2023-03-31' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.36' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.41' , '76.41' , NOW() , NOW() ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82690' 05/04/2023 06:50:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82690' 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82690' , '20877' , 'NEL SEGNO DELLA DIVINA VOLONTA - L. PICCARRETA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '30' , '5.60' ) 05/04/2023 06:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20877' AND id_supplier = '47' 05/04/2023 06:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20877' , '47' , '1' ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82690' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '30' , '2.10' ) 05/04/2023 06:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '47' 05/04/2023 06:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '47' , '1' ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82690' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '3' , '0' , '4' , '17.5000' , '17.5' , '0' , '30' , '36.75' ) 05/04/2023 06:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20878' AND id_supplier = '47' 05/04/2023 06:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20878' , '47' , '1' ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82690' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '14.00' ) 05/04/2023 06:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20880' AND id_supplier = '47' 05/04/2023 06:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20880' , '47' , '1' ) 05/04/2023 06:50:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82690' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 05/04/2023 06:50:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20879' AND id_supplier = '47' 05/04/2023 06:50:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20879' , '47' , '1' ) 05/04/2023 06:52:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 06:52:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1161' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.56' , NOW() , NOW() ) 05/04/2023 06:52:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82691' 05/04/2023 06:52:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82691' 05/04/2023 06:52:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82691' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/04/2023 06:52:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82691' , '6019' , 'LUMINO ROSSO - 10B' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 05/04/2023 06:54:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1158' AND id_document != '82683' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 06:54:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1158', document_date = '2023-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 = '0', id_causal = '0', price_tax_included = '186.95', price_tax_excluded = '156.84', date_upd = NOW() WHERE id_document = '82683' 05/04/2023 06:54:41 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 = '82683' 05/04/2023 06:54:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82683' 05/04/2023 06:54:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 05/04/2023 06:54:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/04/2023 06:54:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/04/2023 06:54:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.0000' , '7' , '0' , '5' , '19.95' ) 05/04/2023 06:54:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82683' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '97' , '79.508196721311' , '22' , '0' , '97.00' ) 05/04/2023 07:26:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 07:26:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1162' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 05/04/2023 07:26:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82692' 05/04/2023 07:26:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82692' 05/04/2023 07:26:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82692' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 05/04/2023 07:31:18 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '96' 05/04/2023 07:31:18 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '96' , '10' , '135' , 'ECUMENICUS' , '' , '' , 'VIA D. CHIESA, 18' , '' , '24026' , 'LEFFE' , '' , '035731966' , '' , '' , '' , NOW() , NOW() ) 05/04/2023 07:31:18 pm >> UPDATE ps_customer SET email = 'ecumenicus@ecumenicus.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '96' 05/04/2023 07:31:44 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '89/23', document_date = '2023-03-23', document_letter = '23', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '60.00', price_tax_excluded = '60.00', date_upd = NOW() WHERE id_document = '82635' 05/04/2023 07:31:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82635' 05/04/2023 07:31:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82635' 05/04/2023 07:31: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 ( '82635' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '100' , '4' , '0.6000' , '0.6' , '0' , '0' , '60.00' ) 05/04/2023 07:32:16 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '89/23', document_date = '2023-03-23', document_letter = '23', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '60.00', price_tax_excluded = '60.00', date_upd = NOW() WHERE id_document = '82635' 05/04/2023 07:32:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82635' 05/04/2023 07:32:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82635' 05/04/2023 07:32:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82635' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '100' , '4' , '0.6000' , '0.6' , '0' , '0' , '60.00' ) 05/04/2023 07:32:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17861' AND id_supplier = '17' 05/04/2023 07:32:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17861' , '17' , '1' ) 05/04/2023 07:46:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 07:46:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1163' , '2023-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 05/04/2023 07:46:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82693' 05/04/2023 07:46:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82693' 05/04/2023 07:46:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82693' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/04/2023 07:47:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '49/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 05/04/2023 07:47:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '49/A' , '2023-04-05' , 'A' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 05/04/2023 07:47:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82694' 05/04/2023 07:47:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '82694' 05/04/2023 07:47: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 ( '82694' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 05/04/2023 07:47: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 ( '82694' , '' , 'PIGNE CERO' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' )