All pastes #575643 Raw Edit

Untitled

public text v1 · immutable
·published 2007-06-19 03:57 UTC
rendered paste body
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)