Untitled query #48842

SQL

USE trwiki_p;
SELECT CONCAT("#[[",REPLACE(pl_title,"_"," "),"]]")
FROM pagelinks
INNER JOIN page ON pl_from = page_id AND pl_from_namespace = 0 AND pl_namespace = 0
WHERE 
NOT EXISTS
(SELECT p1.page_title FROM page AS p1
WHERE p1.page_title = pl_title
AND pl_namespace = 0
AND p1.page_namespace = 0)
AND (pl_title RLIKE "(B|b)üyükelçi")
GROUP BY pl_title
HAVING COUNT(pl_title)>0
ORDER BY pl_title ASC, page_title ASC;

use trwiki_p;
SELECT
  page_title, el_to
FROM externallinks, page
WHERE el_from = page_id
AND page_namespace = 0
AND el_to LIKE "%osmanli700.gen.tr%"
GROUP BY 2
/*HAVING COUNT(*) >= 49*/
ORDER BY COUNT(*) DESC ;
SQL

Checking query status...
