Untitled query #54617

SQL

use bnwiki_p;

select page_title, (SELECT count(*) FROM templatelinks WHERE tl_title = page_title AND tl_namespace = 10) as transclusions
from page where  page_namespace=10 and page_title like "%তথ্যছক%" and page_is_redirect=0;

SELECT rd_title, rd_namespace, p1.page_title, p1.page_namespace,
	(SELECT count(*) FROM templatelinks WHERE tl_title = rd_title AND tl_namespace = 10) as transclusions
FROM redirect
INNER JOIN page p1 ON rd_from=p1.page_id
join page p2 on rd_title=p2.page_title and p2.page_namespace=10 and p2.page_title like "%তথ্যছক%" and p2.page_is_redirect=0
WHERE
rd_namespace=10;
SQL

Checking query status...
