22/07/2024 10:02:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:02:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2313' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '196.00' , '160.66' , NOW() , NOW() ) 22/07/2024 10:02:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92678' 22/07/2024 10:02:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92678' 22/07/2024 10:02:07 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 ( '92678' , '15445' , 'QUADRO DECORATO 61X38' , '2' , '-2' , '1' , '86.00' , '70.491803278689' , '22' , '0' , '172.00' ) 22/07/2024 10:02:07 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 ( '92678' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 22/07/2024 10:02:07 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 ( '92678' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '100' , '0.00' ) 22/07/2024 10:02:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:02:40 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' , '2314' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.70' , '69.43' , NOW() , NOW() ) 22/07/2024 10:02:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92679' 22/07/2024 10:02:40 am >> DELETE FROM ps_document_detail WHERE id_document = '92679' 22/07/2024 10:02:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92679' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 22/07/2024 10:02:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92679' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '5' , '-5' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '39.00' ) 22/07/2024 10:02:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92679' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '5' , '-5' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '33.50' ) 22/07/2024 10:05:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2315' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:05: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' , '2315' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.50' , '116.80' , NOW() , NOW() ) 22/07/2024 10:05: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 = '92680' 22/07/2024 10:05:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92680' 22/07/2024 10:05: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 ( '92680' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '3' , '-3' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '40.50' ) 22/07/2024 10:05: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 ( '92680' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/07/2024 10:05: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 ( '92680' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/07/2024 10:05:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:05:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2316' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 22/07/2024 10:05:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92681' 22/07/2024 10:05:46 am >> DELETE FROM ps_document_detail WHERE id_document = '92681' 22/07/2024 10:05:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92681' , '16272' , 'GEMELLI IN MADREPERLA PX - 21773' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 22/07/2024 10:05:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92681' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 22/07/2024 10:05:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92681' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 22/07/2024 10:25:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '92681' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:25:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2316', document_date = '2024-07-22', 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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '92681' 22/07/2024 10:25:33 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 = '92681' 22/07/2024 10:25:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92681' 22/07/2024 10:25:33 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 ( '92681' , '16273' , 'GEMELLI MADREPERLA CROCE - 21774' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 22/07/2024 10:25:33 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 ( '92681' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '36.00' ) 22/07/2024 10:25:33 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 ( '92681' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 22/07/2024 10:26:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '92681' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:26:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2316', document_date = '2024-07-22', 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 = '131.00', price_tax_excluded = '107.38', date_upd = NOW() WHERE id_document = '92681' 22/07/2024 10:26:09 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 = '92681' 22/07/2024 10:26:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92681' 22/07/2024 10:26:09 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 ( '92681' , '16273' , 'GEMELLI MADREPERLA CROCE - 21774' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 22/07/2024 10:26:09 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 ( '92681' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '36.00' ) 22/07/2024 10:26:09 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 ( '92681' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 22/07/2024 10:26:09 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 ( '92681' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 22/07/2024 10:59:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 10:59: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' , '2317' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.25' , '71.25' , NOW() , NOW() ) 22/07/2024 10:59: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 = '92682' 22/07/2024 10:59:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92682' 22/07/2024 10:59: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 ( '92682' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '5' , '71.25' ) 22/07/2024 11:09:39 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/07/2024 11:09:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22761' , '1' , '' , 'nuovo-prodotto' ) 22/07/2024 11:09:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22761' , '1' , '1' , '2' , NOW() , NOW() ) 22/07/2024 11:09:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22761' , '0' , '1' , '0' , '0' ) 22/07/2024 11:10:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788816307179' AND id_product != '22761' AND ean13 != '' 22/07/2024 11:10:39 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788816307179', date_upd = NOW() WHERE id_product = '22761' 22/07/2024 11:10:39 am >> UPDATE ps_product_lang SET name = 'BREVE CATECHESI SUL MATRIMONIO - A. SICARI', description = '' WHERE id_product = '22761' 22/07/2024 11:10:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22761' 22/07/2024 11:10:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '265', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22761' 22/07/2024 11:10:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22761' 22/07/2024 11:10:40 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22761' 22/07/2024 11:10:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22762' , '1' , '' , 'nuovo-prodotto' ) 22/07/2024 11:10:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22762' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22761' 22/07/2024 11:10:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22762' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22761' 22/07/2024 11:11:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893188159' AND id_product != '22762' AND ean13 != '' 22/07/2024 11:11:37 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788893188159', date_upd = NOW() WHERE id_product = '22762' 22/07/2024 11:11:37 am >> UPDATE ps_product_lang SET name = 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO', description = '' WHERE id_product = '22762' 22/07/2024 11:11:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22762' 22/07/2024 11:11:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '47', 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 = '22762' 22/07/2024 11:11:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22762' 22/07/2024 11:11:38 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 = '22762' 22/07/2024 11:11:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22763' , '1' , '' , 'nuovo-prodotto' ) 22/07/2024 11:11:38 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 '22763' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22762' 22/07/2024 11:11:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22763' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22762' 22/07/2024 11:12:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804776079' AND id_product != '22763' AND ean13 != '' 22/07/2024 11:12:44 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788804776079', date_upd = NOW() WHERE id_product = '22763' 22/07/2024 11:12:44 am >> UPDATE ps_product_lang SET name = 'DOVE TERRA E CIELO SI INCONTRANO - EPICOCO/REGOLO', description = '' WHERE id_product = '22763' 22/07/2024 11:12:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.5' WHERE id_product = '22763' 22/07/2024 11:12:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.5', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22763' 22/07/2024 11:12:44 am >> DELETE FROM ps_specific_price WHERE id_product = '22763' 22/07/2024 11:12:48 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 = '22763' 22/07/2024 11:12:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22764' , '1' , '' , 'nuovo-prodotto' ) 22/07/2024 11:12:48 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 '22764' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22763' 22/07/2024 11:12:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22764' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22763' 22/07/2024 11:13:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259622808' AND id_product != '22764' AND ean13 != '' 22/07/2024 11:13:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259622808', date_upd = NOW() WHERE id_product = '22764' 22/07/2024 11:13:46 am >> UPDATE ps_product_lang SET name = 'FINE DELLA CRISTIANITA\' E IL RITORNO DEL PAGANESIMO - C. DELSOL', description = '' WHERE id_product = '22764' 22/07/2024 11:13:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '22764' 22/07/2024 11:13:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22764' 22/07/2024 11:13:46 am >> DELETE FROM ps_specific_price WHERE id_product = '22764' 22/07/2024 11:13:47 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 = '22764' 22/07/2024 11:13:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22765' , '1' , '' , 'nuovo-prodotto' ) 22/07/2024 11:13:47 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 '22765' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22764' 22/07/2024 11:13:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22765' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22764' 22/07/2024 11:16:26 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' , '1411930' , '2024-07-18' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.40' , '101.40' , NOW() , NOW() ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92683' 22/07/2024 11:16:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92683' 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22761' , 'BREVE CATECHESI SUL MATRIMONIO - A. SICARI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22761' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22761' , '177' , '1' ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22429' , 'DAVIDE IL BAMBINO - C. SIGNORELLI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22429' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22429' , '177' , '1' ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '0' , '24.90' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22334' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22334' , '177' , '1' ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22763' , 'DOVE TERRA E CIELO SI INCONTRANO - EPICOCO/REGOLO' , '1' , '1' , '4' , '17.50' , '17.5' , '0' , '0' , '17.50' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22763' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22763' , '177' , '1' ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22764' , 'FINE DELLA CRISTIANITA E IL RITORNO DEL PAGANESIMO - C. DELSOL' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22764' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22764' , '177' , '1' ) 22/07/2024 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92683' , '22762' , 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/07/2024 11:16:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22762' AND id_supplier = '177' 22/07/2024 11:16:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22762' , '177' , '1' ) 22/07/2024 11:33:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 11:33:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2318' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 22/07/2024 11:33:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92684' 22/07/2024 11:33:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92684' 22/07/2024 11:33:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92684' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 22/07/2024 11:56:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 11:56:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2319' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.10' , '67.10' , NOW() , NOW() ) 22/07/2024 11:56:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92685' 22/07/2024 11:56:34 am >> DELETE FROM ps_document_detail WHERE id_document = '92685' 22/07/2024 11:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/07/2024 11:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '9019' , 'RITO DELLE ESEQUIE - MAG' , '1' , '-1' , '4' , '36.1' , '36.1' , '0' , '0' , '36.10' ) 22/07/2024 11:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '18176' , 'ANTIQUUM MINISTERIUM ' , '12' , '-12' , '4' , '1.00' , '1' , '0' , '0' , '12.00' ) 22/07/2024 11:57:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 11:57:28 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' , '2320' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 22/07/2024 11:57:28 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 = '92686' 22/07/2024 11:57:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92686' 22/07/2024 11:57:28 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 ( '92686' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 22/07/2024 12:00:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:00:28 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' , '2321' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '201.50' , '184.01' , NOW() , NOW() ) 22/07/2024 12:00:28 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 = '92687' 22/07/2024 12:00:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92687' 22/07/2024 12:00: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 ( '92687' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 22/07/2024 12:00: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 ( '92687' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 22/07/2024 12:00: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 ( '92687' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/07/2024 12:00: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 ( '92687' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 22/07/2024 12:00: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 ( '92687' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 22/07/2024 12:00: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 ( '92687' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/07/2024 12:01:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:01: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 ( '11' , '2322' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.10' , '80.36' , NOW() , NOW() ) 22/07/2024 12:01: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 = '92688' 22/07/2024 12:01:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92688' 22/07/2024 12:01: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 ( '92688' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/07/2024 12:01: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 ( '92688' , '21871' , '50 DOMANDE SULLA FEDE - R. MACCIONI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 22/07/2024 12:01: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 ( '92688' , '22015' , 'MEDJUGORJE VERA STORIA - 8593' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 22/07/2024 12:01: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 ( '92688' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 22/07/2024 12:04:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:04:51 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' , '2323' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.55' , '46.55' , NOW() , NOW() ) 22/07/2024 12:04:51 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 = '92689' 22/07/2024 12:04:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '92689' 22/07/2024 12:04: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 ( '92689' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 22/07/2024 12:04: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 ( '92689' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/07/2024 12:04: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 ( '92689' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 22/07/2024 12:05:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:05:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2324' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 22/07/2024 12:05: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 = '92690' 22/07/2024 12:05:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92690' 22/07/2024 12:05: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 ( '92690' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/07/2024 12:06:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2324' AND id_document != '92690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:06:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2324', document_date = '2024-07-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '92690' 22/07/2024 12:06:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92690' 22/07/2024 12:06:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92690' 22/07/2024 12:06: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 ( '92690' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '6.66' ) 22/07/2024 12:06: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 ( '92690' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.34' , '2.7377049180328' , '22' , '0' , '3.34' ) 22/07/2024 12:08:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2319' AND id_document != '92685' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:08:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2319', document_date = '2024-07-22', 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 = '67.10', price_tax_excluded = '67.10', date_upd = NOW() WHERE id_document = '92685' 22/07/2024 12:08:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92685' 22/07/2024 12:08:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92685' 22/07/2024 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 22/07/2024 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '9019' , 'RITO DELLE ESEQUIE - MAG' , '1' , '-1' , '4' , '36.1000' , '36.1' , '0' , '0' , '36.10' ) 22/07/2024 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92685' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 22/07/2024 12:21:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:21:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '83/A' , '2024-07-22' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '14.08' , NOW() , NOW() ) 22/07/2024 12:21:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92691' 22/07/2024 12:21:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 22/07/2024 12:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 22/07/2024 12:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/07/2024 12:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/07/2024 12:26:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:26:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.50', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '92691' 22/07/2024 12:26:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92691' 22/07/2024 12:26:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 22/07/2024 12:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 22/07/2024 12:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/07/2024 12:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/07/2024 12:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 22/07/2024 12:35:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:35:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '84/A' , '2024-07-22' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'ospedale battipaglia' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 22/07/2024 12:35: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 = '92692' 22/07/2024 12:35:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92692' 22/07/2024 12:35: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 ( '92692' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 22/07/2024 12:36:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1598' AND id_document != '91819' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-15') 22/07/2024 12:36:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1598', document_date = '2024-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '106.00', price_tax_excluded = '86.89', date_upd = NOW() WHERE id_document = '91819' 22/07/2024 12:36:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91819' 22/07/2024 12:36:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91819' 22/07/2024 12:36:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91819' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 22/07/2024 12:36:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91819' , '15445' , 'QUADRO DECORATO 61X38' , '1' , '-1' , '1' , '86.00' , '70.491803278689' , '22' , '0' , '86.00' ) 22/07/2024 12:47:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 12:47:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2325' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 22/07/2024 12:47: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 = '92693' 22/07/2024 12:47:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92693' 22/07/2024 12:47: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 ( '92693' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 22/07/2024 12:56:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2307' AND id_document != '92671' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-19') 22/07/2024 12:56:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2307', document_date = '2024-07-19', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO', 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 = '197.40', price_tax_excluded = '161.80', date_upd = NOW() WHERE id_document = '92671' 22/07/2024 12:56:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92671' 22/07/2024 12:56:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92671' 22/07/2024 12:56:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92671' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/07/2024 12:56:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92671' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/07/2024 12:56:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92671' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 22/07/2024 02:54:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2326' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 02:54:28 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' , '2326' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 22/07/2024 02:54:28 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 = '92694' 22/07/2024 02:54:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92694' 22/07/2024 02:54: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 ( '92694' , '22429' , 'DAVIDE IL BAMBINO - C. SIGNORELLI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/07/2024 03:54:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000459' AND id_product != '4203' AND ean13 != '' 22/07/2024 03:54:34 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000459', date_upd = NOW() WHERE id_product = '4203' 22/07/2024 03:54:34 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X80 - 148 ', description = '' WHERE id_product = '4203' 22/07/2024 03:54:34 pm >> UPDATE ps_product SET wholesale_price = '6.70', on_sale = '0', price = '17.21311475409836' WHERE id_product = '4203' 22/07/2024 03:54:34 pm >> UPDATE ps_product_shop SET wholesale_price = '6.70', price = '17.21311475409836', id_tax_rules_group = '1', id_category_default = '147', 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 = '4203' 22/07/2024 03:54:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '4203' 22/07/2024 03:55:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000459' AND id_product != '4203' AND ean13 != '' 22/07/2024 03:55:39 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000459', date_upd = NOW() WHERE id_product = '4203' 22/07/2024 03:55:39 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X80 - 148 ', description = '' WHERE id_product = '4203' 22/07/2024 03:55:39 pm >> UPDATE ps_product SET wholesale_price = '6.70', on_sale = '0', price = '18.852459016393443' WHERE id_product = '4203' 22/07/2024 03:55:40 pm >> UPDATE ps_product_shop SET wholesale_price = '6.70', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '147', 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 = '4203' 22/07/2024 03:55:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '4203' 22/07/2024 04:08:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000051' AND id_product != '546' AND ean13 != '' 22/07/2024 04:08:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000051', date_upd = NOW() WHERE id_product = '546' 22/07/2024 04:08:00 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE SU VASSOIO VETRO - 1500', description = '' WHERE id_product = '546' 22/07/2024 04:08:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '45.0820' WHERE id_product = '546' 22/07/2024 04:08:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '45.0820', id_tax_rules_group = '1', id_category_default = '147', 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 = '546' 22/07/2024 04:08:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '546' 22/07/2024 04:13: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 ( '31' , '2414' , '2024-07-18' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '369.23' , '302.65' , NOW() , NOW() ) 22/07/2024 04:13: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 = '92695' 22/07/2024 04:13:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92695' 22/07/2024 04:13: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 ( '92695' , '4203' , 'FINTA CANDELA 4X80 - 148 ' , '12' , '12' , '1' , '10.5' , '8.6065573770492' , '22' , '5' , '146.0340' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4203' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4203' , '12' , '1' ) 22/07/2024 04:13: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 ( '92695' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '3' , '1' , '18.5' , '15.16393442623' , '22' , '5' , '64.3245' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 22/07/2024 04:13: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 ( '92695' , '546' , 'AMPOLLE SU VASSOIO VETRO - 1500' , '2' , '2' , '1' , '23' , '18.852459016393' , '22' , '5' , '53.3140' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '546' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '546' , '12' , '1' ) 22/07/2024 04:13: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 ( '92695' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '4' , '4' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '39.4060' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '12' , '1' ) 22/07/2024 04:13: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 ( '92695' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '11' , '9.016393442623' , '22' , '0' , '13.4200' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '12' , '1' ) 22/07/2024 04:13: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 ( '92695' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '45.5' , '37.295081967213' , '22' , '5' , '52.7345' ) 22/07/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '12' 22/07/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '12' , '1' ) 22/07/2024 04:44:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 04:44:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2327' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 22/07/2024 04:44: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 = '92696' 22/07/2024 04:44:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92696' 22/07/2024 04:44: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 ( '92696' , '22466' , 'CASULA M LINO/BAMBOO - 1214' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 22/07/2024 05:01:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 05:01:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2328' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.40' , '91.95' , NOW() , NOW() ) 22/07/2024 05:01:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92697' 22/07/2024 05:01:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '92697' 22/07/2024 05:01: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 ( '92697' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 22/07/2024 05:01: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 ( '92697' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36.5' , '29.918032786885' , '22' , '0' , '36.50' ) 22/07/2024 05:01: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 ( '92697' , '22718' , 'PAOLO APOSTOLO E MAESTRO - LORI/VOLTAGGIO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 22/07/2024 05:01: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 ( '92697' , '15795' , 'CARLO ACUTIS - 8950' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/07/2024 05:03:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 05:03:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2329' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 22/07/2024 05:03:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92698' 22/07/2024 05:03:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92698' 22/07/2024 05:03:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 22/07/2024 05:34:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 05:34:38 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 ( '23' , '15/L' , '2024-07-22' , 'L' , '3479' , '0' , '4673306' , 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '386.00' , '361.22' , NOW() , NOW() ) 22/07/2024 05:34:38 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 = '92699' 22/07/2024 05:34:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92699' 22/07/2024 05:34:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92699' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 22/07/2024 05:34:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92699' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 22/07/2024 05:34:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92699' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 22/07/2024 05:34:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92699' , '7311' , 'OSTIA SOTTILE 74MM' , '158' , '-158' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '316.00' ) 22/07/2024 05:39:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/L' AND id_document != '92561' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-11') 22/07/2024 05:39:03 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '14/L', document_date = '2024-07-11', document_letter = 'L', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '617.90', price_tax_excluded = '617.90', date_upd = NOW() WHERE id_document = '92561' 22/07/2024 05:39:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92561' 22/07/2024 05:39:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '92561' 22/07/2024 05:39: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 ( '92561' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '20' , '81.60' ) 22/07/2024 05:39: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 ( '92561' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '20' , '8.00' ) 22/07/2024 05:39: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 ( '92561' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '10' , '81.00' ) 22/07/2024 05:39: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 ( '92561' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 22/07/2024 05:39: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 ( '92561' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '10' , '81.00' ) 22/07/2024 05:39: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 ( '92561' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 22/07/2024 05:39: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 ( '92561' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 22/07/2024 05:39: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 ( '92561' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '14' , '-14' , '4' , '3.0000' , '3' , '0' , '10' , '37.80' ) 22/07/2024 05:39: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 ( '92561' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '10' , '45.00' ) 22/07/2024 05:39: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 ( '92561' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '10' , '13.50' ) 22/07/2024 06:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2328' AND id_document != '92697' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 06:08:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2328', document_date = '2024-07-22', 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 = '103.40', price_tax_excluded = '91.95', date_upd = NOW() WHERE id_document = '92697' 22/07/2024 06:08: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 = '92697' 22/07/2024 06:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92697' 22/07/2024 06:08: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 ( '92697' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 22/07/2024 06:08: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 ( '92697' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 22/07/2024 06:08: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 ( '92697' , '22718' , 'PAOLO APOSTOLO E MAESTRO - LORI/VOLTAGGIO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 22/07/2024 06:08: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 ( '92697' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.65' , '6.65' , '0' , '0' , '6.65' ) 22/07/2024 06:54:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 06:54:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2330' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 22/07/2024 06:54: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 = '92700' 22/07/2024 06:54:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92700' 22/07/2024 06:54: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 ( '92700' , '17600' , 'STATUA S. MICHELE CM 20 BIANCA - 203SM' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 22/07/2024 06:54: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 ( '92700' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 22/07/2024 06:54: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 ( '92700' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/07/2024 07:14:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 22/07/2024 07:14:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2331' , '2024-07-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.00' , '614.75' , NOW() , NOW() ) 22/07/2024 07:14:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92701' 22/07/2024 07:14:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92701' 22/07/2024 07:14:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92701' , '22759' , 'MANTOVANA IHS - 7475-7482' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' )