title: reuse temporary table in mysql
body: <p>I have a query like this:</p>
  
  <pre><code>(SELECT id,content,userid FROM article WHERE type='A' LIMIT 10)
  UNION ALL
  (SELECT c.id,c.content,c.userid FROM comment AS c
  JOIN (SELECT id,content,userid FROM article WHERE type='A' LIMIT 10) AS a
  ON c.articleid = a.id)
  </code></pre>
  
  <p>How can I reuse instead of requerying this temporary table <code>SELECT id,content,userid FROM article WHERE type='A' LIMIT 10</code>?</p>