USE trwiki_p;

SELECT count(distinct tl_from) as sayi,  SUM(IF(tl_from_namespace = 0, 1, 0)) AS sayi_madde

, CONCAT("Şablon:",page_title) as ad, CONCAT("Şablon:",rd_title) as yonlendirme

, CONCAT("https://tr.wikipedia.org/wiki/?redirect=no&curid=",page_id,"") AS link

,IF(page_title IS NULL, 0, 1) AS sayfa_var, page_latest

    FROM (SELECT * FROM page WHERE page_namespace = 10 AND page_is_redirect = 1) AS boxes

    JOIN redirect

        ON rd_from = page_id

    LEFT JOIN templatelinks

        ON tl_title = page_title AND tl_namespace = page_namespace

WHERE page_title not LIKE "%doc" and page_title not like "GSR%" and page_title not rlike "PD"

and page_title not rlike "taslak"

-- and page_title rlike "lavuz"

GROUP BY page_title having sayi_madde<1

ORDER BY sayi_madde,sayi,page_latest

LIMIT 1000

​

;