Error: Subquery returns more than 1 row
Error No: 1242
SELECT name FROM manufacturer WHERE manufacturer_id = (SELECT SUBSTRING_INDEX( (SELECT query FROM url_alias WHERE keyword = 'sodanca'), '=', -1) AS manufacturer_id )