All Architecture

2 | 3 | 4 | 5 | 6 | 7 | 8 ... 72 | 73

This house for guardians of a property near Paris, has been particularly interesting studies regarding the siting, design and overall volume of domestic distribution.
The first problem was to have this Annex according to the main house located at the lowest point of the ground and enjoying the..

Add to a collection

Atelier Fleuriste

Chieri, Italy
by Elastico

The project envisages two blocks that are very different from a formal point of view: one is concerned as a large showcase/plaza giving onto Andezeno street; the other is a sort of free-standing pavilion within the garden, which is open to the public and can be glimpsed from the road. The..

Add to a collection

This building is located on a 622 sq. meter piece of land, on a hill at the foot of Mt. Yatsugatake in Yamanashi, Japan. The small wooden house is called ‘Atelier for calligrapher’ and was designed by Japanese firm Kochi Architect’s Studio.

With a compact 62 square meter floor space, this..

Add to a collection

The Atelier in Oyodo designed by Tadao Ando is a seven-storey property with two basement floors for the junior staff.

When designing this space, he had in mind Piranesi’s drawings, The Prisons. The atrium walls decked with a spectacular array of quality art hardbacks. Applying his own office..

Add to a collection

This is an atelier for a doll artist and a residence of the couple. The request was an atelier that can be used as a gallery at the same time functioning as a doll-making studio. Additionally, it should be a space where her friends, who are often invited, can be gathered around pleasantly. In the..

Add to a collection

There are as many ideas as there are organism. The parallel strategy of surviving with the unparalleled ways of practicality highlights the distinct features of sustaining life for more than three billion years ago. To provide meaningful architecture is not to parody history but to articulate it...

Add to a collection

Atherton Gardens estate in Fitzroy, Melbourne was built by the Housing Commission of Victoria between the mid 1960s and 1971. Following World War II the government embarked on a development program to raise living conditions throughout the city. Several housing estates were built across Melbourne..

Add to a collection

The Atherton Gardens Estate extension project came after the Australian Federal Government gave funding to the Victorian State Government as part of the Housing Affordability Fund.

In 2010 planning approval was granted for 152 new homes to be developed as part of the existing Atherton Gardens..

Add to a collection

The Atlanta Marriott Marquis is a 52-story, 168.86 m (554.0 ft) Marriott hotel in Atlanta, Georgia. It is the 14th tallest skyscraper in the city. The building was designed by Atlanta architect John C. Portman, Jr. with construction completed in 1985, and because of its bulging base, it is often..

Add to a collection

In October of 1954, Popular Mechanics contained an article entitled "At Home, 2004 A.D.", in which Paul Laszlo's concept of Atomville and the home of the future were described in detail.

The city would be laid out with all the city streets concentric circles and major highways like the spokes..

Add to a collection

Atrium Cinema

Budapest, Hungary
by Lajos Kozma

Right after the 32nd Hungarian Filmfestival, the Atrium Cinema - which was called 1st of May Cinema for years - closed its red curtains. However during the Filmfestival the old, well-thumbed Cinema attracted the public with its graceful, retro style and spirit. The Atrium Cinema is one of the two..

Add to a collection

The Atsushi Imai Memorial Gymnasium was designed for a hospital in the city of Odate in the mountainous Akita region of northern Japan.
Named after the hospital's founder, it was commissioned to give patients a place to exercise in winter, when the region receives an average of 2-3 m of snow...

Add to a collection

The project responds to the features that its location provides. On the one hand, it reacts to the need to create ties with the urban tissue, while, on the other hand, there is the desire to maintain the expressiveness of its natural setting. This produces a dialectic relationship between the..

Add to a collection

Auditorium Atlantida

Barcelona, Spain
by Josep Llinas

Auditorium Atlantida is an extension to an existing music school and include a theatre, an auditorium and restaurant. The facade features copper-aluminium alloy panels.

In relation to the location, the site is placed between the boundary of the consolidated town and the future expansion areas...

