TYPO3: read category names of a page

    table = sys_category
    select {
        languageField = sys_language_uid
        pidInList = 222
        selectFields = LOWER(sys_category.title) as aTitle
        join = sys_category_record_mm ON sys_category.uid = sys_category_record_mm.uid_local
        where = sys_category_record_mm.tablenames = 'pages'
        andWhere.data = page:uid
        andWhere.wrap = sys_category_record_mm.uid_foreign IN (|)
    }