How to optimize this crazy SQL Query (Specific)
What do you want to achieve?  How are the two tables linked? 

Perhaps a LEFT JOIN + USING(RaagID) or something like that is better?

Also, it might help to know what Shabad and Raag mean in English.

Update from comments:
shabad is the main table and has references to the other two, so I believe the answer is

SELECT *
FROM shabad s
LEFT JOIN raag r using (raagid)
LEFT JOIN writer w using (writerid)


then filter that with where-clause and your criteria