问答类
已解决问题列表页
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 = 1 AND PE_QA_Question.Title LIKE '%@Keyword%'
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 = 1 AND PE_QA_Question.Title LIKE '%@Keyword%'
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 = 1 AND PE_QA_Question.Title LIKE '%@Keyword%'
AND (PE_QA_Question.CategoryId=@CategoryID or PE_QA_Category.ParentID=@CategoryID)
]]>
]]>
True
标记之间写分页SQL查询语句
请在上面的标记之间写分页SQL查询语句
select count(id) from database]]>
TitleLen
int
30
标题长度
CategoryID
supersql
0
问题类型ID
Keyword
supersql
关键字