Details

Keywords Change this

International Bauausstellung 1987, Social Housing, IBA 1987

Project timeline

1981 – 1985

Type

Residential

Location Change this

Friedrichstrasse 43-45
10969 Berlin
Germany
www.mauermuseum.de

Current state

Original

Also known as Change this

IBA Social Housing, Haus am Checkpoint Charlie

Architect Change this

Client Change this

Hauert Noack, GmbH & Company

__

Article last edited by Bostjan on
November 13th, 2019

Checkpoint Charlie Museum Change this

Berlin, Germany
by Peter Eisenman Change this
1 of 16

Description Change this

The Checkpoint Charlie Museum was originally designed as a residential building on Friedrichstrasse 43 in the Berlin district of Kreuzberg. The building was designed by Peter Eisenman and built as part of the International Building Exhibition (International Bauausstellung or IBA) in 1987. It is located opposite another apartment building designed for the International Building Exhibition, Checkpoint Charlie Apartments by Rem Koolhaas, Elia Zenghelis and Matthias Sauerbruch.

History


The building was originally built for social housing in Berlin from 1981 until 1985. The American architect Peter Eisenman belonged to the architecture group, the New York Five. The Checkpoint Charlie Museum is in central Berlin and is a short distance from the Memorial to the Murdered Jews of Europe, one Eisenman's most famous works. The building's namesake comes from the then existing adjacent Checkpoint Charlie, a crossing point between the two German states, which was necessitated by the Berlin Wall. Today the building houses a museum about the GDR and the Berlin Wall.

Grind Appearance

The appearance of the building at Checkpoint Charlie thrives on interaction of a differing square grid, the meridian and the streetscape. Since the land is situated on the border of two different urban patterns, the excise wall and the Berlin Wall, it is symbolized as the red ribbon in the facade of the 19th Century. Originally a garden was to be built, according to plans by Eisenman, but this was not realized after the fall of the Berlin Wall. In this house is located the Wall Museum, which documents the history and events of the Berlin Wall. It was founded in 1962 by Rainer Hildebrandt. It is one of the most visited museums in Germany.

Checkpoint Charlie residential development

The residential and office building is located at Checkpoint Charlie, at the historic epicentre of the Cold War. With this building, IBA Berlin sought to add architectural and functional value to the junction of Kochstrasse/Friedrichstrasse, and implement one of the most important goals of IBA Berlin: Reclaiming the inner city as a residential space.

IBA-Neubau called for a critical reference to the historical location when designing new buildings. The historic city ground plan, with its typical block perimeter development, was to be advanced creatively. And that was the basis for the competition process for Block 5 in the southern Friedrichstadt quarter. American architect Peter Eisenman won the competition with a block concept which, in addition to filling empty sites, includes a green space in the form of an “artificially excavated city with overlapping walls and towers.” The design thus incorporated the border location of the block and the political division of east and west.

While the green space was not implemented, Eisenman designed his residential building at the corner of the block, built in 1986, in a confident contemporary design vocabulary. The building volume is derived by superimposing different geographic orientation grids: One grid refers to the rectangular historic city structure of Friedrichstrasse, while a second grid stands for the Mercator geodesic grid – a symbolic connection between past and present. In terms of architecture history, the building completed in 1986 represents an important contribution for the development of the 1980s and 1990s deconstructivism and became one of the flagships of IBA Berlin.

Comments

Posted by Christian | Friday, March 14th, 2014 | 13:18pm
Dear Andreas, thank you for the great link. We will update the entry!
Posted by Guest | Tuesday, March 11th, 2014 | 16:58pm
Posted by Guest | Tuesday, March 11th, 2014 | 16:53pm
sorry to see that there are several mistakes about the house in the text

Register to join to conversation.

