SELECT count(*) as total FROM AecoBlack_web WHERE group_type = '1' AND name LIKE '%48_ pendant light%' AND features LIKE '%alabaster%effect%resin%' AND web=1 AND enable=1 ORDER BY announced_date DESC; B4 AecoBlack Lighting | Wholesale Decorative & LED Lighting
