Details

Keywords Change this

Heritage

Foundation

2009, Berlin, Germany

Selected Architecture


Practice / Active in Change this

Code Of Practice
Gipsstrasse 3
10119 Berlin, Germany

www.codeofpractice.de

Linked to Change this

Stanley Fuls

Code of Practice Change this

Change thisBerlin, Germany
est. 2009, Berlin
1 of 5

About Change this

Code of Practice was founded in 2009 by Stanley Fuls, Florian Boxberg and Tom Mival who had practiced as senior staff in the Berlin offices of Foster + Partners and Sauerbruch Hutton Architects.

Taking a specific approach to their work, they undertake detailed analysis of context and subsequently task which formulates the foundation of their design process. This methodology was founded through various experiences in the design and realisation of large scale, new-build projects and the renovation of heritage-listed buildings.

Their work is often characterised by a reconsideration of any existing building structures and commitment to sustainability within the practice and work is always maintained. Solutions are distinguished by their flexibility, ease and efficiency.

Partners

Stanley Fuls is a founding partner of Code of Practice. Fuls previously worked for the German office of Foster + Partners, leading large scale restoration projects including the Dresden Train Station.

Florian Boxberg is one of the founding partners of the studio and has built a unique background in both architecture and information technology. While working as Associate Partner at Foster + Partners’ German office he combined overall responsibility for CAD and IT administration with the management of a number of international projects. Boxberg has previously taught computer-aided design, parametric modelling and visualisation at Berlin Technical University.

Tom Mival is also one of the founding partners, he has overseen the design process of a series of innovative award-winning projects in senior positions at Sauerbruch Hutton Architects and Foster + Partners. Tom ran the competition studio at Sauerbruch Hutton and before that he worked in both the London and Berlin offices for Foster + Partners specialising in the design and delivery of energy-efficient building envelopes. He has also lived and worked in China and Spain and has taught design units at both the Architectural Association in London and the University of Edinburgh.

Comments

Register to join to conversation.

