Details

Keywords Change this

IBA 1987, DIY

Project timeline

1988 – 1992

Type

Residential

Location Change this

Wilhelmstraße 119-121
10963 Berlin
Germany

Current state

Original

Also known as Change this

Selbstbauterrassen

Architect Change this

__

Article last edited by Sonja Dragovic on
November 13th, 2019

Block 9 Change this

DIY terraces

1 of 5

Description Change this

Block 9 was built as part of IBA Berlin 1987. Terraces and the tower house were constructed in 1988-89, while the playground was built during 1990-92 period.

Urban situation before the start of IBA 1987

During the Second World War, southern Friedrichstadt was almost completely destroyed. What remained was a ruined city structure, which barely reminded of the previous situation in its basic features. Block 9, which stretches between Stresemannstrasse in the west, Wilhelmstraße in the east, Anhalter Straße in the north and Hedemannstraße in the south, was characterized by large brownfield sites. The middle of the block was dominated by a large fire wall of a former wing of a Wilhelminian style building.

Historical structure of the area

The development on the southern edge of Friedrichstadt was defined by solid block structures before the destruction in 1945. These structures were marked by development of a block edge, courtyards, and adapted eaves heights. The entire area used to be a mixture of residential and commercial functions; behind the large fire wall in Block 9 there use to be a printing house.

Planning history and redevelopment goals

A new concept in building social housing was to involve the residents and use their assistance in the planning and construction. The aim was to reduce costs, while simultaneously strengthening the feeling of belonging - the identification of residents with their neighborhood. The project was to be incorporated into the prevailing block concept in southern Friedrichstadt, and form a tower on the street corner as a focal point. Besides the planned residential development, it was necessary to design a children's playground.

The international architectural competition "Southern Friedrichstadt - Wilhelmstraße", organized in 1981, was won by the Spanish architectural group C2. In 1982/83, IBA approved the draft of the plan. Additionally, the land-use plan was changed and creation of a new cul-de-sac in Block 9 was approved. A year later, design for the new playground followed. Construction of the "Do It Yourself" terraces and the residential tower began in the late 1988 and was completed a year later. The playground was completed in 1992.

Urban planning and architectural solution

In southern Friedrichstadt, three towers were built during the period of IBA planning: residential building at the corner of Wilhelmstraße / Anhalter Straße, the Atelierturm in Charlottenstraße, and the 12-storey residential building in Block 9, which soon became a new landmarks in the district.

The building, built by the Turin architect Pietro Derossi and his Berlin contact, architect Klaus Kammann, consists of two parts. Up to the 6th floor, the facade is designed in exposed brickwork. Additionally, the tower is plastered in parts, with semicircular balconies and loggias which make the tower appear dynamic. The roof is broken in the middle and adorned with a playful sculpture. The buidling containes 11 apartments and two shops.

Next to the tower, the building defined by so-called "Do it yourself" (DIY) terraces was built. Designed by the architect Dietrich von Beulwitz, it follows a newly created branch road. The three equally designed terrace houses line up along the existing fire wall, follow the block idea of a side wing, and are 120 meters long. The buildings, with skeletons made of reinforced concrete, are 5-stories high, with up to 45 m² of south-oriented terraces. These can be used as gardens, living rooms, or sun lounges. The construction offers open, almost support-free surfaces and opens up a wide variety of extension options for the occupants. Both the lower and the upper floors are suitable for commercial use.

Altogether, the DIY terrace building offers 30 adaptable apartments. While house no.3 has been almost completely expanded and completed by the client, in house no.1 residents were involved in the construction and have somewhat contributed to its completion. House no.2 was the one where the residents had the biggest role; their budilding efforts took place under expert supervision. The DIY structure is never completed, but can be constantly supplemented or changed. Each of the three houses opens up into its own playground, which then continues into another, large playground with an area of 2,500 m², completed in 1992. Jasper Halfmann and Klaus Zillich designed the green spaces here, as well as at several other IBA locations in southern Friedrichstadt.

