Kursaal

The Kursaal Congress Palace is an architectural work of Rafael Moneo. Facing the sea, translucent glass cubes host two auditoriums and multiple function rooms. The cultural center is the venue for international events like the San Sebastián International Film Festival, Heineken Jazz Festival, the San Sebastian Musical Fortnight and El Sol-Latin American Festival of Advertising Communication.


It has 2 auditoriums with capacities of 1806 and 624 people.

(default) 15 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Client`.*, `I18n__name`.`content` FROM `liquidmaps`.`clients` AS `Client` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Client`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Client' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'en_us') WHERE `Client`.`slug` = 'observatori' LIMIT 1110
2SELECT `Client`.*, `I18n__name`.`content` FROM `liquidmaps`.`clients` AS `Client` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Client`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Client' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'en_us') WHERE `Client`.`slug` = 'observatori' LIMIT 1110
3SELECT `User`.`id`, `User`.`email`, `User`.`username`, `User`.`user_type`, `User`.`user_info`, `User`.`password`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`acronym`, `User`.`author`, `User`.`author_year`, `User`.`year`, `User`.`image`, `User`.`dir`, `User`.`topic_id`, `User`.`about`, `User`.`webpage`, `User`.`company_position`, `User`.`company_trade_name`, `User`.`company_cif`, `User`.`company_sector`, `User`.`company_address`, `User`.`company_population`, `User`.`company_postal_code`, `User`.`company_phone`, `User`.`company_fax`, `User`.`company_email`, `User`.`role`, `User`.`group_id`, `User`.`hash`, `User`.`enabled`, `User`.`created`, `User`.`modified`, `User`.`document`, `User`.`address`, `User`.`population`, `User`.`province`, `User`.`country_id`, `User`.`lat`, `User`.`lng`, `User`.`postal_code`, `User`.`phone`, `User`.`fax`, `User`.`profile_css`, `User`.`login_activated`, `User`.`is_vip`, `User`.`related`, `User`.`newsletter`, `User`.`measure`, `User`.`technique`, `User`.`material`, `User`.`source`, `User`.`fund`, `User`.`location`, `User`.`catalog`, `User`.`origin`, `User`.`preferences`, (CONCAT(`User`.`name`, ' (', `User`.`email`, ')')) AS `User__full_name` FROM `liquidmaps`.`users` AS `User` WHERE `User`.`id` = 1876 LIMIT 1110
4SELECT `UserField`.`id`, `UserField`.`label`, `UserField`.`value`, `UserField`.`user_id`, `UserField`.`public`, `UserField`.`created`, `UserField`.`modified` FROM `liquidmaps`.`user_fields` AS `UserField` WHERE `UserField`.`user_id` = (1876)001
5SELECT `UsersFicha`.*, `I18n__name`.`content`, `I18n__body`.`content` FROM `liquidmaps`.`users_fichas` AS `UsersFicha` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`UsersFicha`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'UsersFicha' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__body` ON (`UsersFicha`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'UsersFicha' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'eng') WHERE `UsersFicha`.`user_id` = 1876 AND `UsersFicha`.`publish` = '1' ORDER BY `UsersFicha`.`order` ASC553
6SELECT `UsersFicha`.*, `I18n__name`.`content`, `I18n__body`.`content` FROM `liquidmaps`.`users_fichas` AS `UsersFicha` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`UsersFicha`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'UsersFicha' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__body` ON (`UsersFicha`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'UsersFicha' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'eng') WHERE `UsersFicha`.`id` = 4617 ORDER BY `UsersFicha`.`order` ASC LIMIT 1110
7SELECT `UsersFichasItem`.*, `I18n__dir`.`content`, `I18n__title`.`content` FROM `liquidmaps`.`users_fichas_items` AS `UsersFichasItem` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__dir` ON (`UsersFichasItem`.`id` = `I18n__dir`.`foreign_key` AND `I18n__dir`.`model` = 'UsersFichasItem' AND `I18n__dir`.`field` = 'dir' AND `I18n__dir`.`locale` = 'eng') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`UsersFichasItem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'UsersFichasItem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') WHERE `UsersFichasItem`.`user_id` = 1876 AND `UsersFichasItem`.`users_ficha_id` = 4617 AND `UsersFichasItem`.`publish` = '1'119
8SELECT `Client`.*, `I18n__name`.`content` FROM `liquidmaps`.`clients` AS `Client` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Client`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Client' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'en_us') WHERE `Client`.`user_id` IS NULL LIMIT 1110
9SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
10SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
11SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
12SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
13SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_URL' LIMIT 1110
14SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
15SELECT `Menu`.*, `I18n__title`.`content` FROM `liquidmaps`.`menus` AS `Menu` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`Menu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menu' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Menu`.`order` ASC221