ARCHI-TECTONICS

NYC 2106 - A SYSTEMATIC APPROACH

EXHIBIT GRAND CENTRAL STATION NYC 2006 // Considering the future of New York, it is undeniable that its ancient technology needs thorough replacement, and not fixing. We propose two major insertions to reduce pressure on the island of Manhattan: a new system of floating islands and an offshore dual traffic system, which simultaneously provides renewable energy for the urban region. Manhattan, now one of the islands, in a natural floodscape of new artificial islands York, it will be free to become what it wants to be: a relaxed urban landscape where living is easy and tourism celebrated. In this proposal, we envision the future of New York City as transformed in four fundamental ways:

A network of artificial floating islands will fill the upper Hudson Bay, stitching together the five boroughs with New Jersey, and creating a distinct landscape for the New York of 2106. As semi-international zones, the islands provide for an open economy, tax-free shopping, and a new international personal travel hub.

These new islands constitute a distributed landscape of urban productivity, providing for renewable energy resources while simultaneously capturing opportunities for a new typology of urban recreation.

Connecting these islands is an automated intra- urban transit system which will activate the river surface and diminish coast to coast distance, thus alleviating major traffic congestion from the heart of the city, and from poorly maintained highways and bridges. At the mouth of the harbor a new international transport hub provides vital connections for high speed global travel.

The island of Manhattan evolves to house mostly residential and tourist destinations. The City is serviced by a dynamic combination of ‘zip cars’ and ‘zip flats’ which can be either plugged or unplugged from the power grid, or a hybrid version of both.

INFO

Project Type: Urban Plan

Location: New York, NY

Status: Exhibition 2006

Design: Archi-Tectonics

Principal in charge: Winka Dubbeldam

Project Leader: Thomas Berry

Archi-Tectonics Team: Bittor Sanchez, Robert Mezquiti, Brian Holland, Owen Gerst, Patrick Wong, Monty Foreman, Greg Getman

SHARE twitter. facebook. tumblr. email.

prev next

0 / 0

download pdf
print project

Gallery Fullscreen

close share

facebook tumblr twitter email

prev next

