Events

Unfinished

Unfinished is a tour de force through Europe to shed limelight on the status quo of regional architecture. We meet with three generations of architects and engage them in public conversations to undig forgotten architectural gems, discuss perceived failures and try to trace the evolution of local architectural practice from the early 20th century to the present. For this ongoing endevour we partner with architecture institutions all over Europe. Our research will be, as always, made freely available on Architectuul.

(default) 29 queries took 112 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `users`38383
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SHOW FULL COLUMNS FROM `roles`662
4SHOW FULL COLUMNS FROM `countries`3311
5SHOW FULL COLUMNS FROM `states`332
6SHOW FULL COLUMNS FROM `auth_keys`772
7SHOW FULL COLUMNS FROM `auth_key_types`222
8SHOW FULL COLUMNS FROM `feeds`662
9SHOW FULL COLUMNS FROM `top_list_items`772
10SHOW FULL COLUMNS FROM `top_lists`552
11SHOW FULL COLUMNS FROM `architectures`63633
12SHOW FULL COLUMNS FROM `articles`22223
13SHOW FULL COLUMNS FROM `architects`54543
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
15SHOW FULL COLUMNS FROM `associates`662
16SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
17SHOW FULL COLUMNS FROM `images`22222
18SHOW FULL COLUMNS FROM `sources`772
19SHOW FULL COLUMNS FROM `timelines`662
20SHOW FULL COLUMNS FROM `hp_features`4410
21SHOW FULL COLUMNS FROM `object_views`552
22SHOW FULL COLUMNS FROM `posts`882
23SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';112
24SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
25SELECT `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
26SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
27SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
28UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-12-08 21:20:41', `modified` = '2019-12-08 21:20:41' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
29SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11113