Details

Keywords Change this

Opera, Expressionist, Cut Sphere

Project timeline

March 2nd 1959 – October 20th 1973

Type

Culture & Entertainment

Location Change this

2 Macquarie St
NSW 2000 Sydney
Australia
www.sydneyoperahouse.com

Current state

Original

Architect Change this

Client Change this

New South Wales State Government
www.nsw.gov.au/

Partners Change this

Structural engineers
Ove Arup and Partners
www.arup.com/

Sydney Opera House Change this

Sydney, Australia
by Jørn Utzon Change this
1 of 13

Description Change this

The Sydney Opera House was designed by Danish Architect Jørn Utzon, after his design won a competition in 1957. This highly controversial project at the time came to define Australia. The Sydney Opera House is a modern expressionist design, with a series of large precast concrete "shells", each composed of sections of a sphere, forming the roofs of the structure, set on a monumental podium. The building covers 1.8 hectares (4.4 acres) of land and is 183 m (600 ft) long and 120 m (394 ft) wide at its widest point. It is supported on 588 concrete piers sunk as much as 25 m (82 ft) below sea level.

The Sydney Opera House opened the way for the immensely complex geometries of some modern architecture. The design was one of the first examples of the use of computer-aided design to design complex shapes.

Although the roof structures of the Sydney Opera House are commonly referred to as "shells", they are in fact not shells in a strictly structural sense, but are instead precast concrete panels supported by precast concrete ribs. The shells are covered in a subtle chevron pattern with 1,056,006 glossy white- and matte-cream-coloured Swedish-made tiles from Höganäs AB, a factory that generally produced stoneware tiles for the paper-mill industry.

Apart from the tile of the shells and the glass curtain walls of the foyer spaces, the buildings exterior is largely clad with aggregate panels composed of pink granite quarried at Tarana. Significant interior surface treatments also include off-form concrete, Australian white birch plywood supplied from Wauchope in northern New South Wales, and brush box glulam.

Construction

The project was built in three stages. Stage I (1959–1963) consisted of building the upper podium. Stage II (1963–1967) saw the construction of the outer shells. Stage III (1967–1973) consisted of the interior design and construction.

Stage I
The government had pushed for work to begin early, fearing that funding, or public opinion, might turn against them. However, Utzon had still not completed the final designs. Major structural issues still remained unresolved. The forced early start led to significant later problems, not least of which was the fact that the podium columns were not strong enough to support the roof structure, and had to be re-built.

Stage II
The shells of the competition entry were originally of undefined geometry. But, early in the design process, the "shells" were perceived as a series of parabolas supported by precast concrete ribs. However, the engineers were unable to find an acceptable solution to constructing them. The formwork for using in-situ concrete would have been prohibitively expensive, but, because there was no repetition in any of the roof forms, the construction of precast concrete for each individual section would possibly have been even more expensive.

From 1957 to 1963, the design team went through at least twelve iterations of the form of the shells trying to find an economically acceptable form (including schemes with parabolas, circular ribs and ellipsoids) before a workable solution was completed. The design work on the shells involved one of the earliest uses of computers in structural analysis, in order to understand the complex forces to which the shells would be subjected. In mid-1961, the design team found a solution to the problem: the shells all being created as sections from a sphere.

Stage III
The interiors started with Utzon moving his entire office to Sydney in February 1963. However, there was a change of government in 1965, and the new Robert Askin government declared the project under the jurisdiction of the Ministry of Public Works. This ultimately led to Utzon's resignation in 1966.

The cost of the project so far, even in October 1966, was still only $22.9 million, less than a quarter of the final $102 million cost. However, the projected costs for the design were at this stage much more significant.

The second stage of construction was progressing toward completion when Utzon resigned. His position was principally taken over by Peter Hall, who became largely responsible for the interior design. Other persons appointed that same year to replace Utzon were E. H. Farmer as government architect, D. S. Littlemore and Lionel Todd.

Following Utzon's resignation, the acoustic advisor, Lothar Cremer, confirmed to the Sydney Opera House Executive Committee (SOHEC) that Utzon's original acoustic design only allowed for 2000 seats in the main hall and further stated that increasing the number of seats to 3000 as specified in the brief would be disastrous for the acoustics.

Controversy

There was distinct controversy around this project. In mid 1965 a new Liberal government was elected in the State of NSW. The Minster of Works began questioning Utzon's designs, schedules and cost estimates and eventually stopped payments to Utzon. This accompanied by continual arguments, reached crisis point and Jorn Utzon resigned from the project, he left the country at the end of April 1966 with his family, never to return to see his masterpiece again. Following Utzon’s letter of resignation there were protests and marches through the streets of Sydney, demanding Utzon be reinstated as architect. The building was eventually completed by others in 1973.

Comments

Posted by yantramstudio | Saturday, July 22nd, 2017 | 09:55am
Lovely exterior design. Designing is such an art. And It should always appreciate.

Register to join to conversation.

