Filter: Family
SQL DEBUG: SELECT TOP 200 L.LatestID, L.LatestHeading, L.LatestDesc, L.LatestDatePosted, L.LatestOrgType, L.LatestOrgID, CASE WHEN (L.LatestCityActive='Y' AND CO.COOrgID IS NOT NULL) THEN 1 WHEN (L.LatestCountyActive='Y' AND TOC.TOOrgID IS NOT NULL) THEN 1 WHEN (L.LatestStateActive='Y' AND SO.SOOrgID IS NOT NULL) THEN 2 WHEN (L.LatestRegionActive='Y' AND RO.ROOrgID IS NOT NULL) THEN 3 WHEN (L.LatestNationActive='Y' AND NAO.NOOrgID IS NOT NULL) THEN 4 ELSE 99 END AS Priority, CASE WHEN L.LatestOrgType='E' THEN ENT.EntityName WHEN L.LatestOrgType='C' THEN C.CityDesc WHEN L.LatestOrgType='T' THEN T.CountyDesc WHEN L.LatestOrgType='S' THEN S.StateDesc WHEN L.LatestOrgType='R' THEN R.RegionDesc WHEN L.LatestOrgType='N' THEN NAT.NationDesc WHEN L.LatestOrgType='H' THEN CBA.ClubName WHEN L.LatestOrgType='B' THEN BS.BoardName END AS OrgName FROM Latests L LEFT JOIN Entitys ENT ON L.LatestOrgType='E' AND L.LatestOrgID=ENT.EntityID LEFT JOIN Citys C ON L.LatestOrgType='C' AND L.LatestOrgID=C.CityID LEFT JOIN Countys T ON L.LatestOrgType='T' AND L.LatestOrgID=T.CountyID LEFT JOIN States S ON L.LatestOrgType='S' AND L.LatestOrgID=S.StateID LEFT JOIN Regions R ON L.LatestOrgType='R' AND L.LatestOrgID=R.RegionID LEFT JOIN Nations NAT ON L.LatestOrgType='N' AND L.LatestOrgID=NAT.NationID LEFT JOIN Clubs CBA ON L.LatestOrgType='H' AND L.LatestOrgID=CBA.ClubID LEFT JOIN Boards BS ON L.LatestOrgType='B' AND L.LatestOrgID=BS.BoardID LEFT JOIN CityOrgs CO ON CO.COOrgType=L.LatestOrgType AND CO.COOrgID=L.LatestOrgID AND CO.COCityID=23545 AND CO.COActive='Y' AND CO.CODisplayActive='Y' LEFT JOIN CountyOrgs TOC ON TOC.TOOrgType=L.LatestOrgType AND TOC.TOOrgID=L.LatestOrgID AND TOC.TOCountyID= AND TOC.TOActive='Y' AND TOC.TODisplayActive='Y' LEFT JOIN StateOrgs SO ON SO.SOOrgType=L.LatestOrgType AND SO.SOOrgID=L.LatestOrgID AND SO.SOStateID=44 AND SO.SOActive='Y' AND SO.SODisplayActive='Y' LEFT JOIN RegionOrgs RO ON RO.ROOrgType=L.LatestOrgType AND RO.ROOrgID=L.LatestOrgID AND RO.RORegionID=8 AND RO.ROActive='Y' AND RO.RODisplayActive='Y' LEFT JOIN NationOrgs NAO ON NAO.NOOrgType=L.LatestOrgType AND NAO.NOOrgID=L.LatestOrgID AND NAO.NONationID=3 AND NAO.NOActive='Y' AND NAO.NODisplayActive='Y' WHERE L.LatestActive='Y' AND L.LatestDisplayActive='Y' AND L.LatestDatePosted >= DATEADD(day, -15, GETDATE()) AND ( (L.LatestCityActive='Y' AND CO.COOrgID IS NOT NULL) OR (L.LatestCountyActive='Y' AND TOC.TOOrgID IS NOT NULL) OR (L.LatestStateActive='Y' AND SO.SOOrgID IS NOT NULL) OR (L.LatestRegionActive='Y' AND RO.ROOrgID IS NOT NULL) OR (L.LatestNationActive='Y' AND NAO.NOOrgID IS NOT NULL) ) AND LatestFamilyActive = 'Y' ORDER BY Priority ASC, L.LatestOrgType ASC, L.LatestOrgID ASC, L.LatestID DESC