Query Error: Unknown column 'r' in 'where clause'
SQL: SELECT p.id, p.cname, t.filename AS contentfile, l.templatefile AS layoutfile, t.id AS template_id, t.code FROM pages p INNER JOIN pageversions pv ON pv.id = p.published_pageversions_id INNER JOIN templates t ON t.id = p.templates_id INNER JOIN layouts l ON l.id = t.layouts_id WHERE p.isdeleted = 0 AND p.sites_id = '1' AND p.languages_id = 1 AND p.url = 'templates/main/js/gulpified/'+r+'&qlt=45,0' Exception::__set_state(array( 'message' => 'Query Error:
SQL: SELECT p.id, p.cname, t.filename AS contentfile, l.templatefile AS layoutfile, t.id AS template_id, t.code AS templatecode FROM pages p INNER JOIN pageversions pv ON pv.id = p.published_pageversions_id INNER JOIN templates t ON t.id = p.templates_id INNER JOIN layouts l ON l.id = t.layouts_id WHERE p.isdeleted = 0 AND p.sites_id = \'1\' AND p.languages_id = 1 AND p.url = \'templates/main/js/gulpified/\'+r+\'&qlt=45,0\' ', 'string' => '', 'code' => 38387, 'file' => '/var/www/share/esite/classes/Db.Class.php', 'line' => 292, 'trace' => array ( 0 => array ( 'file' => '/var/www/html/mandarinoriental_com/trunk/classes/Navigation.Class.php', 'line' => 152, 'function' => 'Query', 'class' => 'Db', 'type' => '->', 'args' => array ( 0 => 'SELECT p.id, p.cname, t.filename AS contentfile, l.templatefile AS layoutfile, t.id AS template_id, t.code AS templatecode FROM pages p INNER JOIN pageversions pv ON pv.id = p.published_pageversions_id INNER JOIN templates t ON t.id = p.templates_id INNER JOIN layouts l ON l.id = t.layouts_id WHERE p.isdeleted = 0 AND p.sites_id = \'1\' AND p.languages_id = 1 AND p.url = \'templates/main/js/gulpified/\'+r+\'&qlt=45,0\' ', ), ), 1 => array ( 'file' => '/var/www/html/mandarinoriental_com/trunk/structure.php', 'line' => 60, 'function' => 'getStructureXml', 'class' => 'Navigation', 'type' => '->', 'args' => array ( 0 => 1, ), ), 2 => array ( 'file' => '/var/www/share/cde/branches/v1.8.4_chain/caliban.php', 'line' => 1313, 'args' => array ( 0 => '/var/www/html/mandarinoriental_com/trunk/structure.php', ), 'function' => 'include', ), 3 => array ( 'file' => '/var/www/share/cde/branches/v1.8.4_chain/caliban.php', 'line' => 301, 'function' => 'structure', 'class' => 'caliban', 'type' => '->', 'args' => array ( ), ), 4 => array ( 'file' => '/var/www/html/mandarinoriental_com/trunk/index.php', 'line' => 65, 'function' => 'caliban', 'class' => 'caliban', 'type' => '->', 'args' => array ( 0 => '/var/www/html/mandarinoriental_com/trunk/index.php', 1 => array ( 'prePath' => NULL, 'deviceHandling' => 1, ), ), ), ), 'previous' => NULL, ))