Details

Keywords Change this

Forgotten Masterpieces, Soviet Architecture, Foma

Project timeline

1970 – ?

Type

Civic

Location Change this

Shevchenko ulitsa
Kaliningrad
Russia

Current state

Under Construction

Also known as Change this

House of Soviets Kaliningrad, Дом Советов

Architect Change this

Dom Sovietov Kaliningrad Change this

Kaliningrad, Russia
by Yulian L. Shvartsbreim Change this

The empty shell of the Dom Sovietov in the 1990s

1 of 6

Description Change this

The Dom Sovietov (House of Soviets) is situated in the centre of Kaliningrad on the historical site of the Prussian Königsberg Castle which was severely damaged by allied bombing in WW II. The remains were blown up between 1964 and 1968 by order of the executive committee of the communist party of Kaliningrad. The Dom Sovietov, a building for the local administration was to be erected, in its place.

History

Königsberg Castle was severely damaged during the bombing of Königsberg in World War II. Following the war, as the city came under the control of the USSR, the site of the castle was redeveloped as part of the reconstruction of the city. Construction began on the House of Soviets in 1960, and was intended to be the central administration building of the Kaliningrad Oblast.

The Dom Sovetov was to be built as a symbol of Soviet power on the ruins of the Prussian castle. It was planned as a 28-storey building consisting of two tall rectangular towers, lined with embossed panels and a two-level covered walkway between them. However, the building's foundations juxtaposed on the foundations of the destroyed castle were too weak and ultimately only 21 storeys were built. The project was halted when it was already 95% complete in 1985. After the demise of the Soviet Union, the complex was to be converted into a business center. Financing issues and criminal charges against the proprietors led to a new standstill. Today, the building is still empty. The local population endearingly calls it "our monster" or "the buried robot".

On the occasion of Kaliningrad’s 60th and Königsberg's 750th anniversary in July 2005, the building was painted in sky-blue and new window panes were mounted. Presently, its future is still undecided.

Sources

Comments

Posted by ziggurat | Wednesday, November 2nd, 2011 | 10:33am
The situation is still the same and its future still undecided.
Posted by krazin | Tuesday, September 20th, 2011 | 17:55pm
What's happening with this crazy building now. Any news?

Register to join to conversation.

(default) 48 queries took 759 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `tags`55214
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SHOW FULL COLUMNS FROM `architectures_tags`662
4SHOW FULL COLUMNS FROM `architects_tags`662
5SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
6SELECT `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 11123
7SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
8SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
9UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-08-23 12:02:02', `modified` = '2019-08-23 12:02:02' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'14
10SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11113
11SELECT `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` = 'dom-sovietov-kaliningrad' AND `Architecture`.`deleted` = 0 LIMIT 1114
12SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-7c74-432e-82d4-0acfb372233b' 112
13SELECT `ArchitectureCondition`.`title` FROM `architecture_conditions` AS `ArchitectureCondition` WHERE `ArchitectureCondition`.`id` = '4beb2658-bb54-4148-a910-244c183d6281' 112
14SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4a1161a3-f5e8-40cb-95ed-804f1030b5da' 112
15SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('4d7c00c7-7dd4-4662-96ee-21666d7b5f76') 113
16SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('4d7c00c7-7dd4-4662-96ee-21666d7b5f76') 002
17SELECT `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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 335
18SELECT `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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 114
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`, `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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 6631
20SELECT `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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
21SELECT `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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
22SELECT `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` <> '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'Soviet Architecture') OR (`Article`.`tags` LIKE '%, Soviet Architecture') OR (`Article`.`tags` LIKE '%, Soviet Architecture, %') OR (`Article`.`tags` LIKE 'Soviet Architecture, %') OR (`Article`.`tags` LIKE 'Forgotten Masterpieces') OR (`Article`.`tags` LIKE '%, Forgotten Masterpieces') OR (`Article`.`tags` LIKE '%, Forgotten Masterpieces, %') OR (`Article`.`tags` LIKE 'Forgotten Masterpieces, %') OR (`Article`.`tags` LIKE 'foma') OR (`Article`.`tags` LIKE '%, foma') OR (`Article`.`tags` LIKE '%, foma, %') OR (`Article`.`tags` LIKE 'foma, %')) ORDER BY Rand() ASC LIMIT 22248
23SELECT `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` = '4b46391b-f0b0-4530-b2b7-0a6bb372233b' 1119
24SELECT `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` = ('4b46391b-f0b0-4530-b2b7-0a6bb372233b') ORDER BY `_order` asc, `created` asc 121234
25SELECT `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` = '4f67640d-96e0-4018-8bcd-08086d7b5f76' 115
26SELECT `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` = ('4f67640d-96e0-4018-8bcd-08086d7b5f76') ORDER BY `_order` asc, `created` asc 8831
27SELECT 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` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' ORDER BY `Comment`.`id` desc 222
28SELECT `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 ('4eb11c82-cd88-44b0-a9a7-5c106d7b5f76', '4e78d385-1920-43cf-9acc-60976d7b5f76') ORDER BY `Comment`.`last_message_id` desc, `Comment`.`id` desc 222
29SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '4d51db71-740c-4693-b0fe-07e16d7b5f76' 112
30SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '4bb0a157-05ac-4c98-9085-54ab183d6281' 11207
31SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
32SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
33SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 112
34SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 112
35SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
36SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
37SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
38SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 002
39SELECT `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 ('4eb11c82-cd88-44b0-a9a7-5c106d7b5f76', '4e78d385-1920-43cf-9acc-60976d7b5f76') AND `CommentsUser`.`mention_user_id` = `Mention`.`id`) 002
40SELECT `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` = '4eb11c82-cd88-44b0-a9a7-5c106d7b5f76' ORDER BY `Comment`.`id` DESC 0018
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` = '4e78d385-1920-43cf-9acc-60976d7b5f76' ORDER BY `Comment`.`id` DESC 004
42SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 112
43SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' 112
44UPDATE `architectures` SET `id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76', `views` = 8479, `views_last_day` = 1, `views_last_week` = 8, `views_last_month` = 34, `last_viewed` = '2019-08-23 12:02:02', `modified` = '2013-12-30 08:38:53' WHERE `architectures`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76'15
45SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76' AND `Architecture`.`deleted` <> 1 LIMIT 1112
46SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '4d51db71-740c-4693-b0fe-07e16d7b5f76' AND `Architecture`.`deleted` <> 1 117
47UPDATE `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` = 200 WHERE `User`.`id` = '4d51db71-740c-4693-b0fe-07e16d7b5f76'02
48UPDATE `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` = "8479", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "8", `Article`.`views_last_month` = "34", `Article`.`last_viewed` = "2019-08-23 12:02:03" WHERE `foreign_id` = '4d7c00c7-7dd4-4662-96ee-21666d7b5f76'124