Untitled query #79167

This query is marked as a draft This query has been published by PleaseStand.

SQL

select
  page_namespace,
  page_title,
  group_concat(
    trim(
      leading 'Redirects_'
      from
        cl_to
    )
    order by
      cl_to separator ", "
  )
from
  redirect
  join page on rd_from = page_id
  join categorylinks on rd_from = cl_from
where
  rd_namespace = 0
  and rd_title = 'Human_sexuality'
  and cl_to like 'Redirects_%'
group by
  rd_from
order by
  null;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...