Untitled query #83597

SQL

        select pl_from_namespace, page_title, group_concat(lt_title SEPARATOR '@') as ff
        from page , categorylinks , pagelinks, linktarget
        where cl_from = page_id
        and pl_from = page_id

        and lt_id = pl_target_id

        and page_namespace = 0
        and page_is_redirect = 0
        and cl_to = "بذرة_اليمن"
        #and pl_from_namespace in (100)   # بوابات فقط
        and lt_title in (select replace(p.page_title,"بذرة_","") from page p where p.page_namespace = 10 and p.page_title like "بذرة_%")
        group by page_title
        limit 10
SQL

Checking query status...
