SELECT DISTINCT g2_ChildEntity.g_id, g2_ItemAttributesMap.g_orderWeight
FROM g2_ChildEntity JOIN g2_Item ON g2_ChildEntity.g_id = g2_Item.g_id, g2_AccessSubscriberMap, g2_ItemAttributesMap, g2_AccessMap
WHERE g2_ChildEntity.g_parentId =7 AND g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND (
g2_AccessMap.g_userId =5 OR g2_AccessMap.g_groupId
IN ( 4 )
) AND g2_ItemAttributesMap.g_itemId = g2_ChildEntity.g_id
GROUP BY g2_ChildEntity.g_id
HAVING BIT_OR( g2_AccessMap.g_permission ) &1 =1
ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id
LIMIT 9