{'ObjectID' : '1126', 'ObjectCode' : 'N-6589-00', 'ObjectNumber' : 'NG6589', 'ObjectDateBegin' : '1787-01-01', 'ObjectDateEnd' : '1792-12-31', 'ObjectDisplayDate' : 'about 1789-90', 'ObjectDimensions' : '110.5 x 123.6 cm', 'ObjectMedium' : 'Oil on canvas', 'ObjectAlphaSort' : 'Raeburn, Sir Henry', 'ObjectAuthor' : 'Sir Henry Raeburn, 1756 - 1823', 'ObjectTitle' : 'Robert Ferguson of Raith 1770-1840 and Lieutenant-General Sir Ronald Ferguson 1773-1841 (\'The Archers\')', 'ObjectShortTitle' : '\'The Archers\'', 'ObjectCreditLine' : 'Acquired under the Acceptance-in-Lieu procedure, 2001', 'ObjectString' : 'NG6589: Sir Henry Raeburn, 1756 - 1823, \'The Archers\', about 1789-90, Oil on canvas, (110.5 x 123.6 cm), Acquired under the Acceptance-in-Lieu procedure, 2001.', 'ObjectLocation' : 'Room 34', 'ObjectPrivateLocation' : 'Gallery 34', 'ObjectPublicLocation' : 'Room 34', 'ObjectSchool' : 'British', 'ObjectCurator' : 'Susan Foister', 'ObjectDescription' : '', 'ObjectStatusID' : '1', 'PublicAccess' : '1', 'GroupNumber' : '', 'GroupTitle' : '', 'GroupArtist' : '', 'GroupDate' : '', 'GroupParts' : '', 'ImageID' : '1151', 'ImageFile' : 'N-6589-00-000013-WZ-PYR.tif', 'ImageCode' : 'N-6589-00-000013-WZ', 'ImagePath' : '/pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ web NG Fronts/', 'ImageLevels' : '6', 'ImageXsize' : '6000', 'ImageYsize' : '4854', 'FileGroup_ID' : '14', 'impos' : '1975'} /* Array ( [0] =>
Array
(
    [what] => details
    [val] => 1151
    [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 = '1151'

[2] =>
SELECT * FROM Object, Image WHERE Object.ObjectID = Image.ObjectID AND FileGroup_id in (14) ORDER BY Object.ObjectAlphaSort
[3] =>
1975 --> 1151 N-6589-00 Sir Henry Raeburn, 1756 - 1823
[4] =>
Array
(
    [ObjectID] => 1126
    [ObjectCode] => N-6589-00
    [ObjectNumber] => NG6589
    [ObjectDateBegin] => 1787-01-01
    [ObjectDateEnd] => 1792-12-31
    [ObjectDisplayDate] => about 1789-90
    [ObjectDimensions] => 110.5 x 123.6 cm
    [ObjectMedium] => Oil on canvas
    [ObjectAlphaSort] => Raeburn, Sir Henry
    [ObjectAuthor] => Sir Henry Raeburn, 1756 - 1823
    [ObjectTitle] => Robert Ferguson of Raith 1770-1840 and Lieutenant-General Sir Ronald Ferguson 1773-1841 (\'The Archers\')
    [ObjectShortTitle] => \'The Archers\'
    [ObjectCreditLine] => Acquired under the Acceptance-in-Lieu procedure, 2001
    [ObjectString] => NG6589: Sir Henry Raeburn, 1756 - 1823, \'The Archers\', about 1789-90, Oil on canvas, (110.5 x 123.6 cm), Acquired under the Acceptance-in-Lieu procedure, 2001.
    [ObjectLocation] => Room 34
    [ObjectPrivateLocation] => Gallery 34
    [ObjectPublicLocation] => Room 34
    [ObjectSchool] => British
    [ObjectCurator] => Susan Foister
    [ObjectDescription] => 
    [ObjectStatusID] => 1
    [PublicAccess] => 1
    [GroupNumber] => 
    [GroupTitle] => 
    [GroupArtist] => 
    [GroupDate] => 
    [GroupParts] => 
    [ImageID] => 1151
    [ImageFile] => N-6589-00-000013-WZ-PYR.tif
    [ImageCode] => N-6589-00-000013-WZ
    [ImagePath] => /pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ web NG Fronts/
    [ImageLevels] => 6
    [ImageXsize] => 6000
    [ImageYsize] => 4854
    [FileGroup_ID] => 14
    [impos] => 1975
)
) */