Details

Keywords Change this

Modernism, New Objectivity

Birth date / place

August 5th 1899, Purmerend, The Netherlands

Selected Architecture


Practice / Active in Change this

Rotterdam, Netherlands

Linked to Change this

Ludwig Mies van der Rohe
Marcel Breuer
Johannes Andreas Brinkman

Mart Stam Change this

Change thisRotterdam, Netherlands
born 1899, Purmerend
1 of 2

About Change this

Mart Stam (August 5, 1899 – February 21, 1986) was a Dutch architect, urban planner, and furniture designer. Stam was extraordinarily well-connected, and his career intersects with important moments in the history of 20th-century European architecture, including chair design at the Bauhaus, the Weissenhof Estate, the Van Nelle Factory, an important modernist landmark building in Rotterdam, buildings for Ernst May's New Frankfurt housing project then to Russia with the idealistic May Brigade, to postwar reconstruction in Germany.

His style of design has been classified as New Objectivity, an art movement formed during the depression in 1920's Germany, as a counter-movement and an out growth of Expressionism.

Early life and education

Martinus Adrianus Stam was born in Purmerend, The Netherlands. Stam began working as a draftsman with an architectural firm in Rotterdam. He boldly stated between his qualification and first career that "We have to change the world." The architectural firm was run by the architect Granpré Molière. Molière was a traditionalist, and had a different style of design to Stam. He was imprisoned in 1920 for refusing to serve in the military, something which was compulsory in the Netherlands at that time. Fortunately, he was released in 1922.

Pre-War Berlin Years

Stam had moved to Berlin by the end of 1922, There he began to develop his New Objectivity style. His first major work in Berlin was under prominent architect Max Taut. Stam was assigned to design a variety of buildings across Germany, notably assisting Taut in the design of the German Trade Union Federation Building, Düsseldorf. During this time, he also worked with Russian avant-garde architect El Lissitzky. The pair's most striking design was the Wolkenbügel, or cloud iron, a t-shaped skyscraper supported on 3 metal framed columns. Although never built, the building was a vivid contrast to America's vertical building style, as the building only rose up a relatively modest height then expanded horizontally over an intersection so make better use of space. An illustration of it appeared on the front cover of Adolf Behne's book, Der Moderne Zweckbau, and articles on it written by Lissitzky appeared in an issue journal of ASNOVA, the Association of New Architects and in the German art journal Das Kunstblatt. He co-founded the magazine ABC Beitrage zum Bauen with architect Hans Schmidt, future Bauhaus director Hannes Meyer and El Lissitzky.

Stam is also credited for at least part of the design of the Van Nelle Factory in Rotterdam. This coffee and tea factory is still a powerful example of early modernist industrial architecture, recently rehabilitated into offices. After moving to Berlin, Stam devised a steel-tubing cantilever chair, using lengths of standard gas pipe and standard pipe joint fittings. New research indicates that Stam was inspired by a cantilever tubular steel seat seen installed in a 1926 Tatra T12 two-door saloon car. Ludwig Mies van der Rohe became aware of Stam's work on the chair during planning for the Weissenhof Siedlung and mentioned it to Marcel Breuer at the Bauhaus. This led almost immediately to variations on the cantilevered tubular-steel chair theme by both Mies van der Rohe and Marcel Breuer, and began an entire genre of chair design. In the late 1920s, Breuer and Stam were involved in a patent lawsuit in German courts, both claiming to be the inventor of the basic cantilever chair design principle. Stam won the lawsuit, and, since that time, specific Breuer chair designs have often been erroneously attributed to Stam. In the United States, Breuer assigned the rights to his designs to Knoll, and for that reason it is possible to find the identical chair attributed to Stam in Europe and to Breuer in the U.S.

