|
|
726 Read Memorial Definitions~~~Required
We apologize but due to a database error we are unable to complete the request.
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%7BSITE_DATA1%7D ORDER BY ujima_Memorials.LastName, ujima_Memorials.FirstNam...' at line 1 Failing Command: SELECT ujima_Memorials.*, ujima_File_Descriptors.FileNum, ujima_File_Descriptors.FilePath, ujima_File_Descriptors.ImageWidth, ujima_File_Descriptors.ImageHeight, ujima_Verbage.VerbageText, ujima_Locations.LocationName AS KnownCemeteryName, ujima_Locations.Addr1Line1 AS KnownCemeteryAddr1Line1, ujima_Locations.Addr1City AS KnownCemeteryAddr1City, ujima_Locations.Addr1State AS KnownCemeteryAddr1State, ujima_Locations.Addr1Zip AS KnownCemeteryAddr1ZipCode, ujima_Locations.Addr1Latitude AS KnownCemeteryLatitude, ujima_Locations.Addr1Longitude AS KnownCemeteryLongitude, ujima_Locations.Phone1 AS KnownCemeteryPhone1, ujima_Locations.WebsiteURL AS KnownCemeteryWebsiteURL, ZIPCodes.CountyMixedCase AS KnownCounty FROM ujima_Memorials LEFT JOIN ujima_File_Descriptors ON ujima_Memorials.Image1FileNum = ujima_File_Descriptors.FileNum LEFT JOIN ujima_Verbage ON ujima_Memorials.VerbageNum = ujima_Verbage.VerbageNum LEFT JOIN ujima_Locations ON ujima_Memorials.LocationNum = ujima_Locations.LocationNum LEFT JOIN ZIPCodes ON ((ZIPCodes.ZipCode = ujima_Locations.Addr1Zip AND ujima_Locations.LocationNum = ujima_Memorials.LocationNum) AND ZIPCodes.PrimaryRecord = 'P') WHERE ujima_Memorials.SystemNum = 1 AND ujima_Memorials.SubSystemNum IN(1) AND ujima_Memorials.MemorialNum = %7BSITE_DATA1%7D ORDER BY ujima_Memorials.LastName, ujima_Memorials.FirstName, ujima_Memorials.MiddleName LIMIT 0, 100 |
|
|