An Error Was Encountered

Error Number: 1064

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 p.IS_NEW DESC, rand()' at line 7

SELECT p.*,c1.NAME as CATALOG_NAME,c2.NAME as CATEGORY_NAME,s.NAME as SUBCATEGORY_NAME,pi.* from product p join catalog c1 on p.CATALOG_ID = c1.CATALOG_ID join category c2 on p.CATEGORY_ID = c2.CATEGORY_ID left join subcategory s on p.SUBCATEGORY_ID = s.SUBCATEGORY_ID join product_image pi on p.IMAGE_ID = pi.PRODUCT_IMAGE_ID where p.CATALOG_ID = order by p.IS_NEW DESC, rand()