SELECT b.* FROM `brands` AS `b` WHERE b.`url_name` = '' GROUP BY b.`brand_id`