An error occurred with the query: SELECT e.id,e.title,e.title_normalized,e.status,e.description,e.data,e.image_data,e.is_cancelled,e.location,e.tags,e.submitter_id,e.venue_id,e.site_id,e.feed_id,e.assignment_id,e.ignored_assignment_ids,e.creation_timestamp,e.last_modified,e.import_id,e.grade,e.quality,u.email_address AS submitter_email_address,et.id AS event_time_id,CONVERT_TZ(CURRENT_TIMESTAMP,'UTC',v.time_zone) AS current_localtime,CONVERT_TZ(et.start_time,'UTC',v.time_zone) AS start_time,CONVERT_TZ(et.end_time,'UTC',v.time_zone) AS end_time,et.is_all_day,v.id AS v_id,v.assignment_id AS v_assignment_id,v.creation_timestamp AS v_creation_timestamp,v.data AS v_data,v.description AS v_description,v.address AS v_address,v.address_2 AS v_address_2,v.city AS v_city,v.city_normalized AS v_city_normalized,v.latitude AS v_latitude,v.longitude AS v_longitude,v.country_code AS v_country_code,v.county AS v_county,v.feed_id AS v_feed_id,v.foursquare_id AS v_foursquare_id,v.grade AS v_grade,v.image_data AS v_image_data,v.import_id AS v_import_id,v.last_modified AS v_last_modified,v.postal_code AS v_postal_code,v.quality AS v_quality,v.site_id AS v_site_id,v.state AS v_state,v.status AS v_status,v.submitter_id AS v_submitter_id,v.tags AS v_tags,v.time_zone AS v_time_zone,v.title AS v_title,v.title_normalized AS v_title_normalized,CASE WHEN (e.image_data IS NOT NULL OR v.image_data IS NOT NULL) THEN TRUE ELSE FALSE END AS has_image_data,CASE WHEN (es.site_id = 1436 AND es.is_sponsored IS TRUE) THEN TRUE ELSE FALSE END AS is_sponsored,CASE WHEN (es.site_id = 1436 AND es.is_editor_selection IS TRUE) THEN TRUE ELSE FALSE END AS is_editor_selection FROM event_time et, venue v, event e LEFT JOIN evie_user u ON e.submitter_id IS NOT NULL AND e.submitter_id = u.id LEFT JOIN event_site es ON es.event_id=e.id WHERE v.id = e.venue_id AND e.id = et.event_id AND e.id = id
Column 'id' in where clause is ambiguous