{'ObjectID' : '1199', 'ObjectCode' : 'L-0856-00', 'ObjectNumber' : 'L856', 'ObjectDateBegin' : '1815-01-01', 'ObjectDateEnd' : '1819-12-31', 'ObjectDisplayDate' : 'about 1817', 'ObjectDimensions' : '30.5 x 24 cm', 'ObjectMedium' : 'Oil on paper', 'ObjectAlphaSort' : 'Michallon, Achille-Etna', 'ObjectAuthor' : 'Achille-Etna Michallon, 1796 - 1822', 'ObjectTitle' : 'A Tree', 'ObjectShortTitle' : 'A Tree', 'ObjectCreditLine' : 'The Gere Collection, on long-term loan to the National Gallery', 'ObjectString' : 'L856: Achille-Etna Michallon, 1796 - 1822, A Tree, about 1817, Oil on paper, (30.5 x 24 cm), The Gere Collection, on long-term loan to the National Gallery.', 'ObjectLocation' : 'Not on display', 'ObjectPrivateLocation' : 'Conservation - Lower Studio Secure Cupboard', 'ObjectPublicLocation' : 'Not on display', 'ObjectSchool' : '', 'ObjectCurator' : 'Christopher Riopelle', 'ObjectDescription' : '', 'ObjectStatusID' : '4', 'PublicAccess' : '1', 'GroupNumber' : '', 'GroupTitle' : '', 'GroupArtist' : '', 'GroupDate' : '', 'GroupParts' : '', 'ImageID' : '1227', 'ImageFile' : 'L-0856-00-000004-WZ-PYR.tif', 'ImageCode' : 'L-0856-00-000004-WZ', 'ImagePath' : '/pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ Long Loans/', 'ImageLevels' : '6', 'ImageXsize' : '4654', 'ImageYsize' : '6000', 'FileGroup_ID' : '14', 'impos' : '1627'} /* Array ( [0] =>
Array
(
    [what] => details
    [val] => 1227
    [crop] => false
    [sqllimit] =>  AND FileGroup_id in (14) 
    [whichdb] => externalIIP
    [whichtable] => Image
    [sortby] => ObjectAlphaSort
)
[1] =>

SELECT * FROM Object, Image WHERE Object.ObjectID = Image.ObjectID AND ImageID = '1227'

[2] =>
SELECT * FROM Object, Image WHERE Object.ObjectID = Image.ObjectID AND FileGroup_id in (14) ORDER BY Object.ObjectAlphaSort
[3] =>
1627 --> 1227 L-0856-00 Achille-Etna Michallon, 1796 - 1822
[4] =>
Array
(
    [ObjectID] => 1199
    [ObjectCode] => L-0856-00
    [ObjectNumber] => L856
    [ObjectDateBegin] => 1815-01-01
    [ObjectDateEnd] => 1819-12-31
    [ObjectDisplayDate] => about 1817
    [ObjectDimensions] => 30.5 x 24 cm
    [ObjectMedium] => Oil on paper
    [ObjectAlphaSort] => Michallon, Achille-Etna
    [ObjectAuthor] => Achille-Etna Michallon, 1796 - 1822
    [ObjectTitle] => A Tree
    [ObjectShortTitle] => A Tree
    [ObjectCreditLine] => The Gere Collection, on long-term loan to the National Gallery
    [ObjectString] => L856: Achille-Etna Michallon, 1796 - 1822, A Tree, about 1817, Oil on paper, (30.5 x 24 cm), The Gere Collection, on long-term loan to the National Gallery.
    [ObjectLocation] => Not on display
    [ObjectPrivateLocation] => Conservation - Lower Studio Secure Cupboard
    [ObjectPublicLocation] => Not on display
    [ObjectSchool] => 
    [ObjectCurator] => Christopher Riopelle
    [ObjectDescription] => 
    [ObjectStatusID] => 4
    [PublicAccess] => 1
    [GroupNumber] => 
    [GroupTitle] => 
    [GroupArtist] => 
    [GroupDate] => 
    [GroupParts] => 
    [ImageID] => 1227
    [ImageFile] => L-0856-00-000004-WZ-PYR.tif
    [ImageCode] => L-0856-00-000004-WZ
    [ImagePath] => /pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ Long Loans/
    [ImageLevels] => 6
    [ImageXsize] => 4654
    [ImageYsize] => 6000
    [FileGroup_ID] => 14
    [impos] => 1627
)
) */