Listing authenticated users without roles
Sometimes we'd like to list users who have registered with a Drupal site, but haven't been placed into any proper roles yet via subscriptions, purchases, membership approval or whatever.
Try this join query to get started:
SELECT users.uid, name, created, access, login, status FROM {users} LEFT OUTER JOIN {users_roles} ON users.uid = users_roles.uid WHERE users_roles.uid IS NULL AND users.uid != 0
articles
latest comments
leafish_paul
leafish_paul
NicolasH (not verified)
Brad Bowman (beeradb) (not verified)
Dale (not verified)
latest tweets
- Nursing a bruised wrist and listening to some random Russian feller's choons: http://www.last.fm/user/liago0sh — 7 weeks 1 hour ago
- Blimey. Take a break for a weekend and a whole bunch of sites get a facelift. — 8 weeks 6 days ago
- thinks every cloud... last minute tickets get for Radiohead at Manchester (http://hellotxt.com/l/T7N1 Gutted Andy... — 14 weeks 21 hours ago
- Loving Unison (http://tinyurl.com/6muvj) — 14 weeks 3 days ago
- Moving large Drupal e-commerce sites with corrupted DB tables = ++unfun. — 15 weeks 2 days ago
some news of interest
recently bookmarked
recent code
news from friends
Amazee - Drupal powered social collaboration. A redesign case study.
Leadel - A Drupal & Flash intensive site
Student Activities Supports 170 Drupal 6 Sites at Texas A&M
Acquia out of beta
When Cold Water Attacks!
October 2 -- Knight Drupal Initiative review meeting
Announcing the new Getting Involved handbook
Davis Applied Technology College Drupal Case Study
Everyone’s an expert

GIMP 2.6 released, one step closer to taking on Photoshop
GeeXboX uShare UPnP A/V Media Server HomePage
Discounts not applied in e-mail templates?
















Post new comment