- 06 Mar 2016, 08:34
#2243
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Table '. \ Opencart \ JobOrder is labeled' crashed 'and should be repaired
SELECT
candidate.first_name as firstName,
candidate.last_name as lastName,
candidate.candidate_id as candidateID,
company.name as companyName,
company.company_id as companyID,
user.first_name as userFirstName,
user.last_name as userLastName,
IF (company.is_hot = 1, 'jobLinkHot', 'jobLinkCold') as companyClassName,
IF (candidate.is_hot = 1, 'jobLinkHot', 'jobLinkCold') as candidateClassName,
DATE_FORMAT(
candidate_joborder_status_history.date, '%d-%m-%y'
) AS date,
candidate_joborder_status_history.date AS datesort
FROM
candidate_joborder_status_history
LEFT JOIN candidate ON
candidate.candidate_id = candidate_joborder_status_history.candidate_id
LEFT JOIN joborder ON
joborder.joborder_id = candidate_joborder_status_history.joborder_id
LEFT JOIN company ON
joborder.company_id = company.company_id
LEFT JOIN user ON
joborder.recruiter = user.user_id
WHERE
status_to = 800
AND
candidate_joborder_status_history.site_id = 1
ORDER BY
datesort DESC
LIMIT
10
MySQL Query Failed: Table '. \ Opencart \ JobOrder is labeled' crashed 'and should be repaired
SELECT
candidate.first_name as firstName,
candidate.last_name as lastName,
candidate.candidate_id as candidateID,
company.name as companyName,
company.company_id as companyID,
user.first_name as userFirstName,
user.last_name as userLastName,
IF (company.is_hot = 1, 'jobLinkHot', 'jobLinkCold') as companyClassName,
IF (candidate.is_hot = 1, 'jobLinkHot', 'jobLinkCold') as candidateClassName,
DATE_FORMAT(
candidate_joborder_status_history.date, '%d-%m-%y'
) AS date,
candidate_joborder_status_history.date AS datesort
FROM
candidate_joborder_status_history
LEFT JOIN candidate ON
candidate.candidate_id = candidate_joborder_status_history.candidate_id
LEFT JOIN joborder ON
joborder.joborder_id = candidate_joborder_status_history.joborder_id
LEFT JOIN company ON
joborder.company_id = company.company_id
LEFT JOIN user ON
joborder.recruiter = user.user_id
WHERE
status_to = 800
AND
candidate_joborder_status_history.site_id = 1
ORDER BY
datesort DESC
LIMIT
10