(default) 52 queries took 912 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `containers`	12	12	3
2	DESCRIBE `contents`	20	20	3
3	DESCRIBE `content_types`	4	4	3
4	DESCRIBE `content_mappings`	9	9	3
5	DESCRIBE `assets`	26	26	3
6	DESCRIBE `tags`	15	15	3
7	DESCRIBE `news_items`	19	19	3
8	DESCRIBE `news_categories`	6	6	3
9	DESCRIBE `contacts`	45	45	4
10	DESCRIBE `contact_prefixes`	5	5	3
11	DESCRIBE `cities`	6	6	3
12	DESCRIBE `states`	6	6	3
13	DESCRIBE `countries`	5	5	3
14	DESCRIBE `companies`	23	23	3
15	DESCRIBE `company_types`	7	7	3
16	DESCRIBE `contact_types`	7	7	3
17	DESCRIBE `groups`	8	8	3
18	DESCRIBE `contacts_groups`	4	4	3
19	DESCRIBE `contacts_containers`	5	5	3
20	DESCRIBE `contacts_contents`	5	5	3
21	DESCRIBE `assets_contacts`	5	5	2
22	DESCRIBE `assets_news_items`	4	4	2
23	DESCRIBE `news_items_tags`	4	4	7
24	DESCRIBE `contacts_news_items`	4	4	2
25	DESCRIBE `contents_tags`	4	4	3
26	DESCRIBE `assets_tags`	4	4	6
27	DESCRIBE `campaigns`	37	37	3
28	DESCRIBE `campaign_clicks`	8	8	3
29	DESCRIBE `campaign_opens`	7	7	4
30	DESCRIBE `campaigns_contacts`	12	12	3
31	DESCRIBE `campaigns_contents`	8	8	3
32	DESCRIBE `projects`	27	27	3
33	DESCRIBE `item_types`	6	6	2
34	DESCRIBE `settings`	13	13	3
35	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`is_system`, `Setting`.`long_value`, `Setting`.`group`, `Setting`.`choices`, `Setting`.`value_type`, `Setting`.`owner`, `Setting`.`user_id` FROM `settings` AS `Setting` WHERE 1 = 1	5	5	2
36	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`published` = 1 AND `Container`.`deleted` = 0 ORDER BY `Container`.`position` ASC	53	53	7
37	SELECT `Contact`.`id`, `ContactsContainer`.`contact_id`, `ContactsContainer`.`container_id`, `ContactsContainer`.`created`, `ContactsContainer`.`modified`, `ContactsContainer`.`is_system` FROM `contacts` AS `Contact` JOIN `contacts_containers` AS `ContactsContainer` ON (`ContactsContainer`.`container_id` IN ('4fb174e6-d610-41e5-bd44-407d0a790aa9', '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9', '5006cf9a-056c-49c9-bf54-6eef0a557a36', '4faa9788-de20-49c7-9b70-1a640a790aa9', '4faa8c5a-f318-4ba1-8879-2bc00a790aa9', '4fb28450-2108-40c8-a523-407d0a790aa9', '4fbe681d-b7f8-42d2-94d2-7f850a660dbf', '4faadc21-1188-48ef-a737-7cd20a790aa9', '4ffd8f3c-6544-4ed0-859c-25cf0a557a36', '4faad6b1-31f0-46d7-913e-67420a790aa9', '500d5aae-5994-4fb7-a0eb-52530a557a36', '4fa9b671-01ac-4c22-afc4-43910a790aa9', '50a6a323-ea74-4021-bc81-2cef0ac4b3bf', '4fab0f2e-a0b0-4fa9-94c3-4dae0a790aa9', '4faabbf4-b1d4-4f7f-89e3-2ac80a790aa9', '4faad49d-1858-4ee8-8fde-673c0a790aa9', '4fab10c7-e6fc-437b-bb7f-4db10a790aa9', '4fa9acb2-bd50-4560-b308-5baa0a790aa9', '515df1c6-1c48-463a-b4e5-48f20a557a36', '50be2a14-bc6c-4812-822f-43bf0a557a36', '4fa9ed96-f934-4a26-a3f0-438b0a790aa9', '4faa9092-66bc-40ec-ba9f-1a620a790aa9', '4fb279f9-4b28-4397-8bad-1b6e0a790aa9', '4fb27ec7-91a0-4791-b43a-407f0a790aa9', '50100dc8-f804-4c3d-984f-52550a557a36', '4fb178d5-9810-4930-b466-407f0a790aa9', '4faaa7ae-e4d0-4a93-acb2-1a620a790aa9', '4fb2ab6a-866c-4b59-a8f1-31710a790aa9', '4faadd74-2b54-4fa4-a1e9-7cd30a790aa9', '5006f5c7-fa38-4719-a1f2-684f0a557a36', '4fa9e82c-d35c-47cb-af65-438e0a790aa9', '4faa907b-5ef8-4e44-80b9-1a670a790aa9', '4faab7a2-70f8-4007-b947-2bc00a790aa9', '4faadf1a-0428-4684-a30b-7cd30a790aa9', '4faaaf4f-b2f0-42c5-80bf-2ac80a790aa9', '4faab409-8778-4004-9bcc-1a640a790aa9', '500060d4-33ec-4f7d-a1c4-58f70a557a36', '4faaad5c-e7cc-4a35-af74-1a670a790aa9', '5086effc-1f20-466d-88ba-4ed10ae2f966', '4fab16fa-c91c-47b8-904c-4db00a790aa9', '4faa8241-fa38-4611-b048-1a670a790aa9', '512fceb9-c6e4-4881-b7a0-7be20a557a36', '4fad4057-ea14-4097-8de9-20af0a790aa9', '4fa9ea98-c668-4021-a2a4-43910a790aa9', '4faad8dd-27b0-44d5-baa4-7cd80a790aa9', '4fad5591-db1c-427d-8313-3a0f0a790aa9', '4faac9b9-e600-4eca-b674-67410a790aa9', '4faac56e-8aac-43c7-b655-67410a790aa9', '4fabc751-b548-4a25-be83-4dae0a790aa9', '4faaa411-b53c-4826-ac31-1a690a790aa9', '4faa7d07-5844-4973-974a-1a690a790aa9', '4faab2b5-be8c-47e8-8624-1a620a790aa9', '4faa8eb2-3994-4c47-9f0c-2f5f0a790aa9') AND `ContactsContainer`.`contact_id` = `Contact`.`id`)	2	2	3
38	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`filename`, `Content`.`slug`, `Artist`.`slug`, `Division`.`slug`, `TopFolder`.`slug`, `Content`.`published` FROM `tags` AS `Tag` INNER JOIN assets_tags AS AssetsTag ON AssetsTag.tag_id=Tag.id INNER JOIN assets AS Asset ON Asset.id=AssetsTag.asset_id INNER JOIN content_mappings AS ContentMappings ON ContentMappings.asset_id=Asset.id INNER JOIN contents AS Content ON Content.id=ContentMappings.content_id AND Content.deleted=0 INNER JOIN containers AS Artist ON Artist.id=Content.container_id AND Artist.published=1 AND Artist.deleted=0 INNER JOIN containers AS Division ON Division.id=Artist.parent_id AND Division.published=1 AND Division.deleted=0 LEFT JOIN containers AS TopFolder ON TopFolder.id=Division.parent_id WHERE `Tag`.`name` LIKE 'artistcover%' AND `Asset`.`deleted` = 0 AND `Asset`.`asset_type_id` = '1' ORDER BY `Tag`.`name` ASC	0	0	2
39	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`filename`, `Content`.`slug`, `Artist`.`slug`, `Division`.`slug`, `TopFolder`.`slug`, `Content`.`published` FROM `tags` AS `Tag` INNER JOIN assets_tags AS AssetsTag ON AssetsTag.tag_id=Tag.id INNER JOIN assets AS Asset ON Asset.id=AssetsTag.asset_id INNER JOIN content_mappings AS ContentMappings ON ContentMappings.asset_id=Asset.id INNER JOIN contents AS Content ON Content.id=ContentMappings.content_id AND Content.deleted=0 INNER JOIN containers AS Artist ON Artist.id=Content.container_id AND Artist.published=1 AND Artist.deleted=0 INNER JOIN containers AS Division ON Division.id=Artist.parent_id AND Division.published=1 AND Division.deleted=0 LEFT JOIN containers AS TopFolder ON TopFolder.id=Division.parent_id WHERE `Tag`.`name` LIKE 'divisioncover%' AND `Asset`.`deleted` = 0 AND `Asset`.`asset_type_id` = '1' ORDER BY `Tag`.`name` ASC, `Content`.`published` DESC	0	0	3
40	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `name` = 'Projects' AND `parent_id` IS NULL LIMIT 1	1	1	2
41	SELECT * FROM `containers` AS `Container` INNER JOIN contacts AS Contact ON Contact.id=Container.ref_id INNER JOIN projects AS Project ON Project.contact_id=Contact.id AND Project.is_published_web=1 INNER JOIN contact_types AS Phase ON Phase.id=Contact.contact_type_id WHERE `parent_id` = '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 ORDER BY `Container`.`position` DESC	46	46	39
42	SELECT * FROM `news_items` AS `NewsItem` INNER JOIN news_categories AS Category ON LOWER(Category.name LIKE 'press') AND Category.id=NewsItem.news_category_id INNER JOIN contacts_news_items AS ContactMapping ON ContactMapping.news_item_id = NewsItem.id INNER JOIN contacts AS Contact ON Contact.id=ContactMapping.contact_id INNER JOIN projects AS Project ON Project.contact_id=Contact.id INNER JOIN item_types AS ItemType ON ItemType.id=Project.item_type_id INNER JOIN containers AS Container ON Container.id=Project.container_id INNER JOIN assets_news_items AS AssetMapping ON AssetMapping.news_item_id=NewsItem.id INNER JOIN assets AS Asset on Asset.id=AssetMapping.asset_id LEFT OUTER JOIN contents AS Render ON Render.id=Project.render_content_id LEFT OUTER JOIN contents AS Construct ON Construct.id=Project.construct_content_id LEFT OUTER JOIN contents AS Complete ON Complete.id=Project.complete_content_id LEFT OUTER JOIN countries AS Country ON Country.id=Contact.country_id LEFT OUTER JOIN states AS State ON State.id=Contact.state_id WHERE `NewsItem`.`published` = 1 AND `NewsItem`.`deleted` = 0 GROUP BY `NewsItem`.`id` ORDER BY `NewsItem`.`item_date` DESC	75	75	695
43	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'projects' AND `Container`.`parent_id` IS NULL AND `Container`.`published` IN (1, 0) AND `Container`.`deleted` = 0 LIMIT 1	1	1	2
44	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'nyc-2106-a-systematic-approach' AND `Container`.`parent_id` = '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	1	1	3
45	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'diagram' AND `Container`.`parent_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	0	0	4
46	SELECT `Content`.`id`, `Content`.`container_id`, `Content`.`content_type_id`, `Content`.`name`, `Content`.`created`, `Content`.`modified`, `Content`.`position`, `Content`.`is_primary`, `Content`.`published`, `Content`.`deleted`, `Content`.`ref_id`, `Content`.`tag_list`, `Content`.`image_count`, `Content`.`video_count`, `Content`.`publication_date`, `Content`.`slug`, `Content`.`description`, `Content`.`parent_containers`, `Content`.`custom_url`, `Content`.`visible` FROM `contents` AS `Content` WHERE `Content`.`slug` = 'diagram' AND `Content`.`container_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Content`.`published` = 1 AND `Content`.`deleted` = 0 LIMIT 1	1	1	2
47	SELECT `Content`.`id`, `Content`.`container_id`, `Content`.`content_type_id`, `Content`.`name`, `Content`.`created`, `Content`.`modified`, `Content`.`position`, `Content`.`is_primary`, `Content`.`published`, `Content`.`deleted`, `Content`.`ref_id`, `Content`.`tag_list`, `Content`.`image_count`, `Content`.`video_count`, `Content`.`publication_date`, `Content`.`slug`, `Content`.`description`, `Content`.`parent_containers`, `Content`.`custom_url`, `Content`.`visible` FROM `contents` AS `Content` WHERE `Content`.`container_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Content`.`deleted` = 0 AND `Content`.`published` = 1 ORDER BY `Content`.`position` ASC	4	4	4
48	SELECT `ContentMapping`.`asset_id`, `ContentMapping`.`content_id`, `ContentMapping`.`position`, `ContentMapping`.`is_primary`, `ContentMapping`.`created`, `ContentMapping`.`modified`, `ContentMapping`.`published`, `ContentMapping`.`division_id`, `ContentMapping`.`portfolio_id` FROM `content_mappings` AS `ContentMapping` WHERE `ContentMapping`.`published` = 1 AND `ContentMapping`.`content_id` IN ('4faadf1a-30d0-41a4-9718-7cd30a790aa9', '4faadf1a-7d1c-4674-809e-7cd30a790aa9', '4faadf1a-7bac-445a-a670-7cd30a790aa9', '50071d17-6f28-4606-a06d-68480a557a36')	21	21	4
49	SELECT *, ContentType.id, Container.id, `Content`.`id` FROM `contents` AS `Content` INNER JOIN containers AS ContentContainer ON ContentContainer.id = Content.container_id INNER JOIN contacts AS Contact ON Contact.id = ContentContainer.ref_id INNER JOIN projects AS Project ON Project.contact_id = Contact.id LEFT OUTER JOIN item_types AS ItemType ON ItemType.id = Project.item_type_id LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `containers` AS `Container` ON (`Content`.`container_id` = `Container`.`id`) WHERE `Content`.`id` = '4faadf1a-30d0-41a4-9718-7cd30a790aa9' LIMIT 1	1	1	4
50	SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9'	1	1	24
51	SELECT `ContentMapping`.`asset_id`, `ContentMapping`.`content_id`, `ContentMapping`.`position`, `ContentMapping`.`is_primary`, `ContentMapping`.`created`, `ContentMapping`.`modified`, `ContentMapping`.`published`, `ContentMapping`.`division_id`, `ContentMapping`.`portfolio_id` FROM `content_mappings` AS `ContentMapping` WHERE `ContentMapping`.`published` = 1 AND `ContentMapping`.`content_id` = ('4faadf1a-30d0-41a4-9718-7cd30a790aa9') ORDER BY `ContentMapping`.`position` ASC	0	0	2
52	SELECT `Container`., `Contact`., `Project`., `Country`., `Company`., `itemType`. FROM `containers` AS `Container` INNER JOIN contacts AS Contact ON Contact.id = Container.ref_id INNER JOIN projects AS Project ON Project.contact_id = Contact.id LEFT OUTER JOIN companies AS Company ON Contact.company_id = Company.id LEFT OUTER JOIN countries AS Country ON Country.id = Contact.country_id LEFT OUTER JOIN item_types AS itemType ON itemType.id = Project.item_type_id WHERE `Container`.`id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	1	1	3

