An error occurred executing the following query, and page execution has been terminated.
SELECT contentID, contTitle, section, displayDate, startDate, seoURL, shortIntro, mainContent, picTitle, picFile, eventDate, groupColour, linkName, (SELECT m_value FROM tbltotalbristolContentMeta WHERE m_contentID = contentID AND m_key = 'Advertiser') AS Advertiser FROM tbltotalbristolContentLive c JOIN tbltotalbristolRelatedContent r ON (r.relContentID = '2488' AND r.relatedContentID = c.contentID) LEFT JOIN tbltotalbristolGroups g ON g.groupID = c_groupID LEFT JOIN tbltotalbristolContentImagesLive i ON i.picID = (SELECT TOP 1 il.picID FROM tbltotalbristolContentImagesLive il WHERE il.picContentID = c.contentID AND il.status = 'live' ORDER BY picDisplayOrder ASC) AND i.status = 'live' WHERE (mastersection = 'news' OR mastersection = 'main') AND (relatedmastersection <> 'listings' AND relatedmastersection <> 'bannerads') AND c.status = 'live' AND c.startDate <= '11/23/2024 11:08:27' AND (c.endDate = '01/01/2000' OR c.endDate >= '11/23/2024 11:08:27') ORDER BY c.mastersection ASC, c.startDate DESC, c.contentID ASC, c.contTitle ASC
Error Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Page of error : /404/index.asp
Query String :
404;https://www.totalbristol.com:443/lifestyle/secondary-school-pupils-to-participate-in-bridge-building-challenge/