Sources

Comments

Register to join to conversation.

(default) 36 queries took 317 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
2SELECT `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 11124
3SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
4SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
5UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2020-02-19 22:17:05', `modified` = '2020-02-19 22:17:05' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'03
6SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11112
7SELECT `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` = 'block-9' AND `Architecture`.`deleted` = 0 LIMIT 11116
8SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-c1c8-4e46-b88e-0acfb372233b' 112
9SELECT `ArchitectureCondition`.`title` FROM `architecture_conditions` AS `ArchitectureCondition` WHERE `ArchitectureCondition`.`id` = '4b4640b6-a4b4-4492-a7cd-0ae3b372233b' 112
10SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948b-a388-49b6-8eb4-42fd1030b5da' 112
11SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b') 114
12SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b') 002
13SELECT `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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 225
14SELECT `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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 554
15SELECT `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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 5531
16SELECT `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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1114
17SELECT `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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' AND `Version`.`version_id` = 11 LIMIT 1114
18SELECT `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` <> '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'IBA 1987') OR (`Article`.`tags` LIKE '%, IBA 1987') OR (`Article`.`tags` LIKE '%, IBA 1987, %') OR (`Article`.`tags` LIKE 'IBA 1987, %') OR (`Article`.`tags` LIKE 'DIY') OR (`Article`.`tags` LIKE '%, DIY') OR (`Article`.`tags` LIKE '%, DIY, %') OR (`Article`.`tags` LIKE 'DIY, %')) ORDER BY Rand() ASC LIMIT 22237
19SELECT `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` = '58dcdf5f-e210-4b50-8bde-30b66d7b5e1b' 112
20SELECT `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` = ('58dcdf5f-e210-4b50-8bde-30b66d7b5e1b') ORDER BY `_order` asc, `created` asc 4428
21SELECT `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` = '58dcd9b2-3678-49af-b2fc-305e6d7b5e1b' 112
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` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('58dcd9b2-3678-49af-b2fc-305e6d7b5e1b') ORDER BY `_order` asc, `created` asc 5544
23SELECT 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` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' ORDER BY `Comment`.`id` desc 003
24SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' 112
25SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' 112
26UPDATE `architectures` SET `id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b', `views` = 150, `views_last_day` = 150, `views_last_week` = 150, `views_last_month` = 150, `last_viewed` = '2020-02-19 22:17:06', `modified` = '2019-11-13 12:43:26' WHERE `architectures`.`id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b'13
27SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b' AND `Architecture`.`deleted` <> 1 LIMIT 1112
28SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '5c537fc1-29ec-4d4a-9a41-07de6d7b5e1b' AND `Architecture`.`deleted` <> 1 115
29UPDATE `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` = 25 WHERE `User`.`id` = '5c537fc1-29ec-4d4a-9a41-07de6d7b5e1b'02
30UPDATE `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` = "150", `Article`.`views_last_day` = "150", `Article`.`views_last_week` = "150", `Article`.`views_last_month` = "150", `Article`.`last_viewed` = "2020-02-19 22:17:06" WHERE `foreign_id` = '5dc1681d-f1f0-48b6-9bbd-7ddd6d7b5e1b'123
31SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'IBA Berlin 1987' AND `Architecture`.`deleted` <> 1 LIMIT 1119
32SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Pietro Derossi' AND `Architect`.`deleted` <> 1 LIMIT 1118
33SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Klaus Kammann' AND `Architect`.`deleted` <> 1 LIMIT 1116
34SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Dietrich von Beulwitz' AND `Architect`.`deleted` <> 1 LIMIT 1116
35SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Jasper Halfmann' AND `Architect`.`deleted` <> 1 LIMIT 1116
36SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Klaus Zillich' AND `Architect`.`deleted` <> 1 LIMIT 1116