Senior Team

An error occurred executing the following query, and page execution has been terminated.

SELECT contentID, linkName, contTitle, shortIntro, mainContent, template, seoURL, picTitle, picFile, c_groupID, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Button Text') AS subButtonText, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Background') AS subBackgroundClass, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Display') AS subNavDisplay, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Size') AS subNavSize, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Colour') AS subNavColour, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Title') AS SubTitle, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Intro') AS SubIntro, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Load Child Content') AS loadChildContent, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Child Content Limit') AS childContentLimit, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Remove Link') AS removeLink, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Document Link') AS documentLink, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Contact Tel') AS contactTel, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Contact Email') AS contactEmail, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'In-Page Icon') AS subIcon, (SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Service Icon') AS serviceIcon, contDocs, contPanels, author, mastersection FROM tblKinaxiaNewContentLive c JOIN tblKinaxiaNewContentMeta ON m_contentID = contentID AND m_key = 'Display In-Page' AND m_value = 'Yes' LEFT JOIN tblKinaxiaNewContentImagesLive i ON i.picID = (SELECT TOP 1 il.picID FROM tblKinaxiaNewContentImagesLive il WHERE il.picContentID = c.contentID AND il.status = 'live' AND (il.picPosition = '' OR il.picPosition IS NULL OR il.picPosition = 'main') ORDER BY picDisplayOrder ASC) AND i.status = 'live' WHERE (mastersection = 'main' OR mastersection = 'casestudies') AND c.status = 'live' AND parentID = '42' AND ((SELECT m_value FROM tblKinaxiaNewContentMeta WHERE m_contentID = contentID AND m_key = 'Show in service panel') = 'yes') AND startDate <= '5/3/2024' AND (endDate = '01/01/2000' OR endDate >= '5/3/2024') ORDER BY displayOrder 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;http://kinaxia.h2multimedia.co.uk:80/senior-team/