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