如果要首先从联合表中获取结果，请首先在该联合后选择该表，然后再选择另一个表。就像this:-

(SELECT virtuemart_product_id
 FROM #__virtuemart_product_badges
 WHERE badge = 3)
UNION
SELECT virtuemart_product_id 
FROM #__virtuemart_products 
WHERE product_special = 1

你可以试试这个。它创建一个人工值，指示数据来自哪个表，然后在id值之前按该值排序。通过更改分配给数据集的值和排序顺序，可以更改首先输出的值：

(SELECT virtuemart_product_id, 0 AS dataset
FROM #__virtuemart_products 
WHERE product_special = 1)
UNION
(SELECT virtuemart_product_id, 1 AS dataset
 FROM #__virtuemart_product_badges
 WHERE badge = 3)
ORDER BY dataset DESC, virtuemart_product_id

编辑
因为要求只返回一列( virtuemart_product_id )，则需要将此查询 Package 在子查询中，然后 SELECT virtuemart_product_id 从中：

SELECT virtuemart_product_id
FROM ((SELECT virtuemart_product_id, 0 AS dataset
       FROM #__virtuemart_products 
       WHERE product_special = 1)
      UNION
      (SELECT virtuemart_product_id, 1 AS dataset
       FROM #__virtuemart_product_badges
       WHERE badge = 3)
      ORDER BY dataset DESC, virtuemart_product_id) v

尝试进行一些嵌套查询：

select * from (YOUR ALL QUERY) AS p order by virtuemart_product_id