Error: Subquery returns more than 1 row<br />Error No: 1242<br /> select  distinct r.*,(select `keyword` from `url_alias` where `query` = concat('range_id=',cast(r.range_id as char))) as keyword,m.`name` as manufacturer from    ranges_retso r 		  left join  manufacturer m on m.manufacturer_id = r.parent_id  where   r.active = '1' and r.parent_id = '14' order by m.`name`,r.sort_order,r.range_name ASC LIMIT 0,52;