subquery-factoring

how do you Use the "With" Clause in MySQL

I am converting all my MSSQL queries to mysql and my queries that has "with" in them are all failing with t1 as ( 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.ar...