ARCHI-TECTONICS

TASHAN

The Owner of the famed “Tiffin” Concept in Philadelphia, Munish Narula, was ready for a new step in his career and developed together with Chef Silva the “Indian Tapas” concept. Location; the 5000 sq.ft. space in the new Dranoff building on 777 Broad street in the Theatre district in Philadelphia. Archi-Tectonics created the design for Tashan, merging traditional Indian craft with a innovative, digital design. The result is a warm, sultry space with a relaxed lounge, a high-dining area, a communal dining table overlooking the open kitchen and last but not least; private dining in the wineroom.

A new spatial concept was inherent in the innovative cuisine proposed; intimate zones, each with their own dining experience were created. These “rooms” were both seperated and connected through laser cut patterned open wood screens, and oblique angles. The private dining can be closed by padded leather doors, providing a calm and quiet space perfect for a special evening. The communal dining room provides the “in the kitchen” effect, and is perfect for both large groups and individuals ready to meet other foodies. Highlight is the communal bathroom with glass bead walls and a large black shared washbasin in the middle.

Indirect light, differentiated ceiling levels, clear, translucent and colored glass panels, all help to create a very special atmosphere, hovering between a precious past and an exiting future.

INFO

Client: Munish Narula

Project Type: Restaurant, New Indian Tapas concept

Location: Theatre District Philadelphia, PA

Area: 5,000 sf // 464.5 m²

Status: Completed 2011

Design: Archi-Tectonics

Principal in charge: Winka Dubbeldam

Project Team: David Barr, Wilfredo Rodriguez, Thomas Woodcock, Ryan Henrickson, Gabriela Bruno, Alessandro Perinelli

Architect of Record: Zimmers Associates

Consultants:

Structural Engineers: Mulhern Kulp

Mechanical Engineer: MPH Consulting Engineers

General Contractor: United American Builders

Electrical: Mulhem Consulting Engineers

Photography: Don Pearse Photographers

SHARE twitter. facebook. tumblr. email.

prev next

1 / 10

download pdf
print project

Gallery Fullscreen

close share

facebook tumblr twitter email

prev next

(default) 62 queries took 870 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `containers`	12	12	2
2	DESCRIBE `contents`	20	20	2
3	DESCRIBE `content_types`	4	4	1
4	DESCRIBE `content_mappings`	9	9	1
5	DESCRIBE `assets`	26	26	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	1
14	DESCRIBE `companies`	23	23	2
15	DESCRIBE `company_types`	7	7	1
16	DESCRIBE `contact_types`	7	7	24
17	DESCRIBE `groups`	8	8	6
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	2
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	55	55	2
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', '50c7b0cc-7600-4475-b64f-3e9c0a557a36', '5124fdb8-9584-4fe7-98dc-30120a557a36') 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	48	48	15
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	76	76	746
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` = 'tashan' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' AND `Content`.`deleted` = 0 AND `Content`.`published` = 1 ORDER BY `Content`.`position` ASC	4	4	5
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 ('4faaa411-21b4-4dfd-9438-1a690a790aa9', '4faaa412-759c-499c-a31b-1a690a790aa9', '4faaa412-13a8-48be-bbee-1a690a790aa9', '500826a3-acb8-4d85-91f8-68440a557a36')	30	30	5
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` = '4faaa412-13a8-48be-bbee-1a690a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9'	1	1	4
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` = ('4faaa412-13a8-48be-bbee-1a690a790aa9') ORDER BY `ContentMapping`.`position` ASC	10	10	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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa332-e8e4-4acd-8dbb-1a640a790aa9' AND `Asset`.`deleted` = 0	1	1	2
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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa225-5670-441a-9a62-2f5f0a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa2ee-3510-4023-80d1-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa29f-53b8-4388-974a-1a620a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa38f-2a94-4b13-af76-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa238-f294-44e2-aa1d-1a640a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa3ad-dd18-4e48-9e3f-1a620a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa39e-cd28-4200-ae25-1a660a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa343-1338-4fd5-af8b-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa290-a6e0-46ef-9ba6-1a630a790aa9' AND `Asset`.`deleted` = 0	1	1	1
62	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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1	1	1	1

(default) 62 queries took 870 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', '50c7b0cc-7600-4475-b64f-3e9c0a557a36', '5124fdb8-9584-4fe7-98dc-30120a557a36') 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

746

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` = 'tashan' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' 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 ('4faaa411-21b4-4dfd-9438-1a690a790aa9', '4faaa412-759c-499c-a31b-1a690a790aa9', '4faaa412-13a8-48be-bbee-1a690a790aa9', '500826a3-acb8-4d85-91f8-68440a557a36')

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` = '4faaa412-13a8-48be-bbee-1a690a790aa9' 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` = ('4faaa412-13a8-48be-bbee-1a690a790aa9') 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa332-e8e4-4acd-8dbb-1a640a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa225-5670-441a-9a62-2f5f0a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa2ee-3510-4023-80d1-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa29f-53b8-4388-974a-1a620a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa38f-2a94-4b13-af76-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa238-f294-44e2-aa1d-1a640a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa3ad-dd18-4e48-9e3f-1a620a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa39e-cd28-4200-ae25-1a660a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa343-1338-4fd5-af8b-1a650a790aa9' 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`, `Asset`.`rating` FROM `assets` AS `Asset` WHERE `Asset`.`id` = '4faaa290-a6e0-46ef-9ba6-1a630a790aa9' 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` = '4faaa411-b53c-4826-ac31-1a690a790aa9' AND `Container`.`published` = 1 AND `Container`.`deleted` = 0 LIMIT 1

.about US

TASHAN