bcmiller

http://pdup.allplayers.com/g/group-86938/node/86938/edit

this took 26 seconds:


/* admin : execute */ SELECT DISTINCT node.nid AS nid, node.title AS node_title, og.og_description AS og_og_description, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(*) FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE ou.nid = og.nid AND u.status > 0 AND ou.is_active >= 1 AND ou.is_admin >= 0 ) AS member_count, node_data_field_nodeorder.field_nodeorder_value AS node_data_field_nodeorder_field_nodeorder_value, node.type AS node_type, node.vid AS node_vid, node_data_field_group.field_group_nid AS node_data_field_group_field_group_nid FROM node node LEFT JOIN og og ON node.nid = og.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_field_nodeorder node_data_field_nodeorder ON node.vid = node_data_field_nodeorder.vid LEFT JOIN content_field_group node_data_field_group ON node.vid = node_data_field_group.vid WHERE (node.status <> 0) AND (node.type IN ('group','association','league','team'

bcmiller

from group_members view, and members by role:


mysql> explain SELECT users.uid AS uid,
    ->    users.name AS users_name,
    ->    users.picture AS users_picture,
    ->    og_rap_og_rap_uid.name AS og_rap_og_rap_uid_name
    ->  FROM users users 
    ->  INNER JOIN og_rap_uid og_rap_uid ON users.uid = og_rap_uid.uid
    ->  INNER JOIN og_rap og_rap_og_rap_uid ON og_rap_uid.rid = og_rap_og_rap_uid.rid