Skip to content

Instantly share code, notes, and snippets.

@thsigit

thsigit/Drupal 8 List Users MysQL

Last active March 6, 2021 15:56
Show Gist options
  • Save thsigit/b81f29be6484c2fc784a2f99e9bbbd9a to your computer and use it in GitHub Desktop.
Save thsigit/b81f29be6484c2fc784a2f99e9bbbd9a to your computer and use it in GitHub Desktop.
Download ZIP
Drupal 8 List Users MysQL
Raw
Drupal 8 List Users MysQL
SELECT users_field_data.uid,users_field_data.name,users_field_data.mail,from_unixtime(users_field_data.login) AS "lastlogin",user__roles.roles_target_id,users_field_data.status FROM users_field_data LEFT JOIN user__roles ON users_field_data.uid = user__roles.entity_id;
@thsigit
Copy link
Author

thsigit commented Mar 6, 2021 •
edited

source: https://drupal.stackexchange.com/a/280919

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment