SELECT q.ID, q.Question as `text`, q.AnswerTypeID as `AnswerType`, q.QuestionCategoryID as `CategoryID`, c.Name as `Category`, fq.IsRequired FROM RFP_Questions q LEFT JOIN RFP_QuestionCategories c on c.ID = q.QuestionCategoryID LEFT JOIN RFP_FormQuestions fq on fq.QuestionID = q.ID WHERE q.ID in (1,2,3,4,5,6,7,8,9,10,11,34) AND q.IsActive = 1 ORDER BY FIELD(q.ID,1,2,3,4,5,6,7,8,9,10,11,34)