SQL= SELECT e.id AS eid, e.title, e.datdescription, e.meta_keywords, e.meta_description, e.datimage, e.contact, e.email, e.url, e.cost, e.maxseats, e.showseats, e.start_date, e.end_date, e.allday, e.start_time, e.end_time, e.timezone, e.virtual, e.durday, e.durhr, e.durmin, e.recur_type, e.recur_subtype, e.recur_freq, e.end_type, e.end_cnt, e.until_date, e.untilmonth, e.untilday, e.untilyear, e.recur_detail, e.recur_mth, e.recur_sun, e.recur_mon, e.recur_tue, e.recur_wed, e.recur_thu, e.recur_fri, e.recur_sat, e.recur_1, e.recur_2, e.recur_3, e.recur_4, e.recur_last, e.published AS published, e.approved, e.registra, e.unregistra, e.locid, e.catsid, e.created_by, l.id AS locid, l.venue, l.city, l.state, l.city, l.plz, l.street, l.country, l.created_by AS venueowner, c.id AS cid, c.catname, c.published AS catpublished, c.access, u.name AS creator_name, u.username AS creator_username, CASE WHEN CHAR_LENGTH(e.alias) THEN CONCAT_WS(':', e.id, e.alias) ELSE e.id END as slug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', e.locid, l.alias) ELSE e.locid END as venueslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM #__ciws_cal_events AS e LEFT JOIN #__ciws_cal_venues AS l ON e.locid = l.id LEFT JOIN #__ciws_cal_categories AS c ON c.id = e.catsid LEFT JOIN #__users AS u ON u.id = e.created_by WHERE e.id = 22