This query is marked as a draft This query has been published by Zache.

SQL

AخA
 
use fiwiki_p;
select 
    iwl1.iwl_title as iwl1, 
    iwl2.iwl_title as iwl2 
from iwlinks as iwl1 
LEFT JOIN (
  select iwlinks.*  
  from iwlinks,categorylinks 
  where 
    cl_from=iwl_from 
    and cl_to="Luettelot_Helsingin_rakennuksista_ja_rakennelmista"
) as iwl2 
ON iwl1.iwl_title=iwl2.iwl_title 
where iwl1.iwl_from = 1593353;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...