(default) 52 queries took 912 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `containers`

DESCRIBE `contents`

DESCRIBE `content_types`

DESCRIBE `content_mappings`

DESCRIBE `assets`

DESCRIBE `tags`

DESCRIBE `news_items`

DESCRIBE `news_categories`

DESCRIBE `contacts`

DESCRIBE `contact_prefixes`

DESCRIBE `cities`

DESCRIBE `states`

DESCRIBE `countries`

DESCRIBE `companies`

DESCRIBE `company_types`

DESCRIBE `contact_types`

DESCRIBE `groups`

DESCRIBE `contacts_groups`

DESCRIBE `contacts_containers`

DESCRIBE `contacts_contents`

DESCRIBE `assets_contacts`

DESCRIBE `assets_news_items`

DESCRIBE `news_items_tags`

DESCRIBE `contacts_news_items`

DESCRIBE `contents_tags`

DESCRIBE `assets_tags`

DESCRIBE `campaigns`

DESCRIBE `campaign_clicks`

DESCRIBE `campaign_opens`

DESCRIBE `campaigns_contacts`

DESCRIBE `campaigns_contents`

DESCRIBE `projects`

DESCRIBE `item_types`

DESCRIBE `settings`

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`is_system`, `Setting`.`long_value`, `Setting`.`group`, `Setting`.`choices`, `Setting`.`value_type`, `Setting`.`owner`, `Setting`.`user_id` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`published` = 1 AND `Container`.`deleted` = 0 ORDER BY `Container`.`position` ASC

