16/10/2024 08:56:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30/580' AND id_product != '22647' AND ean13 != '' 16/10/2024 08:56:24 am >> UPDATE ps_product SET id_supplier = '129', reference = '', ean13 = '30/580', date_upd = NOW() WHERE id_product = '22647' 16/10/2024 08:56:25 am >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA - 30/580', description = '' WHERE id_product = '22647' 16/10/2024 08:56:25 am >> UPDATE ps_product SET wholesale_price = '69.97', on_sale = '0', price = '168.0327868852459' WHERE id_product = '22647' 16/10/2024 08:56:25 am >> UPDATE ps_product_shop SET wholesale_price = '69.97', price = '168.0327868852459', id_tax_rules_group = '1', id_category_default = '450', 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 = '22647' 16/10/2024 08:56:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22647' 16/10/2024 08:57:06 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/10/2024 08:57:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23047' , '1' , '' , 'nuovo-prodotto' ) 16/10/2024 08:57:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23047' , '1' , '1' , '2' , NOW() , NOW() ) 16/10/2024 08:57:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23047' , '0' , '1' , '0' , '0' ) 16/10/2024 08:58:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '60/1018' AND id_product != '23047' AND ean13 != '' 16/10/2024 08:58:03 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/1018', date_upd = NOW() WHERE id_product = '23047' 16/10/2024 08:58:03 am >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO - 60/1018', description = '' WHERE id_product = '23047' 16/10/2024 08:58:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '209.01639344262296' WHERE id_product = '23047' 16/10/2024 08:58:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '209.01639344262296', id_tax_rules_group = '1', id_category_default = '450', 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 = '23047' 16/10/2024 08:58:03 am >> DELETE FROM ps_specific_price WHERE id_product = '23047' 16/10/2024 08:59:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '4207/2024' , '2024-10-11' , '2024' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '608.71' , '498.94' , NOW() , NOW() ) 16/10/2024 08:59: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 = '93646' 16/10/2024 08:59:33 am >> DELETE FROM ps_document_detail WHERE id_document = '93646' 16/10/2024 08:59: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 ( '93646' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '1' , '1' , '196' , '160.65573770492' , '22' , '3' , '231.9464' ) 16/10/2024 08:59:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22840' AND id_supplier = '129' 16/10/2024 08:59:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22840' , '129' , '1' ) 16/10/2024 08:59: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 ( '93646' , '21044' , 'STOLA IN LANA TESS. TELAIO - 75/1602' , '1' , '1' , '1' , '95' , '77.868852459016' , '22' , '3' , '112.4230' ) 16/10/2024 08:59:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21044' AND id_supplier = '129' 16/10/2024 08:59:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21044' , '129' , '1' ) 16/10/2024 08:59: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 ( '93646' , '21042' , 'AMITTO MISTO LANA - 60/3111' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '3' , '21.3012' ) 16/10/2024 08:59:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21042' AND id_supplier = '129' 16/10/2024 08:59:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21042' , '129' , '1' ) 16/10/2024 08:59: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 ( '93646' , '22647' , 'COMPLETO MESSA - 30/580' , '1' , '1' , '1' , '88' , '72.131147540984' , '22' , '3' , '104.1392' ) 16/10/2024 08:59:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22647' AND id_supplier = '129' 16/10/2024 08:59:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22647' , '129' , '1' ) 16/10/2024 08:59: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 ( '93646' , '23047' , 'COMPLETO MESSA LINO - 60/1018' , '1' , '1' , '1' , '105' , '86.065573770492' , '22' , '3' , '124.2570' ) 16/10/2024 08:59:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23047' AND id_supplier = '129' 16/10/2024 08:59:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23047' , '129' , '1' ) 16/10/2024 09:02:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '60/1018' AND id_product != '23047' AND ean13 != '' 16/10/2024 09:02:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/1018', date_upd = NOW() WHERE id_product = '23047' 16/10/2024 09:02:09 am >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO - 60/1018', description = '' WHERE id_product = '23047' 16/10/2024 09:02:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '209.01639344262296' WHERE id_product = '23047' 16/10/2024 09:02:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '209.01639344262296', id_tax_rules_group = '1', id_category_default = '450', 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 = '23047' 16/10/2024 09:02:09 am >> DELETE FROM ps_specific_price WHERE id_product = '23047' 16/10/2024 09:16: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 ( '33' , '167/2024' , '2024-10-14' , '2024' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 16/10/2024 09:16: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 = '93647' 16/10/2024 09:16:28 am >> DELETE FROM ps_document_detail WHERE id_document = '93647' 16/10/2024 09:16: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 ( '93647' , '16955' , 'STOLA MARIANA - 8005' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/10/2024 09:16:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126' 16/10/2024 09:16:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' ) 16/10/2024 09:16: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 ( '93647' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/10/2024 09:16:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '21420' AND id_supplier = '126' 16/10/2024 09:16:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21420' , '126' , '1' ) 16/10/2024 09:16: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 ( '93647' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '2' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/10/2024 09:16:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 16/10/2024 09:16:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 16/10/2024 09:22:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3058' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 09:22:13 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' , '3058' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.55' , '138.11' , NOW() , NOW() ) 16/10/2024 09:22:13 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 = '93648' 16/10/2024 09:22:13 am >> DELETE FROM ps_document_detail WHERE id_document = '93648' 16/10/2024 09:22:13 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 ( '93648' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 16/10/2024 09:22:13 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 ( '93648' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/10/2024 09:22:13 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 ( '93648' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 16/10/2024 09:22:13 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 ( '93648' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 16/10/2024 09:22:13 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 ( '93648' , '21613' , 'RITO DELLA CONFERMAZIONE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 16/10/2024 09:22:13 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 ( '93648' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 09:27:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001495' AND id_product != '16961' AND ean13 != '' 16/10/2024 09:27:01 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001495', date_upd = NOW() WHERE id_product = '16961' 16/10/2024 09:27:01 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA - 5838/4', description = '' WHERE id_product = '16961' 16/10/2024 09:27:01 am >> UPDATE ps_product SET wholesale_price = '40.00', on_sale = '0', price = '98.36065573770492' WHERE id_product = '16961' 16/10/2024 09:27:01 am >> UPDATE ps_product_shop SET wholesale_price = '40.00', price = '98.36065573770492', id_tax_rules_group = '1', id_category_default = '448', 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 = '16961' 16/10/2024 09:27:01 am >> DELETE FROM ps_specific_price WHERE id_product = '16961' 16/10/2024 09:27:15 am >> UPDATE ps_document SET id_document_type = '33', document_num = '167/2024', document_date = '2024-10-14', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '4669995', address1 = 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '93647' 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93647' 16/10/2024 09:27:15 am >> DELETE FROM ps_document_detail WHERE id_document = '93647' 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93647' , '16955' , 'STOLA MARIANA - 8005' , '1' , '1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93647' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93647' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '2' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93647' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/10/2024 09:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93647' , '16961' , 'SERVIZIO MESSA - 5838/4' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 16/10/2024 09:57:46 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 09:57: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 ( '21' , '159' , '2024-10-16' , '' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.10' , '107.10' , NOW() , NOW() ) 16/10/2024 09:57: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 = '93649' 16/10/2024 09:57:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93649' 16/10/2024 09:57: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 ( '93649' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '-45' , '4' , '2.80' , '2.8' , '0' , '15' , '107.10' ) 16/10/2024 10:12:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3059' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 10:12:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3059' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '9.24' , NOW() , NOW() ) 16/10/2024 10:12:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93650' 16/10/2024 10:12:29 am >> DELETE FROM ps_document_detail WHERE id_document = '93650' 16/10/2024 10:12:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93650' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 16/10/2024 10:12:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93650' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/10/2024 10:12: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 ( '93650' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/10/2024 10:16:41 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 16/10/2024 10:16:41 am >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24', 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 = '984.80', price_tax_excluded = '807.21', date_upd = NOW() WHERE id_document = '93088' 16/10/2024 10:16:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93088' 16/10/2024 10:16:41 am >> DELETE FROM ps_document_detail WHERE id_document = '93088' 16/10/2024 10:16:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 16/10/2024 10:16:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 16/10/2024 10:27:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3060' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 10:27:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3060' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.56' , '43.21' , NOW() , NOW() ) 16/10/2024 10:27:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93651' 16/10/2024 10:27:18 am >> DELETE FROM ps_document_detail WHERE id_document = '93651' 16/10/2024 10:27:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93651' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '-2' , '4' , '19.50' , '19.5' , '0' , '5' , '37.06' ) 16/10/2024 10:27:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93651' , '6403' , 'MENSA BIANCA 80X150 ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 16/10/2024 10:32:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3044' AND id_document != '93628' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 16/10/2024 10:32:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3044', document_date = '2024-10-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 = '58.51', price_tax_excluded = '58.51', date_upd = NOW() WHERE id_document = '93628' 16/10/2024 10:32:51 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 = '93628' 16/10/2024 10:32:51 am >> DELETE FROM ps_document_detail WHERE id_document = '93628' 16/10/2024 10:32:51 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 ( '93628' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 16/10/2024 10:32:51 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 ( '93628' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 16/10/2024 10:32:51 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 ( '93628' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 16/10/2024 10:32:51 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 ( '93628' , '2879' , 'CRESIMA: IL MIRACOLO DI SEGUIRE GESÙ - C. PELLEGRINO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '5' , '7.13' ) 16/10/2024 10:32:51 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 ( '93628' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '5.00' ) 16/10/2024 10:32:51 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 ( '93628' , '9679' , 'SARETE MIEI TESTIMONI - GUIDA - G. MORANTE' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 16/10/2024 10:32:51 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 ( '93628' , '11186' , 'VENITE CON ME - GUIDA - M. FILIPPI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 16/10/2024 10:32:51 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 ( '93628' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.32' , '15.32' , '0' , '0' , '15.32' ) 16/10/2024 10:35:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 10:35: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' , '3061' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 16/10/2024 10:35: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 = '93652' 16/10/2024 10:35:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93652' 16/10/2024 10:35: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 ( '93652' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 16/10/2024 10:36:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 10:36:09 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' , '3062' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.10' , '140.05' , NOW() , NOW() ) 16/10/2024 10:36: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 = '93653' 16/10/2024 10:36:09 am >> DELETE FROM ps_document_detail WHERE id_document = '93653' 16/10/2024 10:36: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 ( '93653' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO - 60/3096' , '1' , '-1' , '1' , '150.00' , '122.95081967213' , '22' , '0' , '150.00' ) 16/10/2024 10:36: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 ( '93653' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 16/10/2024 11:01:35 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '93649' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 11:01:35 am >> UPDATE ps_document SET id_document_type = '21', document_num = '159', document_date = '2024-10-16', document_letter = '', id_customer = '371', id_supplier = '', id_address = '4679091', 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 = '3', id_causal = '0', price_tax_included = '107.10', price_tax_excluded = '107.10', date_upd = NOW() WHERE id_document = '93649' 16/10/2024 11:01:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93649' 16/10/2024 11:01:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93649' 16/10/2024 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93649' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '-45' , '4' , '2.8000' , '2.8' , '0' , '15' , '107.10' ) 16/10/2024 11:13:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 11:13:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3063' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.70' , '12.01' , NOW() , NOW() ) 16/10/2024 11:13:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93654' 16/10/2024 11:13:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93654' 16/10/2024 11:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93654' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 16/10/2024 11:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93654' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 16/10/2024 11:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93654' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/10/2024 11:13:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93654' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 16/10/2024 11:19:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 11:19: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' , '3064' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 16/10/2024 11:19: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 = '93655' 16/10/2024 11:19:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93655' 16/10/2024 11:19: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 ( '93655' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 16/10/2024 11:19: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 ( '93655' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 16/10/2024 11:45:06 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 16/10/2024 11:45:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '189.76', price_tax_excluded = '172.93', date_upd = NOW() WHERE id_document = '90734' 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90734' 16/10/2024 11:45:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90734' 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 16/10/2024 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 16/10/2024 11:45: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 ( '90734' , '13086' , 'VENTI SABATI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/10/2024 11:45: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 ( '90734' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '5' , '11.31' ) 16/10/2024 11:45: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 ( '90734' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 16/10/2024 11:45:24 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 16/10/2024 11:45:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.76', price_tax_excluded = '179.49', date_upd = NOW() WHERE id_document = '90734' 16/10/2024 11:45:24 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 = '90734' 16/10/2024 11:45:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90734' 16/10/2024 11:45:25 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 ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 16/10/2024 11:45:25 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 ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 16/10/2024 11:45:25 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 ( '90734' , '6629' , 'MIA PREGHIERA' , '3' , '-3' , '4' , '0.9000' , '0.9' , '0' , '0' , '2.70' ) 16/10/2024 11:45:25 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 ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 16/10/2024 11:45:25 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 ( '90734' , '22099' , 'YOUCAT' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 16/10/2024 11:45:25 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 ( '90734' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/10/2024 11:45:25 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 ( '90734' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 16/10/2024 11:45:25 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 ( '90734' , '23003' , 'SANTA MESSA - M. MIRTILLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 16/10/2024 11:45:25 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 ( '90734' , '13086' , 'VENTI SABATI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/10/2024 11:45:25 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 ( '90734' , '22981' , 'CALENDARIO PARROCCHIALE 2025' , '1' , '-1' , '1' , '11.9000' , '9.7540983606557' , '22' , '5' , '11.31' ) 16/10/2024 11:45:25 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 ( '90734' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '4' , '-4' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '32.00' ) 16/10/2024 11:56:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 11:56: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 ( '11' , '3065' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 16/10/2024 11:56: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 = '93656' 16/10/2024 11:56:26 am >> DELETE FROM ps_document_detail WHERE id_document = '93656' 16/10/2024 11:56: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 ( '93656' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 16/10/2024 12:03:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:03:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3066' , '2024-10-16' , '' , '188' , '0' , '4679150' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.60' , '54.80' , NOW() , NOW() ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93657' 16/10/2024 12:03:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93657' 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 16/10/2024 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93657' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 16/10/2024 12:04:28 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '188' 16/10/2024 12:04:28 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '188' , '10' , '210' , 'PARROCCHIA S. TROFIMENA DELL\'ANNUNZIATA' , 'NADDEO' , 'DON SABATINO' , 'VIA ROMA' , '' , '84121' , 'SALERNO' , '' , '089224852' , '' , '' , '80047580651' , NOW() , NOW() ) 16/10/2024 12:04:28 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '188' 16/10/2024 12:04:34 pm >> DELETE FROM ps_document WHERE id_document = '93335' 16/10/2024 12:04:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93335' 16/10/2024 12:05:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:05: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' , '3067' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 16/10/2024 12:05: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 = '93658' 16/10/2024 12:05:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '93658' 16/10/2024 12:05:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93658' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 16/10/2024 12:05:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93658' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 12:16:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:16: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 ( '21' , '38' , '2024-10-16' , '' , '6941' , '0' , '37343288' , 'VIA SANT\\\'ANNA 4 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.05' , '28.05' , NOW() , NOW() ) 16/10/2024 12:16: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 = '14761' 16/10/2024 12:16:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '14761' 16/10/2024 12:16: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 ( '14761' , '125' , 'MIE PREGHIERINE - N. E.' , '22' , '-22' , '4' , '1.50' , '1.5' , '0' , '15' , '28.05' ) 16/10/2024 12:16:45 pm >> DELETE FROM ps_document WHERE id_document = '93561' 16/10/2024 12:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93561' 16/10/2024 12:18:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3068' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:18: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' , '3068' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 16/10/2024 12:18: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 = '93659' 16/10/2024 12:18:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93659' 16/10/2024 12:18: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 ( '93659' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 12:19:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:19:42 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' , '3069' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.65' , '168.27' , NOW() , NOW() ) 16/10/2024 12:19: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 = '93660' 16/10/2024 12:19:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '93660' 16/10/2024 12:19: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 ( '93660' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 16/10/2024 12:19: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 ( '93660' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 12:19: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 ( '93660' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 16/10/2024 12:19: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 ( '93660' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 16/10/2024 12:19: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 ( '93660' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 16/10/2024 12:19: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 ( '93660' , '22303' , 'TURIBOLO PLACCATO ARG. CM 26' , '1' , '-1' , '1' , '125.00' , '102.45901639344' , '22' , '0' , '125.00' ) 16/10/2024 12:25:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3066' AND id_document != '93657' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 12:25:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3066', document_date = '2024-10-16', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA ROMA 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 = '63.60', price_tax_excluded = '54.80', date_upd = NOW() WHERE id_document = '93657' 16/10/2024 12:25: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 = '93657' 16/10/2024 12:25:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93657' 16/10/2024 12:25: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 ( '93657' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 16/10/2024 12:25: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 ( '93657' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/10/2024 12:25: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 ( '93657' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 16/10/2024 12:25: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 ( '93657' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 12:25: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 ( '93657' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 16/10/2024 12:25: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 ( '93657' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 16/10/2024 12:26:08 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'O1GrphIYMJt3vIvD' , NOW() , NOW() ) 16/10/2024 12:26:08 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4127' , '1' ) 16/10/2024 12:26:08 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4127' , '2' ) 16/10/2024 12:26:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4127' , '3' ) 16/10/2024 12:27:57 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4127' 16/10/2024 12:27:57 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4127' , '10' , '210' , 'CHIESA DI SANT\'ANNA AL PORTO' , 'RAIMONDO' , 'DON CLAUDIO' , 'VIA SANTA TERESA' , '' , '84121' , 'SALERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 16/10/2024 12:27:57 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4127' 16/10/2024 05:19:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 05:19: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 ( '11' , '3070' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 16/10/2024 05:19: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 = '93661' 16/10/2024 05:19:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '93661' 16/10/2024 05:19: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 ( '93661' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2024 05:27:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3071' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 05:27: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' , '3071' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 16/10/2024 05:27: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 = '93662' 16/10/2024 05:27:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93662' 16/10/2024 05:27: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 ( '93662' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 16/10/2024 05:27: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 ( '93662' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/10/2024 05:27: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 ( '93662' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/10/2024 05:27: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 ( '93662' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/10/2024 05:27: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 ( '93662' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/10/2024 05:38:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 05:38:36 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' , '3072' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.90' , '70.75' , NOW() , NOW() ) 16/10/2024 05:38: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 = '93663' 16/10/2024 05:38:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '93663' 16/10/2024 05:38: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 ( '93663' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/10/2024 05:38: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 ( '93663' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/10/2024 05:38: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 ( '93663' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/10/2024 06:22:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2848' AND id_document != '93358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 16/10/2024 06:22:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2848', document_date = '2024-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '125.00', price_tax_excluded = '102.46', date_upd = NOW() WHERE id_document = '93358' 16/10/2024 06:22:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93358' 16/10/2024 06:22:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93358' 16/10/2024 06:22:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93358' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 16/10/2024 06:22:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93358' , '20646' , 'STOLA DIACONALE - 881D' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 16/10/2024 06:22:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93358' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 16/10/2024 06:22:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2959' AND id_document != '93513' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 16/10/2024 06:22:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2959', document_date = '2024-10-08', 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 = '8.30', price_tax_excluded = '6.80', date_upd = NOW() WHERE id_document = '93513' 16/10/2024 06:22:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93513' 16/10/2024 06:22:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93513' 16/10/2024 06:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93513' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 16/10/2024 06:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93513' , '6314' , 'MEDAGLIA LOURDES MM 22' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 16/10/2024 06:22:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93513' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 16/10/2024 07:37:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-16') 16/10/2024 07:37:42 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' , '3073' , '2024-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 16/10/2024 07:37: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 = '93664' 16/10/2024 07:37:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '93664' 16/10/2024 07:37: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 ( '93664' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )