SELECT judges.photoVisible, judges.firstName, judges.middleName, judges.lastName, judges.court, judges.rankTitle, judges.jurisdiction, isnull(judges.workstatus, 'active') as workstatus, judges.retiredYear, ISNULL(judges.courthouseID, 0) AS courthouseID, judges.phone as DirectPhone, judges.chambersemail, judges.photo, judges.district, judges.catTitle1, judges.catTitle2, judges.catTitle3, judges.catTitle4, judges.catTitle5, judges.catTitle6, judges.catTitle7, judges.catTitle8, judges.catTitle9, judges.catTitle10, judges.catContent1, judges.catContent2, judges.catContent3, judges.catContent4, judges.catContent5, judges.catContent6, judges.catContent7, judges.catContent8, judges.catContent9, judges.catContent10, ISNULL(CtHouse.BuildingName, '') AS BuildingName, ISNULL(CtHouse.Phone, '') AS Phone, ISNULL(CtHouse.Visible, '') AS Visible FROM weJudgeBios judges LEFT JOIN WeCtHouseDirectory CtHouse ON CtHouse.CtHsID = judges.courthouseID WHERE (judges.bioVisible = 1) AND (judges.judgeID =30443) AND ISNULL(workStatus, 'active') <> 'retired' Error accessing Database.
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
Microsoft OLE DB Provider for SQL Server Judge Profile
Mn Judicial Branch Logo
Find Court