SELECT `Contact`.`id`, `ContactsContainer`.`contact_id`, `ContactsContainer`.`container_id`, `ContactsContainer`.`created`, `ContactsContainer`.`modified`, `ContactsContainer`.`is_system` FROM `contacts` AS `Contact` JOIN `contacts_containers` AS `ContactsContainer` ON (`ContactsContainer`.`container_id` IN ('4fb174e6-d610-41e5-bd44-407d0a790aa9', '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9', '5006cf9a-056c-49c9-bf54-6eef0a557a36', '4faa9788-de20-49c7-9b70-1a640a790aa9', '4faa8c5a-f318-4ba1-8879-2bc00a790aa9', '4fb28450-2108-40c8-a523-407d0a790aa9', '4fbe681d-b7f8-42d2-94d2-7f850a660dbf', '4faadc21-1188-48ef-a737-7cd20a790aa9', '4ffd8f3c-6544-4ed0-859c-25cf0a557a36', '4faad6b1-31f0-46d7-913e-67420a790aa9', '500d5aae-5994-4fb7-a0eb-52530a557a36', '4fa9b671-01ac-4c22-afc4-43910a790aa9', '50a6a323-ea74-4021-bc81-2cef0ac4b3bf', '4fab0f2e-a0b0-4fa9-94c3-4dae0a790aa9', '4faabbf4-b1d4-4f7f-89e3-2ac80a790aa9', '4faad49d-1858-4ee8-8fde-673c0a790aa9', '4fab10c7-e6fc-437b-bb7f-4db10a790aa9', '4fa9acb2-bd50-4560-b308-5baa0a790aa9', '515df1c6-1c48-463a-b4e5-48f20a557a36', '50be2a14-bc6c-4812-822f-43bf0a557a36', '4fa9ed96-f934-4a26-a3f0-438b0a790aa9', '4faa9092-66bc-40ec-ba9f-1a620a790aa9', '4fb279f9-4b28-4397-8bad-1b6e0a790aa9', '4fb27ec7-91a0-4791-b43a-407f0a790aa9', '50100dc8-f804-4c3d-984f-52550a557a36', '4fb178d5-9810-4930-b466-407f0a790aa9', '4faaa7ae-e4d0-4a93-acb2-1a620a790aa9', '4fb2ab6a-866c-4b59-a8f1-31710a790aa9', '4faadd74-2b54-4fa4-a1e9-7cd30a790aa9', '5006f5c7-fa38-4719-a1f2-684f0a557a36', '4fa9e82c-d35c-47cb-af65-438e0a790aa9', '4faa907b-5ef8-4e44-80b9-1a670a790aa9', '4faab7a2-70f8-4007-b947-2bc00a790aa9', '4faadf1a-0428-4684-a30b-7cd30a790aa9', '4faaaf4f-b2f0-42c5-80bf-2ac80a790aa9', '4faab409-8778-4004-9bcc-1a640a790aa9', '500060d4-33ec-4f7d-a1c4-58f70a557a36', '4faaad5c-e7cc-4a35-af74-1a670a790aa9', '5086effc-1f20-466d-88ba-4ed10ae2f966', '4fab16fa-c91c-47b8-904c-4db00a790aa9', '4faa8241-fa38-4611-b048-1a670a790aa9', '512fceb9-c6e4-4881-b7a0-7be20a557a36', '4fad4057-ea14-4097-8de9-20af0a790aa9', '4fa9ea98-c668-4021-a2a4-43910a790aa9', '4faad8dd-27b0-44d5-baa4-7cd80a790aa9', '4fad5591-db1c-427d-8313-3a0f0a790aa9', '4faac9b9-e600-4eca-b674-67410a790aa9', '4faac56e-8aac-43c7-b655-67410a790aa9', '4fabc751-b548-4a25-be83-4dae0a790aa9', '4faaa411-b53c-4826-ac31-1a690a790aa9', '4faa7d07-5844-4973-974a-1a690a790aa9', '4faab2b5-be8c-47e8-8624-1a620a790aa9', '4faa8eb2-3994-4c47-9f0c-2f5f0a790aa9') AND `ContactsContainer`.`contact_id` = `Contact`.`id`)

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`filename`, `Content`.`slug`, `Artist`.`slug`, `Division`.`slug`, `TopFolder`.`slug`, `Content`.`published` FROM `tags` AS `Tag` INNER JOIN assets_tags AS AssetsTag ON AssetsTag.tag_id=Tag.id INNER JOIN assets AS Asset ON Asset.id=AssetsTag.asset_id INNER JOIN content_mappings AS ContentMappings ON ContentMappings.asset_id=Asset.id INNER JOIN contents AS Content ON Content.id=ContentMappings.content_id AND Content.deleted=0 INNER JOIN containers AS Artist ON Artist.id=Content.container_id AND Artist.published=1 AND Artist.deleted=0 INNER JOIN containers AS Division ON Division.id=Artist.parent_id AND Division.published=1 AND Division.deleted=0 LEFT JOIN containers AS TopFolder ON TopFolder.id=Division.parent_id WHERE `Tag`.`name` LIKE 'artistcover%' AND `Asset`.`deleted` = 0 AND `Asset`.`asset_type_id` = '1' ORDER BY `Tag`.`name` ASC

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`filename`, `Content`.`slug`, `Artist`.`slug`, `Division`.`slug`, `TopFolder`.`slug`, `Content`.`published` FROM `tags` AS `Tag` INNER JOIN assets_tags AS AssetsTag ON AssetsTag.tag_id=Tag.id INNER JOIN assets AS Asset ON Asset.id=AssetsTag.asset_id INNER JOIN content_mappings AS ContentMappings ON ContentMappings.asset_id=Asset.id INNER JOIN contents AS Content ON Content.id=ContentMappings.content_id AND Content.deleted=0 INNER JOIN containers AS Artist ON Artist.id=Content.container_id AND Artist.published=1 AND Artist.deleted=0 INNER JOIN containers AS Division ON Division.id=Artist.parent_id AND Division.published=1 AND Division.deleted=0 LEFT JOIN containers AS TopFolder ON TopFolder.id=Division.parent_id WHERE `Tag`.`name` LIKE 'divisioncover%' AND `Asset`.`deleted` = 0 AND `Asset`.`asset_type_id` = '1' ORDER BY `Tag`.`name` ASC, `Content`.`published` DESC

