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