This query looks wrong.
SELECT ur.rid in {users_roles} ur WHERE u.uid = ur.uid
because u.uid doesn't have access to the u alias :/

doh

Comments

danielb’s picture

danielb commented
Status: Active » Fixed

error is gone

although now i'm not sure the query works lol

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.