s one has an :inner-join-lateral
</p>
<div class="org-src-container">
<pre class="src src-lisp">(query
      (<span class="org-builtin">:select</span> '*
       <span class="org-builtin">:from</span> (<span class="org-builtin">:as</span> 'tags 't1)
       <span class="org-builtin">:inner-join-lateral</span> (<span class="org-builtin">:as</span>
                            (<span class="org-builtin">:fetch</span>
                             (<span class="org-builtin">:order-by</span>
                       