Veidnes ar ambox

SQL

use lvwiki_p;
select concat("Veidne:",page_title)
from page
where page_title like "Convert%"
and page_is_redirect=0 and page_namespace=10


/*use lvwiki_p;
SELECT
  p1.page_namespace,
  p1.page_title
FROM redirect AS rd
JOIN page p1
ON rd.rd_from = p1.page_id
LEFT JOIN page AS p2
ON rd_namespace = p2.page_namespace
AND rd_title = p2.page_title
WHERE rd_namespace >= 0
AND p2.page_namespace IS NULL
ORDER BY p1.page_namespace ASC;


Select *
from redirect
where rd_title like "Futb%" and rd_namespace=10
limit 100;



use lvwiki_p;
Select *
from pagelinks
where pl_from in (Select page_id
from pagelinks
join page on page_title=pl_title
where pl_from=291630 and pl_namespace=10)
limit 10;



Select concat("*[[Veidne:",p.page_title,"]]") as 'Veidne'
from page p
left join templatelinks tl on p.page_title=tl.tl_title
#select concat("*[[Veidne:",tl_title,"]]") as 'Veidne'
#from templatelinks
#join page p on p.page_id=t.tl_from
where p.page_title like "Futb%"
and p.page_namespace=10
and tl.tl_from is NULL
limit 300;*/
SQL

Checking query status...
