SELECT count(*) as total FROM AecoBlack_web WHERE group_type = '1' AND name LIKE '%11_ premium frosted diffuser flush mount%' AND features LIKE '%premium%matte%texture%' AND web=1 AND enable=1 ORDER BY announced_date DESC; B4 Vortex 11-inch Premium Frosted Diffuser Flush Mount Premium matte texture - C10023PC11MB | SydneyTek
