Database error: Invalid SQL: SELECT COUNT(*) FROM ((((((((((((users RIGHT JOIN applicants ON applicants.ApplicantID = users.UserID) LEFT JOIN countries ON users.CountryID = countries.CountryID) LEFT JOIN genders ON users.GenderID = genders.GenderID) LEFT JOIN `marital status` ON applicants.MaritalStatusID = `marital status`.MaritalStatusID) LEFT JOIN currencies ON applicants.CurrencyID = currencies.CurrencyID) LEFT JOIN `time rates` ON applicants.SalaryRateID = `time rates`.TimeRateID) LEFT JOIN ages ON users.AgeID = ages.AgeID) LEFT JOIN `applicant's education` ON `applicant's education`.ApplicantID = applicants.ApplicantID) LEFT JOIN `applicant's experience` ON `applicant's experience`.ApplicantID = applicants.ApplicantID) LEFT JOIN `applicant's position desired` ON `applicant's position desired`.ApplicantID = applicants.ApplicantID) LEFT JOIN `education type` ON `applicant's education`.EducationTypeID = `education type`.EducationTypeID) LEFT JOIN `position levels` ON `applicant's position desired`.PositionLevelID = `position levels`.PositionLevelID) LEFT JOIN positions ON `applicant's position desired`.PositionID = positions.PositionID WHERE (applicants.ShowMe = 1) AND (users.CountryID = 0 OR '0' = 0) AND (positions.PositionID = 0 OR '0' = 0) AND (`applicant's education`.Education LIKE '%%' OR `applicant's education`.EducationalCentre LIKE '%%' OR `applicant's experience`.Employer LIKE '%%' OR applicants.Available LIKE '%%' OR applicants.Nationality LIKE '%%' OR users.Address LIKE '%%' OR users.City LIKE '%%' OR applicants.Notes LIKE '%%' OR genders.Gender LIKE '%' OR `marital status`.MaritalStatus LIKE '%%' OR countries.Country LIKE '%%' OR positions.Position LIKE '%%' OR `position levels`.PositionLevel LIKE '%%' OR `education type`.EducationType LIKE '%%' )
MySQL Error: 1104 (The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay)
Session halted.