Add to a collection

The Parco della Musica is a large public music complex on the north side of Rome, exploiting a spacious site that was part of the 1960 Olympic area. It is composed of three separate giant bug-like halls whose forms are inspired by musical instruments.

Positioned around an open air..

Add to a collection

The Aula of the Technical University in Delft located on the north side of the campus was built from 1959 to 1966 by the Dutch practice Van den Broek & Bakema. The building houses an auditorium with 1300 seats, four trapezoid lecture halls with 250 to 350 seats, the senate hall and the university..

Add to a collection

Aurland Lookout

Aurland, Norway
by Todd Saunders, ...

Designed by two architects Todd Saunders & Tommie Wilhelmsen, the 33-metre “diving board” shooting out from the road into thin air above the Aurland Fjord in Norway. This Aurland Lookout project is part of a national program on tourist routes commissioned by the Norwegian Highway Department.
Add to a collection

Aurora Resort Hotels

Cap Aurora, Romania
by Dinu Gheorghiu

Completed in 1973, Aurora is the newest resort of the Romanian socialist leisure development to be built. With an original capacity of 2,700 bed-places, it is amongst the smallest resorts, but it easily stands out due to its distinctive architecture.

Designed by architect Dinu Gheorghiu,..

Add to a collection

Auroville

Auroville, India
by Roger Anger

Auroville (City of Dawn) is an experimental township in Viluppuram district mostly in the state of Tamil Nadu, India with some parts in the Union Territory of Puducherry in South India. It was founded in 1968 by Mirra Alfassa (known as "the Mother") and designed by architect Roger Anger. As..

Add to a collection

An architectural statement, inspired by the techniques and geometrical rigour of boat building.

Add to a collection

The Australian Red Cross Blood Service Melbourne Processing Centre is the largest blood processing facility in the Southern Hemisphere. It was designed by DesignInc Melbourne and completed in April 2012.

The new Centre has 17,500m2 of accommodation comprised of blood processing and..

Add to a collection

The Austrian Cultural Forum tower is the first major United States project for Austrian-born New York architect Raimund Abraham. The competition was held in 1992, the building was completed in 2002.

Twenty-five feet wide and 81 feet deep, glazed with dramatic glass panels, the 24-story..

Add to a collection

The Austrian Film Museum is famous for its „Invisible Cinema“, in which the physical space of the auditorium disappears into the black in favour of the projection to be the only space of experience in this movie theatre. The new construction for the Austrian Film Museum works complementary to the..

Add to a collection

German office rasmussen | brunke | sauer sesigned a new administrative building for BSU in Hamburg, Germany. It was an invited competition and they won the first prize ex aequo with three other offices (Sauerbruch Hutton, Behnisch Architects and GAP).

This administrative and commercial..

Add to a collection

Auto Haus

Austin, Texas, USA
by Matt Fajkus

One of the key main focus of this project is a high level of security. Another main consideration was making sure that the walls have a high fire rating to ensure the integrity of the structure and adjoining residence from any internal fires.

The surrounding space was also conditioned and the..

Add to a collection

AutoCAD Drafting India

Ahmedabad, India

AutoCAD Drafting India is a leading engineering design support providing company headquartered in India with a skilled workforce of 700+ professionals and excellent infrastructure capabilities.

With a successful execution of 1200+ projects over a span of 10 years, the Company primarily..

Add to a collection

Autogrill

Limena (Padua), Italy
by Pier Luigi Nervi, ...

The Autogrill is a true icon of the economic rebirth of Italy Its modernity and elegance as a destination along the journey lends itself as both visually pleasant and also a representation of speed and growth of Italy in the 60s, becoming the manifestation of new ideas idea driving the nascent..

Add to a collection

No More Information Available.

Add to a collection

Automotive Service Center in Moscow was designed by one of the key architects of the Soviet period, Leonid Pavlov whose architecture featured grand urban scale in the spirit of Le Corbusier.
The building features a very contemporary form and looks somewhat like striving forward aircraft. The..

