慕姐8265434
在SQL中,WITH语句指定一个临时命名的结果集,称为公共表达式(CTE)。它可以用于递归查询,但在本例中,它指定为子集。如果MySQL允许子选择,我会尝试select t1.* from (
SELECT article.*,
userinfo.*,
category.*
FROM question INNER JOIN
userinfo ON userinfo.user_userid=article.article_ownerid INNER JOIN category ON
article.article_categoryid=category.catid WHERE article.article_isdeleted = 0
) t1ORDER BY t1.article_date DESC Limit 1, 3