Details

Keywords Change this

Contemporary Architecture

Foundation

1994, Zagreb, Croatia

Selected Architecture


Practice / Active in Change this

3LHD
Nikole Božidarevića 13/4
Zagreb Zagreb, Croatia

www.3lhd.com/en/

Awards Change this

  • 2008 - Award for best building in Sport category on first World Architecture Festival WAF
  • 2008 - Croatian professional awards Drago Galić
  • 2008 - ID Magazine Award (USA)
  • 2008 - AR Emerging Architecture Award (UK)
  • 2009 - Bernando Bernardi Award
  • 2009 - IOC/IAKS Bronze Medal Award
  • 2009 - Vladimir Nazor Award
  • 2011 - Viktor Kovačić Award

3LHD Change this

Change thisZagreb, Croatia
est. 1994, Zagreb
1 of 2

About Change this

3LHD is an architectural firm based in Zagreb, Croatia. The studio was responsible for designing many public and business objects throughout the country and abroad, is known for its simplicity and contemporary visual look in architecture. 3LHD was founded in 1994 by founding partners Saša Begović (born 1967 in Bjelovar), Marko Dabrović (born 1969 in Dubrovnik), Tanja Grozdanić (born 1968 in Zagreb) and Silvije Novak (born 1971 in Rijeka). All partners are graduates from Architectural Faculty, University of Zagreb, Croatia.

3LHD is focused on integrating various disciplines – architecture, urban planning, design and art. Projects, such as Memorial Bridge in Rijeka, Croatian Pavilion in EXPO 2005 in Japan and EXPO 2008 in Zaragoza, Riva waterfront in Split, Sports Hall Bale in Istria, Centre Zamet in Rijeka, Zagreb Dance Centre in Zagreb and Hotel Lone in Rovinj are some of the important highlights.

3LHD architects are actively involved in teaching and have been visiting lecturers and critics in numerous cities and institutions such as ETH in Zurich, Berlage Institute in Rotterdam, RIBA London and Architectural Faculties and Universities. Currently the office partners are Guest Professors at GAF Architectural Faculty, University of Split and at Architecture Faculty, University of Zagreb, Croatia. Their work has been presented in Vienna, London and New York. Given the intense activity of 3LHD in the past ten years, a number of relevant and successful projects are still awaiting realization.

Sources

Comments

Register to join to conversation.

(default) 68 queries took 386 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
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`63633
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`663
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 11135
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-01-29 03:12:23', `modified` = '2020-01-29 03:12:23' 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 11116
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` = '3lhd' LIMIT 11110
45SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '49369489-b79c-4779-9003-487f1030b5da' 112
46SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b') 116
47SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b') ORDER BY `Timeline`.`date` asc 883
48SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b') 003
49SELECT `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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 114
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`, `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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 2236
51SELECT `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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1002
52SELECT `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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
53SELECT `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` <> '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' AND `Article`.`deleted` = 0 AND `Architect`.`biography` <> '' AND `Architect`.`tags` <> '' AND `Architect`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'contemporary architecture') OR (`Article`.`tags` LIKE '%, contemporary architecture') OR (`Article`.`tags` LIKE '%, contemporary architecture, %') OR (`Article`.`tags` LIKE 'contemporary architecture, %')) ORDER BY Rand() ASC LIMIT 22228
54SELECT `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` = '54065a43-5c00-4a45-9629-7c5a6d7b5e1b' 112
55SELECT `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` = ('54065a43-5c00-4a45-9629-7c5a6d7b5e1b') ORDER BY `_order` asc, `created` asc 1129
56SELECT `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` = '53e21ed2-40a4-40d9-931d-57626d7b5e1b' 112
57SELECT `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` = ('53e21ed2-40a4-40d9-931d-57626d7b5e1b') ORDER BY `_order` asc, `created` asc 1130
58SELECT 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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' ORDER BY `Comment`.`id` desc 003
59SELECT `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` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' ORDER BY `Architecture`.`views` desc LIMIT 6116
60SELECT `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` = '53cd0a28-7c44-455b-b66a-2e4b6d7b5e1b' 112
61SELECT `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` = ('53cd0a28-7c44-455b-b66a-2e4b6d7b5e1b') ORDER BY `_order` asc, `created` asc 4429
62SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' 112
63SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' 112
64UPDATE `architects` SET `id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b', `views` = 3057, `views_last_day` = 224, `views_last_week` = 261, `views_last_month` = 284, `last_viewed` = '2020-01-29 03:12:23', `modified` = '2014-07-21 12:46:38' WHERE `architects`.`id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b'14
65SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b' AND `Architect`.`deleted` <> 1 LIMIT 1112
66SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '52ff7855-3800-424e-affd-679b6d7b5e1b' AND `Architect`.`deleted` <> 1 115
67UPDATE `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` = 773 WHERE `User`.`id` = '52ff7855-3800-424e-affd-679b6d7b5e1b'02
68UPDATE `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` = "3057", `Article`.`views_last_day` = "224", `Article`.`views_last_week` = "261", `Article`.`views_last_month` = "284", `Article`.`last_viewed` = "2020-01-29 03:12:23" WHERE `foreign_id` = '53cd06ce-ad50-42ee-b5f2-2e4b6d7b5e1b'134