SELECT `language`, `category_alias` FROM `translation_categories_translated` WHERE `category_id` = ( SELECT `id` FROM `categories` WHERE `uri` = "modern" )
Subquery returns more than 1 row