You have an error in your SQL syntax near 'halloran' and sc.PersonalityNumber=pi.id' at line 1