(default) 41 queries took 287 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
2SELECT `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 11124
3SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
4SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
5UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-09-23 12:28:18', `modified` = '2019-09-23 12:28:18' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
6SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11112
7SELECT `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` = 'sydney-opera-house' AND `Architecture`.`deleted` = 0 LIMIT 1112
8SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-e514-450b-8667-0acfb372233b' 112
9SELECT `ArchitectureCondition`.`title` FROM `architecture_conditions` AS `ArchitectureCondition` WHERE `ArchitectureCondition`.`id` = '4b4640b6-a4b4-4492-a7cd-0ae3b372233b' 112
10SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948a-6424-4013-979f-41681030b5da' 112
11SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('4b463917-0fd0-4940-94b0-0a6bb372233b') 224
12SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('4b463917-0fd0-4940-94b0-0a6bb372233b') 112
13SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4bf23ac3-6768-49e6-b13e-87d7183d6281' 112
14SELECT `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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 335
15SELECT `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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 114
16SELECT `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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 131329
17SELECT `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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' ORDER BY `Version`.`version_id` desc LIMIT 1002
18SELECT `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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' AND `Version`.`version_id` IS NULL LIMIT 1002
19SELECT `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` <> '4b463917-0fd0-4940-94b0-0a6bb372233b' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'Opera') OR (`Article`.`tags` LIKE '%, Opera') OR (`Article`.`tags` LIKE '%, Opera, %') OR (`Article`.`tags` LIKE 'Opera, %') OR (`Article`.`tags` LIKE 'Expressionist') OR (`Article`.`tags` LIKE '%, Expressionist') OR (`Article`.`tags` LIKE '%, Expressionist, %') OR (`Article`.`tags` LIKE 'Expressionist, %') OR (`Article`.`tags` LIKE 'Cut Sphere') OR (`Article`.`tags` LIKE '%, Cut Sphere') OR (`Article`.`tags` LIKE '%, Cut Sphere, %') OR (`Article`.`tags` LIKE 'Cut Sphere, %')) ORDER BY Rand() ASC LIMIT 22237
20SELECT `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` = '58773272-4720-4e73-9029-3d506d7b5e1b' 112
21SELECT `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` = ('58773272-4720-4e73-9029-3d506d7b5e1b') ORDER BY `_order` asc, `created` asc 7730
22SELECT `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` = '587784a1-6fd8-461a-b4a2-51216d7b5e1b' 112
23SELECT `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` = ('587784a1-6fd8-461a-b4a2-51216d7b5e1b') ORDER BY `_order` asc, `created` asc 2240
24SELECT 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` = '4b463917-0fd0-4940-94b0-0a6bb372233b' ORDER BY `Comment`.`id` desc 113
25SELECT `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` = ('5973210c-a2a4-4126-b59c-6ca36d7b5e1b') ORDER BY `Comment`.`last_message_id` desc, `Comment`.`id` desc 112
26SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '58340c95-a1d8-4da6-b1b2-7d6a6d7b5e1b' 112
27SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 002
28SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 112
29SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 002
30SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 002
31SELECT `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` = '5973210c-a2a4-4126-b59c-6ca36d7b5e1b' AND `CommentsUser`.`mention_user_id` = `Mention`.`id`) 112
32SELECT `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` = '5973210c-a2a4-4126-b59c-6ca36d7b5e1b' ORDER BY `Comment`.`id` DESC 003
33SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 112
34SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' 112
35UPDATE `architectures` SET `id` = '4b463917-0fd0-4940-94b0-0a6bb372233b', `views` = 29175, `views_last_day` = 18, `views_last_week` = 324, `views_last_month` = 592, `last_viewed` = '2019-09-23 12:28:18', `modified` = '2016-03-02 14:14:31' WHERE `architectures`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b'13
36SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b463917-0fd0-4940-94b0-0a6bb372233b' AND `Architecture`.`deleted` <> 1 LIMIT 1112
37SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '4ca09256-a7cc-4067-bc27-4339183d6281' AND `Architecture`.`deleted` <> 1 116
38UPDATE `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` = 6 WHERE `User`.`id` = '4ca09256-a7cc-4067-bc27-4339183d6281'02
39UPDATE `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` = "29175", `Article`.`views_last_day` = "18", `Article`.`views_last_week` = "324", `Article`.`views_last_month` = "592", `Article`.`last_viewed` = "2019-09-23 12:28:18" WHERE `foreign_id` = '4b463917-0fd0-4940-94b0-0a6bb372233b'124
40SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Jørn Utzon' AND `Architect`.`deleted` <> 1 LIMIT 1112
41SELECT `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`, `Architecture`.`title`, `Architecture`.`slug`, `Architect`.`title`, `Architect`.`slug` FROM `images` AS `Image` LEFT JOIN `architectures` AS `Architecture` ON (`Image`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Image`.`foreign_id` = `Architect`.`id`) WHERE `Image`.`aiid` = 6256 LIMIT 11110