Error!

MySQL Error: 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 'as heap_id FROM contents JOIN heap_contents on heap_contents.content_id=contents' at line 1
SQL Statement: SELECT contents.* ,heap_contents.id as heap_content_id, as heap_id FROM contents JOIN heap_contents on heap_contents.content_id=contents.id WHERE heap_contents.heap_id= '' ORDER BY heap_contents.priority desc