wb group

SELECT t.* FROM (
SELECT
ps.id psid,
 ps.price,
 ab.barcode,
 ps.site_id,
 p.id
FROM product AS p
LEFT JOIN product_site ps ON p.id = ps.product_id
LEFT JOIN additional_barcodes AS ab ON ab.model = "Product" AND ab.pk = p.id AND ab. `source` = "wildberries"
WHERE ps.price >= 20000 AND p.brand_id IN(30) AND ab.barcode IS NOT NULL
ORDER BY CASE WHEN ps.site_id=4 THEN 0 ELSE 1 END DESC) AS t
GROUP BY t.id