SQL
AخA
USE fawiki_p;
SELECT page_title, COUNT(ll_lang)
FROM revision INNER JOIN page ON rev_page = page_id join langlinks on page_id = ll_from
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_user_text = 'Saeidpourbabak'
AND rev_parent_id = 0
AND rev_parent_id = 0
GROUP BY page_title
ORDER BY COUNT(ll_lang) DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.