>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3135440. --> Reported by: [james.williams](https://www.drupal.org/user/592268) Related to !8 >>> <p>As reported in <span class="drupalorg-gitlab-issue-link drupalorg-gitlab-link-wrapper"><a href="https://git.drupalcode.org/project/language_hierarchy/-/work_items/3098399" class="drupalorg-gitlab-link">https://git.drupalcode.org/project/language_hierarchy/-/work_items/3098399</a></span>:</p> <blockquote><p>The query limit in language_hierarchy_query_path_alias_language_fallback_alter() which was introduced at <span class="drupalorg-gitlab-issue-link drupalorg-gitlab-link-wrapper"><a href="https://git.drupalcode.org/project/language_hierarchy/-/work_items/2830291" class="drupalorg-gitlab-link">https://git.drupalcode.org/project/language_hierarchy/-/work_items/2830291</a></span>.</p> <p>We found this while using the layout builder and placing custom blocks with links. All links except one are un-aliased.</p> <p>The AliasManager::getAliasByPath loads all paths (preloadedPathLookups) and fetch their aliases via Drupal\Core\Path\AliasRepository::preloadPathAlias. In this method multiple paths could be added to the query. LH limits this to only one result which leads to have only one link left with an aliased path.</p> <p>Example query from AliasRepository::preloadPathAlias (Limit is added by LH):</p> <pre>SELECT base_table.path AS path, base_table.alias AS alias<br>FROM<br>path_alias base_table<br>LEFT OUTER JOIN language_hierarchy_priority lhp ON base_table.langcode = lhp.langcode<br>WHERE (base_table.status = 1) AND ((base_table.path LIKE '/node/81' ESCAPE '\\') OR (base_table.path LIKE '/node/73' ESCAPE '\\')) AND (base_table.langcode IN ('de', 'und'))<br>ORDER BY lhp.priority DESC, base_table.id ASC<br>LIMIT 1 OFFSET 0</pre><p>What happens if we remove the limit?</p> <p>Hook from language_hierarchy.module:</p> <div class="codeblock"> <pre><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br></span><span style="color: #FF8000">/**<br>&nbsp;* Implements hook_query_TAG_alter().<br>&nbsp;*<br>&nbsp;* Order the fallback candidates to be used when querying path aliases.<br>&nbsp;*<br>&nbsp;* @see \Drupal\path_alias\AliasRepository::addLanguageFallback()<br>&nbsp;*/<br></span><span style="color: #007700">function </span><span style="color: #0000BB">language_hierarchy_query_path_alias_language_fallback_alter</span><span style="color: #007700">(</span><span style="color: #0000BB">AlterableInterface $query</span><span style="color: #007700">) {<br>&nbsp; if (!</span><span style="color: #0000BB">$query </span><span style="color: #007700">instanceof </span><span style="color: #0000BB">SelectInterface</span><span style="color: #007700">) {<br>&nbsp;&nbsp;&nbsp; return;<br>&nbsp; }<br><br>&nbsp; </span><span style="color: #0000BB">$alias </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">leftJoin</span><span style="color: #007700">(</span><span style="color: #DD0000">'language_hierarchy_priority'</span><span style="color: #007700">, </span><span style="color: #DD0000">'lhp'</span><span style="color: #007700">, </span><span style="color: #DD0000">"base_table.langcode = %alias.langcode"</span><span style="color: #007700">);<br>&nbsp; </span><span style="color: #FF8000">// Replace the existing language code ordering.<br>&nbsp; </span><span style="color: #0000BB">$fields </span><span style="color: #007700">= &amp;</span><span style="color: #0000BB">$query</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">getOrderBy</span><span style="color: #007700">();<br>&nbsp; unset(</span><span style="color: #0000BB">$fields</span><span style="color: #007700">[</span><span style="color: #DD0000">'base_table.langcode'</span><span style="color: #007700">]);<br>&nbsp; </span><span style="color: #0000BB">$fields </span><span style="color: #007700">= [</span><span style="color: #0000BB">$alias </span><span style="color: #007700">. </span><span style="color: #DD0000">'.priority' </span><span style="color: #007700">=&gt; </span><span style="color: #DD0000">'DESC'</span><span style="color: #007700">] + </span><span style="color: #0000BB">$fields</span><span style="color: #007700">;<br>&nbsp; </span><span style="color: #FF8000">// Limit the query as only the first result will be used anyway.<br>&nbsp; </span><span style="color: #0000BB">$query</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">range</span><span style="color: #007700">(</span><span style="color: #0000BB">0</span><span style="color: #007700">, </span><span style="color: #0000BB">1</span><span style="color: #007700">);&nbsp;&nbsp; &lt;---------------------------------<br>}<br></span><span style="color: #0000BB">?&gt;</span></span></pre></div> </blockquote> > Related issue: [Issue #3091336](https://www.drupal.org/node/3091336)