jason,

you will need to join in the user table and adjust your grouping 
accordingly.  somthing like:

     count = db.users_tags.id.count()

     query = db((db.users_tags.user != auth.user.id)&           #\/-- isn't 
that the join?

                (db.users_tags.tag.belongs(db(db.users_tags.user==
auth.user.id)._select(db.users_tags.tag))) &

                (db.auth_user.id==db.user_tags.user))

     rows = query.select(db.users_tags.user, db.auth_user.first_name, 
db.auth_user.last_name

                         count,

                        
 groupby=db.users_tags.user|db.auth_user.first_name|db.auth_user.last_name,

                         orderby=count)

     for row in rows:

         print row.as_dict()

Reply via email to