SELECT count(*) as total FROM AecoBlack_web WHERE group_type = '2' AND name LIKE '%30_ luxury alabaster led vanity%' AND features LIKE '%authentic%spanish%alabaster%' AND web=1 AND enable=1 ORDER BY announced_date DESC; B4 AecoBlack Lighting | Wholesale Decorative & LED Lighting