(default) 55 queries took 322 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 553
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` = '2019-12-14 18:27:07', `modified` = '2019-12-14 18:27:07' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
6SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11111
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` = 'checkpoint-charlie-museum' AND `Architecture`.`deleted` = 0 LIMIT 1118
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` = ('51751bed-ca40-45d7-8286-10676d7b5f76') 224
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` = ('51751bed-ca40-45d7-8286-10676d7b5f76') 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` = '51751bed-ca40-45d7-8286-10676d7b5f76' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 335
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` = '51751bed-ca40-45d7-8286-10676d7b5f76' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 114
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` = '51751bed-ca40-45d7-8286-10676d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 161633
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` = '51751bed-ca40-45d7-8286-10676d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1115
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` = '51751bed-ca40-45d7-8286-10676d7b5f76' AND `Version`.`version_id` = 9 LIMIT 1115
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` <> '51751bed-ca40-45d7-8286-10676d7b5f76' 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 'International Bauausstellung 1987') OR (`Article`.`tags` LIKE '%, International Bauausstellung 1987') OR (`Article`.`tags` LIKE '%, International Bauausstellung 1987, %') OR (`Article`.`tags` LIKE 'International Bauausstellung 1987, %') OR (`Article`.`tags` LIKE 'Social Housing') OR (`Article`.`tags` LIKE '%, Social Housing') OR (`Article`.`tags` LIKE '%, Social Housing, %') OR (`Article`.`tags` LIKE 'Social Housing, %')) ORDER BY Rand() ASC LIMIT 22243
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` = '4e7757a6-f1b0-4ecd-b3c6-36816d7b5f76' 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` = ('4e7757a6-f1b0-4ecd-b3c6-36816d7b5f76') ORDER BY `_order` asc, `created` asc 3328
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` = '58dbc4f5-52b4-4c09-b8bc-6d0e6d7b5e1b' 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` = ('58dbc4f5-52b4-4c09-b8bc-6d0e6d7b5e1b') ORDER BY `_order` asc, `created` asc 151529
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` = '51751bed-ca40-45d7-8286-10676d7b5f76' ORDER BY `Comment`.`id` desc 333
24SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`id` IN ('532301bb-ae8c-42f9-8a17-02256d7b5e1b', '531f40bc-325c-4316-a58a-758d6d7b5e1b', '531f3fa5-fdc4-4ff1-bf9c-7c236d7b5e1b') ORDER BY `Comment`.`last_message_id` desc, `Comment`.`id` desc 333
25SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '4b8c0eee-37d4-4d14-804b-5428183d6281' 112
26SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
27SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
28SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
29SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
30SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
31SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 112
32SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 112
33SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 112
34SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
35SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
36SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
37SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
38SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
39SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 002
40SELECT `Mention`.`id`, `Mention`.`username`, `Mention`.`slug`, `Mention`.`fname`, `Mention`.`lname`, `Mention`.`verified`, `Mention`.`top_list_count`, `Mention`.`comment_count`, `Mention`.`old_id`, `Mention`.`created`, `Mention`.`modified`, `Mention`.`name`, `Mention`.`password`, `Mention`.`password_hash_version`, `Mention`.`old_password_hash`, `Mention`.`role_id`, `Mention`.`login`, `Mention`.`active`, `Mention`.`gender`, `Mention`.`profile_visit_count`, `Mention`.`country_id`, `Mention`.`state_id`, `Mention`.`background`, `Mention`.`profession`, `Mention`.`photo_url`, `Mention`.`sm_photo_url`, `Mention`.`architecture_count`, `Mention`.`architect_count`, `Mention`.`activation_reminded`, `Mention`.`website`, `Mention`.`facebook`, `Mention`.`twitter`, `Mention`.`archived`, `Mention`.`last_login`, `Mention`.`cancelled`, `Mention`.`comment_notification`, `Mention`.`watch_notification`, `Mention`.`collection_notification`, `CommentsUser`.`id`, `CommentsUser`.`comment_id`, `CommentsUser`.`user_id`, `CommentsUser`.`mention_user_id`, `CommentsUser`.`foreign_id`, `CommentsUser`.`parent_id` FROM `users` AS `Mention` JOIN `comments_users` AS `CommentsUser` ON (`CommentsUser`.`comment_id` IN ('532301bb-ae8c-42f9-8a17-02256d7b5e1b', '531f40bc-325c-4316-a58a-758d6d7b5e1b', '531f3fa5-fdc4-4ff1-bf9c-7c236d7b5e1b') AND `CommentsUser`.`mention_user_id` = `Mention`.`id`) 003
41SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '532301bb-ae8c-42f9-8a17-02256d7b5e1b' ORDER BY `Comment`.`id` DESC 003
42SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '531f40bc-325c-4316-a58a-758d6d7b5e1b' ORDER BY `Comment`.`id` DESC 003
43SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '531f3fa5-fdc4-4ff1-bf9c-7c236d7b5e1b' ORDER BY `Comment`.`id` DESC 003
44SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 112
45SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' 112
46UPDATE `architectures` SET `id` = '51751bed-ca40-45d7-8286-10676d7b5f76', `views` = 15039, `views_last_day` = 720, `views_last_week` = 797, `views_last_month` = 902, `last_viewed` = '2019-12-14 18:27:08', `modified` = '2019-11-13 14:42:00' WHERE `architectures`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76'13
47SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51751bed-ca40-45d7-8286-10676d7b5f76' AND `Architecture`.`deleted` <> 1 LIMIT 1112
48SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '5086ae03-a600-41ab-8776-06866d7b5f76' AND `Architecture`.`deleted` <> 1 116
49UPDATE `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
50UPDATE `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` = "15039", `Article`.`views_last_day` = "720", `Article`.`views_last_week` = "797", `Article`.`views_last_month` = "902", `Article`.`last_viewed` = "2019-12-14 18:27:08" WHERE `foreign_id` = '51751bed-ca40-45d7-8286-10676d7b5f76'124
51SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Peter Eisenman' AND `Architect`.`deleted` <> 1 LIMIT 1112
52SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Checkpoint Charlie Apartments' AND `Architecture`.`deleted` <> 1 LIMIT 1113
53SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Rem Koolhaas' AND `Architect`.`deleted` <> 1 LIMIT 1112
54SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Matthias Sauerbruch' AND `Architect`.`deleted` <> 1 LIMIT 1112
55SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Memorial to the Murdered Jews of Europe' AND `Architecture`.`deleted` <> 1 LIMIT 1113