array(3) { [0]=> string(5) "42S02" [1]=> int(1146) [2]=> string(32) "Table 'aatc.locus' doesn't exist" } SQL: [1132] SELECT flow.id, flow.locusID, flow.`name`, flow.url, flow.epURL, flow.numDays, flow.numStars, flow.displayName, flow.title, flow.orientation, flow.viewMode, flow.printParentIsTarget, flow.printIsTargetSibling, flow.printNephewOfParent, flow.printSiblingOfParent, flow.printIsTargetParent, flow.printParentSibling, flow.printParentIsInTargetPath, flow.printAncestorOfTarget, flow.htmlBlob, flow.siteID, flow.root_id, flow.lft, flow.rgt, flow.tmpid, flow.tmp2id from flow where flow.epURL in (SELECT locus.entUri AS URI FROM locus RIGHT JOIN ( SELECT sid as jsid, entID as jentID, pageSetID as jpageSetID FROM locus WHERE locus.entUri = :entUri ) AS target on target.jsid = locus.sid and target.jentID = locus.entID and target.jpageSetID = locus.pageSetID order by epType) and root_id = :sid and (isSymbolic = 0 or isSymbolic is null) order by lft Sent SQL: [1209] SELECT flow.id, flow.locusID, flow.`name`, flow.url, flow.epURL, flow.numDays, flow.numStars, flow.displayName, flow.title, flow.orientation, flow.viewMode, flow.printParentIsTarget, flow.printIsTargetSibling, flow.printNephewOfParent, flow.printSiblingOfParent, flow.printIsTargetParent, flow.printParentSibling, flow.printParentIsInTargetPath, flow.printAncestorOfTarget, flow.htmlBlob, flow.siteID, flow.root_id, flow.lft, flow.rgt, flow.tmpid, flow.tmp2id from flow where flow.epURL in (SELECT locus.entUri AS URI FROM locus RIGHT JOIN ( SELECT sid as jsid, entID as jentID, pageSetID as jpageSetID FROM locus WHERE locus.entUri = '/Kruger_Park_Romantic_Lodge_Safari-travel/reservation_memorable-luxury-safari.html' ) AS target on target.jsid = locus.sid and target.jentID = locus.entID and target.jpageSetID = locus.pageSetID order by epType) and root_id = '12' and (isSymbolic = 0 or isSymbolic is null) order by lft Params: 2 Key: Name: [4] :sid paramno=-1 name=[4] ":sid" is_param=1 param_type=2 Key: Name: [7] :entUri paramno=-1 name=[7] ":entUri" is_param=1 param_type=2
Array
(
    [sid] => 12
    [entUri] => /Kruger_Park_Romantic_Lodge_Safari-travel/reservation_memorable-luxury-safari.html
)
SELECT
      flow.id,
      flow.locusID,
      flow.`name`,
      flow.url,
      flow.epURL,
      flow.numDays,
      flow.numStars,
      flow.displayName,
      flow.title,
      flow.orientation,
      flow.viewMode,
      flow.printParentIsTarget,
      flow.printIsTargetSibling,
      flow.printNephewOfParent,
      flow.printSiblingOfParent,
      flow.printIsTargetParent,
      flow.printParentSibling,
      flow.printParentIsInTargetPath,
      flow.printAncestorOfTarget,
      flow.htmlBlob,
      flow.siteID,
      flow.root_id,
      flow.lft,
      flow.rgt,
      flow.tmpid,
      flow.tmp2id
      from flow
      where 
      flow.epURL in (SELECT
        locus.entUri AS URI
      FROM
        locus
      RIGHT JOIN (
        SELECT
         sid as jsid,
         entID as jentID,
         pageSetID as jpageSetID
        FROM
          locus
        WHERE
          locus.entUri = :entUri
      ) AS target on target.jsid = locus.sid and target.jentID = locus.entID and target.jpageSetID = locus.pageSetID 
      order by epType) and root_id = :sid and (isSymbolic = 0 or isSymbolic is null) order by lft
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aatc.locus' doesn't exist