Unnamed

# Query_time: 11  Lock_time: 0  Rows_sent: 2  Rows_examined: 13
SELECT
	  g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight, BIT_OR(g2_AccessMap.g_permission) as perm
	FROM
	  g2_ChildEntity, g2_Item, g2_AccessSubscriberMap, g2_ItemAttributesMap, g2_AccessMap
	WHERE
	  g2_ChildEntity.g_parentId = 7
	  AND
	  g2_ChildEntity.g_id = g2_Item.g_id
	
	     AND
	     g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id
	     AND
	     g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId
          AND
          (  g2_AccessMap.g_userId = ...
             OR
             g2_AccessMap.g_groupId IN (...)
          )
          AND 
          perm & 1 = 1
	    AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id
          GROUP BY g2_ChildEntity.g_id
          LIMIT 9;