title: Oracle select with subquery
body: <p>Could you please help me with next oracle sql query. </p>
  
  <pre><code>SELECT "NEWS"."NEWSID" as ID,
         "NEWS"."SLUG",
         "NEWS_TRANSLATION".*, 
         (SELECT FILENAME FROM NEWS_MEDIA WHERE NEWSID = ID AND rownum &lt;= 1 ORDER BY POSITION ASC) as FILENAME
  FROM "NEWS" 
  INNER JOIN "NEWS_TRANSLATION" ON NEWS.NEWSID = NEWS_TRANSLATION.NEWSID 
  WHERE (NEWS.PUBLISH = 1) AND (NEWS_TRANSLATION.LANG = :lang) 
  ORDER BY "NEWS"."NEWSID" DESC;
  </code></pre>
  
  <p>When I execute this query I have error</p>
  
  <pre><code>ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"
  *Cause:    
  *Action:
  Error at Line: 4 Column: 74
  </code></pre>