Search
  GENERAL CONTACTS
 
Upcoming  Events
Sponsor Sector    Event
Type   Date Location
Fitch Ratings Structured Finance
ABS Vegas 2016  Third Party Sun, Feb 28, 16 USA, Las Vegas
Fitch Solutions Fitch Solutions
ABS Vegas 2016  Third Party Sun, Feb 28, 16 UK, Las Vegas
SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( SubSector LIKE '%501%' OR SubSector LIKE '%502%' OR SubSector LIKE '%503%' OR SubSector LIKE '%504%' OR SubSector LIKE '%505%' OR SubSector LIKE '%506%' OR SubSector LIKE '%507%' OR SubSector LIKE '%508%' OR SubSector LIKE '%509%' OR SubSector LIKE '%101%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( SubSector LIKE '%510%' OR SubSector LIKE '%511%' OR SubSector LIKE '%512%' OR SubSector LIKE '%513%' OR SubSector LIKE '%516%' OR SubSector LIKE '%517%' OR SubSector LIKE '%519%' OR SubSector LIKE '%520%' OR SubSector LIKE '%521%' OR SubSector LIKE '%522%' OR SubSector LIKE '%102%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( SubSector LIKE '%548%' OR SubSector LIKE '%110%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( Subsector LIKE '%111%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( SubSector LIKE '%523%' OR SubSector LIKE '%524%' OR SubSector LIKE '%525%' OR SubSector LIKE '%526%' OR SubSector LIKE '%527%' OR SubSector LIKE '%528%' OR SubSector LIKE '%529%' OR SubSector LIKE '%530%' OR SubSector LIKE '%531%' OR SubSector LIKE '%532%' OR SubSector LIKE '%549%' OR SubSector LIKE '%103%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( Subsector LIKE '%104%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( Subsector LIKE '%105%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( Subsector LIKE '%106%' )

SELECT COUNT(ID) FROM Pages WHERE active=1 AND InviteOnly = 0 AND Category<>1 AND aWhen >='11/9/2015' AND ( Subsector LIKE '%112%' )