Anonymous

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;