ARCHI-TECTONICS

Archi-Tectonics Spotted In China!

Archi-Tectonics’ latest publication was spotted by Yifan (a former Archi-Tectonics employee) in the center of the business district in Bejing’s largest imported bookstore! Yifan was kind enough to send us some pictures of the display…… Good luck there Yifan!

prev next

1 / 3

Back to News Archi-Tectonics Spotted In China!

(default) 45 queries took 1444 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `news_items`	19	19	2
2	DESCRIBE `news_categories`	6	6	1
3	DESCRIBE `assets`	25	25	2
4	DESCRIBE `content_mappings`	9	9	1
5	DESCRIBE `contents`	20	20	2
6	DESCRIBE `content_types`	4	4	1
7	DESCRIBE `containers`	12	12	1
8	DESCRIBE `contacts`	45	45	2
9	DESCRIBE `contact_prefixes`	5	5	1
10	DESCRIBE `cities`	6	6	1
11	DESCRIBE `states`	6	6	21
12	DESCRIBE `countries`	5	5	1
13	DESCRIBE `companies`	23	23	22
14	DESCRIBE `company_types`	7	7	1
15	DESCRIBE `contact_types`	7	7	68
16	DESCRIBE `groups`	8	8	1
17	DESCRIBE `contacts_groups`	4	4	1
18	DESCRIBE `contacts_containers`	5	5	4
19	DESCRIBE `contacts_contents`	5	5	1
20	DESCRIBE `assets_contacts`	5	5	1
21	DESCRIBE `tags`	15	15	1
22	DESCRIBE `contents_tags`	4	4	1
23	DESCRIBE `assets_tags`	4	4	1
24	DESCRIBE `news_items_tags`	4	4	1
25	DESCRIBE `campaigns`	37	37	2
26	DESCRIBE `campaign_clicks`	8	8	11
27	DESCRIBE `campaign_opens`	7	7	1
28	DESCRIBE `campaigns_contacts`	12	12	1
29	DESCRIBE `campaigns_contents`	8	8	1
30	DESCRIBE `assets_news_items`	4	4	1
31	DESCRIBE `contacts_news_items`	4	4	1
32	DESCRIBE `news_links`	6	6	6
33	DESCRIBE `settings`	13	13	1
34	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
35	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
36	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
37	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
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 'divisioncover%' AND `Asset`.`deleted` = 0 AND `Asset`.`asset_type_id` = '1' ORDER BY `Tag`.`name` ASC, `Content`.`published` DESC	0	0	1
39	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
40	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	23
41	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	1228
42	SELECT `NewsItem`.`id`, `NewsItem`.`published`, `NewsItem`.`deleted`, `NewsItem`.`title`, `NewsItem`.`slug`, `NewsItem`.`body`, `NewsItem`.`summary`, `NewsItem`.`created`, `NewsItem`.`modified`, `NewsItem`.`ref_id`, `NewsItem`.`item_date`, `NewsItem`.`news_category_id`, `NewsItem`.`tag_list`, `NewsItem`.`latitude`, `NewsItem`.`longitude`, `NewsItem`.`location_name`, `NewsItem`.`legacy`, `NewsItem`.`legacy_content`, `NewsItem`.`marketplace_status` FROM `news_items` AS `NewsItem` WHERE `NewsItem`.`slug` = 'archi-tectonics-spotted-in-china' AND `NewsItem`.`published` = 1 AND `NewsItem`.`deleted` = 0 LIMIT 1	1	1	2
43	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`, `AssetsNewsItem`.`asset_id`, `AssetsNewsItem`.`news_item_id`, `AssetsNewsItem`.`created`, `AssetsNewsItem`.`modified` FROM `assets` AS `Asset` JOIN `assets_news_items` AS `AssetsNewsItem` ON (`AssetsNewsItem`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `AssetsNewsItem`.`asset_id` = `Asset`.`id`)	3	3	3
44	SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`asset_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`ref_id`, `Tag`.`content_count`, `Tag`.`news_item_count`, `Tag`.`page_count`, `Tag`.`container_count`, `Tag`.`campaign_count`, `Tag`.`contact_count`, `Tag`.`category_id`, `Tag`.`stamp_id`, `Tag`.`show_category_name`, `NewsItemsTag`.`news_item_id`, `NewsItemsTag`.`tag_id`, `NewsItemsTag`.`created`, `NewsItemsTag`.`modified` FROM `tags` AS `Tag` JOIN `news_items_tags` AS `NewsItemsTag` ON (`NewsItemsTag`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `NewsItemsTag`.`tag_id` = `Tag`.`id`)	0	0	1
45	SELECT `Contact`.`id`, `Contact`.`contact_prefix_id`, `Contact`.`first_name`, `Contact`.`last_name`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city_id`, `Contact`.`state_id`, `Contact`.`country_id`, `Contact`.`postal_code`, `Contact`.`phone`, `Contact`.`alt_phone`, `Contact`.`fax`, `Contact`.`toll_free`, `Contact`.`email`, `Contact`.`website`, `Contact`.`facebook`, `Contact`.`twitter`, `Contact`.`company_id`, `Contact`.`contact_type_id`, `Contact`.`description`, `Contact`.`created`, `Contact`.`modified`, `Contact`.`deleted`, `Contact`.`title`, `Contact`.`is_client`, `Contact`.`ref_id`, `Contact`.`im`, `Contact`.`im_type`, `Contact`.`rss_blog`, `Contact`.`home_phone`, `Contact`.`mobile_phone`, `Contact`.`image`, `Contact`.`hover_image`, `Contact`.`unsubscribe_campaign_id`, `Contact`.`unsubscribe_date`, `Contact`.`cover_asset_id`, `Contact`.`additional_info`, `Contact`.`tumblr`, `Contact`.`tag_list`, `Contact`.`use_company_address`, `Contact`.`pinterest`, `Contact`.`instagram`, `Contact`.`lookbooks_login_email`, `Contact`.`container_id`, `ContactsNewsItem`.`contact_id`, `ContactsNewsItem`.`news_item_id`, `ContactsNewsItem`.`created`, `ContactsNewsItem`.`modified` FROM `contacts` AS `Contact` JOIN `contacts_news_items` AS `ContactsNewsItem` ON (`ContactsNewsItem`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `ContactsNewsItem`.`contact_id` = `Contact`.`id`)	0	0	6

(default) 45 queries took 1444 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `news_items`

DESCRIBE `news_categories`

DESCRIBE `assets`

DESCRIBE `content_mappings`

DESCRIBE `contents`

DESCRIBE `content_types`

DESCRIBE `containers`

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 `tags`

DESCRIBE `contents_tags`

DESCRIBE `assets_tags`

DESCRIBE `news_items_tags`

DESCRIBE `campaigns`

DESCRIBE `campaign_clicks`

DESCRIBE `campaign_opens`

DESCRIBE `campaigns_contacts`

DESCRIBE `campaigns_contents`

DESCRIBE `assets_news_items`

DESCRIBE `contacts_news_items`

DESCRIBE `news_links`

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

1228

SELECT `NewsItem`.`id`, `NewsItem`.`published`, `NewsItem`.`deleted`, `NewsItem`.`title`, `NewsItem`.`slug`, `NewsItem`.`body`, `NewsItem`.`summary`, `NewsItem`.`created`, `NewsItem`.`modified`, `NewsItem`.`ref_id`, `NewsItem`.`item_date`, `NewsItem`.`news_category_id`, `NewsItem`.`tag_list`, `NewsItem`.`latitude`, `NewsItem`.`longitude`, `NewsItem`.`location_name`, `NewsItem`.`legacy`, `NewsItem`.`legacy_content`, `NewsItem`.`marketplace_status` FROM `news_items` AS `NewsItem` WHERE `NewsItem`.`slug` = 'archi-tectonics-spotted-in-china' AND `NewsItem`.`published` = 1 AND `NewsItem`.`deleted` = 0 LIMIT 1

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`, `AssetsNewsItem`.`asset_id`, `AssetsNewsItem`.`news_item_id`, `AssetsNewsItem`.`created`, `AssetsNewsItem`.`modified` FROM `assets` AS `Asset` JOIN `assets_news_items` AS `AssetsNewsItem` ON (`AssetsNewsItem`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `AssetsNewsItem`.`asset_id` = `Asset`.`id`)

SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`asset_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`ref_id`, `Tag`.`content_count`, `Tag`.`news_item_count`, `Tag`.`page_count`, `Tag`.`container_count`, `Tag`.`campaign_count`, `Tag`.`contact_count`, `Tag`.`category_id`, `Tag`.`stamp_id`, `Tag`.`show_category_name`, `NewsItemsTag`.`news_item_id`, `NewsItemsTag`.`tag_id`, `NewsItemsTag`.`created`, `NewsItemsTag`.`modified` FROM `tags` AS `Tag` JOIN `news_items_tags` AS `NewsItemsTag` ON (`NewsItemsTag`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `NewsItemsTag`.`tag_id` = `Tag`.`id`)

SELECT `Contact`.`id`, `Contact`.`contact_prefix_id`, `Contact`.`first_name`, `Contact`.`last_name`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city_id`, `Contact`.`state_id`, `Contact`.`country_id`, `Contact`.`postal_code`, `Contact`.`phone`, `Contact`.`alt_phone`, `Contact`.`fax`, `Contact`.`toll_free`, `Contact`.`email`, `Contact`.`website`, `Contact`.`facebook`, `Contact`.`twitter`, `Contact`.`company_id`, `Contact`.`contact_type_id`, `Contact`.`description`, `Contact`.`created`, `Contact`.`modified`, `Contact`.`deleted`, `Contact`.`title`, `Contact`.`is_client`, `Contact`.`ref_id`, `Contact`.`im`, `Contact`.`im_type`, `Contact`.`rss_blog`, `Contact`.`home_phone`, `Contact`.`mobile_phone`, `Contact`.`image`, `Contact`.`hover_image`, `Contact`.`unsubscribe_campaign_id`, `Contact`.`unsubscribe_date`, `Contact`.`cover_asset_id`, `Contact`.`additional_info`, `Contact`.`tumblr`, `Contact`.`tag_list`, `Contact`.`use_company_address`, `Contact`.`pinterest`, `Contact`.`instagram`, `Contact`.`lookbooks_login_email`, `Contact`.`container_id`, `ContactsNewsItem`.`contact_id`, `ContactsNewsItem`.`news_item_id`, `ContactsNewsItem`.`created`, `ContactsNewsItem`.`modified` FROM `contacts` AS `Contact` JOIN `contacts_news_items` AS `ContactsNewsItem` ON (`ContactsNewsItem`.`news_item_id` = '4ffd9344-6794-4d58-877c-25cb0a557a36' AND `ContactsNewsItem`.`contact_id` = `Contact`.`id`)

.about US

Archi-Tectonics Spotted In China!