Stam contributed a house to the 1927 Weissenhof Estate, the permanent housing project developed and presented by the exhibition Die Wohnung, organized by the Deutscher Werkbund in Stuttgart. This put him in the company of Le Corbusier, Peter Behrens, Bruno Taut, Hans Poelzig, and Walter Gropius, and the exhibition had as many as 20,000 visitors a day. In 1927 he became a founding member, with Gerrit Rietveld and Hendrik Petrus Berlage, of the Congrès Internationaux d`Architecture Moderne (CIAM).

In the late 1920s Stam was part of the team at the New Frankfurt project. In 1930 Stam became one of the 20 architects and urban planners organized by Frankfurt city planner Ernst May who traveled together to the Soviet Union to create a string of new Stalinist cities, including Magnitogorsk. The May Brigade included Austrian architect Margarete Schütte-Lihotzky, her husband Wilhelm Schütte, Arthur Korn, Erich Mauthner and Hans Schmidt. Stam moved to planning activities in Makeyevka in Ukraine in 1932, then to Orsk, with his friend Hans Schmidt (again) and with Bauhaus student and future wife Lotte Beese, then to the copper-mining Soviet city of Balgash. Stam returned to the Netherlands in 1934.

After World War II

Stam was later named director of the Institute of Industrial Art in the Netherlands. From 1948 to 1952 he moved to postwar Germany, with its major reconstruction projects. In 1948 he took a professorship at the Akademie der Bildenden Künste Dresden and began advocating a modern, strict structure for the heavily destroyed urban landscape, a plan which most of the citizens rejected as an "all-out attack on the identity of the city", and which would have obliterated most of the remaining landmarks. In 1950 Stam became director of the Advanced Institute of Art in Berlin. Returning to Amsterdam in 1953, Stam and his wife moved to Switzerland in about 1966 and withdrew from public view. He died, aged 86, in Zürich.

Sources

  • Wikipedia

Comments

Register to join to conversation.

(default) 82 queries took 435 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`22223
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`662
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 11132
40SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 113
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` = '2019-08-18 20:23:13', `modified` = '2019-08-18 20:23:13' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
43SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11111
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` = 'mart-stam' LIMIT 1119
45SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '4936948a-f700-4670-9721-4d641030b5da' 112
46SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('58e4ecbe-25dc-4395-91e3-19e86d7b5e1b') 114
47SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('58e4ecbe-25dc-4395-91e3-19e86d7b5e1b') ORDER BY `Timeline`.`date` asc 002
48SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('58e4ecbe-25dc-4395-91e3-19e86d7b5e1b') 332
49SELECT `User`.`title`, `User`.`slug` FROM `architects` AS `User` WHERE `User`.`id` = '4b463c04-a340-4d32-98b3-0a90b372233b' 112
50SELECT `User`.`title`, `User`.`slug` FROM `architects` AS `User` WHERE `User`.`id` = '4b463bfd-a350-4c4c-8f08-0a90b372233b' 112
51SELECT `User`.`title`, `User`.`slug` FROM `architects` AS `User` WHERE `User`.`id` = '4b463c03-c77c-45ce-93b1-0a90b372233b' 112
52SELECT `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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 223
53SELECT `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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 2228
54SELECT `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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1002
55SELECT `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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
56SELECT `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` <> '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' AND `Article`.`deleted` = 0 AND `Architect`.`biography` <> '' AND `Architect`.`tags` <> '' AND `Architect`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'New Objectivity') OR (`Article`.`tags` LIKE '%, New Objectivity') OR (`Article`.`tags` LIKE '%, New Objectivity, %') OR (`Article`.`tags` LIKE 'New Objectivity, %') OR (`Article`.`tags` LIKE 'Modernism') OR (`Article`.`tags` LIKE '%, Modernism') OR (`Article`.`tags` LIKE '%, Modernism, %') OR (`Article`.`tags` LIKE 'Modernism, %')) ORDER BY Rand() ASC LIMIT 22239
57SELECT `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` = '51dd5795-0efc-434a-b6c3-59896d7b5f76' 112
58SELECT `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` = ('51dd5795-0efc-434a-b6c3-59896d7b5f76') ORDER BY `_order` asc, `created` asc 1125
59SELECT `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` = '5860ef22-e854-4b58-ae9f-40686d7b5e1b' 112
60SELECT `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` = ('5860ef22-e854-4b58-ae9f-40686d7b5e1b') ORDER BY `_order` asc, `created` asc 1126
61SELECT 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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' ORDER BY `Comment`.`id` desc 002
62SELECT `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` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' ORDER BY `Architecture`.`views` desc LIMIT 6336
63SELECT `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` = '4eaa9031-6a7c-4465-9d45-43f36d7b5f76' 112
64SELECT `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` = ('4eaa9031-6a7c-4465-9d45-43f36d7b5f76') ORDER BY `_order` asc, `created` asc 121234
65SELECT `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` = '4b463919-e040-45d5-ac68-0a6bb372233b' 112
66SELECT `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` = ('4b463919-e040-45d5-ac68-0a6bb372233b') ORDER BY `_order` asc, `created` asc 2226
67SELECT `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` = '58e4ff1c-0160-4dbe-8836-1ba86d7b5e1b' 112
68SELECT `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` = ('58e4ff1c-0160-4dbe-8836-1ba86d7b5e1b') ORDER BY `_order` asc, `created` asc 2225
69SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' 112
70SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' 112
71UPDATE `architects` SET `id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b', `views` = 1512, `views_last_day` = 1, `views_last_week` = 1, `views_last_month` = 22, `last_viewed` = '2019-08-18 20:23:13', `modified` = '2017-04-05 13:59:57' WHERE `architects`.`id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b'13
72SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b' AND `Architect`.`deleted` <> 1 LIMIT 1112
73SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '52ff7855-3800-424e-affd-679b6d7b5e1b' AND `Architect`.`deleted` <> 1 115
74UPDATE `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` = 746 WHERE `User`.`id` = '52ff7855-3800-424e-affd-679b6d7b5e1b'02
75UPDATE `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` = "1512", `Article`.`views_last_day` = "1", `Article`.`views_last_week` = "1", `Article`.`views_last_month` = "22", `Article`.`last_viewed` = "2019-08-18 20:23:13" WHERE `foreign_id` = '58e4ecbe-25dc-4395-91e3-19e86d7b5e1b'123
76SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Van Nelle Factory' AND `Architecture`.`deleted` <> 1 LIMIT 1112
77SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Max Taut' AND `Architect`.`deleted` <> 1 LIMIT 1112
78SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'El Lissitzky' AND `Architect`.`deleted` <> 1 LIMIT 1112
79SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Ludwig Mies van der Rohe' AND `Architect`.`deleted` <> 1 LIMIT 1112
80SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Marcel Breuer' AND `Architect`.`deleted` <> 1 LIMIT 1112
81SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Ernst May' AND `Architect`.`deleted` <> 1 LIMIT 1112
82SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Margarete Schütte-Lihotzky' AND `Architect`.`deleted` <> 1 LIMIT 1112