SELECT `group`.* FROM product_group AS `group` WHERE `group`.shop_id=6 AND `group`.id=407 AND `group`.is_active=1