Details

Keywords Change this

Contemporary, Berlin Architekturpreis 2013

Project timeline

2012 – June 1st 2013

Type

Museum

Location Change this

Christinenstrasse 18a
Berlin
Germany

Also known as Change this

Tchoban Foundation Museum for Architectural Drawing

Architect Change this

Team

Philipp Bauer, Nadja Fedorova, Katja Fuks, Ulrike Graefenhain, Dirk Kollendt

Gross floor area Change this

498m²

Museum for Architectural Drawing Change this

Berlin, Germany
by SPeeCH, Sergei Tchoban, ... Change this
1 of 38

Description Change this

Sergei Tchoban, an architect based in Berlin and Moscow, together with Sergey Kuznetsov have completed a private museum space for architectural drawings as SPEECH architects. The new museum will provide a home for the internationally renowned Tchoban Foundation collection as well as for temporary exhibits from leading cultural institutions around the world. Architect and passionate collector Tchoban has finally realized his dream to create the ideal setting for architectural drawings.

Location

The Museum for Architectural Drawing at Pfefferberg takes its place alongside the rich array of important cultural institutions in the capital of Germany. The museum’s new building is located at the western entrance to Pfefferberg from Christinenstraße, the site of the former brewery between Schönhauser Allee and Teutoburger Platz in Prenzlauer Berg.

This area has developed since the 1990s from a non-profit organization to become a centre for Berlin’s cultural scene. Today numerous studios, workshops, agencies, galleries and event-spaces are gathered within the listed industrial buildings and vaults around the renowned Architecture Forum Aedes, with its research and convention centre, Aedes Network Campus Berlin.

Design

The construction is extended from a fire-wall and latches onto a row of typical old Berlin houses. The Museum for Architectural Drawing is a four-storey solid corpus with a glass floor stacked on top. The profile of the four floors is reminiscent of casually piled up blocks. The building’s silhouette is created by a regression and progression of façade elements, and demonstrates a freedom of form that relates to the conventions of the neighbouring historic Berlin buildings and yet is unorthodox and minimalist in its gesture.

The architecture's contemporary nature is seen through its construction, design and choice of materials. The expression of its formal language cannot be overlooked though, it still responds sensitively to its surroundings. The coloured concrete and glass façades of the building are rich in contrast and layers. Its closed surface is detailed with strong magnified fragments of architectural sketches in relief form. The museum has a floor area of approximately 490 square metres, and contains an entrance area, two exhibition rooms, the museum depository and a conference room.

The Collector and the Collection

Sergei Tchoban, born in 1962 in Saint Petersburg, developed a passion for architectural drawing during his student years at the Russian Academy of Arts in his home city. Here he discovered his love for the old Masters and began himself to draw. In 2001, the purchase of a drawing by Pietro di Gottardo Gonzaga was the foundation stone for his collection. Since then, the collection has grown to include several hundred sheets from different periods: from architects of the 16th century to the present day, from Cerceau to Gehry.

The Tchoban Foundation was founded at the end of 2009 with the aim of keeping the interest in architectural representation through drawing alive and to support young talent in this field. Together with the founder Sergei Tchoban, Dr. h. c. Kristin Feireiss, founder of the Aedes Architectural Forum and Dr. Eva-Maria Barkhofen, director of the Architectural Archive at the Academy of Arts, Berlin, two experts highly esteemed in and beyond their specialized fields, form the foundation’s board of trustees.

The Museum for Architectural Drawing will show three exhibitions annually. These will comprise exhibits from its own collection as well as loans from international cooperation partners such as the John Soane‘s Museum, the Hermitage and the École Nationale Supérieure des Beaux-Arts in Paris, which in turn will present exhibitions from the Tchoban Foundation in their galleries.

Comments

Posted by AleeshaCallahan | Friday, May 17th, 2013 | 16:09pm
Good idea, it is quite long
Posted by archibald | Friday, May 17th, 2013 | 14:43pm
What about a shorter title: Museum for Architectural Drawing ... ?

Register to join to conversation.

