All users with their user groups and expiry dates (ckbwiki)

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

This retrieves all Central Kurdish Wikipedia (ckbwiki) users with their user groups and expiry dates sorted by expiration date.
This is a good way and by using the search field, you can find all groups of a single user, all users in a group and who is in a group with an expiration date quickly.

SQL

USE ckbwiki_p;

SELECT
  u.user_name AS "User Name",
  ug.ug_group AS "User Group",
  ug.ug_expiry AS "Expiry Date"
FROM
  user_groups ug
JOIN
  user u ON ug.ug_user = u.user_id
ORDER BY
  ug.ug_expiry DESC;

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...