Details

Keywords Change this

Add this

Foundation

2017, Oslo, Norway

Selected Architecture


Practice / Active in Change this

SAAHA
Maridalsveien 3, Bygg 17
0178 Oslo, Norway

www.saaha.no

SAAHA Change this

Change thisOslo, Norway
est. 2017, Oslo
1 of 3

About Change this

Thor Olav Solbjør and Adnan Harambasic have joined forces and founded SAAHA, an international architectural practice that aims to create sound and innovative projects. SAAHA is working on a wide range of architectural topics, from active involvement in urbanism and planning projects, creative solutions for complex and large building programs, to smaller living quarters, museum, and design projects. SAAHA has offices in Oslo (N) and Sarajevo (BiH).

Sources

Comments

Register to join to conversation.

(default) 58 queries took 719 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architects`54543
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';113
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
4SHOW FULL COLUMNS FROM `users`38382
5SHOW FULL COLUMNS FROM `roles`662
6SHOW FULL COLUMNS FROM `countries`332
7SHOW FULL COLUMNS FROM `states`332
8SHOW FULL COLUMNS FROM `auth_keys`772
9SHOW FULL COLUMNS FROM `auth_key_types`222
10SHOW FULL COLUMNS FROM `feeds`662
11SHOW FULL COLUMNS FROM `top_list_items`772
12SHOW FULL COLUMNS FROM `top_lists`552
13SHOW FULL COLUMNS FROM `architectures`636318
14SHOW FULL COLUMNS FROM `articles`22223
15SHOW FULL COLUMNS FROM `object_views`552
16SHOW FULL COLUMNS FROM `images`22223
17SHOW FULL COLUMNS FROM `sources`772
18SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
19SHOW FULL COLUMNS FROM `hp_features`442
20SHOW FULL COLUMNS FROM `architects_architectures`552
21SHOW FULL COLUMNS FROM `comments`16162
22SHOW FULL COLUMNS FROM `wall_posts`77209
23SHOW FULL COLUMNS FROM `profile_visits`44217
24SHOW FULL COLUMNS FROM `login_tokens`772
25SHOW FULL COLUMNS FROM `watched_objects`662
26SHOW FULL COLUMNS FROM `comments_users`662
27SHOW FULL COLUMNS FROM `tags`552
28SHOW FULL COLUMNS FROM `architectures_tags`662
29SHOW FULL COLUMNS FROM `architects_tags`662
30SHOW FULL COLUMNS FROM `associates`662
31SHOW FULL COLUMNS FROM `timelines`663
32SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 555
33SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification`, `Role`.`id`, `Role`.`name`, `Role`.`permissions`, `Role`.`description`, `Role`.`created`, `Role`.`modified` FROM `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `login` = 'guest@architectuul.com' LIMIT 11142
34SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
35SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
36UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-09-24 09:48:52', `modified` = '2019-09-24 09:48:52' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
37SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11122
38SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date`, `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `architects` AS `Architect` LEFT JOIN `countries` AS `PracticeCountry` ON (`Architect`.`practice_country_id` = `PracticeCountry`.`id`) WHERE `Architect`.`deleted` = 0 AND `Architect`.`slug` = 'saaha' LIMIT 11111
39SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '4936948a-ff9c-408f-ba35-48161030b5da' 112
40SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('5c344bee-d458-4ae0-8e06-53766d7b5e1b') 114
41SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('5c344bee-d458-4ae0-8e06-53766d7b5e1b') ORDER BY `Timeline`.`date` asc 003
42SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('5c344bee-d458-4ae0-8e06-53766d7b5e1b') 003
43SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitectsTag`.`id`, `ArchitectsTag`.`architect_id`, `ArchitectsTag`.`tag_id`, `ArchitectsTag`.`old_id`, `ArchitectsTag`.`old_architect_id`, `ArchitectsTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architects_tags` AS `ArchitectsTag` ON (`ArchitectsTag`.`architect_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 003
44SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created`, `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `images` AS `Image` LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE `foreign_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 3332
45SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created` FROM `versions` AS `Version` WHERE `Version`.`foreign_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1002
46SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created`, `User`.`username`, `User`.`slug` FROM `versions` AS `Version` LEFT JOIN `users` AS `User` ON (`Version`.`user_id` = `User`.`id`) WHERE `Version`.`foreign_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
47SELECT `Associate`.`id`, `Associate`.`user_id`, `Associate`.`architect_id`, `Associate`.`past`, `Associate`.`type`, `Associate`.`created` FROM `associates` AS `Associate` WHERE ((`architect_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b') OR (`user_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b')) 002
48SELECT DISTINCT CommentsUser.comment_id, CommentsUser.parent_id, Comment.body, Comment.last_message_id, `Comment`.`id` FROM `comments_users` AS `CommentsUser` LEFT JOIN `comments` AS `Comment` ON (`CommentsUser`.`comment_id` = `Comment`.`id`) WHERE `CommentsUser`.`foreign_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' ORDER BY `Comment`.`id` desc 002
49SELECT `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created`, `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architects_architectures` AS `ArchitectsArchitecture` LEFT JOIN `architectures` AS `Architecture` ON (`ArchitectsArchitecture`.`architecture_id` = `Architecture`.`id`) WHERE `ArchitectsArchitecture`.`architect_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' ORDER BY `Architecture`.`views` desc LIMIT 6115
50SELECT `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5c344e0c-76e8-45ef-8866-53766d7b5e1b' 112
51SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('5c344e0c-76e8-45ef-8866-53766d7b5e1b') ORDER BY `_order` asc, `created` asc 6626
52SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' 112
53SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' 112
54UPDATE `architects` SET `id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b', `views` = 556, `views_last_day` = 1, `views_last_week` = 10, `views_last_month` = 24, `last_viewed` = '2019-09-24 09:48:52', `modified` = '2019-01-18 15:51:58' WHERE `architects`.`id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b'13
55SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b' AND `Architect`.`deleted` <> 1 LIMIT 1112
56SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '5a19a5ca-6c64-4fb0-9105-36446d7b5e1b' AND `Architect`.`deleted` <> 1 114
57UPDATE `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`User`.`state_id` = `State`.`id`) SET `User`.`architect_count` = 25 WHERE `User`.`id` = '5a19a5ca-6c64-4fb0-9105-36446d7b5e1b'02
58UPDATE `articles` AS `Article` LEFT JOIN `architects` AS `Architect` ON (`Article`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Article`.`foreign_id` = `Architecture`.`id`) SET `Article`.`views` = "556", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "10", `Article`.`views_last_month` = "24", `Article`.`last_viewed` = "2019-09-24 09:48:52" WHERE `foreign_id` = '5c344bee-d458-4ae0-8e06-53766d7b5e1b'124