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

3 of 4 Slide Show Running

Click to Pause Slide Show


 A trip on PEDRO. L-R Mary Wright, Vicky Watling née Negus, Dave Watling, unknown, Alan Smith at the wheel. 
Cat1 Families-->Smith

A trip on PEDRO. L-R Mary Wright, Vicky Watling née Negus, Dave Watling, unknown, Alan Smith at the wheel.
Date: 1955      


Photo: Mersea Museum - Alan Smith Collection
Image ID ALS_NEG_011
Category 1 Families-->Smith


    Top

This image is part of the Mersea Museum Collection.