Untitled query #72323

SQL

#use arwiki_p; qui3
        select page_title, group_concat(distinct SUBSTRING_INDEX(SUBSTRING_INDEX(cl_to, '_في_', 2), '_في_', -1); SEPARATOR = '@')
        from page
        inner join categorylinks
        on cl_from = page_id
        where page_namespace = 0
        and page_is_redirect = 0
        and page_id in (select cl_from from categorylinks where cl_from = page_id and cl_to = "بذرة")

        and concat("بذرة_", SUBSTRING_INDEX(SUBSTRING_INDEX(cl_to, '_في_', 2), '_في_', -1)) 
        in (select page_title from page where page_namespace = 10 and page_title like "بذرة%")
        group by page_title
SQL

Checking query status...
