READ1 - SELECT * from LS_auth_user_LS_party AS a LEFT JOIN wt_users AS b on a.user_id = b.uid WHERE party_id = AND (b.online='Y' OR rds_resource_id>0)