widget venue manager sql mod

if (isset($type) && $type == 'category') {
                $sql = "SELECT e.*, c.category_name, c.category_name, c.category_desc, ese.start_time";

				//Venue sql
				isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= ", v.name venue_name, v.address venue_address, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta " : '';

				$sql .=" FROM " . EVENTS_CATEGORY_TABLE . " c ";
                $sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.cat_id = c.id ";
                $sql .= " JOIN " . EVENTS_DETAIL_TABLE . " e ON e.id = r.event_id ";

				//Venue sql
				isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= " LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " vr ON vr.event_id = e.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id = vr.venue_id " : '';

				$sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
                $sql .= " WHERE c.id = '" . $instance['category_name'] . "' ";
                $sql .= " AND e.is_active = 'Y' ";
            } else {
                $sql = "SELECT e.*, ese.start_time";

				//Venue sql
				isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= ", v.name venue_name, v.address venue_address, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta " : '';

				$sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";

				//Venue sql
				isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= " LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " vr ON vr.event_id = e.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id = vr.venue_id " : '';

				$sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
                $sql .= " WHERE e.is_active = 'Y' ";
            }