问答类
零回答问题列表
sin
sql_sysquery
False
true
true
SELECT TOP @pagesize * FROM PE_QA_Question, PE_QA_Category WHERE PE_QA_Question.CategoryID = PE_QA_Category.CategoryID AND Status = 2
AND PE_QA_Question.Title LIKE '%@Keyword%'
AND NOT EXISTS(SELECT PE_QA_Reply.QuestionID FROM PE_QA_Reply WHERE PE_QA_Reply.QuestionID = PE_QA_Question.QuestionID)
AND (PE_QA_Question.CategoryId=@CategoryID or PE_QA_Category.ParentID=@CategoryID)
AND PE_QA_Question.QuestionID NOT IN(SELECT TOP @startrow PE_QA_Question.QuestionID FROM PE_QA_Question, PE_QA_Category WHERE PE_QA_Question.CategoryID = PE_QA_Category.CategoryID AND Status = 2
AND PE_QA_Question.Title LIKE '%@Keyword%'
AND NOT EXISTS(SELECT PE_QA_Reply.QuestionID FROM PE_QA_Reply WHERE PE_QA_Reply.QuestionID = PE_QA_Question.QuestionID)
AND (PE_QA_Question.CategoryId=@CategoryID or PE_QA_Category.ParentID=@CategoryID)
ORDER BY UpdateTime DESC)
ORDER BY UpdateTime DESC
select count(*) from PE_QA_Question, PE_QA_Category WHERE PE_QA_Question.CategoryID = PE_QA_Category.CategoryID AND Status = 2
AND PE_QA_Question.Title LIKE '%@Keyword%'
AND NOT EXISTS(SELECT * FROM PE_QA_Reply WHERE PE_QA_Reply.QuestionID = PE_QA_Question.QuestionID)
AND (PE_QA_Question.CategoryId=@CategoryID or PE_QA_Category.ParentID=@CategoryID)
]]>
]]>
True
标记之间写分页SQL查询语句
select count(*) from PE_QA_Question, PE_QA_Category WHERE PE_QA_Question.CategoryID = PE_QA_Category.CategoryID AND Status = 2 AND NOT EXISTS(SELECT * FROM PE_QA_Reply WHERE PE_QA_Reply.QuestionID = PE_QA_Question.QuestionID)]]>
TitleLen
int
30
标题长度
CategoryID
supersql
0
问题类型ID
Keyword
supersql
关键字