Unknown column 'CB.firstname' in 'field list' SQL=SELECT classement.id, classement.contact_id, classement.user_id, CASE WHEN (Coalesce(CB.name, "")="") THEN (CASE WHEN (Coalesce(contact.name, "")="") THEN users.name ELSE contact.name END) ELSE (CASE WHEN (Coalesce(CB.firstname, "")="") THEN CB_P.lastname ELSE CONCAT_WS(' ', CB_P.firstname, CB_P.lastname) END)END as nom, CASE WHEN (Coalesce(CB.avatar, "")="") THEN contact.image ELSE (CASE WHEN CB_P.avatarapproved=1 THEN CB_P.avatar ELSE contact.image END) END as photo, CASE WHEN (Coalesce(contact.email_to, "")="") THEN (users.email) ELSE contact.email_to END As email, CASE WHEN (Coalesce(CB_P.avatar, "")="") THEN "contact" ELSE (CASE WHEN CB_P.avatarapproved=1 THEN "third" ELSE "contact" END) END As img_src, classement.published, classement.enroldate,
classement.rang, classement.dossard, classement.temps, classement.section_id, classement.category_id, classement.rang_categorie, classement.commentaire, classement.points, classement.url,
classement.pending, classement.reminder_date, course.id as event_id, course.date, course.closingdate, course.enrolment_enabled, course.titre, contact.alias FROM jos_course_classement AS classement
INNER JOIN jos_course AS course ON classement.event_id = course.id
LEFT JOIN jos_users AS users ON users.id = classement.user_id
LEFT JOIN jos_contact_details AS contact ON classement.contact_id = contact.id LEFT JOIN jos_core_acl_aro AS CB ON CB.value = classement.user_id LEFT JOIN jos_comprofiler AS CB_P ON CB_P.id = CB.value WHERE (course.access <= 0) AND (course.id = 35)ORDER BY classement.enroldate, nom ASC
SQL:
SELECT classement.id, classement.contact_id, classement.user_id, CASE WHEN (Coalesce(CB.name, "")="") THEN (CASE WHEN (Coalesce(contact.name, "")="") THEN users.name ELSE contact.name END) ELSE (CASE WHEN (Coalesce(CB.firstname, "")="") THEN CB_P.lastname ELSE CONCAT_WS(' ', CB_P.firstname, CB_P.lastname) END)END as nom, CASE WHEN (Coalesce(CB.avatar, "")="") THEN contact.image ELSE (CASE WHEN CB_P.avatarapproved=1 THEN CB_P.avatar ELSE contact.image END) END as photo, CASE WHEN (Coalesce(contact.email_to, "")="") THEN (users.email) ELSE contact.email_to END As email, CASE WHEN (Coalesce(CB_P.avatar, "")="") THEN "contact" ELSE (CASE WHEN CB_P.avatarapproved=1 THEN "third" ELSE "contact" END) END As img_src, classement.published, classement.enroldate,
classement.rang, classement.dossard, classement.temps, classement.section_id, classement.category_id, classement.rang_categorie, classement.commentaire, classement.points, classement.url,
classement.pending, classement.reminder_date, course.id as event_id, course.date, course.closingdate, course.enrolment_enabled, course.titre, contact.alias FROM jos_course_classement AS classement
INNER JOIN jos_course AS course ON classement.event_id = course.id
LEFT JOIN jos_users AS users ON users.id = classement.user_id
LEFT JOIN jos_contact_details AS contact ON classement.contact_id = contact.id LEFT JOIN jos_core_acl_aro AS CB ON CB.value = classement.user_id LEFT JOIN jos_comprofiler AS CB_P ON CB_P.id = CB.value WHERE (course.access <= 0) AND (course.id = 35)ORDER BY classement.enroldate, nom ASC
Unknown column 'CB.firstname' in 'field list' SQL=SELECT classement.id, classement.contact_id, classement.user_id, CASE WHEN (Coalesce(CB.name, "")="") THEN (CASE WHEN (Coalesce(contact.name, "")="") THEN users.name ELSE contact.name END) ELSE (CASE WHEN (Coalesce(CB.firstname, "")="") THEN CB_P.lastname ELSE CONCAT_WS(' ', CB_P.firstname, CB_P.lastname) END)END as nom, CASE WHEN (Coalesce(CB.avatar, "")="") THEN contact.image ELSE (CASE WHEN CB_P.avatarapproved=1 THEN CB_P.avatar ELSE contact.image END) END as photo, CASE WHEN (Coalesce(contact.email_to, "")="") THEN (users.email) ELSE contact.email_to END As email, CASE WHEN (Coalesce(CB_P.avatar, "")="") THEN "contact" ELSE (CASE WHEN CB_P.avatarapproved=1 THEN "third" ELSE "contact" END) END As img_src, classement.published, classement.enroldate,
classement.rang, classement.dossard, classement.temps, classement.section_id, classement.category_id, classement.rang_categorie, classement.commentaire, classement.points, classement.url,
classement.pending, classement.reminder_date, course.id as event_id, course.date, course.closingdate, course.enrolment_enabled, course.titre, contact.alias FROM jos_course_classement AS classement
INNER JOIN jos_course AS course ON classement.event_id = course.id
LEFT JOIN jos_users AS users ON users.id = classement.user_id
LEFT JOIN jos_contact_details AS contact ON classement.contact_id = contact.id LEFT JOIN jos_core_acl_aro AS CB ON CB.value = classement.user_id LEFT JOIN jos_comprofiler AS CB_P ON CB_P.id = CB.value WHERE (course.access <= 0) AND (course.id = 35)ORDER BY classement.enroldate, nom ASC
SQL:
SELECT classement.id, classement.contact_id, classement.user_id, CASE WHEN (Coalesce(CB.name, "")="") THEN (CASE WHEN (Coalesce(contact.name, "")="") THEN users.name ELSE contact.name END) ELSE (CASE WHEN (Coalesce(CB.firstname, "")="") THEN CB_P.lastname ELSE CONCAT_WS(' ', CB_P.firstname, CB_P.lastname) END)END as nom, CASE WHEN (Coalesce(CB.avatar, "")="") THEN contact.image ELSE (CASE WHEN CB_P.avatarapproved=1 THEN CB_P.avatar ELSE contact.image END) END as photo, CASE WHEN (Coalesce(contact.email_to, "")="") THEN (users.email) ELSE contact.email_to END As email, CASE WHEN (Coalesce(CB_P.avatar, "")="") THEN "contact" ELSE (CASE WHEN CB_P.avatarapproved=1 THEN "third" ELSE "contact" END) END As img_src, classement.published, classement.enroldate,
classement.rang, classement.dossard, classement.temps, classement.section_id, classement.category_id, classement.rang_categorie, classement.commentaire, classement.points, classement.url,
classement.pending, classement.reminder_date, course.id as event_id, course.date, course.closingdate, course.enrolment_enabled, course.titre, contact.alias FROM jos_course_classement AS classement
INNER JOIN jos_course AS course ON classement.event_id = course.id
LEFT JOIN jos_users AS users ON users.id = classement.user_id
LEFT JOIN jos_contact_details AS contact ON classement.contact_id = contact.id LEFT JOIN jos_core_acl_aro AS CB ON CB.value = classement.user_id LEFT JOIN jos_comprofiler AS CB_P ON CB_P.id = CB.value WHERE (course.access <= 0) AND (course.id = 35)ORDER BY classement.enroldate, nom ASC