Query failed: SELECT SQL_CALC_FOUND_ROWS
0 AS StartRecord,
10 AS EndRecord,
PhD,
Submitted,
SecondaryComplete,
InterviewInvite,
InterviewAttended,
Waitlisted,
Accepted,
Rejected,
Withdrew,
Experience,
search.ID as ID,
ApplicationCycleID,
SchoolID,
search.Timestamp,
UNIX_TIMESTAMP(search.Timestamp) AS Timestamp_Unix,
UserID,
AvatarUrl, AvatarFileName,
DateAMCASSubmitted,
AMCASDateSortField,
TotalMCAT,
TotalMcatOld,
MCAT_BB,
MCAT_CP,
MCAT_CARS,
MCAT_NPS,
OverallGPA,
ScienceGPA,
UserDisplayName,
UserAgeAtTimeOfApplication,
UserEthnicity,
UserState,
UserURM,
UserUndergraduateCollege,
UserUndergraduateAreaOfStudy
FROM search INNER JOIN `users` ON (users.ID = search.UserID AND users.ID > 0)
WHERE search.ID > 0 AND UserUndergraduateCollege LIKE '%University of Puerto Rico - Mayag��ez Campus%'
GROUP BY UserID
ORDER BY AMCASDateSortField DESC LIMIT 10 OFFSET 0Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
