SELECT SQL_CALC_FOUND_ROWS
1 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
WHERE 1 AND UserUndergraduateCollege LIKE '%University of Puerto Rico - Mayag��ez Campus%'
GROUP BY UserID
ORDER BY AMCASDateSortField DESC LIMIT 10 OFFSET 0
