Miscellany

SELECT
          g2_ChildEntity.g_id , g2_ItemAttributesMap.g_orderWeight
        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 = 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
          LIMIT 9;