quick checks - Quarry

This query is marked as a draft This query has been published by CMyrick-WMF.

SQL

WITH base  as(
  	SELECT DISTINCT
		actor_id,
  		actor_user
	FROM actor
	WHERE actor_id = 1
)

SELECT DISTINCT
 base.actor_id,
 base.actor_user,
 user.user_id,
 user.user_name
FROM user
 RIGHT JOIN base on base.actor_user = user.user_id

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