SQL12:
QueryResource Command was
SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmresjl WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmimages WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmrestext WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmaudiovisual WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) ORDER BY ID ;
Error Number 1021 Disk full (/var/lib/mysqltmp/#sql_2b20c2_14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Error:
QueryResource Command was
SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmresjl WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmimages WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmrestext WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) UNION SELECT Record, ID, FileName, Volume, Folder, Media, OriginalFile,Keywords, Date, dtDate, Title, Abstract, Author, Notes, Source, ResourceType,Size, Status, LastUpdateID,LastUpdated, Collection, PageRange, PathID, ImageWidth, Location, Keywords2, RecordCreated,Cat1, Visible1, Thumbnail,Visible3, OwnerID, Visible2 FROM mmaudiovisual WHERE ( ( Length(Visible1) = 1 ) AND (Locate( Visible1, "Y") <> 0 ) AND ( Imagewidth <> 0 OR Collection <> "IM" ) AND (ID = "GSS_061")) ORDER BY ID ;
Error Number 1021 Disk full (/var/lib/mysqltmp/#sql_2b20c2_14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

5 of 10

 George Saunders Smith, Coldstream Guards 
Cat1 Families-->Smith

George Saunders Smith, Coldstream Guards
Date: c1929      


Photo: Mersea Museum - Jan Davey
Image ID JDV_GSS_023
Category 1 Families-->Smith


    Top

This image is part of the Mersea Museum Collection.