Untitled query #8112

SQL

use plwiki_p;
#show tables;
show databases;
CREATE TEMPORARY TABLE u10276__tmp.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 u10276__tmp.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...
