All Architecture

3 | 4 | 5 | 6 | 7 | 8 | 9 ... 71 | 72

The building opens out onto a newly-built square and has a courtyard-style entrance. The new health center, together with future council buildings, will shape a new urban space. The consulting area is a black prism covered with ceramic lattice which is supported from the ground floor. A single,..

Add to a collection

Bahn Tower

Berlin, Germany
by Helmut Jahn

In an attractive urban context on Potsdamer Platz, a modern architectural ensemble has been created in a characteristic triangular arrangement.

The Bahn Tower is the new headquarters of Deutsche Bahn AG, with the Sony-Center behind and one of the entrances to the new subterranean regional..

Add to a collection

Bailey House

Los Angeles, USA
by Pierre Koenig

The Bailey House or Case Study House #21 was registered as a Los Angeles Historic-Cultural Monument #669, with the endorsement of then owner Michael LaFetra, the Los Angeles Conservancy and Pierre and Gloria Koenig.
[h]The Case Study House Program[/h]
In January 1945 John Entenza, the editor..

Add to a collection

No More Information Available.

Add to a collection

No More Information Available.

Add to a collection

Bakema Tower

Berlin, Germany
by Jaap Bakema, ...

The Berlin house was only realized after 1959, but the layout and the model view were showed in the catalog of the Interbau of 1957. The complex offers a split-level system characterized by its internal structure and external effect: the floors are not simply stacked on top of one another, but..

Add to a collection

Bakhmetevsky Bus Garage was a public bus garage in Moscow, designed in 1926 by Konstantin Melnikov (floorplan concept and architectural design) and Vladimir Shukhov (structural engineering). The building, completed in 1927, was an example of applying avant-garde architectural methods to an..

Add to a collection

Baku Circus

Baku, Azerbaijan

In mid-50's, the architectural image of the country's capital was enriched by a number of interesting projects and was highly significant in terms of urban sites, such as the building the Baku circus and the Lenin Palace, now the Heydar Aliyev Palace.

Add to a collection

Baldi House can be considered, as explained in modern architecture Inhibitions, the manifesto of the "listening poetic" by Paolo Portoghesi. Next to the house are the remains of a Roman tomb, which over the centuries had made similar to a "trunk surrounded by a giant plant roots". Baldi house..

Add to a collection

Balfron Tower

London, United Kingdom
by Ernő Goldfinger

Balfron Tower was designed by architect Ernő Goldfinger and, like the nearby Robin Hood Gardens and Goldfinger's later similar but more famous Trellick Tower in west London, is associated with the Brutalist style of 1960s architecture.
[h]Design[/h]
Balfron Tower is 84 metres high and contains..

Add to a collection

The hotel contains of an already existing and a new building – both are designed to be in a constant dialogue without being dependent from each other.

The heart of the concept is the main lobby. By granting it a lot of open space we emphasize the importance of it.

Visitors have the..

Add to a collection

The Baltic Station market is located in north Tallinn between the city’s main railway station and the popular residential district of Kalamaja. The nostalgic market, famous since 1993 for offering exotic post-Soviet experiences - especially for tourists - was quite the attraction with its..

Add to a collection

Bàlvedere

Basle, Switzerland
by Baumraum

This treehouse was built amidst four fir trees in a private garden in a suburb of Basel, Switzerland. The client wished to have a point on his property which enabled him to see the city of Basel and the distant mountains of France. After climbing up three staircases and two landings, one arrives..

Add to a collection

In two weeks during 12.-25.1. 2009 fifteen NTNU Trondheim norwegian architect students designed and built a two storey library building for Safe Haven orphanage in Ban Tha Song Yan village near Burma border. The inhabitants of the orphanage are 42 Karen children of different age.

The workshop..

Add to a collection

The Banca Popolare di Verona is designed by Carlo Scarpa in collaboration with Arrigo Rudi, who has completed the master's work after his death. The building is located in the historic heart of Verona, and overlooks the Nogara Square.

Banca Popolare di Verona was completed after Scarpa’s death..

Add to a collection

