writing mysql in tpl file

I am trying to get a data from particular table. I wrote the mysql query code directly in tpl file and got the result.
But it is okay to write mysql directly in tpl file.

it is ok to do that, just a little messy..