Description

This collection contains a number of historial slide collections that are held at: the University of Oxford; The Hunterian, Glasgow; and University College London. We are keen to encourage others to scan their historically important slide collections and host them on CSlide and would be pleased to discuss how we can help you to do so - msdlt@medsci.ox.ac.uk.

More information about the History of Medical Sciences project, along with seminar recordings and images, can be found on the History of Medical Sciences website.

X
(default) 21 queries took 21 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1005110
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` = 1005 AND `Item`.`status` <> 'trashed' LIMIT 1111
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` = '1005' AND `type` = 'annotation' AND `LinkRight`.`item_left_id` = (1005)000
4SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1005) ORDER BY `created` DESC336
5SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6110
6SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6110
7SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6110
8SELECT `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` = 1005 AND `ItemsTag`.`tag_id` = `Tag`.`id`) 000
9SELECT `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` <> 1005) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1005) 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` = 1005) OR (`LinkRight`.`item_left_id` = 1005)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC002
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`, `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` <> 1005) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1005) 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` = 1005) OR (`LinkRight`.`item_left_id` = 1005)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC LIMIT 20001
11SELECT `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
12SELECT `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
13SELECT `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
14SELECT `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
15SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id` FROM `cslide`.`links` AS `LinkLeft` WHERE `item_right_id` = 1005 AND `LinkLeft`.`type` = 'parent' AND `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published'000
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 COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1000) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'110
18SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1005 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
19SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1005 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'115
20SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1005 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
21SELECT `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` = 1005 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC10106