07/03/2023 08:16:11 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 ( '32' , '357/23' , '2023-02-28' , '23' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0.02' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2750.80' , '2645.00' , NOW() , NOW() ) 07/03/2023 08:16:11 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 = '82166' 07/03/2023 08:16:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82166' 07/03/2023 08:16:11 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 ( '82166' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '3000' , '0' , '3' , '0.27333' , '0.26281730769231' , '4' , '0' , '852.7896' ) 07/03/2023 08:16:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20652' AND id_supplier = '125' 07/03/2023 08:16:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20652' , '125' , '1' ) 07/03/2023 08:16:12 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 ( '82166' , '20722' , 'SEMINATORI DI GIOIA' , '3000' , '0' , '3' , '0.375' , '0.36057692307692' , '4' , '0' , '1170.0000' ) 07/03/2023 08:16:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20722' AND id_supplier = '125' 07/03/2023 08:16:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20722' , '125' , '1' ) 07/03/2023 08:16:12 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 ( '82166' , '20719' , 'CORONA DELL’ADDOLORATA' , '3000' , '0' , '3' , '0.23333' , '0.22435576923077' , '4' , '0' , '727.9896' ) 07/03/2023 08:16:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20719' AND id_supplier = '125' 07/03/2023 08:16:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20719' , '125' , '1' ) 07/03/2023 08:33:42 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 07/03/2023 08:33:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20795' , '1' , '' , 'nuovo-prodotto' ) 07/03/2023 08:33:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20795' , '1' , '1' , '2' , NOW() , NOW() ) 07/03/2023 08:33:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20795' , '0' , '1' , '0' , '0' ) 07/03/2023 08:34:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048493' AND id_product != '20795' AND ean13 != '' 07/03/2023 08:34:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048493', date_upd = NOW() WHERE id_product = '20795' 07/03/2023 08:34:26 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAG GIU 2023 - 516', description = '' WHERE id_product = '20795' 07/03/2023 08:34:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '20795' 07/03/2023 08:34:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20795' 07/03/2023 08:34:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20795' 07/03/2023 08:34:28 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 = '20795' 07/03/2023 08:34:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20796' , '1' , '' , 'nuovo-prodotto' ) 07/03/2023 08:34:28 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 '20796' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20795' 07/03/2023 08:34:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20796' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20795' 07/03/2023 08:36:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048561' AND id_product != '20796' AND ean13 != '' 07/03/2023 08:36:38 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788884048561', date_upd = NOW() WHERE id_product = '20796' 07/03/2023 08:36:38 am >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE STORIA DI UN GRANDE PAPA\' - 8472', description = '' WHERE id_product = '20796' 07/03/2023 08:36:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '20796' 07/03/2023 08:36:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20796' 07/03/2023 08:36:39 am >> DELETE FROM ps_specific_price WHERE id_product = '20796' 07/03/2023 08:36:40 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 = '20796' 07/03/2023 08:36:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20797' , '1' , '' , 'nuovo-prodotto' ) 07/03/2023 08:36:40 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 '20797' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20796' 07/03/2023 08:36:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20797' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20796' 07/03/2023 08:36:52 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' , '3986/00/2023' , '2023-03-03' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '133.80' , '133.80' , NOW() , NOW() ) 07/03/2023 08:36: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 = '82167' 07/03/2023 08:36:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82167' 07/03/2023 08:36: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 ( '82167' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '5' , '5' , '4' , '5.00' , '5' , '0' , '40' , '15.0000' ) 07/03/2023 08:36:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20592' AND id_supplier = '38' 07/03/2023 08:36:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20592' , '38' , '1' ) 07/03/2023 08:36: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 ( '82167' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '18' , '18' , '4' , '5.00' , '5' , '0' , '40' , '54.0000' ) 07/03/2023 08:36:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 07/03/2023 08:36:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 07/03/2023 08:36: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 ( '82167' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '3' , '3' , '4' , '10.00' , '10' , '0' , '40' , '18.0000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '10' , '10' , '4' , '3.00' , '3' , '0' , '40' , '18.0000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '17626' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17626' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '3612' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3612' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '6419' , 'MESE DI MARZO DEDICATO A SAN GIUSEPPE - 8340' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6419' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6419' , '38' , '1' ) 07/03/2023 08:36:53 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 ( '82167' , '20796' , 'SAN GIUSEPPE STORIA DI UN GRANDE PAPA - 8472' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 07/03/2023 08:36:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20796' AND id_supplier = '38' 07/03/2023 08:36:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20796' , '38' , '1' ) 07/03/2023 09:33:45 am >> SELECT document_num FROM ps_document WHERE document_num = '738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 09:33: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' , '738' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 07/03/2023 09:33: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 = '82168' 07/03/2023 09:33:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82168' 07/03/2023 09:33: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 ( '82168' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 07/03/2023 10:42:46 am >> SELECT document_num FROM ps_document WHERE document_num = '739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 10:42: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' , '739' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.34' , '24.34' , NOW() , NOW() ) 07/03/2023 10:42: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 = '82169' 07/03/2023 10:42:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82169' 07/03/2023 10:42: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 ( '82169' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/03/2023 10:42: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 ( '82169' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/03/2023 10:42: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 ( '82169' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/03/2023 10:42: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 ( '82169' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/03/2023 10:42: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 ( '82169' , '20765' , 'AMEN - MAG 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/03/2023 10:42: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 ( '82169' , '20766' , 'AMEN - GIU 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/03/2023 10:50:10 am >> SELECT document_num FROM ps_document WHERE document_num = '740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 10:50: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' , '740' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 07/03/2023 10:50: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 = '82170' 07/03/2023 10:50:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82170' 07/03/2023 10:50: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 ( '82170' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '30' , '-30' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '36.00' ) 07/03/2023 10:51:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240452' AND id_product != '20765' AND ean13 != '' 07/03/2023 10:51:54 am >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788892240452', date_upd = NOW() WHERE id_product = '20765' 07/03/2023 10:51:54 am >> UPDATE ps_product_lang SET name = 'AMEN - MAG 23', description = '' WHERE id_product = '20765' 07/03/2023 10:51:54 am >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '20765' 07/03/2023 10:51:54 am >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20765' 07/03/2023 10:51:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20765' 07/03/2023 10:52:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240469' AND id_product != '20766' AND ean13 != '' 07/03/2023 10:52:02 am >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788892240469', date_upd = NOW() WHERE id_product = '20766' 07/03/2023 10:52:03 am >> UPDATE ps_product_lang SET name = 'AMEN - GIU 23', description = '' WHERE id_product = '20766' 07/03/2023 10:52:03 am >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '20766' 07/03/2023 10:52:03 am >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20766' 07/03/2023 10:52:03 am >> DELETE FROM ps_specific_price WHERE id_product = '20766' 07/03/2023 11:07:57 am >> SELECT document_num FROM ps_document WHERE document_num = '741' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:07:57 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' , '741' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.50' , '89.90' , NOW() , NOW() ) 07/03/2023 11:07:57 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 = '82171' 07/03/2023 11:07:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82171' 07/03/2023 11:07:57 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 ( '82171' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 07/03/2023 11:07:57 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 ( '82171' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '21' , '-21' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '73.50' ) 07/03/2023 11:13:11 am >> SELECT document_num FROM ps_document WHERE document_num = '742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:13:11 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' , '742' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.85' , '142.80' , NOW() , NOW() ) 07/03/2023 11:13:11 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 = '82172' 07/03/2023 11:13:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82172' 07/03/2023 11:13:11 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 ( '82172' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '11' , '-11' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '38.50' ) 07/03/2023 11:13:11 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 ( '82172' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 07/03/2023 11:13:11 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 ( '82172' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 07/03/2023 11:13:11 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 ( '82172' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 07/03/2023 11:13:11 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 ( '82172' , '17876' , 'GIUSEPPE NON TEMERE! - M. GATTAFONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/03/2023 11:13:11 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 ( '82172' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 07/03/2023 11:13:11 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 ( '82172' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 07/03/2023 11:15:06 am >> SELECT document_num FROM ps_document WHERE document_num = '743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:15: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' , '743' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 07/03/2023 11:15: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 = '82173' 07/03/2023 11:15:06 am >> DELETE FROM ps_document_detail WHERE id_document = '82173' 07/03/2023 11:15: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 ( '82173' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 07/03/2023 11:28:07 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:28:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '16' , '2023-03-07' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4024.00' , '4024.00' , NOW() , NOW() ) 07/03/2023 11:28:07 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 = '82174' 07/03/2023 11:28:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82174' 07/03/2023 11:28:08 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 ( '82174' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '600' , '-600' , '4' , '2.40' , '2.4' , '0' , '0' , '1440.00' ) 07/03/2023 11:28:08 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 ( '82174' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '220' , '-220' , '4' , '10.00' , '10' , '0' , '0' , '2200.00' ) 07/03/2023 11:28:08 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 ( '82174' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '240' , '-240' , '4' , '1.60' , '1.6' , '0' , '0' , '384.00' ) 07/03/2023 11:29:56 am >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:29:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '11/E' , '2023-03-07' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '234.00' , '191.80' , NOW() , NOW() ) 07/03/2023 11:29:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82175' 07/03/2023 11:29:56 am >> DELETE FROM ps_document_detail WHERE id_document = '82175' 07/03/2023 11:29:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82175' , '14499' , 'COMUNIONE AI MALATI' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 07/03/2023 11:29:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82175' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '54.00' ) 07/03/2023 11:29:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82175' , '13506' , 'SANTO ROSARIO' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 07/03/2023 11:33:20 am >> SELECT document_num FROM ps_document WHERE document_num = '744' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:33:20 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' , '744' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.31' , '11.31' , NOW() , NOW() ) 07/03/2023 11:33:20 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 = '82176' 07/03/2023 11:33:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82176' 07/03/2023 11:33:20 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 ( '82176' , '20684' , 'PANE QUOTIDIANO - MAR APR 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/03/2023 11:33:20 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 ( '82176' , '20632' , 'MESSA MEDITAZIONE - MAR/APR 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 07/03/2023 11:45:02 am >> SELECT document_num FROM ps_document WHERE document_num = '745' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:45: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 ( '11' , '745' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 07/03/2023 11:45: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 = '82177' 07/03/2023 11:45:02 am >> DELETE FROM ps_document_detail WHERE id_document = '82177' 07/03/2023 11:45: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 ( '82177' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 07/03/2023 11:45: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 ( '82177' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/03/2023 11:45:14 am >> SELECT document_num FROM ps_document WHERE document_num = '746' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:45:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '746' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 07/03/2023 11:45:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82178' 07/03/2023 11:45:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82178' 07/03/2023 11:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82178' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 07/03/2023 11:52:05 am >> SELECT document_num FROM ps_document WHERE document_num = '747' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:52:05 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' , '747' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '463.40' , '386.42' , NOW() , NOW() ) 07/03/2023 11:52: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 = '82179' 07/03/2023 11:52:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82179' 07/03/2023 11:52: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 ( '82179' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 07/03/2023 11:52: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 ( '82179' , '1041' , 'BENEDIZIONI' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 07/03/2023 11:52: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 ( '82179' , '16308' , 'PORTACHIAVI TAU' , '32' , '-32' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '32.00' ) 07/03/2023 11:52: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 ( '82179' , '16310' , 'PORTACHIAVI COLOMBA' , '68' , '-68' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '68.00' ) 07/03/2023 11:52: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 ( '82179' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 07/03/2023 11:52: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 ( '82179' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 07/03/2023 11:52: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 ( '82179' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 07/03/2023 11:52: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 ( '82179' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 07/03/2023 11:53:23 am >> SELECT document_num FROM ps_document WHERE document_num = '748' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 11:53:23 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' , '748' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '12.16' , NOW() , NOW() ) 07/03/2023 11:53:23 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 = '82180' 07/03/2023 11:53:23 am >> DELETE FROM ps_document_detail WHERE id_document = '82180' 07/03/2023 11:53:23 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 ( '82180' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 07/03/2023 11:53:23 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 ( '82180' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 07/03/2023 11:53:23 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 ( '82180' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 07/03/2023 12:12:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 07/03/2023 12:12:41 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2023-02-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'OSP. S. LEONARDO', note = 'OSP. S. LEONARDO', 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 = '234.70', price_tax_excluded = '199.23', date_upd = NOW() WHERE id_document = '81297' 07/03/2023 12:12: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 = '81297' 07/03/2023 12:12:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '81297' 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '0' , '22/02/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '0' , '01/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '' , '07/03/2023' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '' , 'BUSTE PER PALME' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/03/2023 12:12:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '17884' , 'CROCE MOGANO CORPO MET CM 25 - 168M' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/03/2023 12:13:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '749' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 12:13:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '749' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.51' , '24.19' , NOW() , NOW() ) 07/03/2023 12:13:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82181' 07/03/2023 12:13:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82181' 07/03/2023 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '8023' , 'PIER GIORGIO FRASSATI' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 07/03/2023 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '20477' , 'VERITA E MENZOGNE - FULTON J. SHEEN' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 07/03/2023 12:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '9127' , 'ROSARIO LACCATO' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 07/03/2023 12:52:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607900' AND id_product != '20797' AND ean13 != '' 07/03/2023 12:52:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788826607900', date_upd = NOW() WHERE id_product = '20797' 07/03/2023 12:52:46 pm >> UPDATE ps_product_lang SET name = 'QUALCHE PAROLA PRIMA DELL\'APOCALISSE - A. CANDIARD', description = '' WHERE id_product = '20797' 07/03/2023 12:52:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '20797' 07/03/2023 12:52:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20797' 07/03/2023 12:52:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '20797' 07/03/2023 12:52:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20797' 07/03/2023 12:52:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20798' , '1' , '' , 'nuovo-prodotto' ) 07/03/2023 12:52:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20798' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20797' 07/03/2023 12:52:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20798' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20797' 07/03/2023 12:54:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192295' AND id_product != '20798' AND ean13 != '' 07/03/2023 12:54:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280192295', date_upd = NOW() WHERE id_product = '20798' 07/03/2023 12:54:01 pm >> UPDATE ps_product_lang SET name = 'LEZIONARIO FESTIVO ANNO C', description = '' WHERE id_product = '20798' 07/03/2023 12:54:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '60' WHERE id_product = '20798' 07/03/2023 12:54:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '60', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20798' 07/03/2023 12:54:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20798' 07/03/2023 12:54:02 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20798' 07/03/2023 12:54:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20799' , '1' , '' , 'nuovo-prodotto' ) 07/03/2023 12:54:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20799' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20798' 07/03/2023 12:54:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20799' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20798' 07/03/2023 12:54: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 ( '33' , '2023-DL000720' , '2023-03-06' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.35' , '164.35' , NOW() , NOW() ) 07/03/2023 12:54: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 = '82182' 07/03/2023 12:54:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82182' 07/03/2023 12:54: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 ( '82182' , '20797' , 'QUALCHE PAROLA PRIMA DELLAPOCALISSE - A. CANDIARD' , '1' , '1' , '4' , '11.00' , '11' , '0' , '45' , '6.0500' ) 07/03/2023 12:54:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20797' AND id_supplier = '79' 07/03/2023 12:54:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20797' , '79' , '1' ) 07/03/2023 12:54: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 ( '82182' , '13380' , 'INTERPRETAZIONE DELLA BIBBIA NELLA CHIESA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '45' , '3.3000' ) 07/03/2023 12:54:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13380' AND id_supplier = '79' 07/03/2023 12:54:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13380' , '79' , '1' ) 07/03/2023 12:54: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 ( '82182' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '2' , '2' , '4' , '60.00' , '60' , '0' , '35' , '78.0000' ) 07/03/2023 12:54:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 07/03/2023 12:54:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 07/03/2023 12:54: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 ( '82182' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 07/03/2023 12:54:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 07/03/2023 12:54:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 07/03/2023 03:32:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '78795' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 07/03/2023 03:32:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2023-01-12', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '204.82', price_tax_excluded = '204.82', date_upd = NOW() WHERE id_document = '78795' 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78795' 07/03/2023 03:32:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '78795' 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '2' , '-2' , '4' , '14.8000' , '14.8' , '0' , '5' , '28.12' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' , '-4' , '4' , '13.0000' , '13' , '0' , '5' , '49.40' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '3219' , 'CUORE DEI 5 LINGUAGGI DELLAMORE - G. CHAPMAN' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2074' , 'CINQUE LINGUAGGI DELLAMORE DI DIO - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2070' , 'CINQUE LINGUAGGI DEL PERDONO - G. CHAPMAN' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 07/03/2023 03:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '5' , '17.10' ) 07/03/2023 03:34:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '78795' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 07/03/2023 03:34:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2023-01-12', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '218.88', price_tax_excluded = '218.88', date_upd = NOW() WHERE id_document = '78795' 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78795' 07/03/2023 03:34:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '78795' 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '3' , '-3' , '4' , '14.8000' , '14.8' , '0' , '5' , '42.18' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' , '-4' , '4' , '13.0000' , '13' , '0' , '5' , '49.40' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '3219' , 'CUORE DEI 5 LINGUAGGI DELLAMORE - G. CHAPMAN' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2074' , 'CINQUE LINGUAGGI DELLAMORE DI DIO - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2070' , 'CINQUE LINGUAGGI DEL PERDONO - G. CHAPMAN' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 07/03/2023 03:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '5' , '17.10' ) 07/03/2023 03:43:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 03:43:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '750' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 07/03/2023 03:43:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82183' 07/03/2023 03:43:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '82183' 07/03/2023 03:43:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82183' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 07/03/2023 04:01:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 04:01:50 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' , '751' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '31.83' , NOW() , NOW() ) 07/03/2023 04:01: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 = '82184' 07/03/2023 04:01:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82184' 07/03/2023 04:01: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 ( '82184' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 07/03/2023 04:01: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 ( '82184' , '6016' , 'LUMINO ELETTRONICO VOTIVO - 2297 ' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 07/03/2023 04:01: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 ( '82184' , '17719' , 'VIA CRUCIS PER GLI SPOSI E FAMIGLIE - 8444' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 07/03/2023 05:10:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '752' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 05:10:08 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' , '752' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 07/03/2023 05:10:08 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 = '82185' 07/03/2023 05:10:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82185' 07/03/2023 05:10:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82185' , '19320' , 'QUADRO PIASTRELLA 20X20 SACRA FAMIGLIA - 2189/I0102' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 07/03/2023 05:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 05:21:07 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' , '753' , '2023-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 07/03/2023 05:21:07 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 = '82186' 07/03/2023 05:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82186' 07/03/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82186' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/03/2023 05:30:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 05:30:26 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' , '31/A' , '2023-03-07' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.95' , '99.06' , NOW() , NOW() ) 07/03/2023 05:30:26 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 = '82187' 07/03/2023 05:30:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82187' 07/03/2023 05:30:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82187' , '' , 'buste palme' , '7' , '-7' , '0' , '9' , '9' , '' , '0' , '63.00' ) 07/03/2023 05:30:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82187' , '19553' , 'UN PADRE COME CUSTODE - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 07/03/2023 05:30:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82187' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 07/03/2023 05:30:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82187' , '20018' , 'VITA DI GESU - A. TORNIELLI' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.00' ) 07/03/2023 06:43:02 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '0K3PZwjLF9uGwgLQ' , NOW() , NOW() ) 07/03/2023 06:43:02 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7037' , '1' ) 07/03/2023 06:43:02 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7037' , '2' ) 07/03/2023 06:43:02 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7037' , '3' ) 07/03/2023 06:44:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7037' 07/03/2023 06:44:10 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 ( '7037' , '10' , '196' , '' , 'BARBARINI' , 'MAURO' , 'VIA CONCILIAZIONE 17' , '' , '29121' , 'PIACENZA' , '' , '' , '3666096903' , '' , '' , NOW() , NOW() ) 07/03/2023 06:44:10 pm >> UPDATE ps_customer SET email = 'miebimbe74@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7037' 07/03/2023 06:44:25 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7037' 07/03/2023 06:44:25 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 ( '7037' , '10' , '196' , '' , 'BARBARINI' , 'MAURO' , 'VIA CONCILIAZIONE 17' , '' , '29121' , 'PIACENZA' , '' , '' , '3666096903' , '' , '' , NOW() , NOW() ) 07/03/2023 06:44:25 pm >> UPDATE ps_customer SET email = 'miebimbe74@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7037' 07/03/2023 06:45:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 06:45:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '10' , '2023-03-07' , '' , '7037' , '0' , '126019527' , 'VIA CONCILIAZIONE 17 29121 PIACENZA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '21.15' , '21.15' , NOW() , NOW() ) 07/03/2023 06:45: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 = '10800' 07/03/2023 06:45:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '10800' 07/03/2023 06:45: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 ( '10800' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '5' , '14.25' ) 07/03/2023 07:43:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '749' AND id_document != '82181' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 07/03/2023 07:43:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '749', document_date = '2023-03-07', 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 = '24.51', price_tax_excluded = '24.19', date_upd = NOW() WHERE id_document = '82181' 07/03/2023 07:43:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82181' 07/03/2023 07:43:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82181' 07/03/2023 07:43:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '8023' , 'PIER GIORGIO FRASSATI' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 07/03/2023 07:43:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '20477' , 'VERITA E MENZOGNE - FULTON J. SHEEN' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 07/03/2023 07:43:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '7930' , 'PERGAMENE - BATTESIMO MOD. D' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 07/03/2023 07:43:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82181' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' )