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 = "STR_SOL")) 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 = "STR_SOL")) 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 = "STR_SOL")) 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 = "STR_SOL")) ORDER BY ID ;
Error Number 1021 Disk full (/var/lib/mysqltmp/#sql_2b20c2_32.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 = "STR_SOL")) 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 = "STR_SOL")) 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 = "STR_SOL")) 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 = "STR_SOL")) ORDER BY ID ;
Error Number 1021 Disk full (/var/lib/mysqltmp/#sql_2b20c2_32.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Search for Image ID ""Images for Mersea 45 of 3085

 WW1 Memorial at the Strood. 51 Mersea Island soldiers and sailors. Duncan Pittock. 
Cat1 Mersea-->Strood Cat2 War-->World War 1

WW1 Memorial at the Strood. 51 Mersea Island soldiers and sailors. Duncan Pittock.
Date: 9 November 2018      


Photo: Mersea Museum - Anne-Marie Jacobs
Image ID AMJ_SOL_427
Category 1 Mersea-->Strood
Category 2 War-->World War 1


    Top

This image is part of the Mersea Museum Collection.