问按销售降序对部件进行排序，并在最后显示没有图像和参数的部件

EN

ORDER BY CASE WHEN COUNT(images.id) > 0 THEN 0 ELSE 1 END,
         CASE WHEN parts.parameters_count > 0 THEN 0 ELSE 1 END,
         parts.sale_rotation_group DESC

SELECT p.*
FROM parts p LEFT OUTER JOIN
     galleries g
     ON g.part_id = p.id LEFT OUTER JOIN
     images i
     ON i.gallery_id = g.id
GROUP BY p.id
ORDER BY COUNT(i.id) OVER (PARTITION BY p.id) DESC,
         p.parameters_count DESC;