Information
Description

A collection of CNS slides belonging to Sir Wilfrid Le Gros Clark.

X
(default) 26 queries took 24 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1009110
2SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`description`, `Item`.`markings`, `Item`.`zoomable_url`, `Item`.`initial_rotation`, `Item`.`disable_annotations`, `Item`.`zoomify_slideshow`, `Item`.`360_url`, `Item`.`external_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest`, `Item`.`flickr_set`, `Item`.`show_gallery`, `Item`.`user_id`, `Item`.`created`, `Item`.`modified`, `Item`.`primary_parent`, `Item`.`revision_parent`, `Item`.`status`, `AppUser`.`slug`, `AppUser`.`display_name`, `Person`.`sex`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`items` AS `Item` LEFT JOIN `cslide`.`users` AS `AppUser` ON (`Item`.`user_id` = `AppUser`.`id`) LEFT JOIN `cslide`.`people` AS `Person` ON (`Person`.`item_id` = `Item`.`id`) WHERE `Item`.`id` = 1009 AND `Item`.`status` <> 'trashed' LIMIT 1110
3SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type` FROM `cslide`.`links` AS `LinkRight` WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `item_left_id` = '1009' AND `type` = 'annotation' AND `LinkRight`.`item_left_id` = (1009)000
4SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1009) ORDER BY `created` DESC009
5SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `ItemsTag`.`item_id`, `ItemsTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`items_tags` AS `ItemsTag` ON (`ItemsTag`.`item_id` = 1009 AND `ItemsTag`.`tag_id` = `Tag`.`id`) 000
6SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id`, `LinkLeft`.`type`, `LinkLeft`.`item_right_id`, `LinkLeft`.`description`, `LinkLeft`.`confidence`, `LinkLeft`.`location_id`, `LinkLeft`.`date_from`, `LinkLeft`.`date_to`, `LinkLeft`.`date_type`, `LinkLeft`.`link_group_id`, `LinkLeft`.`user_id`, `LinkLeft`.`created`, `LinkLeft`.`modified`, `LinkLeft`.`revision_parent`, `LinkLeft`.`status`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order`, `LinkGroup`.`id`, `LinkGroup`.`type` FROM `cslide`.`links` AS `LinkLeft` LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkLeft`.`item_right_id` = `ItemRight`.`id`) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkLeft`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkLeft`.`type` = `LinkType`.`id`) LEFT JOIN `cslide`.`link_groups` AS `LinkGroup` ON (`LinkLeft`.`link_group_id` = `LinkGroup`.`id`) WHERE `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published' AND `LinkLeft`.`item_left_id` = 1009 AND ((`LinkType`.`id` = 'creation') OR (`LinkType`.`parent` = 'creation')) ORDER BY `ItemRight`.`name` ASC111
7SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 853110
8SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `LinksTag`.`link_id`, `LinksTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`links_tags` AS `LinksTag` ON (`LinksTag`.`link_id` = 4 AND `LinksTag`.`tag_id` = `Tag`.`id`) 000
9SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id`, `LinkLeft`.`type`, `LinkLeft`.`item_right_id`, `LinkLeft`.`description`, `LinkLeft`.`confidence`, `LinkLeft`.`location_id`, `LinkLeft`.`date_from`, `LinkLeft`.`date_to`, `LinkLeft`.`date_type`, `LinkLeft`.`link_group_id`, `LinkLeft`.`user_id`, `LinkLeft`.`created`, `LinkLeft`.`modified`, `LinkLeft`.`revision_parent`, `LinkLeft`.`status`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order`, `LinkGroup`.`id`, `LinkGroup`.`type` FROM `cslide`.`links` AS `LinkLeft` LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkLeft`.`item_right_id` = `ItemRight`.`id`) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkLeft`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkLeft`.`type` = `LinkType`.`id`) LEFT JOIN `cslide`.`link_groups` AS `LinkGroup` ON (`LinkLeft`.`link_group_id` = `LinkGroup`.`id`) WHERE `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published' AND `LinkLeft`.`item_left_id` = 1009 AND ((`LinkType`.`id` = 'current_holder') OR (`LinkType`.`parent` = 'current_holder')) ORDER BY `ItemRight`.`name` ASC001
10SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type`, `LinkRight`.`item_right_id`, `LinkRight`.`description`, `LinkRight`.`confidence`, `LinkRight`.`location_id`, `LinkRight`.`date_from`, `LinkRight`.`date_to`, `LinkRight`.`date_type`, `LinkRight`.`link_group_id`, `LinkRight`.`user_id`, `LinkRight`.`created`, `LinkRight`.`modified`, `LinkRight`.`revision_parent`, `LinkRight`.`status`, `ItemLeft`.`id`, `ItemLeft`.`type`, `ItemLeft`.`name`, `ItemLeft`.`zoomable_url`, `ItemLeft`.`thumbnail`, `ItemLeft`.`thumb_farm`, `ItemLeft`.`thumb_server`, `ItemLeft`.`thumb_id`, `ItemLeft`.`thumb_secret`, `ItemLeft`.`thumb_largest`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order` FROM `cslide`.`links` AS `LinkRight` LEFT JOIN `cslide`.`items` AS `ItemLeft` ON (`LinkRight`.`item_left_id` = `ItemLeft`.`id` AND `ItemLeft`.`id` <> 1009) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1009) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkRight`.`type` = `LinkType`.`id`) WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `LinkRight`.`type` NOT IN ('primary_parent', 'parent', 'annotation') AND ((`LinkRight`.`item_right_id` = 1009) OR (`LinkRight`.`item_left_id` = 1009)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC111
11SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type`, `LinkRight`.`item_right_id`, `LinkRight`.`description`, `LinkRight`.`confidence`, `LinkRight`.`location_id`, `LinkRight`.`date_from`, `LinkRight`.`date_to`, `LinkRight`.`date_type`, `LinkRight`.`link_group_id`, `LinkRight`.`user_id`, `LinkRight`.`created`, `LinkRight`.`modified`, `LinkRight`.`revision_parent`, `LinkRight`.`status`, `ItemLeft`.`id`, `ItemLeft`.`type`, `ItemLeft`.`name`, `ItemLeft`.`zoomable_url`, `ItemLeft`.`thumbnail`, `ItemLeft`.`thumb_farm`, `ItemLeft`.`thumb_server`, `ItemLeft`.`thumb_id`, `ItemLeft`.`thumb_secret`, `ItemLeft`.`thumb_largest`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `AppUser`.`slug`, `AppUser`.`display_name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order` FROM `cslide`.`links` AS `LinkRight` LEFT JOIN `cslide`.`items` AS `ItemLeft` ON (`LinkRight`.`item_left_id` = `ItemLeft`.`id` AND `ItemLeft`.`id` <> 1009) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1009) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkRight`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`users` AS `AppUser` ON (`LinkRight`.`user_id` = `AppUser`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkRight`.`type` = `LinkType`.`id`) WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `LinkRight`.`type` NOT IN ('primary_parent', 'parent', 'annotation') AND ((`LinkRight`.`item_right_id` = 1009) OR (`LinkRight`.`item_left_id` = 1009)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC LIMIT 20111
12SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 853110
13SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `LinksTag`.`link_id`, `LinksTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`links_tags` AS `LinksTag` ON (`LinksTag`.`link_id` = 4 AND `LinksTag`.`tag_id` = `Tag`.`id`) 000
14SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1009 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
15SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1005) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC110
16SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1005 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
17SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1000) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC110
18SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
19SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (NULL) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC000
20SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id` FROM `cslide`.`links` AS `LinkLeft` WHERE `item_right_id` = 1009 AND `LinkLeft`.`type` = 'parent' AND `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published'000
21SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1009 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
22SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1005) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'110
23SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1009 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
24SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1009 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'115
25SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1009 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
26SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1009 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC12126