Advertisement
Guest User

Untitled

a guest
Oct 26th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. MySQL Query Failed: Column 'candidate_ID' in field list is ambiguous
  2.  
  3. SELECT SQL_CALC_FOUND_ROWS
  4. candidate.candidate_id AS candidateID,
  5. candidate.candidate_id AS exportID,
  6. candidate.is_hot AS isHot,
  7. candidate.date_modified AS dateModifiedSort,
  8. candidate.date_created AS dateCreatedSort,
  9. candidate_ID AS candidateID,
  10. candidate.first_name AS firstName,
  11. candidate.last_name AS lastName,
  12. extra_field0.value AS extra_field_value0,
  13. candidate.city AS city,
  14. candidate.desired_pay AS desiredPay,
  15. candidate.email1 AS email1,
  16. candidate.phone_cell AS phoneCell,
  17. DATE_FORMAT(candidate.date_modified, '%d-%m-%y') AS dateModified,
  18. IF(candidate_joborder_submitted.candidate_joborder_id, 1, 0) AS submitted,
  19. IF(attachment_id, 1, 0) AS **strong text**attachmentPresent
  20. FROM
  21. candidate
  22. LEFT JOIN extra_field AS extra_field0 ON candidate.candidate_id = extra_field0.data_item_id AND extra_field0.field_name = 'Job Title' AND extra_field0.data_item_type = 100
  23. LEFT JOIN attachment
  24. ON candidate.candidate_id = attachment.data_item_id
  25. AND attachment.data_item_type = 100
  26. LEFT JOIN candidate_joborder AS candidate_joborder_submitted
  27. ON candidate_joborder_submitted.candidate_id = candidate.candidate_id
  28. AND candidate_joborder_submitted.status >= 400
  29. AND candidate_joborder_submitted.site_id = 1
  30. AND candidate_joborder_submitted.status != 650 LEFT JOIN saved_list_entry
  31. ON saved_list_entry.data_item_type = 100
  32. AND saved_list_entry.data_item_id = candidate.candidate_id
  33. AND saved_list_entry.site_id = 1
  34. WHERE
  35. candidate.site_id = 1
  36.  
  37.  
  38.  
  39. GROUP BY candidate.candidate_id
  40.  
  41. ORDER BY dateModifiedSort DESC
  42. LIMIT 0, 15
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement