- 14 Feb 2010, 18:26
#961
What i export from a list I get the following error:
MySQL Query Failed: Too many tables; MySQL can only use 61 tables in a join
SELECT SQL_CALC_FOUND_ROWS
candidate.candidate_id AS candidateID,
candidate.candidate_id AS exportID,
candidate.is_hot AS isHot,
candidate.date_modified AS dateModifiedSort,
candidate.date_created AS dateCreatedSort,
IF(candidate_joborder_submitted.candidate_joborder_id, 1, 0) AS submitted,
IF(attachment_id, 1, 0) AS attachmentPresent,
candidate.first_name AS firstName,
candidate.last_name AS lastName,
candidate.email1 AS email1,
candidate.email2 AS email2,
candidate.phone_home AS phoneHome,
candidate.phone_cell AS phoneCell,
candidate.phone_work AS phoneWork,
candidate.address AS address,
candidate.city AS city,
candidate.state AS state,
candidate.zip AS zip,
candidate.notes AS notes,
candidate.web_site AS webSite,
candidate.key_skills AS keySkills,
MySQL Query Failed: Too many tables; MySQL can only use 61 tables in a join
SELECT SQL_CALC_FOUND_ROWS
candidate.candidate_id AS candidateID,
candidate.candidate_id AS exportID,
candidate.is_hot AS isHot,
candidate.date_modified AS dateModifiedSort,
candidate.date_created AS dateCreatedSort,
IF(candidate_joborder_submitted.candidate_joborder_id, 1, 0) AS submitted,
IF(attachment_id, 1, 0) AS attachmentPresent,
candidate.first_name AS firstName,
candidate.last_name AS lastName,
candidate.email1 AS email1,
candidate.email2 AS email2,
candidate.phone_home AS phoneHome,
candidate.phone_cell AS phoneCell,
candidate.phone_work AS phoneWork,
candidate.address AS address,
candidate.city AS city,
candidate.state AS state,
candidate.zip AS zip,
candidate.notes AS notes,
candidate.web_site AS webSite,
candidate.key_skills AS keySkills,