Although physically separated from the rest of the city, the project area that can be read from many points of the city due to its high altitude. It also witnesses the transformation of the city while carrying traces from the past. It is now time for an urban transformation for Bandırma.
The..

Add to a collection

Banik Hotel

Pleso, Slovakia
by Ferdinand Konček

Banik Hotel is situated in the resort village Nové Štrbské Pleso in the high Tatras was designed by Ferdinand Konček, Ilija Skoček and Lubomír Tittl. The location gives opportunities for summer recreation because of the nearness of the Slovak mountains High Tatras has numbers of ski resort...

Add to a collection

Bank of China Tower

Hong Kong, China
by I. M. Pei

The Bank of China Tower (abbreviated BOC Tower) is one of the most recognisable skyscrapers in Admiralty, Hong Kong. It houses the headquarters for the Bank of China (Hong Kong) Limited. The building is located at 1 Garden Road, in Central and Western District on Hong Kong Island.

Designed by..

Add to a collection

Bar Babette

Berlin, Germany
by Josef Kaiser

This glass pavilion was erected as part of the second building section of the Karl-Marx-Allee project which was planned and constructed by a collective led by the architect Josef Kaiser. Originally it was planned as an exhibition space for arts and crafts from the Soviet Union. After the..

Add to a collection

The great natural entrance to the Caves of Hams in Mallorca houses a lush botanic garden. It is in this entrance that the bar is situated and made up of a piece of backlit glass of 15 metres in length.

The counter of the bar, the most important element of the project, is fitted into a..

Add to a collection

The New Terminal Area (NAT), designed by a consortium of Richard Rogers Partnership, the Spanish practice Estudio Lamela and two engineering companies TPS and Initec, will establish Madrid as a major European hub, and consolidate its position as the focal connection between Europe and Latin..

Add to a collection

Barbaros House

Izmir, Turkey
by Onurcan Cakir

Barbaros House is located in Barbaros Village of Urla, İzmir. On the upper east side of the building site, the techno park area of Izmir Institute of Technology is located. While designing the house, the main idea was to achieve a silent living space in a natural environment. Local stone and..

Add to a collection

Barbican estate

London, United Kingdom
by Chamberlin, Powell and Bon

The estate was built between 1965 and 1976, on a 35-acre (140,000 m2) site that was bombed in World War II.The complex was designed by architects Chamberlin, Powell and Bon, whose first work was the earlier, ground-breaking Golden Lane Estate immediately North of Barbican. The estate of 40 acres..

Add to a collection

The global project comprises the creation of a new botanical garden for the city of Barcelona, specializing in the flora characteristic of homogeneous climatic with the Mediterranean, such as California, Japan, Chile, South Africa and Australia.

The projected garden results from the layout of..

Add to a collection

The Botanical Institute building, a center dependent on the Higher Council of Scientific Research, is located at the Botanical Gardens on the Montjuïc mountainside, next to the Olympic Ring.

The building leans over the northwest wing of the garden, the area devoted to phyto-sections from the..

Add to a collection

