29/11/2024 09:01:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 09:01:01 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' , '3708' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 29/11/2024 09:01:01 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 = '94567' 29/11/2024 09:01:01 am >> DELETE FROM ps_document_detail WHERE id_document = '94567' 29/11/2024 09:01:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94567' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 29/11/2024 09:20:43 am >> SELECT document_num FROM ps_document WHERE document_num = '98/A' AND id_document != '93134' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-13') 29/11/2024 09:20:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '98/A', document_date = '2024-09-13', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'HOSPICE \"CASA DI LARA\"', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.10', price_tax_excluded = '37.67', date_upd = NOW() WHERE id_document = '93134' 29/11/2024 09:20:43 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 = '93134' 29/11/2024 09:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '93134' 29/11/2024 09:20:43 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 ( '93134' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/11/2024 09:20:43 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 ( '93134' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/11/2024 09:20:43 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 ( '93134' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 29/11/2024 09:20:43 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 ( '93134' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/11/2024 09:20:43 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 ( '93134' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 29/11/2024 09:20:43 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 ( '93134' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 29/11/2024 09:23:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '94164' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 29/11/2024 09:23:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3407', document_date = '2024-11-09', 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 = '11.00', price_tax_excluded = '9.99', date_upd = NOW() WHERE id_document = '94164' 29/11/2024 09:23:03 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 = '94164' 29/11/2024 09:23:03 am >> DELETE FROM ps_document_detail WHERE id_document = '94164' 29/11/2024 09:23:03 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 ( '94164' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/11/2024 09:23:03 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 ( '94164' , '19073' , 'BAMBINELLO CM 4,5 - PB0501' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 29/11/2024 09:23:03 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 ( '94164' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 29/11/2024 09:23:03 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 ( '94164' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 29/11/2024 09:23:03 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 ( '94164' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 29/11/2024 09:23:03 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 ( '94164' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 29/11/2024 09:23:03 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 ( '94164' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 29/11/2024 09:24:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3470' AND id_document != '94251' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 29/11/2024 09:24:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3470', document_date = '2024-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '66.85', date_upd = NOW() WHERE id_document = '94251' 29/11/2024 09:24: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 = '94251' 29/11/2024 09:24:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94251' 29/11/2024 09:24: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 ( '94251' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '22.00' ) 29/11/2024 09:24: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 ( '94251' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '3' , '-3' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '11.70' ) 29/11/2024 09:24: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 ( '94251' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/11/2024 09:24: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 ( '94251' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/11/2024 09:24: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 ( '94251' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/11/2024 09:24: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 ( '94251' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 29/11/2024 09:24: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 ( '94251' , '23090' , 'ALBERO CON PRESEPE ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 29/11/2024 09:38:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/11/2024 09:38:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23273' , '1' , '' , 'nuovo-prodotto' ) 29/11/2024 09:38:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23273' , '1' , '1' , '2' , NOW() , NOW() ) 29/11/2024 09:38:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23273' , '0' , '1' , '0' , '0' ) 29/11/2024 09:38:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7967' AND id_product != '23273' AND ean13 != '' 29/11/2024 09:38:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '7967', date_upd = NOW() WHERE id_product = '23273' 29/11/2024 09:38:55 am >> UPDATE ps_product_lang SET name = 'CASULA PERSONALIZZATA - 7967', description = '' WHERE id_product = '23273' 29/11/2024 09:38:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '319.672131147541' WHERE id_product = '23273' 29/11/2024 09:38:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '319.672131147541', 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 = '23273' 29/11/2024 09:38:55 am >> DELETE FROM ps_specific_price WHERE id_product = '23273' 29/11/2024 09:39:16 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' , '155/2024' , '2024-11-27' , '2024' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '195.20' , '160.00' , NOW() , NOW() ) 29/11/2024 09:39:16 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 = '94568' 29/11/2024 09:39:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94568' 29/11/2024 09:39:16 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 ( '94568' , '23273' , 'CASULA PERSONALIZZATA - 7967' , '1' , '0' , '1' , '150' , '122.95081967213' , '22' , '0' , '183.0000' ) 29/11/2024 09:39:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '23273' AND id_supplier = '126' 29/11/2024 09:39:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23273' , '126' , '1' ) 29/11/2024 09:46:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/11/2024 09:46:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23274' , '1' , '' , 'nuovo-prodotto' ) 29/11/2024 09:46:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23274' , '1' , '1' , '2' , NOW() , NOW() ) 29/11/2024 09:46:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23274' , '0' , '1' , '0' , '0' ) 29/11/2024 10:25:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 10:25: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' , '3709' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.00' , '103.28' , NOW() , NOW() ) 29/11/2024 10:25: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 = '94569' 29/11/2024 10:25:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94569' 29/11/2024 10:25: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 ( '94569' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '180' , '-180' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '126.00' ) 29/11/2024 11:04:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 11:04: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' , '3710' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.39' , NOW() , NOW() ) 29/11/2024 11:04: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 = '94570' 29/11/2024 11:04:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94570' 29/11/2024 11:04: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 ( '94570' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 29/11/2024 11:04: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 ( '94570' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/11/2024 11:05:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 11:05:36 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' , '3711' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.39' , NOW() , NOW() ) 29/11/2024 11:05:36 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 = '94571' 29/11/2024 11:05:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94571' 29/11/2024 11:05:36 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 ( '94571' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '80' , '-80' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '20.00' ) 29/11/2024 11:05:36 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 ( '94571' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 29/11/2024 11:45:04 am >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '94315' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-18') 29/11/2024 11:45:04 am >> UPDATE ps_document SET id_document_type = '24', document_num = '125/A', document_date = '2024-11-18', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '394.80', price_tax_excluded = '326.99', date_upd = NOW() WHERE id_document = '94315' 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94315' 29/11/2024 11:45:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94315' 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '0' , '23/11 DON MICHELE RITIRA' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '96.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '21137' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '60.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '' , '29/11' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '96.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 29/11/2024 11:45:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 29/11/2024 11:55:49 am >> SELECT document_num FROM ps_document WHERE document_num = '236' AND id_document != '94301' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-16') 29/11/2024 11:55:49 am >> UPDATE ps_document SET id_document_type = '21', document_num = '236', document_date = '2024-11-16', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', 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 = '28.68', price_tax_excluded = '28.68', date_upd = NOW() WHERE id_document = '94301' 29/11/2024 11:55:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94301' 29/11/2024 11:55:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94301' 29/11/2024 11:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94301' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '8' , '-8' , '4' , '2.4000' , '2.4' , '0' , '15' , '16.32' ) 29/11/2024 11:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94301' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '15' , '2.38' ) 29/11/2024 11:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94301' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 29/11/2024 11:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94301' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '15' , '4.76' ) 29/11/2024 11:56:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 11:56:01 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' , '3712' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.23' , '5.23' , NOW() , NOW() ) 29/11/2024 11:56:01 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 = '94572' 29/11/2024 11:56:01 am >> DELETE FROM ps_document_detail WHERE id_document = '94572' 29/11/2024 11:56:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94572' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 29/11/2024 12:01:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 12:01:04 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' , '3713' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.50' , '24.52' , NOW() , NOW() ) 29/11/2024 12:01:04 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 = '94573' 29/11/2024 12:01:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94573' 29/11/2024 12:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94573' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 29/11/2024 12:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94573' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 29/11/2024 12:26:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1325' 29/11/2024 12:26:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-13' WHERE id_product = '1325' 29/11/2024 12:30:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 12:30:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3714' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 29/11/2024 12:30:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94574' 29/11/2024 12:30:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94574' 29/11/2024 12:30:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94574' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 29/11/2024 12:48:20 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '155/2024', document_date = '2024-11-27', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '4669995', address1 = 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA', address2 = '', note = '', price_shipping = '10.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '10', id_causal = '0', price_tax_included = '195.20', price_tax_excluded = '160.00', date_upd = NOW() WHERE id_document = '94568' 29/11/2024 12:48: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 = '94568' 29/11/2024 12:48:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94568' 29/11/2024 12:48: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 ( '94568' , '23273' , 'CASULA PERSONALIZZATA - 7967' , '1' , '1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '183.00' ) 29/11/2024 12:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 12:48:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3715' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 29/11/2024 12:48:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94575' 29/11/2024 12:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94575' 29/11/2024 12:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94575' , '23273' , 'CASULA PERSONALIZZATA - 7967' , '1' , '-1' , '1' , '390.00' , '319.67213114754' , '22' , '0' , '390.00' ) 29/11/2024 03:14:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609140' AND id_product != '23274' AND ean13 != '' 29/11/2024 03:14:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826609140', date_upd = NOW() WHERE id_product = '23274' 29/11/2024 03:14:06 pm >> UPDATE ps_product_lang SET name = 'FEDE E\' UN VIAGGIO - PAPA FRANCESCO', description = '' WHERE id_product = '23274' 29/11/2024 03:14:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23274' 29/11/2024 03:14:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23274' 29/11/2024 03:14:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23274' 29/11/2024 03:14:07 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23274' 29/11/2024 03:14:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23275' , '1' , '' , 'nuovo-prodotto' ) 29/11/2024 03:14:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23275' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23274' 29/11/2024 03:14:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23275' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23274' 29/11/2024 03:15:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL003725' , '2024-11-28' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '188.30' , '188.30' , NOW() , NOW() ) 29/11/2024 03:15: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 = '94576' 29/11/2024 03:15:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94576' 29/11/2024 03:15: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 ( '94576' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 29/11/2024 03:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 29/11/2024 03:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 29/11/2024 03:15: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 ( '94576' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '2' , '2' , '4' , '60.00' , '60' , '0' , '35' , '78.0000' ) 29/11/2024 03:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 29/11/2024 03:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 29/11/2024 03:15: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 ( '94576' , '23274' , 'FEDE E UN VIAGGIO - PAPA FRANCESCO' , '2' , '2' , '4' , '8.00' , '8' , '0' , '45' , '8.8000' ) 29/11/2024 03:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23274' AND id_supplier = '79' 29/11/2024 03:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23274' , '79' , '1' ) 29/11/2024 03:15: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 ( '94576' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 29/11/2024 03:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/11/2024 03:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024-FV001760' , '2024-11-29' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '19.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '708.13' , '708.13' , NOW() , NOW() ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94577' 29/11/2024 03:19:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94577' 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94577' , '23219' , 'ORDO MISSAE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 29/11/2024 03:19:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23219' AND id_supplier = '79' 29/11/2024 03:19:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23219' , '79' , '1' ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94577' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/11/2024 03:19:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/11/2024 03:19:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94577' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '2' , '0' , '4' , '2.8000' , '2.8' , '0' , '45' , '3.08' ) 29/11/2024 03:19:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22529' AND id_supplier = '79' 29/11/2024 03:19:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22529' , '79' , '1' ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94577' , '22507' , 'SPES NON CONFUNDIT' , '45' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '49.50' ) 29/11/2024 03:19:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 29/11/2024 03:19:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 29/11/2024 03:19:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94577' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 29/11/2024 03:19:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 29/11/2024 03:19:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '16.25' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '22507' , 'SPES NON CONFUNDIT' , '10' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '11.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '0' , '4' , '60' , '60' , '0' , '30' , '42.0000' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '0' , '4' , '60' , '60' , '0' , '30' , '42.0000' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '22507' , 'SPES NON CONFUNDIT' , '20' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '22.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '78.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '23274' , 'FEDE E UN VIAGGIO - PAPA FRANCESCO' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '45' , '8.80' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23274' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23274' , '79' , '1' ) 29/11/2024 03:19: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 ( '94577' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 29/11/2024 03:19:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 29/11/2024 03:19:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 29/11/2024 03:24:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002040' AND id_product != '20157' AND ean13 != '' 29/11/2024 03:24:53 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002040', date_upd = NOW() WHERE id_product = '20157' 29/11/2024 03:24:53 pm >> UPDATE ps_product_lang SET name = 'ALBERO DI NATALE - MIX', description = '' WHERE id_product = '20157' 29/11/2024 03:24:53 pm >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '20157' 29/11/2024 03:24:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20157' 29/11/2024 03:24:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20157' 29/11/2024 03:25:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002039' AND id_product != '20156' AND ean13 != '' 29/11/2024 03:25:56 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002039', date_upd = NOW() WHERE id_product = '20156' 29/11/2024 03:25:56 pm >> UPDATE ps_product_lang SET name = 'PALLA E STELLE CON CARTONCINO - 23', description = '' WHERE id_product = '20156' 29/11/2024 03:25:57 pm >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '1.639344262295082' WHERE id_product = '20156' 29/11/2024 03:25:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20156' 29/11/2024 03:25:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '20156' 29/11/2024 03:26:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002085' AND id_product != '20521' AND ean13 != '' 29/11/2024 03:26:54 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002085', date_upd = NOW() WHERE id_product = '20521' 29/11/2024 03:26:54 pm >> UPDATE ps_product_lang SET name = 'ALBERO IN RESINA CON NATIVITA\' - 31/175 ', description = '' WHERE id_product = '20521' 29/11/2024 03:26:54 pm >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '3.9344262295081966' WHERE id_product = '20521' 29/11/2024 03:26:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '3.9344262295081966', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20521' 29/11/2024 03:26:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '20521' 29/11/2024 03:27:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002085' AND id_product != '20521' AND ean13 != '' 29/11/2024 03:27:05 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002085', date_upd = NOW() WHERE id_product = '20521' 29/11/2024 03:27:05 pm >> UPDATE ps_product_lang SET name = 'ALBERO IN RESINA CON NATIVITA\' - 31/175 ', description = '' WHERE id_product = '20521' 29/11/2024 03:27:05 pm >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '3.9344262295081966' WHERE id_product = '20521' 29/11/2024 03:27:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '3.9344262295081966', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20521' 29/11/2024 03:27:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '20521' 29/11/2024 03:32:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '852' , '2024-11-28' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1336.02' , '1095.10' , NOW() , NOW() ) 29/11/2024 03:32:00 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 = '94578' 29/11/2024 03:32:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94578' 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20157' , 'ALBERO DI NATALE - MIX' , '209' , '209' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '203.9840' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20157' , 'ALBERO DI NATALE - MIX' , '210' , '210' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '179.3400' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '630' , '630' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '499.5900' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '104' , '104' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '76.1280' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20521' , 'ALBERO IN RESINA CON NATIVITA - 31/175 ' , '32' , '32' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '74.1760' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '40' , '40' , '1' , '2' , '1.6393442622951' , '22' , '0' , '97.6000' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '60' 29/11/2024 03:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '60' , '1' ) 29/11/2024 03:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '12' , '12' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '26.3520' ) 29/11/2024 03:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20154' AND id_supplier = '60' 29/11/2024 03:32:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20154' , '60' , '1' ) 29/11/2024 03:32:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '12' , '12' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '26.3520' ) 29/11/2024 03:32:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20153' AND id_supplier = '60' 29/11/2024 03:32:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20153' , '60' , '1' ) 29/11/2024 03:32:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94578' , '1312' , 'BRACCIALE DECINA' , '250' , '250' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '152.5000' ) 29/11/2024 03:32:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '60' 29/11/2024 03:32:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '60' , '1' ) 29/11/2024 03:39:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002040' AND id_product != '20157' AND ean13 != '' 29/11/2024 03:39:49 pm >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '002040', date_upd = NOW() WHERE id_product = '20157' 29/11/2024 03:39:49 pm >> UPDATE ps_product_lang SET name = 'ALBERO DI NATALE - MIX', description = '' WHERE id_product = '20157' 29/11/2024 03:39:49 pm >> UPDATE ps_product SET wholesale_price = '0.49', on_sale = '0', price = '1.8852459016393441' WHERE id_product = '20157' 29/11/2024 03:39:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.49', price = '1.8852459016393441', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20157' 29/11/2024 03:39:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20157' 29/11/2024 03:54:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 03:54:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3716' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.59' , '94.59' , NOW() , NOW() ) 29/11/2024 03:54:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94579' 29/11/2024 03:54:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94579' 29/11/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94579' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '3' , '-3' , '4' , '19.50' , '19.5' , '0' , '5' , '55.59' ) 29/11/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94579' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '2' , '-2' , '4' , '19.50' , '19.5' , '0' , '' , '39.00' ) 29/11/2024 04:02:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 04:02:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3717' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 29/11/2024 04:02:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94580' 29/11/2024 04:02:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94580' 29/11/2024 04:02:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94580' , '23169' , 'DILEXIT NOS ' , '25' , '-25' , '4' , '2.20' , '2.2' , '0' , '5' , '52.25' ) 29/11/2024 04:05:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '94402' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-21') 29/11/2024 04:05:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '247', document_date = '2024-11-21', document_letter = '', id_customer = '727', id_supplier = '', id_address = '4679429', address1 = 'VIA SAN GIOVANNI BATTISTA, 2 84082 BRACIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '608.43', price_tax_excluded = '608.43', date_upd = NOW() WHERE id_document = '94402' 29/11/2024 04:05:09 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 = '94402' 29/11/2024 04:05:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94402' 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '35' , '-35' , '4' , '3.8000' , '3.8' , '0' , '15' , '113.05' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '41' , '-41' , '4' , '3.8000' , '3.8' , '0' , '15' , '132.43' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '50' , '-50' , '4' , '3.8000' , '3.8' , '0' , '15' , '161.50' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '53' , '-53' , '4' , '3.0000' , '3' , '0' , '15' , '135.15' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 29/11/2024 04:05:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '17' , '17' , '0' , '0' , '17.00' ) 29/11/2024 04:23:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 04:23: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' , '3718' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.55' , '43.24' , NOW() , NOW() ) 29/11/2024 04:23: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 = '94581' 29/11/2024 04:23:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94581' 29/11/2024 04:23: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 ( '94581' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 29/11/2024 04:23: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 ( '94581' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 29/11/2024 04:23: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 ( '94581' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 29/11/2024 04:23: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 ( '94581' , '23249' , 'SPERANZA - G. CUCCI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 29/11/2024 04:32:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 04:32: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' , '3719' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.60' , '29.40' , NOW() , NOW() ) 29/11/2024 04:32: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 = '94582' 29/11/2024 04:32:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94582' 29/11/2024 04:32: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 ( '94582' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 29/11/2024 04:32: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 ( '94582' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 29/11/2024 05:20:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 05:20:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3720' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 29/11/2024 05:20: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 = '94583' 29/11/2024 05:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94583' 29/11/2024 05:20: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 ( '94583' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 29/11/2024 06:06:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 06:06:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3721' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 29/11/2024 06: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 = '94584' 29/11/2024 06:06:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94584' 29/11/2024 06:06:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94584' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 29/11/2024 06:08:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 06:08:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3722' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 29/11/2024 06:08: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 = '94585' 29/11/2024 06:08:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94585' 29/11/2024 06:08: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 ( '94585' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 29/11/2024 06:23:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '94036' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-04') 29/11/2024 06:23:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '206', document_date = '2024-11-04', document_letter = '', id_customer = '1746', id_supplier = '', id_address = '4670977', address1 = 'VIA S. SILVIANO 04019 TERRACINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '90.10', price_tax_excluded = '90.10', date_upd = NOW() WHERE id_document = '94036' 29/11/2024 06:23: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 = '94036' 29/11/2024 06:23:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94036' 29/11/2024 06:23: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 ( '94036' , '8408' , 'PRENDETE E MANGIATE' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '15' , '30.60' ) 29/11/2024 06:23: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 ( '94036' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 29/11/2024 06:23: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 ( '94036' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 29/11/2024 06:23: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 ( '94036' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '15' , '18.70' ) 29/11/2024 06:23: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 ( '94036' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '0.68' , '0.68' , '0' , '0' , '6.80' ) 29/11/2024 06:25:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '214' AND id_document != '94110' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-07') 29/11/2024 06:25:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '214', document_date = '2024-11-07', document_letter = '', 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 = '1', id_causal = '0', price_tax_included = '397.15', price_tax_excluded = '397.15', date_upd = NOW() WHERE id_document = '94110' 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94110' 29/11/2024 06:25:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94110' 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '50' , '-50' , '4' , '2.8000' , '2.8' , '0' , '15' , '119.00' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '-5' , '4' , '3.4000' , '3.4' , '0' , '15' , '14.45' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.8000' , '3.8' , '0' , '15' , '96.90' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '29' , '-29' , '4' , '3.8000' , '3.8' , '0' , '15' , '93.67' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 29/11/2024 06:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94110' , '15020' , 'PREGARE OGNI GIORNO' , '7' , '-7' , '4' , '1.00' , '1' , '0' , '0' , '7.00' ) 29/11/2024 06:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '94121' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-07') 29/11/2024 06:25:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2024-11-07', document_letter = '', id_customer = '260', id_supplier = '', id_address = '4679404', address1 = 'PIAZZA UMBERTO I, 2 03032 ARCE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '293.04', price_tax_excluded = '293.04', date_upd = NOW() WHERE id_document = '94121' 29/11/2024 06:25: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 = '94121' 29/11/2024 06:25:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94121' 29/11/2024 06:25: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 ( '94121' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '28' , '-28' , '4' , '3.4000' , '3.4' , '0' , '15' , '80.92' ) 29/11/2024 06:25: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 ( '94121' , '2679' , 'CONOSCERE GESU\'' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 29/11/2024 06:25: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 ( '94121' , '11192' , 'VENITE CON ME 2 PARTE' , '39' , '-39' , '4' , '2.8000' , '2.8' , '0' , '15' , '92.82' ) 29/11/2024 06:25: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 ( '94121' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '10' , '36.00' ) 29/11/2024 06:26:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '220' AND id_document != '94173' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-11') 29/11/2024 06:26:51 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '220', document_date = '2024-11-11', document_letter = '', id_customer = '4139', id_supplier = '', id_address = '4679417', address1 = 'VIA REGINA ELENA 40 74020 SAN MASSANO DI SAN GIUSEPPE', address2 = '', note = '', price_shipping = '4.10', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '94173' 29/11/2024 06:26: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 = '94173' 29/11/2024 06:26:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94173' 29/11/2024 06:26: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 ( '94173' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 29/11/2024 06:26:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94173' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 29/11/2024 06:34:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '94190' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-11') 29/11/2024 06:34:28 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '223', document_date = '2024-11-11', document_letter = '', id_customer = '949', id_supplier = '', id_address = '4679327', address1 = 'VIA P. PALMIERI 39 10138 TORINO', 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 = '408.74', price_tax_excluded = '408.74', date_upd = NOW() WHERE id_document = '94190' 29/11/2024 06:34: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 = '94190' 29/11/2024 06:34:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94190' 29/11/2024 06:34: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 ( '94190' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '50' , '-50' , '4' , '1.9000' , '1.9' , '0' , '15' , '80.75' ) 29/11/2024 06:34: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 ( '94190' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/11/2024 06:34: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 ( '94190' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 29/11/2024 06:34: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 ( '94190' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 29/11/2024 06:34: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 ( '94190' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '20' , '-20' , '4' , '1.9000' , '1.9' , '0' , '5' , '36.10' ) 29/11/2024 06:34: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 ( '94190' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '15' , '42.50' ) 29/11/2024 06:34: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 ( '94190' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '3' , '-3' , '4' , '11.00' , '11' , '0' , '15' , '28.05' ) 29/11/2024 06:34: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 ( '94190' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 29/11/2024 06:34: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 ( '94190' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '15' , '42.50' ) 29/11/2024 06:34: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 ( '94190' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '2' , '-2' , '4' , '15.00' , '15' , '0' , '15' , '25.50' ) 29/11/2024 06:34: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 ( '94190' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '15' , '13.60' ) 29/11/2024 06:34: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 ( '94190' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '15' , '13.60' ) 29/11/2024 06:34: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 ( '94190' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '13.16' , '13.16' , '0' , '0' , '13.16' ) 29/11/2024 06:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '225' AND id_document != '94204' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-12') 29/11/2024 06:36:34 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '225', document_date = '2024-11-12', document_letter = '', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '254.20', price_tax_excluded = '254.20', date_upd = NOW() WHERE id_document = '94204' 29/11/2024 06:36:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94204' 29/11/2024 06:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94204' 29/11/2024 06:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94204' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '25' , '-25' , '4' , '3.4000' , '3.4' , '0' , '15' , '72.25' ) 29/11/2024 06:36: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 ( '94204' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 29/11/2024 06:36: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 ( '94204' , '4120' , 'FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '10' , '16.20' ) 29/11/2024 06:36: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 ( '94204' , '8408' , 'PRENDETE E MANGIATE' , '33' , '-33' , '4' , '3.0000' , '3' , '0' , '15' , '84.15' ) 29/11/2024 06:36: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 ( '94204' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 29/11/2024 06:36: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 ( '94204' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '28' , '-28' , '4' , '3.00' , '3' , '0' , '15' , '71.40' ) 29/11/2024 06:37:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '94266' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-14') 29/11/2024 06:37:27 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '229', document_date = '2024-11-14', document_letter = '', id_customer = '541', id_supplier = '', id_address = '4671522', address1 = 'VIA GALLIANO 84126 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '125.50', price_tax_excluded = '125.50', date_upd = NOW() WHERE id_document = '94266' 29/11/2024 06:37:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94266' 29/11/2024 06:37:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '94266' 29/11/2024 06:37:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94266' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '50' , '-50' , '4' , '2.8000' , '2.8' , '0' , '15' , '119.00' ) 29/11/2024 06:37:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94266' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '6.5' , '6.5' , '0' , '0' , '6.50' ) 29/11/2024 06:41:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '94327' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 29/11/2024 06:41:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '240', document_date = '2024-11-18', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679378', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = 'attenzione cambiare', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '111.44', price_tax_excluded = '111.44', date_upd = NOW() WHERE id_document = '94327' 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94327' 29/11/2024 06:41:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94327' 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23043' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '14953' , 'FAMIGLIA DI GESU - NOVENA - P. MANCA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '21659' , 'MARIA RITRATTO DI UNA DONNA ' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23156' , 'ACCOGLIAMO GESU' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.75' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23051' , 'PREGHIERE A MARIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23200' , 'VANGELO AL CONTRARIO ANNO C- S. RESCA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '18740' , 'VENITE E PRONTO - ANNO C - A. VITALI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.95' , '0.95' , '0' , '0' , '0.95' ) 29/11/2024 06:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94327' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '9.5' , '9.5' , '0' , '0' , '19.00' ) 29/11/2024 06:43:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '243' AND id_document != '94366' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-19') 29/11/2024 06:43:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '243', document_date = '2024-11-19', document_letter = '', id_customer = '4143', id_supplier = '', id_address = '4679432', address1 = 'VIA G. MEDICI 411A 98076 SANT\\\'AGATA DI MILITELLO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '146.30', price_tax_excluded = '146.30', date_upd = NOW() WHERE id_document = '94366' 29/11/2024 06:43: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 = '94366' 29/11/2024 06:43:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94366' 29/11/2024 06:43: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 ( '94366' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 29/11/2024 06:43: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 ( '94366' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '5' , '57.00' ) 29/11/2024 06:43: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 ( '94366' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 29/11/2024 06:43: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 ( '94366' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '23' , '-23' , '4' , '3.00' , '3' , '0' , '5' , '65.55' ) 29/11/2024 06:44:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '94386' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 29/11/2024 06:44:00 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '245', document_date = '2024-11-20', document_letter = '', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', 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 = '80.70', price_tax_excluded = '80.70', date_upd = NOW() WHERE id_document = '94386' 29/11/2024 06:44:00 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 = '94386' 29/11/2024 06:44:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94386' 29/11/2024 06:44:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94386' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '0' , '5.00' ) 29/11/2024 06:44:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94386' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 29/11/2024 06:44:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94386' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.8000' , '3.8' , '0' , '0' , '19.00' ) 29/11/2024 06:44:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94386' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '0' , '30.40' ) 29/11/2024 06:44:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94386' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '0' , '22.80' ) 29/11/2024 06:45:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '253' AND id_document != '94449' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 29/11/2024 06:45:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '253', document_date = '2024-11-22', document_letter = '', id_customer = '1632', id_supplier = '', id_address = '4679142', address1 = 'P.ZZA PLEBISCITO, 11 84030 SANZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '75.05', price_tax_excluded = '75.05', date_upd = NOW() WHERE id_document = '94449' 29/11/2024 06:45: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 = '94449' 29/11/2024 06:45:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94449' 29/11/2024 06:45: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 ( '94449' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 29/11/2024 06:45: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 ( '94449' , '8408' , 'PRENDETE E MANGIATE' , '11' , '-11' , '4' , '3.0000' , '3' , '0' , '5' , '31.35' ) 29/11/2024 06:45: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 ( '94449' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 29/11/2024 06:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '94470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 29/11/2024 06:48:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3628', document_date = '2024-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '108.00', price_tax_excluded = '101.64', date_upd = NOW() WHERE id_document = '94470' 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94470' 29/11/2024 06:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94470' 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '22507' , 'SPES NON CONFUNDIT' , '9' , '-9' , '4' , '2.0000' , '2' , '0' , '5' , '17.10' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 29/11/2024 06:48:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/11/2024 06:49:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3172' AND id_document != '93813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 29/11/2024 06:49:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3172', document_date = '2024-10-24', 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 = '595.50', price_tax_excluded = '513.86', date_upd = NOW() WHERE id_document = '93813' 29/11/2024 06:49: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 = '93813' 29/11/2024 06:49:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93813' 29/11/2024 06:49: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 ( '93813' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 29/11/2024 06:49: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 ( '93813' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '21.50' ) 29/11/2024 06:49: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 ( '93813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '140.00' ) 29/11/2024 06:49: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 ( '93813' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 29/11/2024 06:49: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 ( '93813' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 29/11/2024 06:49: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 ( '93813' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '3' , '-3' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '33.00' ) 29/11/2024 06:49: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 ( '93813' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 29/11/2024 07:39:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 07:39:52 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' , '3723' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 29/11/2024 07:39:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94586' 29/11/2024 07:39:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94586' 29/11/2024 07:39:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94586' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/11/2024 07:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 07:40:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3724' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 29/11/2024 07:40:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94587' 29/11/2024 07:40:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94587' 29/11/2024 07:40:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94587' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 29/11/2024 07:40:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 07:40:59 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' , '3725' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 29/11/2024 07:40:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94588' 29/11/2024 07:40:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94588' 29/11/2024 07:40:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94588' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/11/2024 07:44:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 29/11/2024 07:44:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3726' , '2024-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.31' , NOW() , NOW() ) 29/11/2024 07:44:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94589' 29/11/2024 07:44:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '94589' 29/11/2024 07:44: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 ( '94589' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 29/11/2024 07:44: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 ( '94589' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' )