array(3) { [0]=> string(5) "42S02" [1]=> int(1146) [2]=> string(32) "Table 'aatc.locus' doesn't exist" } SQL: [1948] SELECT locus.id, locus.scheme, locus.schemeRedirectSyle, locus.entID, locus.entType, locus.sysID, entities.sysType, locus.langSet, locus.langSetCanonical, locus.entUriSet, locus.entUri, locus.pageSetID, locus.pageSetLandingPage, locus.pageID, locus.epID, locus.epBehaviour, locus.epType, locus.epURL, locus.nofollow, locus.noindex, locus.metaTitle, locus.numStar, locus.numDay, locus.iso, locus.fromPrice, locus.toPrice, locus.metaDescription, locus.metaKeywords, locus.canonicalOverride, locus.label, locus.title, locus.callToAction, locus.icon, entities.`name`, dt_pages.par_1, dt_pages.pageSubHeading, locus.pageOrd FROM locus RIGHT JOIN ( SELECT entFeatures.sid as jsid, locus.entID as jentID, locus.langSet as jlangSet, locus.epType as jepType, locus.pageSetID as jpageSetID FROM locus INNER JOIN entFeatures ON entFeatures.entID = locus.entID INNER JOIN entities ON entFeatures.entID = entities.id WHERE locus.entUri = :url and entFeatures.sid = :sid and locus.sid = entFeatures.sid and entities.epStatus = 1 ) AS target ON target.jsid= locus.sid AND target.jentID = locus.entID INNER JOIN entities ON entities.id = locus.entID LEFT JOIN dt_pages ON locus.pageID = dt_pages.pageID order by langSet , pageSetID,pageOrd asc, epType Sent SQL: [2001] SELECT locus.id, locus.scheme, locus.schemeRedirectSyle, locus.entID, locus.entType, locus.sysID, entities.sysType, locus.langSet, locus.langSetCanonical, locus.entUriSet, locus.entUri, locus.pageSetID, locus.pageSetLandingPage, locus.pageID, locus.epID, locus.epBehaviour, locus.epType, locus.epURL, locus.nofollow, locus.noindex, locus.metaTitle, locus.numStar, locus.numDay, locus.iso, locus.fromPrice, locus.toPrice, locus.metaDescription, locus.metaKeywords, locus.canonicalOverride, locus.label, locus.title, locus.callToAction, locus.icon, entities.`name`, dt_pages.par_1, dt_pages.pageSubHeading, locus.pageOrd FROM locus RIGHT JOIN ( SELECT entFeatures.sid as jsid, locus.entID as jentID, locus.langSet as jlangSet, locus.epType as jepType, locus.pageSetID as jpageSetID FROM locus INNER JOIN entFeatures ON entFeatures.entID = locus.entID INNER JOIN entities ON entFeatures.entID = entities.id WHERE locus.entUri = '/reservation_gorilla-safari-10-day-uganda-culture.html' and entFeatures.sid = '402' and locus.sid = entFeatures.sid and entities.epStatus = 1 ) AS target ON target.jsid= locus.sid AND target.jentID = locus.entID INNER JOIN entities ON entities.id = locus.entID LEFT JOIN dt_pages ON locus.pageID = dt_pages.pageID order by langSet , pageSetID,pageOrd asc, epType Params: 2 Key: Name: [4] :url paramno=-1 name=[4] ":url" is_param=1 param_type=2 Key: Name: [4] :sid paramno=-1 name=[4] ":sid" is_param=1 param_type=2
Array
(
    [url] => /reservation_gorilla-safari-10-day-uganda-culture.html
    [sid] => 402
)
SELECT
            locus.id,
            locus.scheme,
            locus.schemeRedirectSyle,
            locus.entID,
            locus.entType,
            locus.sysID,
            entities.sysType,
            locus.langSet,
            locus.langSetCanonical,
            locus.entUriSet,
            locus.entUri,
            locus.pageSetID,
            locus.pageSetLandingPage,
            locus.pageID,
            locus.epID,
            locus.epBehaviour,
            locus.epType,
            locus.epURL,
            locus.nofollow,
            locus.noindex,
            locus.metaTitle,
            locus.numStar,
            locus.numDay,
            locus.iso,
            locus.fromPrice,
            locus.toPrice,
            locus.metaDescription,
            locus.metaKeywords,
            locus.canonicalOverride,
            locus.label,
            locus.title,
            locus.callToAction,
            locus.icon,
            entities.`name`,
            dt_pages.par_1,
            dt_pages.pageSubHeading,
            locus.pageOrd
            FROM
            locus
            RIGHT JOIN (
              SELECT
               entFeatures.sid as jsid,
               locus.entID as jentID,
               locus.langSet as jlangSet,
               locus.epType as jepType,
                locus.pageSetID as jpageSetID

              FROM
                locus
                INNER JOIN entFeatures ON entFeatures.entID = locus.entID
                INNER JOIN entities ON entFeatures.entID = entities.id
              WHERE
                locus.entUri = :url and entFeatures.sid = :sid and locus.sid = entFeatures.sid  and entities.epStatus = 1
            ) AS target ON target.jsid= locus.sid AND target.jentID = locus.entID 
            INNER JOIN entities ON entities.id = locus.entID
            LEFT JOIN dt_pages ON locus.pageID = dt_pages.pageID
            order by langSet , pageSetID,pageOrd asc, epType
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aatc.locus' doesn't exist