loend märksõnad @etwiki

Fork of Bluelinks ja Redlinks sulgudes täpsustussõnaga by Estopedist1

This query is marked as a draft This query has been published by Estopedist1.

SQL

#BLUELINKS, WHICH ARE REDIRECTS
USE etwiki_p;
SELECT page_title
FROM page AS page
WHERE page_title LIKE '%Nimekiri%'
OR page_title LIKE '%nimekiri%'
AND page_is_redirect = 1
LIMIT 500;

#BLUELINKS, WHICH ARE NOT REDIRECTS
USE etwiki_p;
SELECT page_title
FROM page AS page
WHERE page_title LIKE '%Nimekiri%'
OR page_title LIKE '%nimekiri%'
AND page_is_redirect = 0
LIMIT 500;

#REDLINKS
USE etwiki_p;
SELECT pl_title
FROM pagelinks AS pl
WHERE pl_title LIKE '%Nimekiri%'
OR pl_title LIKE '%nimekiri%'
GROUP BY pl_title
LIMIT 500;

SQL

Checking query status...