[ILUGD][MYSQL] MySql query help

Hi,
I have a problem running a sql query. Actually i have five tables and i
have to get the result in one row and have posted this question on
stackoverflow:

http://stackoverflow.com/questions/18016734/my-sql-group-concat-returns-duplicate-rows

I have created a fiddle to demonstrate my question here:
http://sqlfiddle.com/#!2/b96eb/1

I know i am facing this problem because joins calculate product of tables
and so the group_concat. I think creating views can solve this problem but
i don't know how. If someone can please help me..
Thanks
-- 
Regards
RAKESH KUMAR
http://raakeshkumar.wordpress.com