Jump to content

వాడుకరి:Arjunaraoc/పుస్తకపు పేజీలలో కృషి చేసినవారు

వికీసోర్స్ నుండి

https://quarry.wmflabs.org/query/25873 use '_' for matching space in strings in LIKE expression

use tewikisource_p;
SELECT  
        rev_user_text,
        COUNT(*) as Edits
FROM page
JOIN revision ON revision.rev_page = page.page_id 
WHERE (page_title LIKE 'నా_జీవిత%' OR page_title LIKE 'Naajeevitayatrat021599mbp.pdf%') 
GROUP BY rev_user_text
HAVING COUNT(*) > 0
ORDER BY Edits DESC LIMIT 25;