How to extract tag information for the given question.
For Example I am running below query and is returning multiple tag information.
select t.id as tagid , qc.id as question_categoryid, t.name , q.id as questionid ,q.name ,q.questiontext , c.id as context_id , ti.id as taginstaceid from mo_tag t, mo_tag_instance ti , mo_context c , mo_question_categories qc, mo_question q where t.id=ti.tagid and ti.contextid=c.id and qc.contextid = c.id and q.category = qc.id and q.id = 5239;
Kindly suggest what and where I am missing in above query.