将一个查询的结果传递给另一个查询，然后合并这两个查询的结果

I have following query:

我有以下查询:

SELECT name as String
     , COUNT(*) Total
     , SUM(product = 1) Product
           FROM String
                WHERE language = 1
           GROUP 
                BY name
           ORDER
                BY total desc
           LIMIT 10
SELECT name