ARCHI-TECTONICS

Dub Residence

The 2500 sf Dub residence, located in the east of Holland, was conceived as the intersection of two basic volumes; a low stone volume flanking the street with a wooden T-volume crossing over and cantilevering out over the garden. Using prefabricated construction techniques, the Residence was constructed in 3 days and fully finished in 6 weeks. This short and predictable process eliminates the usual stress a client has related to unforeseen costs and unpredictable construction time. On the other hand it adds a high quality and precision to the construction and the engineering. The 15’ cantilever was essentially built as a wooden composite beam without the addition of any steel.

The stone ground floor volume contains living, dining, kitchen and master bed-, and bathrooms. Perched above the stone volume is the cantilevered second floor with a double-height atrium to the office, where one also finds storage rooms and the guestbed-, and bathrooms. This lightweight box of wood and glass is angled towards the garden and ends with a generous balcony. Its cantilever creates a shadowed terrace below directly off of the master bedroom.

ENERGY EFFICIENCY/LOW MAINTENANCE - The prefab panels provide a very high insulation level, which reduces energy consumption. The use of glass at strategic places allows for passive solar energy. The radiant floor system guarantees an efficient heating and cooling system. The choice of natural materials for the exterior promotes a natural ‘aging’ process and a very low maintenance level: untreated reclaimed Ipe siding for natural resistance to decay & weathering; reclaimed wood window & door framing with 1’ insulated glass units.

Prefabrication helped us to make the Dub Residence an affordable intelligent building with 6 weeks construction time.

INFO

Project Type: Custom Designed, Pre-Fabricated, Private Residence

Location: Rotterdam, Netherlands

Area: 2,500 sf // 232 m²

Status: Completed 2008

Design: Archi-Tectonics

Principal in charge: Winka Dubbeldam

Architect of Record: Pass Architektur

Photography: Archi-Tectonics

SHARE twitter. facebook. tumblr. email.

prev next

1 / 14

download pdf
print project

Gallery Fullscreen

close share

facebook tumblr twitter email

prev next

(default) 66 queries took 1305 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `containers`	12	12	1
2	DESCRIBE `contents`	20	20	2
3	DESCRIBE `content_types`	4	4	1
4	DESCRIBE `content_mappings`	9	9	1
5	DESCRIBE `assets`	25	25	2
6	DESCRIBE `tags`	15	15	1
7	DESCRIBE `news_items`	19	19	2
8	DESCRIBE `news_categories`	6	6	1
9	DESCRIBE `contacts`	45	45	2
10	DESCRIBE `contact_prefixes`	5	5	1
11	DESCRIBE `cities`	6	6	1
12	DESCRIBE `states`	6	6	1
13	DESCRIBE `countries`	5	5	11
14	DESCRIBE `companies`	23	23	2
15	DESCRIBE `company_types`	7	7	11
16	DESCRIBE `contact_types`	7	7	1
17	DESCRIBE `groups`	8	8	1
18	DESCRIBE `contacts_groups`	4	4	1
19	DESCRIBE `contacts_containers`	5	5	1
20	DESCRIBE `contacts_contents`	5	5	1
21	DESCRIBE `assets_contacts`	5	5	1
22	DESCRIBE `assets_news_items`	4	4	1
23	DESCRIBE `news_items_tags`	4	4	1
24	DESCRIBE `contacts_news_items`	4	4	1
25	DESCRIBE `contents_tags`	4	4	1
26	DESCRIBE `assets_tags`	4	4	1
27	DESCRIBE `campaigns`	37	37	3
28	DESCRIBE `campaign_clicks`	8	8	1
29	DESCRIBE `campaign_opens`	7	7	1
30	DESCRIBE `campaigns_contacts`	12	12	1
31	DESCRIBE `campaigns_contents`	8	8	1
32	DESCRIBE `projects`	27	27	2
33	DESCRIBE `item_types`	6	6	1
34	DESCRIBE `settings`	13	13	1
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	1
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	12
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	1
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	1
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	1
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	1
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	22
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	1180
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	1
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` = 'dub-residence' AND `Container`.`parent_id` = '4fa9acb2-b30c-41c9-b8cc-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	1	1	1
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` = 'construct' AND `Container`.`parent_id` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	0	0	1
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` = 'construct' AND `Content`.`container_id` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' AND `Content`.`published` = 1 AND `Content`.`deleted` = 0 LIMIT 1	1	1	1
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` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' AND `Content`.`deleted` = 0 AND `Content`.`published` = 1 ORDER BY `Content`.`position` ASC	3	3	1
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 ('4fa9acb2-e4a4-4d54-9817-5baa0a790aa9', '4fa9acb2-abe0-4304-96cf-5baa0a790aa9', '4fa9acb2-71f0-433d-bf9b-5baa0a790aa9')	24	24	1
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` = '4fa9acb2-71f0-433d-bf9b-5baa0a790aa9' LIMIT 1	1	1	1
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` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9'	1	1	1
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` = ('4fa9acb2-71f0-433d-bf9b-5baa0a790aa9') ORDER BY `ContentMapping`.`position` ASC	14	14	1
52	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fb5846c-21b0-4053-8abc-02ac0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
53	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abee-23b4-4d88-be53-438d0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
54	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac15-d348-4fb1-bf34-438d0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
55	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abfa-6b40-4e65-9f3b-438c0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
56	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ab55-e378-4945-89c7-438e0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
57	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ab8f-7e94-4560-a96f-438e0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
58	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abc8-8c6c-41fd-b495-438e0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
59	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfef50-90dc-4bf2-92d1-263c0a660dbf' AND `Asset`.`deleted` = 0	1	1	1
60	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac67-c114-4685-ac2c-438d0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
61	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfeeb8-79b4-4e54-b66b-279b0a660dbf' AND `Asset`.`deleted` = 0	1	1	1
62	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac22-84b0-43d3-9276-438c0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
63	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfeef8-b564-407c-9206-27fc0a660dbf' AND `Asset`.`deleted` = 0	1	1	1
64	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac2e-7724-446a-988c-43910a790aa9' AND `Asset`.`deleted` = 0	1	1	1
65	SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac3a-4b38-4e42-9b93-438e0a790aa9' AND `Asset`.`deleted` = 0	1	1	1
66	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` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	1	1	1

