Untitled
public text v1 · immutableSELECT
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)