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

1 of 12 Slide Show Running

Click to Pause Slide Show


 Layer de la Haye commemoration of the end of WW1. 

Photograph from Mrs Chambers - her husband Adam is the soldier behind the cross. 
Cat1 Places-->Layer de la Haye

Layer de la Haye commemoration of the end of WW1.
Photograph from Mrs Chambers - her husband Adam is the soldier behind the cross.
Date: November 2018      


Photo: Mersea Museum - Brian Chaplin
Image ID CLN_007
Category 1 Places-->Layer de la Haye


    Top

This image is part of the Mersea Museum Collection.