(default) 66 queries took 1305 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

1180

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` = 'dub-residence' 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` = 'construct' AND `Container`.`parent_id` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' 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` = 'construct' AND `Content`.`container_id` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' 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` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' 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 ('4fa9acb2-e4a4-4d54-9817-5baa0a790aa9', '4fa9acb2-abe0-4304-96cf-5baa0a790aa9', '4fa9acb2-71f0-433d-bf9b-5baa0a790aa9')

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` = '4fa9acb2-71f0-433d-bf9b-5baa0a790aa9' 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` = ('4fa9acb2-71f0-433d-bf9b-5baa0a790aa9') ORDER BY `ContentMapping`.`position` ASC

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fb5846c-21b0-4053-8abc-02ac0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abee-23b4-4d88-be53-438d0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac15-d348-4fb1-bf34-438d0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abfa-6b40-4e65-9f3b-438c0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ab55-e378-4945-89c7-438e0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ab8f-7e94-4560-a96f-438e0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9abc8-8c6c-41fd-b495-438e0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfef50-90dc-4bf2-92d1-263c0a660dbf' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac67-c114-4685-ac2c-438d0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfeeb8-79b4-4e54-b66b-279b0a660dbf' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac22-84b0-43d3-9276-438c0a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fbfeef8-b564-407c-9206-27fc0a660dbf' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac2e-7724-446a-988c-43910a790aa9' AND `Asset`.`deleted` = 0

SELECT `Asset`.`id`, `Asset`.`asset_type_id`, `Asset`.`name`, `Asset`.`filename`, `Asset`.`description`, `Asset`.`created`, `Asset`.`modified`, `Asset`.`title`, `Asset`.`width`, `Asset`.`height`, `Asset`.`meta`, `Asset`.`exif_info`, `Asset`.`published`, `Asset`.`deleted`, `Asset`.`status`, `Asset`.`tag_list`, `Asset`.`ref_id`, `Asset`.`upload_set_id`, `Asset`.`upload_set_position`, `Asset`.`extras`, `Asset`.`publication_date`, `Asset`.`total_pages`, `Asset`.`marketplace_status`, `Asset`.`client_count`, `Asset`.`content_count` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4fa9ac3a-4b38-4e42-9b93-438e0a790aa9' AND `Asset`.`deleted` = 0

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` = '4fa9acb2-bd50-4560-b308-5baa0a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1

.about US

Dub Residence