title: Salesforce: SOQL - Top viewed articles titles
body: <p>Article title is present in KnowledgeArticleVersion table and View Normalized Score is present in KnowledgeArticleViewStat table. The parent of both tables is KnowledgeArticle, but I can't join it to KnowledgeArticleVersion, because there is no relation name present in DB schema. Of cos, I can at first execute such query </p>
  
  <pre><code>Select k.ParentId, k.NormalizedScore From KnowledgeArticleViewStat k order by k.NormalizedScore 
  </code></pre>
  
  <p>Then</p>
  
  <pre><code>SELECT Title, UrlName, KnowledgeArticleId FROM KnowledgeArticleVersion WHERE PublishStatus='Online' AND language ='en_US' and KnowledgeArticleId in (:ids)
  </code></pre>
  
  <p>But my religion forbids me from executing two queries instead of one.</p>
  
  <p>Maybe someone can tell me the right way to perform join in SOQL.</p>