SELECT * 

  FROM wikidatawiki_p.wb_items_per_site

 INNER JOIN metawiki_p.iwlinks ON ips_item_id=TRIM('Q' FROM iwl_title)

 INNER JOIN ruwiki_p.page ON page_title=ips_site_page

 WHERE iwl_from=141462 AND iwl_prefix='d' AND ips_site_id="ruwiki" AND page_is_redirect=1

 LIMIT 10

#TRIM('Q' FROM iwl_title) from metawiki_p.iwlinks where iwl_from=141462 and iwl_prefix='d' LIMIT 10; 

​

#select * from wikidatawiki_p.wb_items_per_site limit 10;