{'ObjectID' : '992', 'ObjectCode' : 'N-6301-00', 'ObjectNumber' : 'NG6301', 'ObjectDateBegin' : '1748-01-01', 'ObjectDateEnd' : '1752-12-31', 'ObjectDisplayDate' : 'about 1750', 'ObjectDimensions' : '69.8 x 119.4 cm', 'ObjectMedium' : 'Oil on canvas', 'ObjectAlphaSort' : 'Gainsborough, Thomas', 'ObjectAuthor' : 'Thomas Gainsborough, 1727 - 1788', 'ObjectTitle' : 'Mr and Mrs Andrews', 'ObjectShortTitle' : 'Mr and Mrs Andrews', 'ObjectCreditLine' : 'Bought with contributions from the Pilgrim Trust, The Art Fund, Associated Television Ltd, and Mr and Mrs W. W. Spooner, 1960.', 'ObjectString' : 'NG6301: Thomas Gainsborough, 1727 - 1788, Mr and Mrs Andrews, about 1750, Oil on canvas, (69.8 x 119.4 cm), Bought with contributions from the Pilgrim Trust, The Art Fund, Associated Television Ltd, and Mr and Mrs W. W. Spooner, 1960..', 'ObjectLocation' : 'Room 35', 'ObjectPrivateLocation' : 'Gallery 35', 'ObjectPublicLocation' : 'Room 35', 'ObjectSchool' : 'British', 'ObjectCurator' : 'Susan Foister', 'ObjectDescription' : 'Robert Andrews (1726?-1806) of The Auberies, near Bulmer in Suffolk, married Frances Mary Carter (about 1732-80) of Ballingdon House, near Sudbury, on 10 November 1748 at All Saints, Sudbury, the church whose tower is seen in the centre background of this painting. NG 6301 was probably painted soon after the marriage, about 1748-9. The fields in the landscape setting are part of The Auberies estate.
The unfinished object in Mrs Andrews\' lap remains puzzling; it was once thought to be a pheasant shot by her husband, but the season in which sheaves of ripe corn have been harvested is too early for pheasant-shooting.
By descent to G.W. Andrews; bought, 1960.
Hayes 1991, p. 76', 'ObjectStatusID' : '1', 'PublicAccess' : '1', 'GroupNumber' : '', 'GroupTitle' : '', 'GroupArtist' : '', 'GroupDate' : '', 'GroupParts' : '', 'ImageID' : '1013', 'ImageFile' : 'N-6301-00-000031-WZ-PYR.tif', 'ImageCode' : 'N-6301-00-000031-WZ', 'ImagePath' : '/pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ web NG Fronts/', 'ImageLevels' : '6', 'ImageXsize' : '6000', 'ImageYsize' : '3470', 'FileGroup_ID' : '14', 'impos' : '872'} /* Array ( [0] =>
Array
(
    [what] => details
    [val] => 1013
    [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 = '1013'

[2] =>
SELECT * FROM Object, Image WHERE Object.ObjectID = Image.ObjectID AND FileGroup_id in (14) ORDER BY Object.ObjectAlphaSort
[3] =>
872 --> 1013 N-6301-00 Thomas Gainsborough, 1727 - 1788
[4] =>
Array
(
    [ObjectID] => 992
    [ObjectCode] => N-6301-00
    [ObjectNumber] => NG6301
    [ObjectDateBegin] => 1748-01-01
    [ObjectDateEnd] => 1752-12-31
    [ObjectDisplayDate] => about 1750
    [ObjectDimensions] => 69.8 x 119.4 cm
    [ObjectMedium] => Oil on canvas
    [ObjectAlphaSort] => Gainsborough, Thomas
    [ObjectAuthor] => Thomas Gainsborough, 1727 - 1788
    [ObjectTitle] => Mr and Mrs Andrews
    [ObjectShortTitle] => Mr and Mrs Andrews
    [ObjectCreditLine] => Bought with contributions from the Pilgrim Trust, The Art Fund, Associated Television Ltd, and Mr and Mrs W. W. Spooner, 1960.
    [ObjectString] => NG6301: Thomas Gainsborough, 1727 - 1788, Mr and Mrs Andrews, about 1750, Oil on canvas, (69.8 x 119.4 cm), Bought with contributions from the Pilgrim Trust, The Art Fund, Associated Television Ltd, and Mr and Mrs W. W. Spooner, 1960..
    [ObjectLocation] => Room 35
    [ObjectPrivateLocation] => Gallery 35
    [ObjectPublicLocation] => Room 35
    [ObjectSchool] => British
    [ObjectCurator] => Susan Foister
    [ObjectDescription] => Robert Andrews (1726?-1806) of The Auberies, near Bulmer in Suffolk, married Frances Mary Carter (about 1732-80) of Ballingdon House, near Sudbury, on 10 November 1748 at All Saints, Sudbury, the church whose tower is seen in the centre background of this painting. NG 6301 was probably painted soon after the marriage, about 1748-9. The fields in the landscape setting are part of The Auberies estate.
The unfinished object in Mrs Andrews\' lap remains puzzling; it was once thought to be a pheasant shot by her husband, but the season in which sheaves of ripe corn have been harvested is too early for pheasant-shooting.
By descent to G.W. Andrews; bought, 1960.
Hayes 1991, p. 76 [ObjectStatusID] => 1 [PublicAccess] => 1 [GroupNumber] => [GroupTitle] => [GroupArtist] => [GroupDate] => [GroupParts] => [ImageID] => 1013 [ImageFile] => N-6301-00-000031-WZ-PYR.tif [ImageCode] => N-6301-00-000031-WZ [ImagePath] => /pics/tmp/websiteimages/Website_Collection_Online/Web Zoom Images/WZ web NG Fronts/ [ImageLevels] => 6 [ImageXsize] => 6000 [ImageYsize] => 3470 [FileGroup_ID] => 14 [impos] => 872 )
) */