pages using two or three templates - Quarry

Fork of pages using a template by Draco flavus

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

Lista potrzebnych stron autorów

SQL

USE plwikisource_p;
SELECT *

FROM linktarget lt1 INNER JOIN templatelinks tl1 on tl1.tl_target_id = lt1.lt_id
INNER JOIN linktarget lt2 INNER JOIN templatelinks tl2 on tl2.tl_target_id = lt2.lt_id

WHERE lt1.lt_namespace = 10 AND lt1.lt_id = '3730' AND lt2.lt_namespace = 10 AND lt2.lt_id = '12' AND tl1.tl_from=tl2.tl_from

LIMIT 300;
;

​x
 
USE plwikisource_p;SELECT *​FROM linktarget lt1 INNER JOIN templatelinks tl1 on tl1.tl_target_id = lt1.lt_idINNER JOIN linktarget lt2 INNER JOIN templatelinks tl2 on tl2.tl_target_id = lt2.lt_id​WHERE lt1.lt_namespace = 10 AND lt1.lt_id = '3730' AND lt2.lt_namespace = 10 AND lt2.lt_id = '12' AND tl1.tl_from=tl2.tl_from​LIMIT 300;; 

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.

Checking query status...