visvairāk izmantotās infokastes

SQL

use lvwiki_p;
SELECT
  tl_title,
  COUNT(*)
FROM templatelinks
join page on page_title=tl_title
WHERE tl_namespace = 10 and tl_from_namespace=0# tl_from_namespace=0
and page_id in (select cl_from from categorylinks where cl_to="Hokeja_izlašu_veidnes")
and page_is_redirect=0
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 1000;/*
use lvwiki_p;
SELECT
  tl_title,
  COUNT(*)
FROM templatelinks
join page on page_title=tl_title
WHERE tl_namespace = 10 and tl_from_namespace=0# tl_from_namespace=0
and tl_title like "%nfo%"
and page_is_redirect=0
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 1000;
*/
SQL

Checking query status...
