Details

Keywords Change this

Add this

Birth date / place

Add this

Selected Architecture

Add this

Practice / Active in Change this

Add this

Vladimir Steiskal Change this

 
0 of 0

About Change this

Vladimir Steiskal is a merited Architect of the Russian Federation, winner of the USSR Council of Ministers’ Prize and professor of the International Academy of Architecture.
He is one of the authors of the Hotel “Cosmos”, “Slavyanskaya” and “Pullman-Iris” and responsible for Smolenskaya Square and several complex buildings of the Savings Bank of the Russian Federation.

Comments

Register to join to conversation.

(default) 30 queries took 144 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architects`54542
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
4SHOW FULL COLUMNS FROM `users`38382
5SHOW FULL COLUMNS FROM `roles`662
6SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
7SHOW FULL COLUMNS FROM `likes`552
8SELECT `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 11121
9SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
10SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
11UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-09-18 02:05:11', `modified` = '2019-09-18 02:05:11' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
12SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11111
13SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date`, `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `architects` AS `Architect` LEFT JOIN `countries` AS `PracticeCountry` ON (`Architect`.`practice_country_id` = `PracticeCountry`.`id`) WHERE `Architect`.`deleted` = 0 AND `Architect`.`slug` = 'vladimir-steiskal' LIMIT 1114
14SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76') 004
15SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76') ORDER BY `Timeline`.`date` asc 002
16SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76') 002
17SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitectsTag`.`id`, `ArchitectsTag`.`architect_id`, `ArchitectsTag`.`tag_id`, `ArchitectsTag`.`old_id`, `ArchitectsTag`.`old_architect_id`, `ArchitectsTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architects_tags` AS `ArchitectsTag` ON (`ArchitectsTag`.`architect_id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 003
18SELECT `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` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 0026
19SELECT `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` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
20SELECT `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` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
21SELECT `Associate`.`id`, `Associate`.`user_id`, `Associate`.`architect_id`, `Associate`.`past`, `Associate`.`type`, `Associate`.`created` FROM `associates` AS `Associate` WHERE ((`architect_id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76') OR (`user_id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76')) 002
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` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' ORDER BY `Comment`.`id` desc 002
23SELECT `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created`, `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 `architects_architectures` AS `ArchitectsArchitecture` LEFT JOIN `architectures` AS `Architecture` ON (`ArchitectsArchitecture`.`architecture_id` = `Architecture`.`id`) WHERE `ArchitectsArchitecture`.`architect_id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' ORDER BY `Architecture`.`views` desc LIMIT 6004
24SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' 112
25SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' 112
26UPDATE `architects` SET `id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76', `views` = 1467, `views_last_day` = 1, `views_last_week` = 3, `views_last_month` = 11, `last_viewed` = '2019-09-18 02:05:11', `modified` = '2011-09-18 14:08:01' WHERE `architects`.`id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76'13
27SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76' AND `Architect`.`deleted` <> 1 LIMIT 1112
28SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '4d51db71-740c-4693-b0fe-07e16d7b5f76' AND `Architect`.`deleted` <> 1 114
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`.`architect_count` = 134 WHERE `User`.`id` = '4d51db71-740c-4693-b0fe-07e16d7b5f76'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` = "1467", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "3", `Article`.`views_last_month` = "11", `Article`.`last_viewed` = "2019-09-18 02:05:11" WHERE `foreign_id` = '4e74d535-f3ec-4aad-9a46-7cdb6d7b5f76'123