SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.reservedplaces,a.minbookeduser,a.maxbookeduser,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,a.requestanswer,a.seriesbooking,a.singlebooking, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.color AS venuecolor,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.color AS l_color,l.venue,l.version AS l_version,ct.name AS countryname, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug, CASE WHEN  a.access IN (1,2,3) THEN 1  ELSE 0  END as user_has_access_event, CASE WHEN  l.access IN (1,2,3) THEN 1  ELSE 0  END as user_has_access_venue, CASE WHEN  c.access IN (1,2,3) THEN 1  ELSE 0  END as user_has_access_category
FROM prociv_jem_events as a
LEFT JOIN prociv_users AS u on u.id = a.created_by
LEFT JOIN prociv_jem_venues AS l ON l.id = a.locid
LEFT JOIN prociv_jem_countries AS ct ON ct.iso2 = l.country
LEFT JOIN prociv_jem_cats_event_relations AS rel ON rel.itemid = a.id
LEFT JOIN prociv_jem_categories AS c ON c.id = rel.catid
WHERE a.access IN (1,2,3) AND ((`a`.published IN (0,1))) AND a.publish_up <= '2026-08-20 18:04:38' AND (a.publish_down > '2026-08-20 18:04:38' OR a.publish_down IS null) AND c.id  IN (1,3,4,5,6,7,8)
GROUP BY a.id