Details

Keywords Change this

Architect Studios, Houseboat

Project timeline

2007 – 2009

Type

Mixed Use

Location Change this

Embankment 8c
22081 Hamburg
Germany

Current state

Original

Also known as Change this

Rost Niderehe Studio, Hausboot auf dem Eilbekkanal

Architect Change this

Gross floor area Change this

361m²

Partners Change this

General contractor
Dirsch - Wood Construction
www.dirsch-holzbau.de

General contractor
Holzkonzept - Carpenters
www.holzkonzept.net/Holzkonzept.php

Houseboat on the Eilbekkanal Change this

The boat is used as a home and studio

1 of 11

Description Change this

The houseboat is located on the Eilbek canal in Hamburg and was designed by a young architect couple, Rost Niederehe Architekten, as part of a competition in 2007. Their design encompassed a mixed-use space that incorporated home and office.


Context

Hamburg has the biggest port in Germany and is known for its harbour and waterways. However over the past century these canals have changed greatly due to the cultivation of the surrounding land. The growth of urban areas and the need for transportation routes has meant some of these canals and watercourses have disappeared. Yet property with access to the water remains in high demand.

The demand for this form of living is high which is evidenced through the city’s urban development agency. Right now official mooring areas for permanent residences on the water are missing, but the process has been started: Germany’s first settlement with a new houseboat generation has been completed.

Urban Competition

An urban competition was held for the design of ten houseboats which would be moored as a settlement on the Eilbek canal.

Rost Niederehe Architekten put forward their dream houseboat design with no serious speculation of winning. However with a design that blends a traditional family home with the integral characteristics of a houseboat, their proposal won.

Architecture

The outcome is a design which expresses a clear architectural language. A single wrapping wall slices from the outside to the inside, separating the public and private spaces. The division of public and private space is reiterated again through the levels. The upper level, and entrance level, houses the kitchen and dining rooms while the lower deck has the private areas of bedrooms, bathroom and living quarters.

The material choice was influenced by the technical requirements of naval architecture, thus being mostly steel and wood. However this in turn also influenced the overall design.

Adaptive Use

The residents work and live on the houseboat. A major consideration for houseboats is that when the mooring area needs to be changed, it can simply be moved to a new destination with the help of a tug.

Comments

Register to join to conversation.

