Untitled query #57092

SQL

use bnwiki_p;
Select p.page_title, pl.pl_from, pl.pl_title
from pagelinks pl, page p
where pl.pl_from=p.page_id and pl.pl_title Like "%(%" and pl.pl_title Not Like "%(%)%"
	and p.page_namespace=0
#where pl.pl_from=p.page_id and pl.pl_title Like "%(%)" and pl.pl_title Not Like "%_(%)"#and pl_title Not Like "%)"
#group by pl.pl_title
/*
STRĀDĀ!
use bnwiki_p;
Select p.page_title, pl.pl_from, pl.pl_title
from pagelinks pl, page p
where pl.pl_from=p.page_id and pl.pl_title Like "%(%" and pl.pl_title Not Like "%(%)%"

use bnwiki_p;
Select pl_from, pl_title, count(pl_title)
from pagelinks
where pl_title Like "%(%" and pl_title Not Like "%(%)%" #and pl_title Not Like "%)"
group by pl_title


use bnwiki_p;
Select *
from pagelinks
where pl_title Like "%(%" and pl_title Not Like "%)"
*/
SQL

Checking query status...