Add to a collection

AV Houses

São Paulo, Brazil
by Corsi Hirano Arquitetos

Two blocks face each other across the forecourt of this symmetrical housing development in São Paulo by local firm Corsi Hirano Arquitetos.

Situated in the outskirts of the city, Corsi Hirano Arquitetos split the eight social housing units into a pair of blocks either side of a large paved..

Add to a collection

Avala Tower

Belgrade, Serbia
by Uglješa Bogdanović

The Avala Tower (Serbian: Авалски торањ / Avalski toranj) is a 204.5 m (671 ft) tall telecommunication tower located on Avala mountain in the periphery of Belgrade. It was destroyed in NATO bombardment of Serbia on 29 April 1999. On 21 December 2006, the reconstruction of Avala Tower commenced..

Add to a collection

Avgust Černigoj was born in Trieste in 1898. He is one of the leading figures of the Slovenian historical avant-garde. He spent the last five years of his life in Lipica. The collection in the Gallery of August Černigoj in Lipica consists of over 1,400 works of art. About 400 works, currently on..

Add to a collection

Avianca Building

Bogotá, Colombia
by Germán Samper

The building for Avianca airline was the first highrise built in Bogota. It is located in front of Santander Park and is neighbored by three colonial churches as well as a repertoire of modern buildings. In spite of its massive size, 37 stories, and 4 basements, the freestanding structure is..

Add to a collection

The Awaji Yumebutai is a conference center, hotel and memorial in Awaji, Hyogo built in the wake of the 1995 Great Hanshin earthquake. Tadao Ando created this artificial landscape to showcase flowers of the region. The location is easily accessible from Kobe and Osaka via the Akashi Kaikyo..

Add to a collection

Ayelén School

Rancagua, Chile
by Alejandro Aravena

The Ayelén School was created by the NPO Fundación Impulsa to provide free access to quality education, in a country where access to good education greatly depends on family income.

Quality education is based on a clear methodological approach and architecture must contribute with spaces that..

Add to a collection

Ayios Dometios Check Point Residential Building

Nicosia, Λευκωσία, Lefkosia

Unliving along the Nicosia checkpoint

The building is part of the anonymous 1960s suburban modernist development of the Nicosia. It follows most of Le Corbusier’s five points of Architecture; free plan with piloti, facades independent from the structural system, ribbon windows and roof..

Add to a collection

Ayub National Hospital

Dhaka, Bangladesh
by Louis Kahn

When designing the National Assembly Building of Bangladesh, Kahn also designed the National Hospital. A Medical College was also included but the requirement changed into an examination room and staff hostel and was completed in 1969.

At the time Kahn also designed the Indian Institute of..

Add to a collection

Azadi Tower

Tehran, Iran
by Hossein Amanat

Commissioned to celebrate the 2500th anniversary of the Persian Empire, the Azadi Tower has been a site of celebration, unrest, and revolution. In 1966, the Shah (King), eager to display the wealth generated from oil exploration, and to distance himself from past political turmoil, held a..

Add to a collection

B018

Beirut, Lebanon
by Bernard Khoury

In the early 1998s, the B018 moved to the "Quarantaine", on a site that was better known for its macabre aura. The "Quarantaine" is located at the proximity of the port of Beirut. During the French protectorate, it was a place of quarantine for arriving crews. In the recent war it became the..

Add to a collection

BAAS Office

Barcelona, Spain
by BAAS Arquitectura

The space is on the ground floor of an apartment block where one of the last coal bunkers in Barcelona was located.
The inside height, approximately 2.5 meters under street level, allowed the construction of a metal and wood mezzanine at access level, taking advantage of the natural slope of the..

Add to a collection

Babel

Hildesheim, Germany
by ON/OFF

An installation presents how to bee connected within a heterogeneous society. It was executed in a festival taking place at the Marienfriedhof Cemetery in Hildesheim. They created a spacial framework for this research lab of understanding and common action. Other than spreading the activities..

