My Tribes
- user warning: Unknown column 'node_data_field_tribe_state.field_tribe_state_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1, node_data_field_tribe_number.field_tribe_number_value AS node_data_field_tribe_number_field_tribe_number_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node.title AS node_title, node_data_field_tribe_number.field_tribe_city_value AS node_data_field_tribe_number_field_tribe_city_value, node_data_field_tribe_number.field_tribe_state_value AS node_data_field_tribe_number_field_tribe_state_value, (SELECT COUNT(*) FROM drup_og_uid ou INNER JOIN drup_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, (SELECT COUNT(*) FROM drup_node n INNER JOIN drup_og_ancestry oga ON n.nid = oga.nid LEFT JOIN drup_history h ON n.nid=h.nid AND h.uid = 0 WHERE n.status = 1 AND oga.group_nid = og.nid AND h.timestamp IS NULL AND n.created > 1281529986) AS post_count_new, og_uid.uid AS og_uid_uid, og_uid.nid AS og_uid_nid, og.og_selective AS og_og_selective, node_data_field_tribe_state.field_tribe_state_value AS node_data_field_tribe_number_field_tribe_state_value_1 FROM drup_node node LEFT JOIN drup_og_uid og_uid ON node.nid = og_uid.nid LEFT JOIN drup_node node_og_uid ON og_uid.nid = node_og_uid.nid LEFT JOIN drup_og og ON node.nid = og.nid LEFT JOIN drup_content_type_tribe node_data_field_tribe_number ON node.vid = node_data_field_tribe_number.vid INNER JOIN drup_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (node.status <> 0) AND (og.og_directory <> 0) AND (node.type IN ('tribe')) )GROUP BY nid_1 ORDER BY node_data_field_tribe_number_field_tribe_number_value ASC, node_data_field_tribe_number_field_tribe_state_value_1 ASC ) count_alias in /home2/congaloo/public_html/congaloosh/home/modules/views/plugins/views_plugin_pager.inc on line 134.
- user warning: Unknown column 'node_data_field_tribe_state.field_tribe_state_value' in 'field list' query: SELECT DISTINCT(node.nid) AS nid_1, node_data_field_tribe_number.field_tribe_number_value AS node_data_field_tribe_number_field_tribe_number_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node.title AS node_title, node_data_field_tribe_number.field_tribe_city_value AS node_data_field_tribe_number_field_tribe_city_value, node_data_field_tribe_number.field_tribe_state_value AS node_data_field_tribe_number_field_tribe_state_value, (SELECT COUNT(*) FROM drup_og_uid ou INNER JOIN drup_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, (SELECT COUNT(*) FROM drup_node n INNER JOIN drup_og_ancestry oga ON n.nid = oga.nid LEFT JOIN drup_history h ON n.nid=h.nid AND h.uid = 0 WHERE n.status = 1 AND oga.group_nid = og.nid AND h.timestamp IS NULL AND n.created > 1281529986) AS post_count_new, og_uid.uid AS og_uid_uid, og_uid.nid AS og_uid_nid, og.og_selective AS og_og_selective, node_data_field_tribe_state.field_tribe_state_value AS node_data_field_tribe_number_field_tribe_state_value_1 FROM drup_node node LEFT JOIN drup_og_uid og_uid ON node.nid = og_uid.nid LEFT JOIN drup_node node_og_uid ON og_uid.nid = node_og_uid.nid LEFT JOIN drup_og og ON node.nid = og.nid LEFT JOIN drup_content_type_tribe node_data_field_tribe_number ON node.vid = node_data_field_tribe_number.vid INNER JOIN drup_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (node.status <> 0) AND (og.og_directory <> 0) AND (node.type IN ('tribe')) )GROUP BY nid_1 ORDER BY node_data_field_tribe_number_field_tribe_number_value ASC, node_data_field_tribe_number_field_tribe_state_value_1 ASC LIMIT 0, 50 in /home2/congaloo/public_html/congaloosh/home/modules/views/plugins/views_plugin_query_default.inc on line 1093.
Not a member of any groups.