SELECT * FROM `containers` AS `Container` INNER JOIN contacts AS Contact ON Contact.id=Container.ref_id INNER JOIN projects AS Project ON Project.contact_id=Contact.id AND Project.is_published_web=1 INNER JOIN contact_types AS Phase ON Phase.id=Contact.contact_type_id WHERE `parent_id` = '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 ORDER BY `Container`.`position` DESC

SELECT * FROM `news_items` AS `NewsItem` INNER JOIN news_categories AS Category ON LOWER(Category.name LIKE 'press') AND Category.id=NewsItem.news_category_id INNER JOIN contacts_news_items AS ContactMapping ON ContactMapping.news_item_id = NewsItem.id INNER JOIN contacts AS Contact ON Contact.id=ContactMapping.contact_id INNER JOIN projects AS Project ON Project.contact_id=Contact.id INNER JOIN item_types AS ItemType ON ItemType.id=Project.item_type_id INNER JOIN containers AS Container ON Container.id=Project.container_id INNER JOIN assets_news_items AS AssetMapping ON AssetMapping.news_item_id=NewsItem.id INNER JOIN assets AS Asset on Asset.id=AssetMapping.asset_id LEFT OUTER JOIN contents AS Render ON Render.id=Project.render_content_id LEFT OUTER JOIN contents AS Construct ON Construct.id=Project.construct_content_id LEFT OUTER JOIN contents AS Complete ON Complete.id=Project.complete_content_id LEFT OUTER JOIN countries AS Country ON Country.id=Contact.country_id LEFT OUTER JOIN states AS State ON State.id=Contact.state_id WHERE `NewsItem`.`published` = 1 AND `NewsItem`.`deleted` = 0 GROUP BY `NewsItem`.`id` ORDER BY `NewsItem`.`item_date` DESC

