Fork of رده‌های همسنگ مورد نیاز by Yamaha5
This query is marked as a draft This query has been published by Yamaha5.

SQL

AخA
 
USE fawiki_p;
SELECT /* SLOW_OK */ categorylinks.cl_to , enw.ll_from,enp.cl_to
FROM categorylinks join 
(SELECT DISTINCT *
        FROM langlinks
        WHERE ll_lang = "en"
        ) as enw
        join (SELECT *
        FROM enwiki_p.categorylinks
        ) as enp 
        where categorylinks.cl_from = enw.ll_from and enw.ll_from=enp.cl_from
GROUP BY categorylinks.cl_to limit 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...