SQL
AخA
USE cswiki_p;
SELECT disamb.page_title AS d, disamb.page_len AS d_len, surname.page_title AS s, surname.page_len AS s_len
FROM page AS disamb, page AS surname
WHERE disamb.page_title LIKE '%\_(rozcestník\)'
AND disamb.page_namespace = 0
AND disamb.page_is_redirect = 0
AND surname.page_title LIKE '%\_(příjmení\)'
AND surname.page_namespace = 0
AND surname.page_is_redirect = 0
AND SUBSTRING_INDEX(disamb.page_title, '_(', 1) = SUBSTRING_INDEX(surname.page_title, '_(', 1)
ORDER BY d;
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.