Query correction

Job ID: 34273559

Budget: €8 – €30 EUR

I have a shell script which copy data from mysql table and save in text file. I have issue of interpretation of special characters in the data (XML) and the output is not good formated. see file attached. I want someone to correct the query.
Related categories: PHP XML Linux Shell Script MySQL