NORMA vydána dne

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY c.razeni_cz, b.razeni' at line 1
SELECT a.languages_id, a.photos_id FROM product_variant AS a LEFT JOIN new_products_provedeni AS b ON a.photos_id = b.cislo LEFT JOIN languages AS c ON = a.languages_id WHERE a.product_id = ORDER BY c.razeni_cz, b.razeni;