(default) 72 queries took 353 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architects`54543
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
6SHOW FULL COLUMNS FROM `countries`332
7SHOW FULL COLUMNS FROM `states`332
8SHOW FULL COLUMNS FROM `auth_keys`772
9SHOW FULL COLUMNS FROM `auth_key_types`222
10SHOW FULL COLUMNS FROM `feeds`662
11SHOW FULL COLUMNS FROM `top_list_items`772
12SHOW FULL COLUMNS FROM `top_lists`552
13SHOW FULL COLUMNS FROM `architectures`63632
14SHOW FULL COLUMNS FROM `architecture_types`332
15SHOW FULL COLUMNS FROM `architecture_conditions`332
16SHOW FULL COLUMNS FROM `articles`22222
17SHOW FULL COLUMNS FROM `object_views`552
18SHOW FULL COLUMNS FROM `images`22222
19SHOW FULL COLUMNS FROM `sources`772
20SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
21SHOW FULL COLUMNS FROM `hp_features`442
22SHOW FULL COLUMNS FROM `architects_architectures`552
23SHOW FULL COLUMNS FROM `architecture_partners`662
24SHOW FULL COLUMNS FROM `partner_roles`222
25SHOW FULL COLUMNS FROM `comments`16162
26SHOW FULL COLUMNS FROM `wall_posts`772
27SHOW FULL COLUMNS FROM `profile_visits`442
28SHOW FULL COLUMNS FROM `login_tokens`772
29SHOW FULL COLUMNS FROM `watched_objects`662
30SHOW FULL COLUMNS FROM `comments_users`662
31SHOW FULL COLUMNS FROM `tags`552
32SHOW FULL COLUMNS FROM `architectures_tags`662
33SHOW FULL COLUMNS FROM `architects_tags`662
34SHOW FULL COLUMNS FROM `versions`882
35SHOW FULL COLUMNS FROM `associates`662
36SHOW FULL COLUMNS FROM `timelines`662
37SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
38SHOW FULL COLUMNS FROM `likes`552
39SELECT `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
40SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
41SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
42UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2020-02-23 16:59:59', `modified` = '2020-02-23 16:59:59' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
43SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11113
44SELECT `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` = 'code-of-practice' LIMIT 1115
45SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '4936948b-a388-49b6-8eb4-42fd1030b5da' 112
46SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('51935539-6414-4a3f-bc4c-704d6d7b5f76') 114
47SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('51935539-6414-4a3f-bc4c-704d6d7b5f76') ORDER BY `Timeline`.`date` asc 003
48SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('51935539-6414-4a3f-bc4c-704d6d7b5f76') 112
49SELECT `User`.`title`, `User`.`slug` FROM `architects` AS `User` WHERE `User`.`id` = '51e50f2b-eba8-41fc-8423-50a66d7b5f76' 112
50SELECT `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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 114
51SELECT `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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 5531
52SELECT `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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
53SELECT `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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
54SELECT `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`, `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` FROM `articles` AS `Article` LEFT JOIN `architects` AS `Architect` ON (`Article`.`foreign_id` = `Architect`.`id`) WHERE `Article`.`foreign_id` <> '51935539-6414-4a3f-bc4c-704d6d7b5f76' AND `Article`.`deleted` = 0 AND `Architect`.`biography` <> '' AND `Architect`.`tags` <> '' AND `Architect`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'Heritage') OR (`Article`.`tags` LIKE '%, Heritage') OR (`Article`.`tags` LIKE '%, Heritage, %') OR (`Article`.`tags` LIKE 'Heritage, %')) ORDER BY Rand() ASC LIMIT 22227
55SELECT `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` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51e50f2b-eba8-41fc-8423-50a66d7b5f76' 112
56SELECT `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` = ('51e50f2b-eba8-41fc-8423-50a66d7b5f76') ORDER BY `_order` asc, `created` asc 2227
57SELECT `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` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '5c5d5488-493c-4af8-af13-1ea96d7b5e1b' 112
58SELECT `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` = ('5c5d5488-493c-4af8-af13-1ea96d7b5e1b') ORDER BY `_order` asc, `created` asc 1130
59SELECT 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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' ORDER BY `Comment`.`id` desc 003
60SELECT `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` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' ORDER BY `Architecture`.`views` desc LIMIT 6115
61SELECT `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` = '5215d4ff-e2b4-474a-842a-5ada6d7b5f76' 112
62SELECT `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` = ('5215d4ff-e2b4-474a-842a-5ada6d7b5f76') ORDER BY `_order` asc, `created` asc 6628
63SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' 112
64SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' 112
65UPDATE `architects` SET `id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76', `views` = 2267, `views_last_day` = 204, `views_last_week` = 233, `views_last_month` = 253, `last_viewed` = '2020-02-23 17:00:00', `modified` = '2013-08-23 08:42:53' WHERE `architects`.`id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76'13
66SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76' AND `Architect`.`deleted` <> 1 LIMIT 1112
67SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '5086ae03-a600-41ab-8776-06866d7b5f76' AND `Architect`.`deleted` <> 1 114
68UPDATE `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` = 106 WHERE `User`.`id` = '5086ae03-a600-41ab-8776-06866d7b5f76'02
69UPDATE `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` = "2267", `Article`.`views_last_day` = "204", `Article`.`views_last_week` = "233", `Article`.`views_last_month` = "253", `Article`.`last_viewed` = "2020-02-23 17:00:00" WHERE `foreign_id` = '51935539-6414-4a3f-bc4c-704d6d7b5f76'124
70SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Foster + Partners' AND `Architect`.`deleted` <> 1 LIMIT 1115
71SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Sauerbruch Hutton' AND `Architect`.`deleted` <> 1 LIMIT 1113
72SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Stanley Fuls' AND `Architect`.`deleted` <> 1 LIMIT 1114