Untitled query #8112

SQL

use plwiki_p;
#show tables;
show databases;
#CREATE TEMPORARY TABLE A AS
#  SELECT page_title FROM templatelinks JOIN page ON page_id = tl_from
#    WHERE tl_namespace = 10 and tl_title = 'Miasto_infobox' and tl_from_namespace = 0;
#SELECT * FROM A;

#SELECT * FROM
#(SELECT page_title FROM templatelinks JOIN page ON page_id = tl_from 
#  WHERE tl_namespace = 10 and tl_title = 'Miasto_infobox' and tl_from_namespace = 0 ) AS A
#JOIN
#(SELECT page_title FROM pagelinks JOIN page ON page_id = pl_from
#  WHERE pl_from_namespace = 0 AND pl_namespace = 100 ) AS B
#ON A.page_title = B.page_title;
SQL

Checking query status...