(default) 37 queries took 382 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `users`38383
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SHOW FULL COLUMNS FROM `roles`662
4SHOW FULL COLUMNS FROM `architects`54543
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
6SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
7SELECT `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 11150
8SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
9SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
10UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-12-07 08:50:08', `modified` = '2019-12-07 08:50:08' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
11SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11117
12SELECT `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`, `ArchitectureType`.`id`, `ArchitectureType`.`title`, `ArchitectureCondition`.`title`, `Country`.`name` FROM `architectures` AS `Architecture` LEFT JOIN `architecture_types` AS `ArchitectureType` ON (`Architecture`.`architecture_type_id` = `ArchitectureType`.`id`) LEFT JOIN `architecture_conditions` AS `ArchitectureCondition` ON (`Architecture`.`architecture_condition_id` = `ArchitectureCondition`.`id`) LEFT JOIN `countries` AS `Country` ON (`Architecture`.`country_id` = `Country`.`id`) WHERE `Architecture`.`slug` = 'houseboat-on-the-eilbekkanal' AND `Architecture`.`deleted` = 0 LIMIT 11119
13SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-70ec-41ba-aab4-0acfb372233b' 112
14SELECT `ArchitectureCondition`.`title` FROM `architecture_conditions` AS `ArchitectureCondition` WHERE `ArchitectureCondition`.`id` = '4b4640b6-a4b4-4492-a7cd-0ae3b372233b' 112
15SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948b-a388-49b6-8eb4-42fd1030b5da' 112
16SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('5176683c-f4b8-45d4-9634-3da36d7b5f76') 334
17SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('5176683c-f4b8-45d4-9634-3da36d7b5f76') 222
18SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4c6424ce-7934-4af2-b725-f865183d6281' 115
19SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4c6424ce-7934-4af2-b725-f865183d6281' 112
20SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitecturesTag`.`id`, `ArchitecturesTag`.`architecture_id`, `ArchitecturesTag`.`tag_id`, `ArchitecturesTag`.`old_id`, `ArchitecturesTag`.`old_building_id`, `ArchitecturesTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architectures_tags` AS `ArchitecturesTag` ON (`ArchitecturesTag`.`architecture_id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 228
21SELECT `Architect`.`title`, `Architect`.`slug`, `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created` FROM `architects` AS `Architect` JOIN `architects_architectures` AS `ArchitectsArchitecture` ON (`ArchitectsArchitecture`.`architecture_id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 1112
22SELECT `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` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 111168
23SELECT `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` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
24SELECT `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` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
25SELECT `Article`.`id`, `Article`.`aiid`, `Article`.`foreign_id`, `Article`.`model`, `Article`.`title`, `Article`.`clean_title`, `Article`.`also_known_as`, `Article`.`clean_also_known_as`, `Article`.`architects`, `Article`.`clean_architects`, `Article`.`description`, `Article`.`tags`, `Article`.`location`, `Article`.`is_featured`, `Article`.`views`, `Article`.`views_last_day`, `Article`.`views_last_week`, `Article`.`views_last_month`, `Article`.`last_viewed`, `Article`.`created`, `Article`.`modified`, `Article`.`deleted`, `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 `articles` AS `Article` LEFT JOIN `architectures` AS `Architecture` ON (`Article`.`foreign_id` = `Architecture`.`id`) WHERE `Article`.`foreign_id` <> '5176683c-f4b8-45d4-9634-3da36d7b5f76' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'Houseboat') OR (`Article`.`tags` LIKE '%, Houseboat') OR (`Article`.`tags` LIKE '%, Houseboat, %') OR (`Article`.`tags` LIKE 'Houseboat, %') OR (`Article`.`tags` LIKE 'Architect studios') OR (`Article`.`tags` LIKE '%, Architect studios') OR (`Article`.`tags` LIKE '%, Architect studios, %') OR (`Article`.`tags` LIKE 'Architect studios, %')) ORDER BY Rand() ASC LIMIT 22239
26SELECT `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` = '50ed698b-339c-45d2-8e8a-67886d7b5f76' 112
27SELECT `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` = ('50ed698b-339c-45d2-8e8a-67886d7b5f76') ORDER BY `_order` asc, `created` asc 9928
28SELECT `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` = '50d16cf9-3d58-4472-b77c-71e76d7b5f76' 112
29SELECT `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` = ('50d16cf9-3d58-4472-b77c-71e76d7b5f76') ORDER BY `_order` asc, `created` asc 9931
30SELECT 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` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' ORDER BY `Comment`.`id` desc 003
31SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' 112
32SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' 112
33UPDATE `architectures` SET `id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76', `views` = 2687, `views_last_day` = 53, `views_last_week` = 66, `views_last_month` = 73, `last_viewed` = '2019-12-07 08:50:09', `modified` = '2013-05-07 13:58:14' WHERE `architectures`.`id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76'14
34SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76' AND `Architecture`.`deleted` <> 1 LIMIT 1117
35SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '5086ae03-a600-41ab-8776-06866d7b5f76' AND `Architecture`.`deleted` <> 1 117
36UPDATE `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`.`architecture_count` = 191 WHERE `User`.`id` = '5086ae03-a600-41ab-8776-06866d7b5f76'02
37UPDATE `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` = "2687", `Article`.`views_last_day` = "53", `Article`.`views_last_week` = "66", `Article`.`views_last_month` = "73", `Article`.`last_viewed` = "2019-12-07 08:50:09" WHERE `foreign_id` = '5176683c-f4b8-45d4-9634-3da36d7b5f76'134