USE commonswiki_p;

SELECT CONCAT ("Talk:",page_title,"")

#LEFT JOIN page as page ON page_id=cat_id

FROM page AS page

WHERE page_namespace =1

​

#AND page_title LIKE "K%"

#cat_title LIKE '%by_quantity%'

​

AND page_len >0

​

AND page_is_redirect =0

#AND cat_title NOT LIKE "Images_from_the_Geograph_British_Isles_project_needing_categories%"

​

#(cat_title LIKE '%don%require%'

 #      OR cat_title LIKE '%Biathl%')

#OR pl_title LIKE '%Http%'

#ORDER BY rand()

LIMIT 30000;