An error occurred executing the following query, and page execution has been terminated.
SELECT contentID, contTitle, section, displayDate, startDate, seoURL, shortIntro, mainContent, picTitle, picFile, (SELECT MIN(edEventDate) FROM tbltotalswindonEventDates e WHERE edContentID = contentID AND edEventDate >= '6/5/2023 07:30:06') AS edEventDate, groupColour, linkName, eventLocation, publication, document, (SELECT m_value FROM tbltotalswindonContentMeta WHERE m_contentID = contentID AND m_key = 'Advertiser') AS Advertiser , (SELECT m_value FROM tbltotalswindonContentMeta WHERE m_contentID = contentID AND m_key = 'Advertiser') AS Advertiser FROM tbltotalswindonContentLive c JOIN tbltotalswindonRelatedContent r ON ((r.relContentID = '3962' AND r.relatedContentID = c.contentID) OR (r.relatedContentID = '3962' AND r.relContentID = c.contentID)) LEFT JOIN tbltotalswindonGroups g ON g.groupID = c_groupID LEFT JOIN tbltotalswindonContentImagesLive i ON i.picID = (SELECT TOP 1 il.picID FROM tbltotalswindonContentImagesLive il WHERE il.picContentID = c.contentID AND il.status = 'live' ORDER BY picDisplayOrder ASC) AND i.status = 'live' WHERE mastersection = 'events' AND (relatedmastersection <> 'listings' AND relatedmastersection <> 'bannerads') AND c.status = 'live' AND c.startDate <= '6/5/2023 07:30:06' AND (c.endDate = '01/01/2000' OR c.endDate >= '6/5/2023 07:30:06') AND (SELECT MIN(edEventDate) FROM tbltotalswindonEventDates e WHERE edContentID = contentID AND edEventDate >= '6/5/2023 07:30:06') >= '6/5/2023 07:30:06' ORDER BY (SELECT MIN(edEventDate) FROM tbltotalswindonEventDates e WHERE edContentID = contentID AND edEventDate >= '6/5/2023 07:30:06') 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.totalswindon.com:443/lifestyle/easter-in-swindon/?generate=cache