24/09/2024 08:32:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2148' AND id_document != '92490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 24/09/2024 08:32:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2148', document_date = '2024-07-01', 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 = '123.50', price_tax_excluded = '101.23', date_upd = NOW() WHERE id_document = '92490' 24/09/2024 08:32:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92490' 24/09/2024 08:32:46 am >> DELETE FROM ps_document_detail WHERE id_document = '92490' 24/09/2024 08:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92490' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 24/09/2024 08:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92490' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 24/09/2024 08:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92490' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 24/09/2024 08:32:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92490' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 24/09/2024 09:24:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245884' AND id_product != '14719' AND ean13 != '' 24/09/2024 09:24:51 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861245884', date_upd = NOW() WHERE id_product = '14719' 24/09/2024 09:24:51 am >> UPDATE ps_product_lang SET name = 'TU MI AMI DAVVERO', description = '' WHERE id_product = '14719' 24/09/2024 09:24:51 am >> UPDATE ps_product SET wholesale_price = '4.13', on_sale = '0', price = '6.9' WHERE id_product = '14719' 24/09/2024 09:24:51 am >> UPDATE ps_product_shop SET wholesale_price = '4.13', price = '6.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14719' 24/09/2024 09:24:51 am >> DELETE FROM ps_specific_price WHERE id_product = '14719' 24/09/2024 09:25:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 09:25: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 ( '11' , '2773' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.81' , '24.81' , NOW() , NOW() ) 24/09/2024 09:25: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 = '93259' 24/09/2024 09:25:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93259' 24/09/2024 09:25: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 ( '93259' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/09/2024 09:25: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 ( '93259' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/09/2024 09:25: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 ( '93259' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 24/09/2024 09:25: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 ( '93259' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 24/09/2024 09:25: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 ( '93259' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 24/09/2024 09:25: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 ( '93259' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/09/2024 09:50:06 am >> SELECT document_num FROM ps_document WHERE document_num = '121' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 09:50: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 ( '21' , '121' , '2024-09-24' , '' , '2637' , '0' , '4671050' , 'S. MARIA A VICO 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '38.08' , '38.08' , NOW() , NOW() ) 24/09/2024 09:50: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 = '93260' 24/09/2024 09:50:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93260' 24/09/2024 09:50: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 ( '93260' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 24/09/2024 09:50: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 ( '93260' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 24/09/2024 09:50:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2774' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 09:50:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2774' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.45' , '16.45' , NOW() , NOW() ) 24/09/2024 09:50:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93261' 24/09/2024 09:50:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93261' 24/09/2024 09:50:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93261' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/09/2024 09:50:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93261' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 24/09/2024 09:50:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93261' , '16147' , 'SCOPRIAMO LA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 24/09/2024 09:50:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93261' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 24/09/2024 09:57:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 09:57: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' , '2775' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '213.54' , '187.33' , NOW() , NOW() ) 24/09/2024 09:57: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 = '93262' 24/09/2024 09:57:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93262' 24/09/2024 09:57: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 ( '93262' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 24/09/2024 09:57: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 ( '93262' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '23' , '23' , '0' , '0' , '23.00' ) 24/09/2024 09:57: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 ( '93262' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 24/09/2024 09:57: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 ( '93262' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3' , '2.4590163934426' , '22' , '0' , '72.00' ) 24/09/2024 09:57: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 ( '93262' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 24/09/2024 09:57: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 ( '93262' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 24/09/2024 09:57: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 ( '93262' , '22943' , 'AVVENTO 2024' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/09/2024 09:57: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 ( '93262' , '22944' , 'SUI TUOI PASSI - ADORAZIONE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 24/09/2024 10:07:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 10:07:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2776' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 24/09/2024 10:07: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 = '93263' 24/09/2024 10:07:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93263' 24/09/2024 10:07: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 ( '93263' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 24/09/2024 10:07: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 ( '93263' , '5536' , 'LACCIO' , '4' , '-4' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.00' ) 24/09/2024 10:33:12 am >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 10:33:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '122' , '2024-09-24' , '' , '351' , '0' , '4673707' , 'VIA MASSARENTI, 418 40138 BOLOGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '72.89' , '72.89' , NOW() , NOW() ) 24/09/2024 10:33:12 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 = '93264' 24/09/2024 10:33:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93264' 24/09/2024 10:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '4' , '0.67' , '0.67' , '0' , '0' , '33.50' ) 24/09/2024 10:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '4' , '0.48' , '0.48' , '0' , '0' , '24.00' ) 24/09/2024 10:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93264' , '17257' , 'IO TI BATTEZZO ' , '9' , '-9' , '4' , '1.71' , '1.71' , '0' , '0' , '15.39' ) 24/09/2024 10:40:13 am >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7936' 24/09/2024 11:23:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 11:23:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2777' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '198.90' , '188.73' , NOW() , NOW() ) 24/09/2024 11:23:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93265' 24/09/2024 11:23:48 am >> DELETE FROM ps_document_detail WHERE id_document = '93265' 24/09/2024 11:23:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93265' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 24/09/2024 11:23:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93265' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '5' , '85.50' ) 24/09/2024 11:23:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93265' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/09/2024 11:24:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 11:24:08 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' , '2778' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 24/09/2024 11:24:08 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 = '93266' 24/09/2024 11:24:08 am >> DELETE FROM ps_document_detail WHERE id_document = '93266' 24/09/2024 11:24:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93266' , '16760' , 'LAMPADA MARIANA - 097DP2K' , '1' , '-1' , '1' , '80.00' , '65.573770491803' , '22' , '0' , '80.00' ) 24/09/2024 11:31:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 11:31:27 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' , '2779' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '60.23' , NOW() , NOW() ) 24/09/2024 11:31:27 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 = '93267' 24/09/2024 11:31:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93267' 24/09/2024 11:31:27 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 ( '93267' , '22857' , 'CHIESA COMUNITA DELLAMORE - BENEDETTO XVI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 24/09/2024 11:31:27 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 ( '93267' , '22506' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 24/09/2024 11:31:27 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 ( '93267' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '14.85' , '12.172131147541' , '22' , '0' , '29.70' ) 24/09/2024 11:31:27 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 ( '93267' , '9227' , 'S. MICHELE CM 20 - O023 SMK/20' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 24/09/2024 11:35:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 11:35: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' , '2780' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 24/09/2024 11:35: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 = '93268' 24/09/2024 11:35:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93268' 24/09/2024 11:35: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 ( '93268' , '20028' , 'CANDELA ALTARE 26X350' , '3' , '-3' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '7.20' ) 24/09/2024 12:26:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 12:26:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2781' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '65.16' , NOW() , NOW() ) 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93269' 24/09/2024 12:26:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '93269' 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93269' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93269' , '22518' , 'SANTO ROSARIO NELLANNO DELLA PREGHIERA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93269' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '100' , '0.00' ) 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93269' , '22905' , 'DESTINATI ALLA VITA - V. PAGLIA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 24/09/2024 12:26:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93269' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '49.57' , '40.631147540984' , '22' , '0' , '49.57' ) 24/09/2024 12:39:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 12:39: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' , '2782' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.80' , '91.61' , NOW() , NOW() ) 24/09/2024 12:39: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 = '93270' 24/09/2024 12:39:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93270' 24/09/2024 12:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93270' , '15000' , 'TECA ALTA IHS - 825' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 24/09/2024 12:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93270' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 24/09/2024 12:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93270' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 24/09/2024 12:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93270' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 24/09/2024 12:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93270' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '13.80' ) 24/09/2024 12:42:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 12:42: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 ( '11' , '2783' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 24/09/2024 12:42: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 = '93271' 24/09/2024 12:42:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93271' 24/09/2024 12:42: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 ( '93271' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/09/2024 12:44:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 12:44: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' , '2784' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 24/09/2024 12:44: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 = '93272' 24/09/2024 12:44:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93272' 24/09/2024 12:44: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 ( '93272' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '600' , '491.80327868852' , '22' , '0' , '600.00' ) 24/09/2024 12:53:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 12:53:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2785' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.40' , '69.40' , NOW() , NOW() ) 24/09/2024 12:53: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 = '93273' 24/09/2024 12:53:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93273' 24/09/2024 12:53: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 ( '93273' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 24/09/2024 12:53: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 ( '93273' , '22750' , 'DISCEPOLO AMATO E LA SUA TESTIMONIANZA - G. DE VIRGILIO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 24/09/2024 12:53: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 ( '93273' , '22946' , 'SPIRITO SANTO E I SUOI SETTE DONI - G. DAMORE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 24/09/2024 03:20:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '93204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 24/09/2024 03:20:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2735', document_date = '2024-09-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '46.20', price_tax_excluded = '41.23', date_upd = NOW() WHERE id_document = '93204' 24/09/2024 03:20:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93204' 24/09/2024 03:20:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93204' 24/09/2024 03:20:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 24/09/2024 03:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93204' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 24/09/2024 03:21:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2568' AND id_document != '92991' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-04') 24/09/2024 03:21:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2568', document_date = '2024-09-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '165.00', price_tax_excluded = '144.15', date_upd = NOW() WHERE id_document = '92991' 24/09/2024 03:21:58 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 = '92991' 24/09/2024 03:21:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '92991' 24/09/2024 03:21:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92991' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '5' , '49.40' ) 24/09/2024 03:21:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92991' , '22684' , 'ANELLO ARGENTO - 6619' , '1' , '-1' , '1' , '115.6' , '94.754098360656' , '22' , '0' , '115.60' ) 24/09/2024 04:49:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 04:49:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '123' , '2024-09-24' , '' , '2320' , '0' , '4677538' , 'VIA CONVENTO, 12 75011 ACCETTURA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '17.90' , '15.57' , NOW() , NOW() ) 24/09/2024 04:49:24 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 = '93274' 24/09/2024 04:49:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93274' 24/09/2024 04:49:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93274' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/09/2024 04:49:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93274' , '' , 'CONTRASSEGNO' , '1' , '-1' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '2.90' ) 24/09/2024 04:49:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '93274' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 04:49:56 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '123', document_date = '2024-09-24', document_letter = '', id_customer = '2320', id_supplier = '', id_address = '4677538', address1 = 'VIA CONVENTO, 12 75011 ACCETTURA', address2 = '', note = '', price_shipping = '5.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 = '17.90', price_tax_excluded = '17.38', date_upd = NOW() WHERE id_document = '93274' 24/09/2024 04:49:56 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 = '93274' 24/09/2024 04:49:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93274' 24/09/2024 04:49:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93274' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '0' , '10.0000' , '10' , '' , '0' , '10.00' ) 24/09/2024 04:49:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93274' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 24/09/2024 05:59:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 05:59:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2786' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 24/09/2024 05:59: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 = '93275' 24/09/2024 05:59:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93275' 24/09/2024 05:59: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 ( '93275' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 24/09/2024 06:32:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 06:32:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2787' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 24/09/2024 06:32:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93276' 24/09/2024 06:32:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '93276' 24/09/2024 06:32:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93276' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 24/09/2024 06:36:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 06:36:40 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' , '2788' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '296.00' , '242.62' , NOW() , NOW() ) 24/09/2024 06:36:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93277' 24/09/2024 06:36:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93277' 24/09/2024 06:36:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93277' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '150.00' ) 24/09/2024 06:36:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93277' , '19793' , 'STOLA IHS - 220' , '2' , '-2' , '1' , '73.00' , '59.83606557377' , '22' , '0' , '146.00' ) 24/09/2024 07:54:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 24/09/2024 07:54:12 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' , '2789' , '2024-09-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 24/09/2024 07:54:12 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 = '93278' 24/09/2024 07:54:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93278' 24/09/2024 07:54:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93278' , '20697' , 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' )