02/04/2024 09:12:47 am >> SELECT document_num FROM ps_document WHERE document_num = '986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 09:12: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' , '986' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 02/04/2024 09:12: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 = '91043' 02/04/2024 09:12:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91043' 02/04/2024 09:12: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 ( '91043' , '9486' , 'S. MICHELE ARC. BABY - 023 SMK/9 BB' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2024 09:12: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 ( '91043' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/04/2024 10:15:00 am >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 10:15:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '987' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 02/04/2024 10:15:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91044' 02/04/2024 10:15:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91044' 02/04/2024 10:15:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 02/04/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91044' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '87.8' , '71.967213114754' , '22' , '0' , '87.80' ) 02/04/2024 10:46:17 am >> SELECT document_num FROM ps_document WHERE document_num = '988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 10:46:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '988' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/04/2024 10:46:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91045' 02/04/2024 10:46:17 am >> DELETE FROM ps_document_detail WHERE id_document = '91045' 02/04/2024 10:46:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91045' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/04/2024 11:10:02 am >> SELECT document_num FROM ps_document WHERE document_num = '989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 11:10: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' , '989' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.40' , '52.62' , NOW() , NOW() ) 02/04/2024 11:10: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 = '91046' 02/04/2024 11:10:02 am >> DELETE FROM ps_document_detail WHERE id_document = '91046' 02/04/2024 11:10: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 ( '91046' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '10' , '10' , '0' , '0' , '40.00' ) 02/04/2024 11:10: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 ( '91046' , '7927' , 'PERGAMENE - BATTESIMO MOD. C' , '22' , '-22' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '15.40' ) 02/04/2024 11:11:58 am >> SELECT document_num FROM ps_document WHERE document_num = '990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 11:11: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' , '990' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.60' , '62.79' , NOW() , NOW() ) 02/04/2024 11:11: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 = '91047' 02/04/2024 11:11:58 am >> DELETE FROM ps_document_detail WHERE id_document = '91047' 02/04/2024 11:11: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 ( '91047' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.6' , '32.459016393443' , '22' , '0' , '39.60' ) 02/04/2024 11:11: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 ( '91047' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 02/04/2024 11:13:30 am >> SELECT document_num FROM ps_document WHERE document_num = '991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 11:13:30 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' , '991' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 02/04/2024 11:13:30 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 = '91048' 02/04/2024 11:13:30 am >> DELETE FROM ps_document_detail WHERE id_document = '91048' 02/04/2024 11:13:30 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 ( '91048' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 02/04/2024 11:23:58 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/04/2024 11:23:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22346' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:23:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22346' , '1' , '1' , '2' , NOW() , NOW() ) 02/04/2024 11:23:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22346' , '0' , '1' , '0' , '0' ) 02/04/2024 11:25:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243613' AND id_product != '22346' AND ean13 != '' 02/04/2024 11:25:10 am >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788892243613', date_upd = NOW() WHERE id_product = '22346' 02/04/2024 11:25:10 am >> UPDATE ps_product_lang SET name = 'PARABOLE DI GESU\' - I. ALFEEV', description = '' WHERE id_product = '22346' 02/04/2024 11:25:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '45' WHERE id_product = '22346' 02/04/2024 11:25:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '45', id_tax_rules_group = '4', id_category_default = '30', 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 = '22346' 02/04/2024 11:25:10 am >> DELETE FROM ps_specific_price WHERE id_product = '22346' 02/04/2024 11:25:11 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 = '22346' 02/04/2024 11:25:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22347' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:25:11 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 '22347' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22346' 02/04/2024 11:25:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22347' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22346' 02/04/2024 11:25:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556071' AND id_product != '22347' AND ean13 != '' 02/04/2024 11:25:56 am >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788831556071', date_upd = NOW() WHERE id_product = '22347' 02/04/2024 11:25:56 am >> UPDATE ps_product_lang SET name = 'BIBBIA LINK', description = '' WHERE id_product = '22347' 02/04/2024 11:25:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22347' 02/04/2024 11:25:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '27', 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 = '22347' 02/04/2024 11:25:56 am >> DELETE FROM ps_specific_price WHERE id_product = '22347' 02/04/2024 11:25:57 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 = '22347' 02/04/2024 11:25:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22348' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:25:57 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 '22348' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22347' 02/04/2024 11:25:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22348' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22347' 02/04/2024 11:26:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871175' AND id_product != '22348' AND ean13 != '' 02/04/2024 11:26:55 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788892871175', date_upd = NOW() WHERE id_product = '22348' 02/04/2024 11:26:55 am >> UPDATE ps_product_lang SET name = 'GESU\' QUESTO SCONOSCIUTO - D. CULOT', description = '' WHERE id_product = '22348' 02/04/2024 11:26:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '22348' 02/04/2024 11:26:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22348' 02/04/2024 11:26:55 am >> DELETE FROM ps_specific_price WHERE id_product = '22348' 02/04/2024 11:26:56 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 = '22348' 02/04/2024 11:26:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22349' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:26:56 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 '22349' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22348' 02/04/2024 11:26:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22349' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22348' 02/04/2024 11:27:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259753717' AND id_product != '22349' AND ean13 != '' 02/04/2024 11:27:40 am >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9791259753717', date_upd = NOW() WHERE id_product = '22349' 02/04/2024 11:27:40 am >> UPDATE ps_product_lang SET name = 'SAN FRANCESCO DI PAOLA - G.F. SCARPITTA', description = '' WHERE id_product = '22349' 02/04/2024 11:27:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22349' 02/04/2024 11:27:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22349' 02/04/2024 11:27:40 am >> DELETE FROM ps_specific_price WHERE id_product = '22349' 02/04/2024 11:27:41 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 = '22349' 02/04/2024 11:27:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22350' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:27:41 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 '22350' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22349' 02/04/2024 11:27:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22350' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22349' 02/04/2024 11:28:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946777' AND id_product != '22350' AND ean13 != '' 02/04/2024 11:28:43 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788868946777', date_upd = NOW() WHERE id_product = '22350' 02/04/2024 11:28:43 am >> UPDATE ps_product_lang SET name = 'FAMMI COMINCIARE UNA NUOVA VITA - C. DE FOUCAULD', description = '' WHERE id_product = '22350' 02/04/2024 11:28:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22350' 02/04/2024 11:28:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '103', 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 = '22350' 02/04/2024 11:28:43 am >> DELETE FROM ps_specific_price WHERE id_product = '22350' 02/04/2024 11:28:44 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 = '22350' 02/04/2024 11:28:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22351' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:28:44 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 '22351' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22350' 02/04/2024 11:28:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22351' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22350' 02/04/2024 11:29:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244320' AND id_product != '22351' AND ean13 != '' 02/04/2024 11:29:25 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788892244320', date_upd = NOW() WHERE id_product = '22351' 02/04/2024 11:29:25 am >> UPDATE ps_product_lang SET name = 'AMORE CELIBE - A. FUMAGALLI', description = '' WHERE id_product = '22351' 02/04/2024 11:29:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22351' 02/04/2024 11:29:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22351' 02/04/2024 11:29:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22351' 02/04/2024 11:29:25 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 = '22351' 02/04/2024 11:29:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22352' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 11:29:26 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 '22352' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22351' 02/04/2024 11:29:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22352' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22351' 02/04/2024 11:32: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 ( '33' , '660325' , '2024-03-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.67' , '101.67' , NOW() , NOW() ) 02/04/2024 11:32: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 = '91049' 02/04/2024 11:32:59 am >> DELETE FROM ps_document_detail WHERE id_document = '91049' 02/04/2024 11:32: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 ( '91049' , '22346' , 'PARABOLE DI GESU - I. ALFEEV' , '1' , '1' , '4' , '45.00' , '45' , '0' , '33' , '30.1500' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22346' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22346' , '7' , '1' ) 02/04/2024 11:32: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 ( '91049' , '22347' , 'BIBBIA LINK' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22347' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22347' , '7' , '1' ) 02/04/2024 11:32: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 ( '91049' , '22350' , 'FAMMI COMINCIARE UNA NUOVA VITA - C. DE FOUCAULD' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22350' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22350' , '7' , '1' ) 02/04/2024 11:32: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 ( '91049' , '22348' , 'GESU QUESTO SCONOSCIUTO - D. CULOT' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22348' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22348' , '7' , '1' ) 02/04/2024 11:32: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 ( '91049' , '22351' , 'AMORE CELIBE - A. FUMAGALLI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22351' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22351' , '7' , '1' ) 02/04/2024 11:32: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 ( '91049' , '22349' , 'SAN FRANCESCO DI PAOLA - G.F. SCARPITTA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 02/04/2024 11:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22349' AND id_supplier = '7' 02/04/2024 11:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22349' , '7' , '1' ) 02/04/2024 11:44:49 am >> SELECT document_num FROM ps_document WHERE document_num = '992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 11:44:49 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' , '992' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '24.04' , NOW() , NOW() ) 02/04/2024 11:44:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91050' 02/04/2024 11:44:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91050' 02/04/2024 11:44:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91050' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 02/04/2024 11:44:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91050' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/04/2024 12:00:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 12:00:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '993' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 02/04/2024 12:00: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 = '91051' 02/04/2024 12:00:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91051' 02/04/2024 12:00: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 ( '91051' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '6' , '-6' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '18.00' ) 02/04/2024 12:00: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 ( '91051' , '21153' , 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2024 12:23:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '797' AND id_document != '90815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 02/04/2024 12:23:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '797', document_date = '2024-03-18', 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 = '21.20', price_tax_excluded = '17.38', date_upd = NOW() WHERE id_document = '90815' 02/04/2024 12:23:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90815' 02/04/2024 12:23:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90815' 02/04/2024 12:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90815' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '2' , '-2' , '1' , '10.6' , '8.6885245901639' , '22' , '0' , '21.20' ) 02/04/2024 01:18:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '90632' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 02/04/2024 01:18:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '32/A', document_date = '2024-03-05', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3505.00', price_tax_excluded = '2929.21', date_upd = NOW() WHERE id_document = '90632' 02/04/2024 01:18: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 = '90632' 02/04/2024 01:18:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90632' 02/04/2024 01:18: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 ( '90632' , '19971' , 'CALICE - ART. 642' , '1' , '-1' , '1' , '536.0000' , '439.34426229508' , '22' , '0' , '536.00' ) 02/04/2024 01:18: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 ( '90632' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '310.0000' , '254.09836065574' , '22' , '0' , '310.00' ) 02/04/2024 01:18: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 ( '90632' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '355.0000' , '290.98360655738' , '22' , '0' , '355.00' ) 02/04/2024 01:18: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 ( '90632' , '19660' , 'CASULA POLIESTERE - 65/11648' , '1' , '-1' , '1' , '440.0000' , '360.65573770492' , '22' , '0' , '440.00' ) 02/04/2024 01:18: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 ( '90632' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '-2' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '340.00' ) 02/04/2024 01:18: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 ( '90632' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '-1' , '1' , '360.0000' , '295.08196721311' , '22' , '0' , '360.00' ) 02/04/2024 01:18: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 ( '90632' , '22163' , 'CALICE CLASSICO - 155' , '1' , '-1' , '1' , '459.0000' , '376.22950819672' , '22' , '0' , '459.00' ) 02/04/2024 01:18: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 ( '90632' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '126.00' ) 02/04/2024 01:18: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 ( '90632' , '0' , 'ROMANO' , '6' , '-6' , '0' , '52.0000' , '52' , '0' , '0' , '312.00' ) 02/04/2024 01:18: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 ( '90632' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '225.00' , '184.4262295082' , '22' , '0' , '225.00' ) 02/04/2024 01:18: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 ( '90632' , '' , 'CINGOLO AVORIO' , '3' , '-3' , '1' , '14' , '11.475409836066' , '22' , '0' , '42.00' ) 02/04/2024 03:10:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002256' AND id_product != '22352' AND ean13 != '' 02/04/2024 03:10:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002256', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:10:07 pm >> UPDATE ps_product_lang SET name = 'CORDONCINO CROCE COMUNIONE - 42/200-251K', description = '' WHERE id_product = '22352' 02/04/2024 03:10:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4' WHERE id_product = '22352' 02/04/2024 03:10:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:10:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22352' 02/04/2024 03:10:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002256' AND id_product != '22352' AND ean13 != '' 02/04/2024 03:10:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002256', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:10:40 pm >> UPDATE ps_product_lang SET name = 'CORDONCINO CROCE COMUNIONE - 42/200-251K', description = '' WHERE id_product = '22352' 02/04/2024 03:10:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4' WHERE id_product = '22352' 02/04/2024 03:10:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:10:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22352' 02/04/2024 03:29:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002256' AND id_product != '22352' AND ean13 != '' 02/04/2024 03:29:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002256', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:29:07 pm >> UPDATE ps_product_lang SET name = 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K', description = '' WHERE id_product = '22352' 02/04/2024 03:29:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4' WHERE id_product = '22352' 02/04/2024 03:29:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:29:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22352' 02/04/2024 03:29:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '90485' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-24') 02/04/2024 03:29:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2024-02-24', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '141.90', price_tax_excluded = '116.31', date_upd = NOW() WHERE id_document = '90485' 02/04/2024 03:29:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 03:29:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 03:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '22197' , 'CLERGY ELEGANCE ML - C30' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/04/2024 03:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 02/04/2024 03:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 02/04/2024 03:34:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002256' AND id_product != '22352' AND ean13 != '' 02/04/2024 03:34:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002256', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:34:57 pm >> UPDATE ps_product_lang SET name = 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K', description = '' WHERE id_product = '22352' 02/04/2024 03:34:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.4' WHERE id_product = '22352' 02/04/2024 03:34:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.4', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22352' 02/04/2024 03:34:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '22352' 02/04/2024 03:34:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22352' 02/04/2024 03:34:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22353' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 03:34:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22353' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22352' 02/04/2024 03:34:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22353' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22352' 02/04/2024 03:36:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002257' AND id_product != '22353' AND ean13 != '' 02/04/2024 03:36:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002257', date_upd = NOW() WHERE id_product = '22353' 02/04/2024 03:36:35 pm >> UPDATE ps_product_lang SET name = 'croce comunione - 646', description = '' WHERE id_product = '22353' 02/04/2024 03:36:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22353' 02/04/2024 03:36:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22353' 02/04/2024 03:36:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '22353' 02/04/2024 03:36:45 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 = '22353' 02/04/2024 03:36:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22354' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 03:36:45 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 '22354' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22353' 02/04/2024 03:36:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22354' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22353' 02/04/2024 03:37:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002258' AND id_product != '22354' AND ean13 != '' 02/04/2024 03:37:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002258', date_upd = NOW() WHERE id_product = '22354' 02/04/2024 03:37:28 pm >> UPDATE ps_product_lang SET name = 'croce sacramenti vari - 646', description = '' WHERE id_product = '22354' 02/04/2024 03:37:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22354' 02/04/2024 03:37:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22354' 02/04/2024 03:37:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22354' 02/04/2024 03:37:29 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 = '22354' 02/04/2024 03:37:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22355' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 03:37:29 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 '22355' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22354' 02/04/2024 03:37:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22355' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22354' 02/04/2024 03:38:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002259' AND id_product != '22355' AND ean13 != '' 02/04/2024 03:38:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002259', date_upd = NOW() WHERE id_product = '22355' 02/04/2024 03:38:40 pm >> UPDATE ps_product_lang SET name = 'laccio tau comunione - 42/273-ksb04', description = '' WHERE id_product = '22355' 02/04/2024 03:38:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '22355' 02/04/2024 03:38:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22355' 02/04/2024 03:38:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22355' 02/04/2024 03:38:46 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 = '22355' 02/04/2024 03:38:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22356' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 03:38:46 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 '22356' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22355' 02/04/2024 03:38:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22356' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22355' 02/04/2024 03:40:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002260' AND id_product != '22356' AND ean13 != '' 02/04/2024 03:40:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002260', date_upd = NOW() WHERE id_product = '22356' 02/04/2024 03:40:10 pm >> UPDATE ps_product_lang SET name = 'croce bianca - 703/17', description = '' WHERE id_product = '22356' 02/04/2024 03:40:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22356' 02/04/2024 03:40:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22356' 02/04/2024 03:40:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '22356' 02/04/2024 03:40:17 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/04/2024 03:40:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22357' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 03:40:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22357' , '1' , '1' , '2' , NOW() , NOW() ) 02/04/2024 03:40:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22357' , '0' , '1' , '0' , '0' ) 02/04/2024 03:41:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002261' AND id_product != '22357' AND ean13 != '' 02/04/2024 03:41:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002261', date_upd = NOW() WHERE id_product = '22357' 02/04/2024 03:41:15 pm >> UPDATE ps_product_lang SET name = 'CROCE RESINA - 692/02', description = '' WHERE id_product = '22357' 02/04/2024 03:41:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.327868852459017' WHERE id_product = '22357' 02/04/2024 03:41:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.327868852459017', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22357' 02/04/2024 03:41:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22357' 02/04/2024 03:42:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002257' AND id_product != '22353' AND ean13 != '' 02/04/2024 03:42:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002257', date_upd = NOW() WHERE id_product = '22353' 02/04/2024 03:42:20 pm >> UPDATE ps_product_lang SET name = 'CROCE COMUNIONE - 646', description = '' WHERE id_product = '22353' 02/04/2024 03:42:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8000' WHERE id_product = '22353' 02/04/2024 03:42:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8000', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22353' 02/04/2024 03:42:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22353' 02/04/2024 03:43:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002258' AND id_product != '22354' AND ean13 != '' 02/04/2024 03:43:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002258', date_upd = NOW() WHERE id_product = '22354' 02/04/2024 03:43:01 pm >> UPDATE ps_product_lang SET name = 'CROCE SACRAMENTI VARI - 646', description = '' WHERE id_product = '22354' 02/04/2024 03:43:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8000' WHERE id_product = '22354' 02/04/2024 03:43:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8000', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22354' 02/04/2024 03:43:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22354' 02/04/2024 03:45:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002259' AND id_product != '22355' AND ean13 != '' 02/04/2024 03:45:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002259', date_upd = NOW() WHERE id_product = '22355' 02/04/2024 03:45:09 pm >> UPDATE ps_product_lang SET name = 'LACCIO TAU COMUNIONE - 42/273-KSB04', description = '' WHERE id_product = '22355' 02/04/2024 03:45:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0000' WHERE id_product = '22355' 02/04/2024 03:45:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0000', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22355' 02/04/2024 03:45:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22355' 02/04/2024 03:47:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002260' AND id_product != '22356' AND ean13 != '' 02/04/2024 03:47:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002260', date_upd = NOW() WHERE id_product = '22356' 02/04/2024 03:47:24 pm >> UPDATE ps_product_lang SET name = 'CROCE BIANCA - 703/17', description = '' WHERE id_product = '22356' 02/04/2024 03:47:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.0000' WHERE id_product = '22356' 02/04/2024 03:47:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.0000', id_tax_rules_group = '4', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22356' 02/04/2024 03:47:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '22356' 02/04/2024 03:49:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '199' , '2024-03-27' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1161.41' , '1129.51' , NOW() , NOW() ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91052' 02/04/2024 03:49:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91052' 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22357' , 'CROCE RESINA - 692/02' , '58' , '58' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '176.9000' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22357' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22357' , '60' , '1' ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22353' , 'CROCE COMUNIONE - 646' , '639' , '639' , '4' , '0.55' , '0.55' , '0' , '0' , '351.4500' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22353' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22353' , '60' , '1' ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '511' , '511' , '4' , '0.55' , '0.55' , '0' , '0' , '281.0500' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22354' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22354' , '60' , '1' ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22355' , 'LACCIO TAU COMUNIONE - 42/273-KSB04' , '100' , '100' , '4' , '0.8' , '0.8' , '0' , '0' , '80.0000' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22355' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22355' , '60' , '1' ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '393' , '393' , '4' , '0.57' , '0.57' , '0' , '0' , '224.0100' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22352' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22352' , '60' , '1' ) 02/04/2024 03:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91052' , '22356' , 'CROCE BIANCA - 703/17' , '10' , '10' , '4' , '4.8' , '4.8' , '0' , '0' , '48.0000' ) 02/04/2024 03:49:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22356' AND id_supplier = '60' 02/04/2024 03:49:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22356' , '60' , '1' ) 02/04/2024 04:07:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 04:07:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '994' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.00' , '51.64' , NOW() , NOW() ) 02/04/2024 04:07:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91053' 02/04/2024 04:07:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91053' 02/04/2024 04:07:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91053' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 02/04/2024 04:07:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91053' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 02/04/2024 04:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '90485' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-24') 02/04/2024 04:13:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2024-02-24', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '559.90', price_tax_excluded = '534.31', date_upd = NOW() WHERE id_document = '90485' 02/04/2024 04:13:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 04:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 04:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '22197' , 'CLERGY ELEGANCE ML - C30' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/04/2024 04:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 02/04/2024 04:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 02/04/2024 04:13:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '110' , '-110' , '4' , '3.80' , '3.8' , '0' , '0' , '418.00' ) 02/04/2024 04:19: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 ( '32' , '24V601648' , '2024-03-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '449.65' , '432.64' , NOW() , NOW() ) 02/04/2024 04:19: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 = '91054' 02/04/2024 04:19:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91054' 02/04/2024 04:19: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 ( '91054' , '22287' , 'CIONDOLO SI - ARGENTO' , '17' , '0' , '1' , '2.4500' , '2.0082' , '22' , '30+7' , '33.08' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22287' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22287' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '22288' , 'CIONDOLO SI - ORO' , '30' , '0' , '1' , '2.4500' , '2.0082' , '22' , '30+7' , '58.38' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22288' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22288' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '19953' , 'FELIZ CITTA\' - GIOCO CARLO ACUTIS' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30+7' , '9.77' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19953' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19953' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '10430' , 'TABOR' , '1' , '0' , '4' , '17.9000' , '17.9' , '0' , '30+7' , '11.65' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '22289' , 'DA 1000 STRADE DIVERSE' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '30+7' , '11.07' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22289' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22289' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '17423' , 'CARLO ACUTIS' , '1' , '0' , '4' , '7.5000' , '7.5' , '0' , '30+7' , '4.88' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17423' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17423' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '21129' , 'SAN GIOVANNI BOSCO - M. COMBO' , '1' , '0' , '4' , '7.5000' , '7.5' , '0' , '30+7' , '4.88' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21129' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21129' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '1116' , 'BIBBIA DEI BAMBINI' , '3' , '0' , '4' , '12.9000' , '12.9' , '0' , '30+7' , '25.19' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1116' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1116' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '15983' , 'BIBBIA IN 365 GIORNI' , '1' , '0' , '4' , '18.9000' , '18.9' , '0' , '30+7' , '12.30' ) 02/04/2024 04:19:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15983' AND id_supplier = '7' 02/04/2024 04:19:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15983' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '14309' , 'STORIE PIU BELLE DELLA BIBBIA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30+7' , '10.42' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14309' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14309' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '1164' , 'BIBBIA IN 50 STORIE' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30+7' , '11.72' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1164' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1164' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '20094' , 'BIBBIA IN 365 GIORNI - M. BATCHELOR' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '35+7' , '19.34' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20094' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20094' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '20993' , 'POWER BIBLE 1' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35+7' , '8.46' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20993' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20993' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '17737' , 'BIBBIA IN FAMIGLIA - M.M. SIMON' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '35+7' , '11.49' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17737' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17737' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '11115' , 'VANGELO PER I RAGAZZI' , '1' , '0' , '4' , '6.5000' , '6.5' , '0' , '35+7' , '3.93' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11115' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11115' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '1194' , 'BIBBIA RACCONTATA AI RAGAZZI - G. CIRAVEGNA' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '35+7' , '15.11' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1194' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1194' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '21636' , 'FESTA DELLA MIA CRESIMA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33+7' , '9.97' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21636' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21636' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '19655' , 'FESTA DELLA PRIMA COMUNIONE' , '1' , '0' , '4' , '13.9000' , '13.9' , '0' , '33+7' , '8.66' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19655' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19655' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '19292' , 'PRIMA COMUNIONE' , '10' , '0' , '4' , '2.9000' , '2.9' , '0' , '35+7' , '17.53' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19292' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19292' , '7' , '1' ) 02/04/2024 04:19: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 ( '91054' , '17186' , 'MIA PRIMA COMUNIONE - ALBUM' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '35+7' , '9.01' ) 02/04/2024 04:19:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17186' AND id_supplier = '7' 02/04/2024 04:19:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17186' , '7' , '1' ) 02/04/2024 04:19:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91054' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '35+7' , '7.80' ) 02/04/2024 04:19:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4487' AND id_supplier = '7' 02/04/2024 04:19:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4487' , '7' , '1' ) 02/04/2024 04:19:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91054' , '370' , 'ALBUM DELLA MIA PRIMA COMUNIONE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '35+7' , '7.80' ) 02/04/2024 04:19:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '370' AND id_supplier = '7' 02/04/2024 04:19:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '370' , '7' , '1' ) 02/04/2024 04:19:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91054' , '1090' , 'BIBBIA' , '20' , '0' , '4' , '9.9000' , '9.9' , '0' , '33+7' , '123.37' ) 02/04/2024 04:19:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '7' 02/04/2024 04:19:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '7' , '1' ) 02/04/2024 04:19:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91054' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '10.94' , '10.94' , '0' , '0' , '10.9400' ) 02/04/2024 04:19:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 02/04/2024 04:19:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 02/04/2024 04:19:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91054' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '1' , '2.38' , '1.9508196721311' , '22' , '0' , '2.9036' ) 02/04/2024 04:19:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 02/04/2024 04:19:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '24v601647' , '2024-03-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.70' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '239.69' , '239.69' , NOW() , NOW() ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91055' 02/04/2024 04:28:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '91055' 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22236' , 'CRISTO E RISORTO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 02/04/2024 04:28:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22236' AND id_supplier = '7' 02/04/2024 04:28:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22236' , '7' , '1' ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22237' , 'DALLALBA AL TRAMONTO - APR. 24' , '1' , '0' , '4' , '3.2000' , '3.2' , '0' , '30' , '2.24' ) 02/04/2024 04:28:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22237' AND id_supplier = '7' 02/04/2024 04:28:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22237' , '7' , '1' ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22238' , 'LE MIE PREGHIERE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 02/04/2024 04:28:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22238' AND id_supplier = '7' 02/04/2024 04:28:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22238' , '7' , '1' ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '15471' , 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '4.90' ) 02/04/2024 04:28:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15471' AND id_supplier = '7' 02/04/2024 04:28:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15471' , '7' , '1' ) 02/04/2024 04:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '3' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '25.20' ) 02/04/2024 04:28:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21173' AND id_supplier = '7' 02/04/2024 04:28:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21173' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '11305' , 'VIA CRUCIS DIALOGATA' , '36' , '0' , '4' , '1.0000' , '1' , '0' , '35' , '23.40' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11305' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11305' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '11305' , 'VIA CRUCIS DIALOGATA' , '3' , '0' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11305' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11305' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '12' , '0' , '4' , '5.0000' , '5' , '0' , '33' , '40.20' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22261' , 'DIO MENO DI UNO SPRIZ? - P. PELLEGRINO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '3.15' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22261' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22261' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22263' , 'NON MI ARRENDO - G. PICCOLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22263' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22263' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22264' , 'DIECI CAMMELLI INGINOCCHIATI - E. RONCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22264' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22264' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '33' , '4.02' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22265' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22265' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22266' , 'ARTE DI STARE SOLI - A. GRUN' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22266' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22266' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22267' , 'MIEI VIAGGI DEL CUORE - D. BANZATO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22267' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22267' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22268' , 'COME IN UNO SPECCHIO - S. PINTO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22268' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22268' , '7' , '1' ) 02/04/2024 04:28: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 ( '91055' , '22269' , 'ARTE DELLA PREGHIERA - E. BIANCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/04/2024 04:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22269' AND id_supplier = '7' 02/04/2024 04:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22269' , '7' , '1' ) 02/04/2024 04:28:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '0' , '4' , '36.0000' , '36' , '0' , '30' , '25.20' ) 02/04/2024 04:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22270' AND id_supplier = '7' 02/04/2024 04:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22270' , '7' , '1' ) 02/04/2024 04:28:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22271' , 'ADFORAZIONE EUCARISTICA - G. MORETTI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 02/04/2024 04:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22271' AND id_supplier = '7' 02/04/2024 04:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22271' , '7' , '1' ) 02/04/2024 04:28:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22272' , 'MUSICA E LA BELLEZZA DI DIO - B. FORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 02/04/2024 04:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22272' AND id_supplier = '7' 02/04/2024 04:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22272' , '7' , '1' ) 02/04/2024 04:28:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22273' , 'GESU RACCONTATO AI GIOVANI - R. REPOLE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 02/04/2024 04:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22273' AND id_supplier = '7' 02/04/2024 04:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22273' , '7' , '1' ) 02/04/2024 04:28:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91055' , '22262' , 'CRISTIANI PERCHE NO? - P. PELLEGRINO' , '3' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '9.45' ) 02/04/2024 04:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22262' AND id_supplier = '7' 02/04/2024 04:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22262' , '7' , '1' ) 02/04/2024 04:42:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 04:42: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' , '995' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '42.95' , NOW() , NOW() ) 02/04/2024 04:42: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 = '91056' 02/04/2024 04:42:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91056' 02/04/2024 04:42: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 ( '91056' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '6' , '-6' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '12.00' ) 02/04/2024 04:42: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 ( '91056' , '21099' , 'BRACCIALE DECINA - BD008' , '6' , '-6' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '12.00' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '5' , '4.29' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '15740' , 'PREGHIERA - MEDICINA DELLANIMA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '14503' , 'GIOVANI LIBERI DI AMARE' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '4134' , 'FELICI DI CREDERE - ANNO DELLA FEDE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '16790' , 'MAMMA E PAPA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '19745' , 'BUON COMPLEANNO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '6546' , 'MESSAGGIO DI TENEREZZA' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '5' , '4.29' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.28' , '2.28' , '0' , '0' , '2.28' ) 02/04/2024 04:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91056' , '20758' , 'SEGNALIBRO 5X15' , '20' , '-20' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '4.00' ) 02/04/2024 04:46:17 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '24v601647', document_date = '2024-03-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '28.82', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1016.12', price_tax_excluded = '1016.12', date_upd = NOW() WHERE id_document = '91055' 02/04/2024 04:46: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 = '91055' 02/04/2024 04:46:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91055' 02/04/2024 04:46: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 ( '91055' , '22236' , 'CRISTO E RISORTO - PAPA FRANCESCO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 02/04/2024 04:46: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 ( '91055' , '22237' , 'DALLALBA AL TRAMONTO - APR. 24' , '1' , '0' , '4' , '3.2000' , '3.2' , '0' , '30' , '2.24' ) 02/04/2024 04:46: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 ( '91055' , '22238' , 'LE MIE PREGHIERE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 02/04/2024 04:46: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 ( '91055' , '15471' , 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '4.90' ) 02/04/2024 04:46: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 ( '91055' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '3' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '25.20' ) 02/04/2024 04:46: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 ( '91055' , '11305' , 'VIA CRUCIS DIALOGATA' , '36' , '0' , '4' , '1.0000' , '1' , '0' , '35' , '23.40' ) 02/04/2024 04:46: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 ( '91055' , '11305' , 'VIA CRUCIS DIALOGATA' , '3' , '0' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '12' , '0' , '4' , '5.0000' , '5' , '0' , '33' , '40.20' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 02/04/2024 04:46: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 ( '91055' , '22261' , 'DIO MENO DI UNO SPRIZ? - P. PELLEGRINO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '3.15' ) 02/04/2024 04:46: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 ( '91055' , '22263' , 'NON MI ARRENDO - G. PICCOLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 02/04/2024 04:46: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 ( '91055' , '22264' , 'DIECI CAMMELLI INGINOCCHIATI - E. RONCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/04/2024 04:46: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 ( '91055' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '33' , '4.02' ) 02/04/2024 04:46: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 ( '91055' , '22266' , 'ARTE DI STARE SOLI - A. GRUN' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/04/2024 04:46: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 ( '91055' , '22267' , 'MIEI VIAGGI DEL CUORE - D. BANZATO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/04/2024 04:46: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 ( '91055' , '22268' , 'COME IN UNO SPECCHIO - S. PINTO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/04/2024 04:46: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 ( '91055' , '22269' , 'ARTE DELLA PREGHIERA - E. BIANCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/04/2024 04:46: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 ( '91055' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '0' , '4' , '36.0000' , '36' , '0' , '30' , '25.20' ) 02/04/2024 04:46: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 ( '91055' , '22271' , 'ADFORAZIONE EUCARISTICA - G. MORETTI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 02/04/2024 04:46: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 ( '91055' , '22272' , 'MUSICA E LA BELLEZZA DI DIO - B. FORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 02/04/2024 04:46: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 ( '91055' , '22273' , 'GESU RACCONTATO AI GIOVANI - R. REPOLE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 02/04/2024 04:46: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 ( '91055' , '22262' , 'CRISTIANI PERCHE NO? - P. PELLEGRINO' , '3' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '9.45' ) 02/04/2024 04:46: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 ( '91055' , '22259' , 'SETTIMANA SANTA' , '6' , '0' , '4' , '8.0000' , '8' , '0' , '30' , '33.60' ) 02/04/2024 04:46: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 ( '91055' , '4842' , 'HUMANAE VITAE' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '1.34' ) 02/04/2024 04:46: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 ( '91055' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/04/2024 04:46: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 ( '91055' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '3' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '28.14' ) 02/04/2024 04:46: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 ( '91055' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/04/2024 04:46: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 ( '91055' , '22260' , 'CRESIMA - A. GRUN' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 02/04/2024 04:46: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 ( '91055' , '16686' , 'EVANGELIARIO' , '1' , '0' , '4' , '150.0000' , '150' , '0' , '30' , '105.00' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '12' , '0' , '4' , '5.0000' , '5' , '0' , '33' , '40.20' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 02/04/2024 04:46: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 ( '91055' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/04/2024 04:46: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 ( '91055' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '1.33' ) 02/04/2024 04:46: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 ( '91055' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 02/04/2024 04:46: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 ( '91055' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '0' , '4' , '36.0000' , '36' , '0' , '30' , '25.20' ) 02/04/2024 04:46: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 ( '91055' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '2' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '25.20' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '24' , '0' , '4' , '5.0000' , '5' , '0' , '33' , '80.40' ) 02/04/2024 04:46: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 ( '91055' , '19158' , 'SETTIMANA SANTA - N.E.' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 02/04/2024 04:46: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 ( '91055' , '22310' , 'VIA VAI ORATORIO ESTIVO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/04/2024 04:46: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 ( '91055' , '22309' , 'MI INDICHERAI IL SENTIERO DELLA VITA ' , '1' , '0' , '4' , '2.9000' , '2.9' , '0' , '30' , '2.03' ) 02/04/2024 04:46: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 ( '91055' , '22321' , 'PERDONO CHE GUARISCE - L. PASQUA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 02/04/2024 04:46: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 ( '91055' , '22322' , 'PAROLA E PREGHIERA - GIU 2024' , '4' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '7.77' ) 02/04/2024 04:46: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 ( '91055' , '22323' , 'INSIEME NELLA MESSA - GIU 2024' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 02/04/2024 04:46: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 ( '91055' , '22324' , 'ESODO A CARATTERI GRANDI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 02/04/2024 04:46: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 ( '91055' , '22325' , 'PREGHIERA DEI SALMI - R. VIRGILI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/04/2024 04:46: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 ( '91055' , '22326' , 'AIUTAMI A SUPERARE IL LUTTO ' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 02/04/2024 04:46: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 ( '91055' , '22327' , 'UN SANTO PER AMICO - G. SANTINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/04/2024 04:46: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 ( '91055' , '22328' , 'INDISPONIBILITA - H. ROSA' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 02/04/2024 04:46: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 ( '91055' , '22329' , 'DOGMI - M. FEDOU' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 02/04/2024 04:46: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 ( '91055' , '17327' , 'FIORI E LITURGIA - C. CRUCIANI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33' , '8.71' ) 02/04/2024 04:46: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 ( '91055' , '22141' , 'CATECHESI' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 02/04/2024 04:46: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 ( '91055' , '20778' , 'PASSIO N.E.' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '35' , '19.50' ) 02/04/2024 04:46: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 ( '91055' , '22339' , 'UMILTA UN DONO NASCOSTO - F. LE CORRE' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 02/04/2024 04:46: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 ( '91055' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 02/04/2024 04:46: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 ( '91055' , '16686' , 'EVANGELIARIO' , '1' , '0' , '4' , '150.0000' , '150' , '0' , '30' , '105.00' ) 02/04/2024 04:46: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 ( '91055' , '22346' , 'PARABOLE DI GESU - I. ALFEEV' , '1' , '0' , '4' , '45.0000' , '45' , '0' , '33' , '30.15' ) 02/04/2024 04:46: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 ( '91055' , '22347' , 'BIBBIA LINK' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 02/04/2024 04:46: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 ( '91055' , '22350' , 'FAMMI COMINCIARE UNA NUOVA VITA - C. DE FOUCAULD' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/04/2024 04:46: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 ( '91055' , '22348' , 'GESU QUESTO SCONOSCIUTO - D. CULOT' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '30' , '19.60' ) 02/04/2024 04:46: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 ( '91055' , '22351' , 'AMORE CELIBE - A. FUMAGALLI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/04/2024 04:46: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 ( '91055' , '22349' , 'SAN FRANCESCO DI PAOLA - G.F. SCARPITTA' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 02/04/2024 05:19:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '90632' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 02/04/2024 05:19:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '32/A', document_date = '2024-03-05', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4169.00', price_tax_excluded = '3473.48', date_upd = NOW() WHERE id_document = '90632' 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90632' 02/04/2024 05:19:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90632' 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19971' , 'CALICE - ART. 642' , '1' , '-1' , '1' , '536.0000' , '439.34426229508' , '22' , '0' , '536.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '310.0000' , '254.09836065574' , '22' , '0' , '310.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19660' , 'CASULA POLIESTERE - 65/11648' , '1' , '-1' , '1' , '440.0000' , '360.65573770492' , '22' , '0' , '440.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '170.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '-1' , '1' , '360.0000' , '295.08196721311' , '22' , '0' , '360.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '22163' , 'CALICE CLASSICO - 155' , '1' , '-1' , '1' , '459.0000' , '376.22950819672' , '22' , '0' , '459.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '126.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '0' , 'ROMANO' , '6' , '-6' , '0' , '52.0000' , '52' , '0' , '0' , '312.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '225.0000' , '184.4262295082' , '22' , '0' , '225.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '0' , 'CINGOLO AVORIO' , '3' , '-3' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '42.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '14362' , 'CAMICE SVASATO - 434/TPA' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '74.00' , '60.655737704918' , '22' , '0' , '74.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '22234' , 'CAMICE MISTO LANA - 70/002020' , '1' , '-1' , '1' , '330.00' , '270.49180327869' , '22' , '0' , '330.00' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '15.60' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '13.40' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '2' , '-2' , '1' , '12.20' , '10' , '22' , '0' , '24.40' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '11624' , 'PALLA 16X16 - SERV 3 ' , '2' , '-2' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '11.80' ) 02/04/2024 05:19:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '22231' , 'CASULA - 65/060154' , '1' , '-1' , '1' , '480.00' , '393.44262295082' , '22' , '0' , '480.00' ) 02/04/2024 05:30:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/A' AND id_document != '90485' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-24') 02/04/2024 05:30:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28/A', document_date = '2024-02-24', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '603.90', price_tax_excluded = '570.38', date_upd = NOW() WHERE id_document = '90485' 02/04/2024 05:30:11 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 = '90485' 02/04/2024 05:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 05:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '22197' , 'CLERGY ELEGANCE ML - C30' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/04/2024 05:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 02/04/2024 05:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 02/04/2024 05:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '110' , '-110' , '4' , '3.8000' , '3.8' , '0' , '0' , '418.00' ) 02/04/2024 05:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90485' , '22343' , 'LAMPADA IN CRISTALLO LAVORATA' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 02/04/2024 05:32:05 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/04/2024 05:32:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22358' , '1' , '' , 'nuovo-prodotto' ) 02/04/2024 05:32:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22358' , '1' , '1' , '2' , NOW() , NOW() ) 02/04/2024 05:32:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22358' , '0' , '1' , '0' , '0' ) 02/04/2024 05:34:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '45/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 05:34:14 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' , '45/A' , '2024-04-02' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '230.00' , NOW() , NOW() ) 02/04/2024 05:34:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91057' 02/04/2024 05:34:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91057' 02/04/2024 05:34:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91057' , '22219' , 'ASTUCCIO 3 VASETTI OLI SANTI - 968/3' , '1' , '-1' , '0' , '190.00' , '190' , '' , '0' , '190.00' ) 02/04/2024 05:34:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91057' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '-2' , '0' , '20.00' , '20' , '' , '0' , '40.00' ) 02/04/2024 05:35:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 05:35:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '996' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.32' , '32.32' , NOW() , NOW() ) 02/04/2024 05:35: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 = '91058' 02/04/2024 05:35:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91058' 02/04/2024 05:35: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 ( '91058' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/04/2024 05:35: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 ( '91058' , '22191' , 'PREGARE CON I SALMI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/04/2024 05:35: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 ( '91058' , '22192' , 'PREGHIERA DI GESU' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/04/2024 05:35: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 ( '91058' , '22290' , 'CHIESA IN PREGHIERA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/04/2024 05:52:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 05:52: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' , '997' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 02/04/2024 05:52: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 = '91059' 02/04/2024 05:52:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91059' 02/04/2024 05:52: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 ( '91059' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 02/04/2024 05:57:54 pm >> DELETE FROM ps_document WHERE id_document = '91057' 02/04/2024 05:57:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91057' 02/04/2024 05:57:56 pm >> DELETE FROM ps_document WHERE id_document = '90632' 02/04/2024 05:57:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90632' 02/04/2024 05:57:58 pm >> DELETE FROM ps_document WHERE id_document = '90485' 02/04/2024 05:57:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90485' 02/04/2024 05:58:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '440' AND id_document != '90337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-14') 02/04/2024 05:58:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '440', document_date = '2024-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.60', price_tax_excluded = '31.50', date_upd = NOW() WHERE id_document = '90337' 02/04/2024 05:58:32 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 = '90337' 02/04/2024 05:58:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90337' 02/04/2024 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90337' , '15865' , 'ROSARIO CON MONTFORT - 8862' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 02/04/2024 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90337' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 02/04/2024 05:58:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90337' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 02/04/2024 05:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '89804' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 02/04/2024 05:58:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '28', document_date = '2024-01-04', 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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '89804' 02/04/2024 05:58:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89804' 02/04/2024 05:58:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89804' 02/04/2024 05:58:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89804' , '22219' , 'ASTUCCIO 3 VASETTI OLI SANTI - 968/3' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 02/04/2024 05:59:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '925' AND id_document != '90977' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-27') 02/04/2024 05:59:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '925', document_date = '2024-03-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '90977' 02/04/2024 05:59:42 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 = '90977' 02/04/2024 05:59:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90977' 02/04/2024 05:59: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 ( '90977' , '22343' , 'LAMPADA IN CRISTALLO LAVORATA' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 02/04/2024 06:00:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '922' AND id_document != '90974' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 02/04/2024 06:00:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '922', document_date = '2024-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '90974' 02/04/2024 06:00:11 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 = '90974' 02/04/2024 06:00:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '90974' 02/04/2024 06:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90974' , '22197' , 'CLERGY ELEGANCE ML - C30' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 02/04/2024 06:02:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '375' AND id_document != '90254' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-06') 02/04/2024 06:02:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '375', document_date = '2024-02-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '90254' 02/04/2024 06:02: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 = '90254' 02/04/2024 06:02:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90254' 02/04/2024 06:02: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 ( '90254' , '19971' , 'CALICE - ART. 642' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 02/04/2024 06:02: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 ( '90254' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 02/04/2024 06:02: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 ( '90254' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '1' , '35' , '28.688524590164' , '22' , '0' , '105.00' ) 02/04/2024 06:02: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 ( '90254' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 02/04/2024 06:04:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '445' AND id_document != '90342' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-14') 02/04/2024 06:04:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '445', document_date = '2024-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '90342' 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90342' 02/04/2024 06:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90342' 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90342' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '142' , '116.39344262295' , '22' , '0' , '142.00' ) 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90342' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90342' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90342' , '11624' , 'PALLA 16X16 - SERV 3 ' , '2' , '-2' , '1' , '4' , '3.2786885245902' , '22' , '0' , '8.00' ) 02/04/2024 06:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90342' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/04/2024 06:07:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '737' AND id_document != '90743' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-13') 02/04/2024 06:07:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '737', document_date = '2024-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '450.00', price_tax_excluded = '368.85', date_upd = NOW() WHERE id_document = '90743' 02/04/2024 06:07: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 = '90743' 02/04/2024 06:07:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '90743' 02/04/2024 06:07: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 ( '90743' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '280' , '229.50819672131' , '22' , '0' , '280.00' ) 02/04/2024 06:07: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 ( '90743' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 02/04/2024 06:08:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '577' AND id_document != '90525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-27') 02/04/2024 06:08:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '577', document_date = '2024-02-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '90525' 02/04/2024 06:08: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 = '90525' 02/04/2024 06:08:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '90525' 02/04/2024 06:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90525' , '18223' , 'CORONA MISSIONARIA - R102' , '24' , '-24' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '24.00' ) 02/04/2024 06:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90525' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/04/2024 06:08:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '569' AND id_document != '90516' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 02/04/2024 06:08:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '569', document_date = '2024-02-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '90516' 02/04/2024 06:08:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90516' 02/04/2024 06:08:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90516' 02/04/2024 06:08:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90516' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/04/2024 06:09:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '743' AND id_document != '90750' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-13') 02/04/2024 06:09:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '743', document_date = '2024-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '410.00', price_tax_excluded = '336.07', date_upd = NOW() WHERE id_document = '90750' 02/04/2024 06:09: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 = '90750' 02/04/2024 06:09:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90750' 02/04/2024 06:09: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 ( '90750' , '22231' , 'CASULA - 65/060154' , '1' , '-1' , '1' , '410' , '336.06557377049' , '22' , '0' , '410.00' ) 02/04/2024 06:09:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '892' AND id_document != '90941' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 02/04/2024 06:09:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '892', document_date = '2024-03-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '46.50', price_tax_excluded = '38.39', date_upd = NOW() WHERE id_document = '90941' 02/04/2024 06:09:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90941' 02/04/2024 06:09:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90941' 02/04/2024 06:09:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90941' , '21015' , 'PASQUA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 02/04/2024 06:09: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 ( '90941' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 02/04/2024 06:10:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '869' AND id_document != '90911' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-23') 02/04/2024 06:10:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '869', document_date = '2024-03-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.50', price_tax_excluded = '50.41', date_upd = NOW() WHERE id_document = '90911' 02/04/2024 06:10: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 = '90911' 02/04/2024 06:10:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90911' 02/04/2024 06:10: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 ( '90911' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '5.50' ) 02/04/2024 06:10: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 ( '90911' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 02/04/2024 06:10: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 ( '90911' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '52' , '42.622950819672' , '22' , '0' , '52.00' ) 02/04/2024 06:11:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '89783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 02/04/2024 06:11:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '14', document_date = '2024-01-03', 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 = '658.00', price_tax_excluded = '557.02', date_upd = NOW() WHERE id_document = '89783' 02/04/2024 06:11: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 = '89783' 02/04/2024 06:11:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89783' 02/04/2024 06:11: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 ( '89783' , '3590' , 'DIZIONARIO DEI CONCETTI BIBLICI DEL NUOVO TESTAMENTO' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 02/04/2024 06:11: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 ( '89783' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '175.00' ) 02/04/2024 06:11: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 ( '89783' , '19660' , 'CASULA POLIESTERE - 65/11648' , '1' , '-1' , '1' , '385' , '315.5737704918' , '22' , '0' , '385.00' ) 02/04/2024 06:15:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '829' AND id_document != '90858' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 02/04/2024 06:15:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '829', document_date = '2024-03-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '90858' 02/04/2024 06:15:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90858' 02/04/2024 06:15:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90858' 02/04/2024 06:15:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90858' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 02/04/2024 06:15:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90858' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 02/04/2024 06:15:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90858' , '16456' , 'CINGOLO - CING03' , '3' , '-3' , '1' , '11.6' , '9.5081967213115' , '22' , '' , '34.80' ) 02/04/2024 06:33:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 06:33:25 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' , '998' , '2024-04-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '20.67' , NOW() , NOW() ) 02/04/2024 06:33:25 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 = '91060' 02/04/2024 06:33:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '91060' 02/04/2024 06:33:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91060' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '21.50' ) 02/04/2024 06:56:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '911' AND id_document != '90963' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 02/04/2024 06:56:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '911', document_date = '2024-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '90963' 02/04/2024 06:56:36 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 = '90963' 02/04/2024 06:56:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90963' 02/04/2024 06:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90963' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 02/04/2024 07:50:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '993' AND id_document != '91051' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 07:50:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '993', document_date = '2024-04-02', 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 = '29.00', price_tax_excluded = '23.77', date_upd = NOW() WHERE id_document = '91051' 02/04/2024 07:50:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91051' 02/04/2024 07:50:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91051' 02/04/2024 07:50:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91051' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '6' , '-6' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '18.00' ) 02/04/2024 07:50:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91051' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2024 07:51:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '986' AND id_document != '91043' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 07:51:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '986', document_date = '2024-04-02', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '91043' 02/04/2024 07:51: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 = '91043' 02/04/2024 07:51:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91043' 02/04/2024 07:51: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 ( '91043' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2024 07:51: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 ( '91043' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/04/2024 07:52:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '986' AND id_document != '91043' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 02/04/2024 07:52:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '986', document_date = '2024-04-02', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '91043' 02/04/2024 07:52: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 = '91043' 02/04/2024 07:52:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '91043' 02/04/2024 07:52: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 ( '91043' , '19724' , 'ROSARIO COPPIGLIATO S. FAMIGLIA MM8 - RE1717-SM' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 02/04/2024 07:52: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 ( '91043' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' )