Add to a collection

The bold idea to revive a former pedestrian underpass which was lined by abandoned shops and once connected Babenberger Straße and Burggarten was rewarded by a venturesome client who was seeking an extraordinary place for a new club. From street level, only four descending glass staircases are..

Add to a collection

This cinema was built in 1929 by architect Hans Poelzig, one of the leading representatives of the Modernist Movement in Germany. It is still used as a cinema today and is one of the few remaining buildings by this architect in Berlin.

Add to a collection

The Babyn Yar Holocaust Memorial Landscape Design proposal was conceived as a site-specific reaction to the disappearance and destruction of almost all traces of the massacres of more than 100.000 Jews and other victims of the Nazi occupation in Kiev in 1941-43. After the 1990 and as a reaction..

Add to a collection

Originally constructed between 1958 and 1961, Felix Candela and Ludwig Mies Van Der Rohe designed the corporate office building, bottling plant and ageing cellars of Bacardi & Co.
[h]Structure[/h]
The original cover of the bottler was composed of three vaults hypars, adjacent edges of 4 cm..

Add to a collection

The proposed Bacardi Rum Company Headquarters was designed by Ludwig Mies van der Rohe in 1957. The new office headquarters was to be built in Santiago, Cuba, however with the 1959 Cuban revolution, the building was never realised.

Elements from the Bacardi HQ's design have been re-used for..

Add to a collection

No More Information Available.

Add to a collection

Bachstelze

Eberschwang, Austria
by Baumraum

Eberschwang is a small community in Austria’s Innkreis, between the cities of Salzburg and Linz. The clients wanted to have the treehouse built beside a small stream on the southern edge of their property. It was also important to the family that, from the treehouse, one could see the main house..

Add to a collection

Backpack House

Leipzig, Köln, Essen
by Stefan Eberstadt

The Backpack House designed by Stefan Eberstadt, is mobile parasite on residential buildings.

Perched between art and architecture, form and function, the Backpack House is a walk-in sculpture with its own spatial quality. A hovering illuminated space that looks like a cross between temporary..

Add to a collection

This is a swimming pool constructed on the site of a former train station in Berlin, Kreuzberg.

Add to a collection

2 | 3 | 4 | 5 | 6 | 7 | 8 ... 72 | 73

Contribute

