Tl:Izolēts uzlabošana

SQL

USE lvwiki_p;
SELECT *
  #p.page_namespace,
  #p.page_title
FROM page p, pagelinks pl2
LEFT JOIN pagelinks pl ON pl.pl_title = p.page_title AND pl.pl_namespace = p.page_namespace
INNER JOIN page p2 ON p.page_id = p2.page_id
#inner JOIN pagelinks pl2 ON pl2.pl_from = p.page_id
#INNER JOIN categorylinks cl ON p.page_id = cl.cl_from AND cl.cl_to<>"Izolētie_raksti" AND cl.cl_to<>"Nozīmju_atdalīšana"
#WHERE pl.pl_namespace IS NULL and p.page_is_redirect=0 and p.page_namespace=0 and p.page_title="Mioma"
WHERE p.page_is_redirect=0 and p.page_namespace=0 and p.page_title="Mioma" and pl2.pl_from=p2.page_id
#and pl_from
LIMIT 10;
SQL

Checking query status...
