SELECT * FROM Product WHERE product_group_id NOT IN ( SELECT product_group_id FROM Product WHERE is_shown = 0 )