(default) 22 queries took 560 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
2SHOW FULL COLUMNS FROM `likes`552
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
4SELECT `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
5SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
6SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
7UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-11-20 20:49:33', `modified` = '2019-11-20 20:49:33' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
8SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11110
9SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` LEFT JOIN `countries` AS `Country` ON (`Architecture`.`country_id` = `Country`.`id`) WHERE `Architecture`.`deleted` = 0 1117
10SELECT `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`, `Country`.`id`, `Country`.`name`, `Country`.`user_count` FROM `architectures` AS `Architecture` LEFT JOIN `countries` AS `Country` ON (`Architecture`.`country_id` = `Country`.`id`) WHERE `Architecture`.`deleted` = 0 ORDER BY `title` asc LIMIT 200, 50505093
11SELECT `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` IN ('5167f05d-aa0c-41b8-bb52-20156d7b5f76', '5937e48e-6dd4-4bb0-ad92-7a6b6d7b5e1b', '50367344-1bcc-4755-985f-7dbf6d7b5f76', '51090f83-bbf8-44f8-8903-3da26d7b5f76', '53daac6b-b650-4672-a30f-02206d7b5e1b', '5a707a4d-68d0-4af9-858d-3eb66d7b5e1b', '56d1004b-66e8-4df9-972f-1c686d7b5e1b', '56d10c0e-4abc-4d21-bb7b-3c066d7b5e1b', '545a1d5c-34f0-4df4-8eec-0c466d7b5e1b', '4ea56592-2044-46d3-a90d-4d916d7b5f76', '4e9351d9-6094-4ba9-a2b3-5b476d7b5f76', '51499937-47d0-42d1-bb0d-0e3a6d7b5f76', '593e6d2f-875c-40c9-8e36-45556d7b5e1b', '595a37d1-3a4c-4d48-8cf8-7c1f6d7b5e1b', '5149d941-183c-48ad-a86f-1ca46d7b5f76', '4cb3227c-3160-4fb8-beb0-1495183d6281', '4f39794c-19e0-47bf-8b09-73de6d7b5f76', '5a99b7bd-c908-439a-a6e2-25836d7b5e1b', '5b3640c8-f6a4-400a-9c2c-635d6d7b5e1b', '5b343c48-4d5c-42db-b86a-62486d7b5e1b', '528411ad-4d68-4c8c-a60d-7f676d7b5f76', '4b46391c-26f4-4d7b-aa37-0a6bb372233b', '5b386006-cc5c-4f3a-9386-6ac66d7b5e1b', '4e9bf6e6-76d4-4fd8-970c-0c3d6d7b5f76', '5ae1e69a-9eac-4baf-a70a-13da6d7b5e1b', '5b2a2cf1-5158-4686-b9ee-60186d7b5e1b', '5852561d-c3dc-4044-8b12-5af96d7b5e1b', '4e2614b3-6c50-43b9-b48b-1db96d7b5f76', '5002d77e-1e4c-4cd7-8628-6a9b6d7b5f76', '5220aa58-4a50-4769-8bb4-14c06d7b5f76', '5165663f-9a38-47e3-942d-68d56d7b5f76', '5c1c7bf3-374c-43de-b3f3-4ccb6d7b5e1b', '59303940-d668-405a-af05-6dfb6d7b5e1b', '51cc1911-2d64-481e-9d67-29466d7b5f76', '58e3a165-b060-4782-9084-1cec6d7b5e1b', '5be0b4e4-196c-4c53-b6e9-481a6d7b5e1b', '51c3f884-5168-4af5-a138-22216d7b5f76', '591cb235-4794-406c-8c33-5d116d7b5e1b', '5c3322b8-0d88-4e58-9d36-599e6d7b5e1b', '594b9108-f304-4fb9-bbf5-2f1f6d7b5e1b', '5c3302e3-242c-43e4-b2cf-49956d7b5e1b', '51d43104-b030-43e8-ab93-13c16d7b5f76', '4b46391c-5270-454b-841c-0a6bb372233b', '584afb67-9724-4f0e-9605-2ef36d7b5e1b', '4f5f7db6-6948-4d7c-9730-43516d7b5f76', '50c5e7ce-d6d0-4310-9cfb-728b6d7b5f76', '5a42343e-d998-46de-ab4a-1cb66d7b5e1b', '51b72a7c-7cf0-43d1-b22a-7bc56d7b5f76', '4eb3f22b-a680-40a3-b169-06b96d7b5f76', '4b463916-f368-47ec-8dcc-0a6bb372233b') ORDER BY `_order` asc, `created` asc 351351146
12SELECT `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`, `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` IN ('5167f05d-aa0c-41b8-bb52-20156d7b5f76', '5937e48e-6dd4-4bb0-ad92-7a6b6d7b5e1b', '50367344-1bcc-4755-985f-7dbf6d7b5f76', '51090f83-bbf8-44f8-8903-3da26d7b5f76', '53daac6b-b650-4672-a30f-02206d7b5e1b', '5a707a4d-68d0-4af9-858d-3eb66d7b5e1b', '56d1004b-66e8-4df9-972f-1c686d7b5e1b', '56d10c0e-4abc-4d21-bb7b-3c066d7b5e1b', '545a1d5c-34f0-4df4-8eec-0c466d7b5e1b', '4ea56592-2044-46d3-a90d-4d916d7b5f76', '4e9351d9-6094-4ba9-a2b3-5b476d7b5f76', '51499937-47d0-42d1-bb0d-0e3a6d7b5f76', '593e6d2f-875c-40c9-8e36-45556d7b5e1b', '595a37d1-3a4c-4d48-8cf8-7c1f6d7b5e1b', '5149d941-183c-48ad-a86f-1ca46d7b5f76', '4cb3227c-3160-4fb8-beb0-1495183d6281', '4f39794c-19e0-47bf-8b09-73de6d7b5f76', '5a99b7bd-c908-439a-a6e2-25836d7b5e1b', '5b3640c8-f6a4-400a-9c2c-635d6d7b5e1b', '5b343c48-4d5c-42db-b86a-62486d7b5e1b', '528411ad-4d68-4c8c-a60d-7f676d7b5f76', '4b46391c-26f4-4d7b-aa37-0a6bb372233b', '5b386006-cc5c-4f3a-9386-6ac66d7b5e1b', '4e9bf6e6-76d4-4fd8-970c-0c3d6d7b5f76', '5ae1e69a-9eac-4baf-a70a-13da6d7b5e1b', '5b2a2cf1-5158-4686-b9ee-60186d7b5e1b', '5852561d-c3dc-4044-8b12-5af96d7b5e1b', '4e2614b3-6c50-43b9-b48b-1db96d7b5f76', '5002d77e-1e4c-4cd7-8628-6a9b6d7b5f76', '5220aa58-4a50-4769-8bb4-14c06d7b5f76', '5165663f-9a38-47e3-942d-68d56d7b5f76', '5c1c7bf3-374c-43de-b3f3-4ccb6d7b5e1b', '59303940-d668-405a-af05-6dfb6d7b5e1b', '51cc1911-2d64-481e-9d67-29466d7b5f76', '58e3a165-b060-4782-9084-1cec6d7b5e1b', '5be0b4e4-196c-4c53-b6e9-481a6d7b5e1b', '51c3f884-5168-4af5-a138-22216d7b5f76', '591cb235-4794-406c-8c33-5d116d7b5e1b', '5c3322b8-0d88-4e58-9d36-599e6d7b5e1b', '594b9108-f304-4fb9-bbf5-2f1f6d7b5e1b', '5c3302e3-242c-43e4-b2cf-49956d7b5e1b', '51d43104-b030-43e8-ab93-13c16d7b5f76', '4b46391c-5270-454b-841c-0a6bb372233b', '584afb67-9724-4f0e-9605-2ef36d7b5e1b', '4f5f7db6-6948-4d7c-9730-43516d7b5f76', '50c5e7ce-d6d0-4310-9cfb-728b6d7b5f76', '5a42343e-d998-46de-ab4a-1cb66d7b5e1b', '51b72a7c-7cf0-43d1-b22a-7bc56d7b5f76', '4eb3f22b-a680-40a3-b169-06b96d7b5f76', '4b463916-f368-47ec-8dcc-0a6bb372233b') AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 565614
13SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Atherton Gardens Estate' AND `Architecture`.`deleted` <> 1 LIMIT 1115
14SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Frank Lloyd Wright' AND `Architect`.`deleted` <> 1 LIMIT 1112
15SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Mecanoo' AND `Architect`.`deleted` <> 1 LIMIT 1113
16SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Melchiorre Bega' AND `Architect`.`deleted` <> 1 LIMIT 1116
17SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Pier Luigi Nervi' AND `Architect`.`deleted` <> 1 LIMIT 111213
18SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'National Assembly Building of Bangladesh' AND `Architecture`.`deleted` <> 1 LIMIT 1113
19SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Indian Institute of Management' AND `Architecture`.`deleted` <> 1 LIMIT 1112
20SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Ludwig Mies van der Rohe' AND `Architect`.`deleted` <> 1 LIMIT 1113
21SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'New National Gallery' AND `Architecture`.`deleted` <> 1 LIMIT 1114
22SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Barcelona Pavilion' AND `Architecture`.`deleted` <> 1 LIMIT 1114