(default) 43 queries took 290 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 11122
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-08-23 16:46:56', `modified` = '2019-08-23 16:46:56' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'09
6SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 1119
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` = 'museum-for-architectural-drawing' AND `Architecture`.`deleted` = 0 LIMIT 1117
8SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-6efc-45c0-9b06-0acfb372233b' 112
9SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948b-a388-49b6-8eb4-42fd1030b5da' 112
10SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('519392e1-04f0-4559-b29c-756c6d7b5f76') 223
11SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('519392e1-04f0-4559-b29c-756c6d7b5f76') 002
12SELECT `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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 225
13SELECT `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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 334
14SELECT `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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 383846
15SELECT `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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
16SELECT `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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
17SELECT `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` <> '519392e1-04f0-4559-b29c-756c6d7b5f76' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'contemporary') OR (`Article`.`tags` LIKE '%, contemporary') OR (`Article`.`tags` LIKE '%, contemporary, %') OR (`Article`.`tags` LIKE 'contemporary, %') OR (`Article`.`tags` LIKE 'Berlin Architekturpreis 2013') OR (`Article`.`tags` LIKE '%, Berlin Architekturpreis 2013') OR (`Article`.`tags` LIKE '%, Berlin Architekturpreis 2013, %') OR (`Article`.`tags` LIKE 'Berlin Architekturpreis 2013, %')) ORDER BY Rand() ASC LIMIT 22234
18SELECT `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` = '4f573375-d050-4ed2-b054-601f6d7b5f76' 112
19SELECT `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` = ('4f573375-d050-4ed2-b054-601f6d7b5f76') ORDER BY `_order` asc, `created` asc 7727
20SELECT `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` = '5409bdd1-90d4-40e2-8b44-42746d7b5e1b' 112
21SELECT `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` = ('5409bdd1-90d4-40e2-8b44-42746d7b5e1b') ORDER BY `_order` asc, `created` asc 161632
22SELECT 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` = '519392e1-04f0-4559-b29c-756c6d7b5f76' ORDER BY `Comment`.`id` desc 222
23SELECT `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 ('51965654-acdc-4c5f-80b1-2f5c6d7b5f76', '51964222-ba60-4eee-8ad6-2f5c6d7b5f76') ORDER BY `Comment`.`last_message_id` desc, `Comment`.`id` desc 222
24SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5086ae03-a600-41ab-8776-06866d7b5f76' 112
25SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '1dc72436-ffa4-11de-b287-4f8fe1b9fcc1' 112
26SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
27SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
28SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 112
29SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 112
30SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
31SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
32SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
33SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 002
34SELECT `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 ('51965654-acdc-4c5f-80b1-2f5c6d7b5f76', '51964222-ba60-4eee-8ad6-2f5c6d7b5f76') AND `CommentsUser`.`mention_user_id` = `Mention`.`id`) 002
35SELECT `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` = '51965654-acdc-4c5f-80b1-2f5c6d7b5f76' ORDER BY `Comment`.`id` DESC 003
36SELECT `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` = '51964222-ba60-4eee-8ad6-2f5c6d7b5f76' ORDER BY `Comment`.`id` DESC 002
37SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 112
38SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' 112
39UPDATE `architectures` SET `id` = '519392e1-04f0-4559-b29c-756c6d7b5f76', `views` = 3410, `views_last_day` = 1, `views_last_week` = 7, `views_last_month` = 24, `last_viewed` = '2019-08-23 16:46:56', `modified` = '2016-06-03 08:06:43' WHERE `architectures`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76'13
40SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '519392e1-04f0-4559-b29c-756c6d7b5f76' AND `Architecture`.`deleted` <> 1 LIMIT 1112
41SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '5086ae03-a600-41ab-8776-06866d7b5f76' AND `Architecture`.`deleted` <> 1 115
42UPDATE `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
43UPDATE `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` = "3410", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "7", `Article`.`views_last_month` = "24", `Article`.`last_viewed` = "2019-08-23 16:46:56" WHERE `foreign_id` = '519392e1-04f0-4559-b29c-756c6d7b5f76'125