Jel imaš više cena po proizvodu?
Ako ne, možeš ovako, joinom:
Kôd:
SELECT p.* FROM proizvodi p
LEFT JOIN cene c ON p.id = c.proizvod_id
ORDER BY c.id IS NULL
A ako da, probaj
Kôd:
SELECT *,
(SELECT COUNT(*) FROM cene WHERE proizvod_id = p.id) AS cnt
FROM proizvodi p
ORDER BY cnt DESC;
BTW, nisam probao, nemam mysql.