title: Finding Interlanguage Related Articles from Wiki Dump
body: <p>Finding the full list of Wikipedia's English articles with their related articles in languages other than English like French and Spanish is a problem that their is no answer about that. You can find some similar questions but most of them are related to previous structure of Wikipedia and the others have left without correct answer. </p>
  
  <p>We can download the dump file of Wikipedia's English and Spanish articles from here:
  <a href="https://dumps.wikimedia.org/enwiki/20180201/" rel="nofollow noreferrer">English Wiki</a> and <a href="https://dumps.wikimedia.org/eswiki/20180201/" rel="nofollow noreferrer">Spanish Wiki</a>. </p>
  
  <p>There is some data named langlinks aka sitelinks in enwiki and also eswiki with the aim to find interlanguage related articles. But it's not clear how to use them to find interlingual related articles(the Spanish article related to each English one). The langlinks schemas are like:</p>
  
  <pre><code>CREATE TABLE `langlinks` (
    `ll_from` int(10) unsigned NOT NULL DEFAULT '0',
    `ll_lang` varbinary(20) NOT NULL DEFAULT '',
    `ll_title` varbinary(255) NOT NULL DEFAULT '',
     UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
     KEY `ll_lang` (`ll_lang`,`ll_title`)
  ) ENGINE=InnoDB DEFAULT CHARSET=binary;
  </code></pre>
  
  <p>Are the record with an special 'll_from' field in English related to record with similar 'll_from' field in Spanish? if yes, Why I can't find records with similar ll_from field in these two langlinks files?</p>
  
  <p>Again, How to use these langlinks files to find interlanguage related articles? I dont want to use other tools like the Wikidata toolkit.  </p>