The Barcelona Museum of Contemporary Art (Museu d'Art Contemporani de Barcelona, or MACBA) is situated in the Plaça dels Àngels, in El Raval, Ciutat Vella, Barcelona, Spain. The Gothic Quarter is a historically sensitive district of Barcelona and this museum played a major role in regeneration of..

Add to a collection

The Barcelona Olympic Stadium was built originally in 1927 for the International Exposition which took place in 1929. It was also built in hopes of getting the bid for the 1936 Summer Olympics which ended up going to the city of Berlin in Germany. The stadium was designed by Pere Domènech i..

Add to a collection

The Barcelona Pavilion, also known as the German Pavilion, designed by Ludwig Mies van der Rohe, as the German national Pavilion for the 1929 Barcelona International Exhibition. The Pavilion was conceived to accommodate the official reception presided over by King Alphonso XIII of Spain along..

Add to a collection

The Barceloneta Market located on the maritime part of Barcelona, designed by the practice of Josep Miàs Gifre, MIAS Architects.

It was an attempt to explain a reality and to offer a new and fuller meaning to an architectural project, beyond resolving a programme or commission. As early as..

Add to a collection

Barragan House and Studio

Mexico City, DF, Mexico
by Luis Barragán

Built in 1948, the House and Studio of architect Luis Barragán in the suburbs of Mexico City represents an outstanding example of the architect’s creative work in the post-Second World War period. The concrete building, totalling 1,161 m2, consists of a ground floor and two upper storeys, as well..

Add to a collection

Bartoli Home

Trieste, Italy
by Max Fabiani

Countess Muratti Bartoli comissioned Max Fabiani, an important figure among architects participating in the movement of Wien Secession, to design the building. Bartoli house was designed for both residential and commercial use. At the time, the ground floor housed a fabric store.

The large..

Add to a collection

Basento Viaduct

Potenza, Italy
by Sergio Musmeci

In the immediate postwar period, several talented engineers entered the fray with structural designs and formally managed to be technological innovators. One was the multi-talented Italian engineer Sergio Musmeci, whose best known work, the Viaduct Basento ,1967-1974, is one of the most..

Add to a collection

BASF Building

Mexico City, Mexico
by Gabriel Tellez, ...

The BASF corporate building is situated in Insurgentes Avenue, one of the most famous avenue in Mexico City.

The ground floor is of 1,315.0 m2 and each standard floor of approximately 942.0 m2. The shape has three differently-oriented squares brought together by a central core.

BASF's..

Add to a collection

Contrary to common belief, the world's largest Catholic church is to be found not in Rome but in Yamoussoukro, a small city in the war-torn African state of Côte d'Ivoire. The massive Basilica of Our Lady of Peace of Yamoussoukro, whose architecture is clearly inspired by the Basilica of St...

Add to a collection

Basque Pavilion

Carilo, Argentina
by Estudio Galera

A building at the back of an existing house and the re-functionalization of the own dwelling were the main issues of this project. Some basic operations define the search for a connection between the original building and the new one. A growing family, a change of uses and a fondness for..

Add to a collection

Case Study House #20 was designed by Conrad Buff, Calvin Straub, and Donald Hensman. This house was built in 1947 for Saul Bass and is located in Altadena, California.

In the case study house #20, the architects choose to use traditional and innovative material for its construction. Wood was..

Add to a collection

Bastei Restaurant

Cologne, Germany
by Wilhelm Riphahn

This restaurant on the Rhein in Cologne was designed by the local architect Wilhelm Riphahn.

Add to a collection

Stadt:Symbiont is a guideline for the autonomous creation of a central, durable and cost-effective working space in the city. Through re-interpretation of the parking regulations we adapt the space and reuse it as building site for our office. The periodic relocation enables a permanent..

Add to a collection

Bat Cone

Baghdad, Iraq

This unusual looking cone-shaped structure was once a pigeon cove located on the grounds of a palace former Iraqi dictator Sadaam Hussein built for one of his mistresses. Today the palace is a U.S. Army post called Camp Liberty (formerly known as Camp Victory North) and the pigeon cove is now a..

Add to a collection

Bat Yam Town Hall

Bat Yam, Israel
by Zvi Hecker, ...

Zvi Hecker founded a firm with Eldar Sharon (until 1964) and Alfred Neumann (until 1966). The physical and economic conditions in Israel at the time, allowed them to complete a fair number of works in a relatively brief period of time, which brought international attention.

Their joint works..

Add to a collection

BAŤA House of Shoes

Bratislava, Slovakia
by Vladimír Karfík

The Baťa department store is characterised primarily by its open interior plan and austere facade enlivened only by the lighted advertisements.

During the design, the architect was forced to rework the original conception so that the bulk of the store did not block the view of the historic..

Add to a collection

Batbridge

Monster, Netherlands
by Next Architects

The Vlotwateringbrug or popularly Batbridge has three specific components that provide roost for several bat species. At the north side the abutment functions as a winter stay. The deck and the brick balustrade accommodate stays for bats during the summer. The bridge design is intended to..

Add to a collection

Bathouse+Kursaal

Ostia Lido, Rome, Italy
by Pier Luigi Nervi

No More Information Available.

Add to a collection

Bauhaus Archiv

Berlin, Germany
by Walter Gropius

Stimulated by the euphoria around the commissioning of Mies van der Rohe for the construction of the New National Gallery 1962 in Berlin, Hans Maria Wingler, founding director of the Bauhaus Archive, asked Walter Gropius, the founding director of the original Bauhaus, if he would like to design a..

Add to a collection

Bauhaus Dessau

Dessau, Germany
by Walter Gropius

When the Bauhaus school was created in 1919, its founding manifesto stated that 'architecture was the fine arts' ultimate goal ("Das Endziel aller bildnerischen Tätigkeit ist der Bau") However, initially architecture was not taught at the school itself. Instead, the founder of the Bauhaus, Walter..

Add to a collection

Bauhaus Prellerhaus

Dessau-Roßlau, Germany
by Walter Gropius

The Prellerhaus is the name of the five-storey studio building in the Bauhaus Dessau. After its completion in 1926, the 28 studios were used by young masters and students as living and working space. Ludwig Mies van der Rohe had 1930 converted studios into large classrooms. In 2006 the house was..

Add to a collection

The building was erected in two construction phases in 1904 and 1910–1911 by Henry van de Velde as the premises of the Grand-Ducal Academy of Art of Saxony. Along with the ‘Winkelbau’, completed in 1905–1906, which originally housed the Grand-Ducal College of Applied Arts, headed by van de Velde,..

Add to a collection

Bavinger House

Oklahoma, USA
by Bruce Goff

The Bavinger House put a new twist on the naturalist modernism of Goff’s contemporaries. Where Wright used flat planes and conventional floor plans, Goff introduced distinctive floor plans, mixing materiality with eccentric spaces to produce a desired effect.

The walls are made of locally..

Add to a collection

Bayer AG Headquarters

Leverkusen, Germany
by Helmut Jahn

The semi-oval shape brings the Carl-Duisberg-Park into the building. With the addition of a long garden pergola to the north, the linear quality of the Kaiser-Wilhelm-Allee is maintained and further reinforced. The pergola also requires that those approaching the building pass through landscaping..

Add to a collection

Bayer Building Q30

Leverkusen, Germany
by Emil Fahrenkamp

Emil Fahrenkamp who designed several administrative for the Bayer AG in the 1930s was commissioned to design the building for the administration pharmaceutical activities of the gtoup. Today it houses the headquarters of the Bayer Healthcare division.

Add to a collection

3 | 4 | 5 | 6 | 7 | 8 | 9 ... 71 | 72

Contribute

(default) 31 queries took 1914 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architectures`63633
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';113
3SHOW FULL COLUMNS FROM `users`38383
4SHOW FULL COLUMNS FROM `roles`663
5SHOW FULL COLUMNS FROM `countries`333
6SHOW FULL COLUMNS FROM `states`33207
7SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 553
8SELECT `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 11162
9SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
10SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 113
11UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-09-22 12:48:41', `modified` = '2019-09-22 12:48:41' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
12SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11121
13SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` LEFT JOIN `countries` AS `Country` ON (`Architecture`.`country_id` = `Country`.`id`) WHERE `Architecture`.`deleted` = 0 1114
14SELECT `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 250, 50505081
15SELECT `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 ('594b8e1c-cb28-468b-adcc-2f4e6d7b5e1b', '5270c4c0-4b7c-45b3-978e-39d36d7b5f76', '51a7067a-c21c-4327-a36a-71e86d7b5f76', '5c17abfe-8aa4-466f-b7b7-43826d7b5e1b', '54228db4-79ac-44f0-ae14-1be96d7b5e1b', '4fb23b7e-0c78-4b61-82b5-17326d7b5f76', '4d75fcff-0844-4b44-9652-51926d7b5f76', '4eaebe28-357c-45b9-aba9-16ca6d7b5f76', '57a34323-6cc8-456f-b928-3d896d7b5e1b', '4b46391a-de44-4d01-9b0a-0a6bb372233b', '531d97d3-48d0-4722-807a-46a96d7b5e1b', '5a9eb163-04f4-4d46-8d00-16986d7b5e1b', '51b72b88-5778-4d61-8c9f-75e06d7b5f76', '4eb11cb7-5320-469b-88c3-5c1b6d7b5f76', '5320d1ef-021c-4868-ac81-2a2a6d7b5e1b', '5909cd6e-d890-434e-8178-2c896d7b5e1b', '594774f8-1924-4ac4-a8c2-3e2b6d7b5e1b', '554230e0-4784-4a82-931b-5ec86d7b5e1b', '4bf28c10-e280-4b0c-9a60-2e62183d6281', '5093a6f5-7a5c-4214-9f18-32fe6d7b5f76', '5018c4c0-8d38-4202-81b1-13246d7b5f76', '57275c7d-d22c-42ab-9134-0a306d7b5e1b', '4d7becb8-7b70-4888-98b7-214b6d7b5f76', '595bb88a-bb28-4dc1-8c1f-74a86d7b5e1b', '595bb468-4764-43f9-97d0-73e36d7b5e1b', '4b463919-6774-46ab-86e9-0a6bb372233b', '5852b9bf-5c40-41f8-9dc9-75a36d7b5e1b', '50bc9064-0c44-4cfb-a2a9-412a6d7b5f76', '4eb80c69-e6e0-4987-af71-2bc06d7b5f76', '4b46391a-62fc-4183-8cc0-0a6bb372233b', '588b3349-e23c-4d9d-aebc-4b7b6d7b5e1b', '5550affc-4504-4d21-bee4-3b876d7b5e1b', '53566c7f-8678-44ba-8515-553a6d7b5e1b', '5c8bf4d7-96fc-4df5-8800-73976d7b5e1b', '5d457b0e-26dc-464d-af5d-0fe06d7b5e1b', '51a756ec-3a40-483a-99eb-05ef6d7b5f76', '4b46391c-83e8-4eff-b87a-0a6bb372233b', '5784c979-fb78-4855-a923-64196d7b5e1b', '4f214d14-5818-4766-ab1f-6aec6d7b5f76', '51236b05-19a8-47b6-a8fa-61946d7b5f76', '5382ebee-670c-4369-88e7-2bbd6d7b5e1b', '59916117-a564-4f6a-a7dc-08f56d7b5e1b', '572082bf-cdf0-4b40-a265-384b6d7b5e1b', '4b463917-4604-45c3-bbad-0a6bb372233b', '4b46391d-0004-423f-841e-0a6bb372233b', '557374ed-9610-4016-a280-1eb46d7b5e1b', '55d8562c-5b5c-48bb-9dcc-5a006d7b5e1b', '574c37b2-2c60-4e58-9326-74216d7b5e1b', '4b46391d-5cb0-4aa3-a636-0a6bb372233b', '4b46391e-0e90-4b2c-ac20-0a6bb372233b') ORDER BY `_order` asc, `created` asc 3853851149
16SELECT `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 ('594b8e1c-cb28-468b-adcc-2f4e6d7b5e1b', '5270c4c0-4b7c-45b3-978e-39d36d7b5f76', '51a7067a-c21c-4327-a36a-71e86d7b5f76', '5c17abfe-8aa4-466f-b7b7-43826d7b5e1b', '54228db4-79ac-44f0-ae14-1be96d7b5e1b', '4fb23b7e-0c78-4b61-82b5-17326d7b5f76', '4d75fcff-0844-4b44-9652-51926d7b5f76', '4eaebe28-357c-45b9-aba9-16ca6d7b5f76', '57a34323-6cc8-456f-b928-3d896d7b5e1b', '4b46391a-de44-4d01-9b0a-0a6bb372233b', '531d97d3-48d0-4722-807a-46a96d7b5e1b', '5a9eb163-04f4-4d46-8d00-16986d7b5e1b', '51b72b88-5778-4d61-8c9f-75e06d7b5f76', '4eb11cb7-5320-469b-88c3-5c1b6d7b5f76', '5320d1ef-021c-4868-ac81-2a2a6d7b5e1b', '5909cd6e-d890-434e-8178-2c896d7b5e1b', '594774f8-1924-4ac4-a8c2-3e2b6d7b5e1b', '554230e0-4784-4a82-931b-5ec86d7b5e1b', '4bf28c10-e280-4b0c-9a60-2e62183d6281', '5093a6f5-7a5c-4214-9f18-32fe6d7b5f76', '5018c4c0-8d38-4202-81b1-13246d7b5f76', '57275c7d-d22c-42ab-9134-0a306d7b5e1b', '4d7becb8-7b70-4888-98b7-214b6d7b5f76', '595bb88a-bb28-4dc1-8c1f-74a86d7b5e1b', '595bb468-4764-43f9-97d0-73e36d7b5e1b', '4b463919-6774-46ab-86e9-0a6bb372233b', '5852b9bf-5c40-41f8-9dc9-75a36d7b5e1b', '50bc9064-0c44-4cfb-a2a9-412a6d7b5f76', '4eb80c69-e6e0-4987-af71-2bc06d7b5f76', '4b46391a-62fc-4183-8cc0-0a6bb372233b', '588b3349-e23c-4d9d-aebc-4b7b6d7b5e1b', '5550affc-4504-4d21-bee4-3b876d7b5e1b', '53566c7f-8678-44ba-8515-553a6d7b5e1b', '5c8bf4d7-96fc-4df5-8800-73976d7b5e1b', '5d457b0e-26dc-464d-af5d-0fe06d7b5e1b', '51a756ec-3a40-483a-99eb-05ef6d7b5f76', '4b46391c-83e8-4eff-b87a-0a6bb372233b', '5784c979-fb78-4855-a923-64196d7b5e1b', '4f214d14-5818-4766-ab1f-6aec6d7b5f76', '51236b05-19a8-47b6-a8fa-61946d7b5f76', '5382ebee-670c-4369-88e7-2bbd6d7b5e1b', '59916117-a564-4f6a-a7dc-08f56d7b5e1b', '572082bf-cdf0-4b40-a265-384b6d7b5e1b', '4b463917-4604-45c3-bbad-0a6bb372233b', '4b46391d-0004-423f-841e-0a6bb372233b', '557374ed-9610-4016-a280-1eb46d7b5e1b', '55d8562c-5b5c-48bb-9dcc-5a006d7b5e1b', '574c37b2-2c60-4e58-9326-74216d7b5e1b', '4b46391d-5cb0-4aa3-a636-0a6bb372233b', '4b46391e-0e90-4b2c-ac20-0a6bb372233b') AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 535379
17SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Unite d\'Habitation in Berlin' AND `Architecture`.`deleted` <> 1 LIMIT 11110
18SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Shigeru Ban' AND `Architect`.`deleted` <> 1 LIMIT 1113
19SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Robin Hood Gardens' AND `Architecture`.`deleted` <> 1 LIMIT 1114
20SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Trellick Tower' AND `Architecture`.`deleted` <> 1 LIMIT 111209
21SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Richard Meier' AND `Architect`.`deleted` <> 1 LIMIT 1113
22SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Ludwig Mies van der Rohe' AND `Architect`.`deleted` <> 1 LIMIT 1113
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`, `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` = 6248 LIMIT 11110
24SELECT `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` = 6249 LIMIT 11110
25SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Max Fabiani' AND `Architect`.`deleted` <> 1 LIMIT 1115
26SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Otto Wagner' AND `Architect`.`deleted` <> 1 LIMIT 1113
27SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Max Fabiani' AND `Architect`.`deleted` <> 1 LIMIT 1114
28SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Habitat 67' AND `Architecture`.`deleted` <> 1 LIMIT 1113
29SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Moshe Safdie' AND `Architect`.`deleted` <> 1 LIMIT 1112
30SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Haus am Horn' AND `Architecture`.`deleted` <> 1 LIMIT 1113
31SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Fagus Factory' AND `Architecture`.`deleted` <> 1 LIMIT 1113