© 2025 REMOTE.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
INNER JOIN
THcQj_posts AS posts
ON posts.ID = ex_app.exh_company_i...' at line 14]SELECT
COUNT(DISTINCT ex_app._ID) AS quantidade,
GROUP_CONCAT(DISTINCT ex_app.exh_company_id ORDER BY ex_app.exh_company_id ASC) AS Ids,
GROUP_CONCAT(DISTINCT CASE WHEN ord.event_id = 1 THEN ex_app.exh_company_id END ORDER BY ex_app.exh_company_id ASC) AS `Ids event 1`,
GROUP_CONCAT(DISTINCT CASE WHEN ord.event_id = 2 THEN ex_app.exh_company_id END ORDER BY ex_app.exh_company_id ASC) AS `Ids event 2`,
GROUP_CONCAT(DISTINCT CASE WHEN ord.event_id = 5 THEN ex_app.exh_company_id END ORDER BY ex_app.exh_company_id ASC) AS `Ids event 5`
FROM
THcQj_jet_cct_exh_applications AS ex_app
INNER JOIN
THcQj_jet_cct_orders AS ord
ON ex_app._ID = ord.application_id
AND ord.order_status = 'Enrolled'
AND ord.remoter_type = 'exhibitor'
AND ord.event_id IN ()
INNER JOIN
THcQj_posts AS posts
ON posts.ID = ex_app.exh_company_id
AND posts.post_status = 'publish'
WHERE
ex_app.exh_company_id <> '';