Untitled query #69207

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

SQL

SELECT
		page_title, page_id 
                    FROM
                    	page,
                    	templatelinks,
                        linktarget
                    WHERE
                    	page_id=tl_from AND
                    	page_namespace=0 AND
                        tl_target_id=lt_id AND
                        lt_namespace=10 AND
                        lt_title='Naukowiec_infobox' AND
	page_id IN (SELECT DISTINCT
                    	tl_from
                    FROM
                    	templatelinks,
                    	page,
                		linktarget
                    WHERE
                    	page_id=tl_from AND
                    	page_namespace=0 AND
                        tl_target_id=lt_id AND
                        lt_namespace=10 AND
                        lt_title Like '%ikiźródła%')
                    	
LIMIT 50;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...