first question: is there a way to count how many flag lists that a user have?
second question: is there a way to count how many nodes that a flag lists have?

can someone help me? i am appreciative of this.

Comments

rosko’s picture

rosko commented

I think this is right, or at least along the right lines...

count how many flag lists that a user has

SELECT count( * )
FROM `flag_lists_flags`
WHERE uid =1

how many nodes that a flag lists has

SELECT count( * )
FROM `flag_lists_counts`
WHERE fid =1
sl27257’s picture

sl27257
Location Stockholm
commented
Issue summary: View changes
Status: Active » Closed (outdated)