Untitled query #52684

SQL

/*USE trwikisource_p;
SELECT CONCAT('* [[',page_title,']]') AS  "Maddeler" #,  COUNT(cl_to) AS "Kategori sayısı"
FROM page 
JOIN categorylinks ON cl_from = page_id 
WHERE cl_to = "Doğrulanmış" 
ORDER BY COUNT(cl_to)
limit 2000;
*/

/*USE trwikisource_p;
SELECT CONCAT('* [[',page_title,']]') AS  "Maddeler" , cl_to
FROM page 
JOIN categorylinks ON cl_from = page_id 
WHERE page_namespace = 250
AND page_content_model = 'proofread-page'
limit 5000;
*/

/*use trwikisource_p;

select *
from page
*/

use trwikisource_p;
select distinct pp_propname
from page_props
order by pp_propname;
SQL

Checking query status...
