Error: SELECT DISTINCT cwgc_raw.id,images.imageId,images.imageUrl,images.imageSource,images.sourceUrl,images.status,lives_locations.livesId,livesRank,livesForenames,livesSurname,livesServiceNumber,livesRegiment,rank,forename,surname,servicenumberexport,regiment,date_of_death,age_text,additionalinformation,cemeterymemorial FROM `cwgc_raw` LEFT JOIN images on images.cwgcId=cwgc_raw.id LEFT JOIN lives_locations ON lives_locations.cwgcId=cwgc_raw.id ORDER BY case WHEN images.status=1 THEN 1 END DESC,surname ASC LIMIT 400, 100
MySQL server has gone away
Error: SELECT count(distinct cwgc_raw.id) as totalCount FROM `cwgc_raw` LEFT JOIN lives_locations ON lives_locations.cwgcId=cwgc_raw.id
MySQL server has gone away Search Commonwealth First World War casualties - A Street Near You

Search First World War Casualties

Forenames will match anything starting with the value entered. The data is very variable, so try 'James T', 'James', 'J T' etc. Surname will match anything starting with the value entered
Will match the entered text anywhere within the name of the Regiment, Ship or Squadron. So 'Highland' would match 'Highland Light Infantry', 'Black Watch (Royal Highlanders)' etc.
Format: 'DD/MM/YYYY'. Partial dates e.g. '07/1916' also supported, as are date ranges in the form of '31/07/1917 - 10/11/1917'