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