Details

Keywords Change this

Add this

Project timeline

2005 – 2010

Type

Mixed Use

Location Change this

Zmaja od Bosne 7
71000 Sarajevo
Bosnia and Herzegovina

Current state

Original

Also known as Change this

Balkan Puzzle

Architect Change this

Team

Sanja Galic - Grozdanic
Igor Grozdanic
Edin Avdibegovic
Hasnija Kazic
Ilhana Poplata
Jasmina Topcagic

Client Change this

Teloptic d.o.o. Sarajevo

Gross floor area Change this

44,800m²

Importanne Centre Change this

Sarajevo, Bosnia and Herzegovina
by Studio nonstop Change this
1 of 14

Description Change this

The Importanne Centre - designed by Studio nonstop in Sarajevo - consists of eight towers interconnected by vertical gardens and façade “blanks” as a symbolic representation of the points at which the towers could interlock to form urban jigsaw puzzles.

The buildings constitute a multifunctional business centre with offices, a hotel, flats, a shopping centre and an underground garage. In the light of the urban and programmatic context, the centre consists of eight towers compressed into a single entity to form a multiblock. Each tower remains a separate functional and formal entity linked to the others by greenery forming vertical garden façades. Each of the towers has its own special aesthetic expression in the rhythm of the openings, the colour of the façade panels, and the position of the façade “blanks.”

This creates an extremely interesting dynamics of interconnection, interaction and communication between the separate yet interlinked towers of the urban multiblock, providing a range of functional links in response to market demands and tenants’ needs.

Sources

  • Book: Restart 1995-2010 - Arhitektura u Bosni i Hercegovini

Comments

Register to join to conversation.

(default) 60 queries took 471 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `feeds`662
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SHOW FULL COLUMNS FROM `top_list_items`772
4SHOW FULL COLUMNS FROM `top_lists`552
5SHOW FULL COLUMNS FROM `architects`54542
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
7SHOW FULL COLUMNS FROM `articles`22222
8SHOW FULL COLUMNS FROM `object_views`552
9SHOW FULL COLUMNS FROM `associates`662
10SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
11SHOW FULL COLUMNS FROM `images`222210
12SHOW FULL COLUMNS FROM `sources`772
13SHOW FULL COLUMNS FROM `timelines`662
14SHOW FULL COLUMNS FROM `hp_features`442
15SHOW FULL COLUMNS FROM `architects_architectures`553
16SHOW FULL COLUMNS FROM `comments`16162
17SHOW FULL COLUMNS FROM `wall_posts`772
18SHOW FULL COLUMNS FROM `profile_visits`443
19SHOW FULL COLUMNS FROM `login_tokens`772
20SHOW FULL COLUMNS FROM `watched_objects`662
21SHOW FULL COLUMNS FROM `comments_users`662
22SHOW FULL COLUMNS FROM `tags`552
23SHOW FULL COLUMNS FROM `architectures_tags`662
24SHOW FULL COLUMNS FROM `architects_tags`662
25SHOW FULL COLUMNS FROM `versions`883
26SHOW FULL COLUMNS FROM `architecture_types`332
27SHOW FULL COLUMNS FROM `architecture_conditions`332
28SHOW FULL COLUMNS FROM `architecture_partners`662
29SHOW FULL COLUMNS FROM `partner_roles`222
30SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
31SHOW FULL COLUMNS FROM `likes`552
32SELECT `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 11133
33SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
34SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
35UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-08-21 10:21:01', `modified` = '2019-08-21 10:21:01' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
36SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11115
37SELECT `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` = 'importanne-centre' AND `Architecture`.`deleted` = 0 LIMIT 11110
38SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-70ec-41ba-aab4-0acfb372233b' 112
39SELECT `ArchitectureCondition`.`title` FROM `architecture_conditions` AS `ArchitectureCondition` WHERE `ArchitectureCondition`.`id` = '4b4640b6-a4b4-4492-a7cd-0ae3b372233b' 112
40SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948a-01cc-4051-87e5-42341030b5da' 112
41SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('537c57a2-06dc-473d-9374-60f06d7b5e1b') 115
42SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('537c57a2-06dc-473d-9374-60f06d7b5e1b') 002
43SELECT `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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 007
44SELECT `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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 116
45SELECT `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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 141453
46SELECT `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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1003
47SELECT `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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
48SELECT `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` <> '537c57a2-06dc-473d-9374-60f06d7b5e1b' AND `Article`.`deleted` = 0 AND `Architecture`.`architecture_type_id` = '4b463ec8-70ec-41ba-aab4-0acfb372233b' AND `Architecture`.`description` <> '' AND `Architecture`.`image_count` > 0 ORDER BY Rand() ASC LIMIT 222125
49SELECT `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` = '5183d8ef-8aac-49a7-9763-2d846d7b5f76' 113
50SELECT `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` = ('5183d8ef-8aac-49a7-9763-2d846d7b5f76') ORDER BY `_order` asc, `created` asc 2236
51SELECT `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` = '58e78614-fe74-4732-b89a-33476d7b5e1b' 112
52SELECT `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` = ('58e78614-fe74-4732-b89a-33476d7b5e1b') ORDER BY `_order` asc, `created` asc 7732
53SELECT 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` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' ORDER BY `Comment`.`id` desc 003
54SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' 112
55SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' 112
56UPDATE `architectures` SET `id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b', `views` = 1790, `views_last_day` = 36, `views_last_week` = 40, `views_last_month` = 49, `last_viewed` = '2019-08-21 10:21:01', `modified` = '2014-09-23 09:50:28' WHERE `architectures`.`id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b'13
57SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b' AND `Architecture`.`deleted` <> 1 LIMIT 1112
58SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '5360c7a4-9d14-4040-a6a5-27596d7b5e1b' AND `Architecture`.`deleted` <> 1 118
59UPDATE `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` = 98 WHERE `User`.`id` = '5360c7a4-9d14-4040-a6a5-27596d7b5e1b'03
60UPDATE `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` = "1790", `Article`.`views_last_day` = "36", `Article`.`views_last_week` = "40", `Article`.`views_last_month` = "49", `Article`.`last_viewed` = "2019-08-21 10:21:01" WHERE `foreign_id` = '537c57a2-06dc-473d-9374-60f06d7b5e1b'128