695

SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'projects' AND `Container`.`parent_id` IS NULL AND `Container`.`published` IN (1, 0) AND `Container`.`deleted` = 0 LIMIT 1

SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'nyc-2106-a-systematic-approach' AND `Container`.`parent_id` = '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1

SELECT `Container`.`id`, `Container`.`name`, `Container`.`position`, `Container`.`created`, `Container`.`modified`, `Container`.`published`, `Container`.`deleted`, `Container`.`parent_id`, `Container`.`ref_id`, `Container`.`slug`, `Container`.`description`, `Container`.`tag_list` FROM `containers` AS `Container` WHERE `Container`.`slug` = 'diagram' AND `Container`.`parent_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1

SELECT `Content`.`id`, `Content`.`container_id`, `Content`.`content_type_id`, `Content`.`name`, `Content`.`created`, `Content`.`modified`, `Content`.`position`, `Content`.`is_primary`, `Content`.`published`, `Content`.`deleted`, `Content`.`ref_id`, `Content`.`tag_list`, `Content`.`image_count`, `Content`.`video_count`, `Content`.`publication_date`, `Content`.`slug`, `Content`.`description`, `Content`.`parent_containers`, `Content`.`custom_url`, `Content`.`visible` FROM `contents` AS `Content` WHERE `Content`.`slug` = 'diagram' AND `Content`.`container_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Content`.`published` = 1 AND `Content`.`deleted` = 0 LIMIT 1

SELECT `Content`.`id`, `Content`.`container_id`, `Content`.`content_type_id`, `Content`.`name`, `Content`.`created`, `Content`.`modified`, `Content`.`position`, `Content`.`is_primary`, `Content`.`published`, `Content`.`deleted`, `Content`.`ref_id`, `Content`.`tag_list`, `Content`.`image_count`, `Content`.`video_count`, `Content`.`publication_date`, `Content`.`slug`, `Content`.`description`, `Content`.`parent_containers`, `Content`.`custom_url`, `Content`.`visible` FROM `contents` AS `Content` WHERE `Content`.`container_id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Content`.`deleted` = 0 AND `Content`.`published` = 1 ORDER BY `Content`.`position` ASC

SELECT `ContentMapping`.`asset_id`, `ContentMapping`.`content_id`, `ContentMapping`.`position`, `ContentMapping`.`is_primary`, `ContentMapping`.`created`, `ContentMapping`.`modified`, `ContentMapping`.`published`, `ContentMapping`.`division_id`, `ContentMapping`.`portfolio_id` FROM `content_mappings` AS `ContentMapping` WHERE `ContentMapping`.`published` = 1 AND `ContentMapping`.`content_id` IN ('4faadf1a-30d0-41a4-9718-7cd30a790aa9', '4faadf1a-7d1c-4674-809e-7cd30a790aa9', '4faadf1a-7bac-445a-a670-7cd30a790aa9', '50071d17-6f28-4606-a06d-68480a557a36')

SELECT *, ContentType.id, Container.id, `Content`.`id` FROM `contents` AS `Content` INNER JOIN containers AS ContentContainer ON ContentContainer.id = Content.container_id INNER JOIN contacts AS Contact ON Contact.id = ContentContainer.ref_id INNER JOIN projects AS Project ON Project.contact_id = Contact.id LEFT OUTER JOIN item_types AS ItemType ON ItemType.id = Project.item_type_id LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `containers` AS `Container` ON (`Content`.`container_id` = `Container`.`id`) WHERE `Content`.`id` = '4faadf1a-30d0-41a4-9718-7cd30a790aa9' LIMIT 1

SELECT `ContentMapping`.`asset_id`, `ContentMapping`.`content_id`, `ContentMapping`.`position`, `ContentMapping`.`is_primary`, `ContentMapping`.`created`, `ContentMapping`.`modified`, `ContentMapping`.`published`, `ContentMapping`.`division_id`, `ContentMapping`.`portfolio_id` FROM `content_mappings` AS `ContentMapping` WHERE `ContentMapping`.`published` = 1 AND `ContentMapping`.`content_id` = ('4faadf1a-30d0-41a4-9718-7cd30a790aa9') ORDER BY `ContentMapping`.`position` ASC

SELECT `Container`.*, `Contact`.*, `Project`.*, `Country`.*, `Company`.*, `itemType`.* FROM `containers` AS `Container` INNER JOIN contacts AS Contact ON Contact.id = Container.ref_id INNER JOIN projects AS Project ON Project.contact_id = Contact.id LEFT OUTER JOIN companies AS Company ON Contact.company_id = Company.id LEFT OUTER JOIN countries AS Country ON Country.id = Contact.country_id LEFT OUTER JOIN item_types AS itemType ON itemType.id = Project.item_type_id WHERE `Container`.`id` = '4faadf1a-0428-4684-a30b-7cd30a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1

.about US

NYC 2106 - A SYSTEMATIC APPROACH