An unexpected error occurred.

An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID INNER JOIN CollectionAttributeValues cavTopics ON cv.cID = cavTopics.cID and cv.cvID = cavTopics.cvID INNER JOIN CollectionAttributeValues cavTopics ON cv.cID = cavTopics.cID and cv.cvID = cavTopics.cvID INNER JOIN atSelectedTopics atst ON cavTopics.avID = atst.avID INNER JOIN atSelectedTopics atst ON cavTopics.avID = atst.avID INNER JOIN atSelectedTopics atst ON cavTopics.avID = atst.avID INNER JOIN atSelectedTopics atst ON cavTopics.avID = atst.avID WHERE (cvName != ?) AND (pt.ptID = ?) AND (atst.TopicNodeID = ?) AND ((ak_exclude_page_list = 0 or ak_exclude_page_list is null)) AND (p.cParentID = ?) AND (atst.TopicNodeID = ?) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) ORDER BY cv.cvDatePublic desc LIMIT 1000' with params ["", "8", 12, "250", 12, true, false]: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'cavTopics'

< Back to Home