Lines Matching refs:sql
129 $sql = "DELETE FROM ".self::$writable." WHERE ". implode(" AND ", $filters);
132 $query = $this->_db->prepare($sql);
176 $sql = "SELECT subject, predicate, object, graph FROM ".self::$readable." WHERE ". implode(" AND ", $filters).$scopeRestriction;
179 $query = $this->_db->prepare($sql);
217 $sql = "INSERT INTO ".self::$writable."(subject, predicate, object, graph) VALUES(?, ?, ?, ?)";
218 $query = $this->_db->prepare($sql);
251 list($sql, $literals, $projected, $grouped) = $generator->translate($queryTree);
254 $query = $this->_db->prepare($sql);
265 msg(sprintf($this->getLang('debug_sql'),hsc($sql)),-1);
518 'sql'=>'SELECT '.$this->_genPR($tp).' FROM '.helper_plugin_strata_triples::$readable.' WHERE '.$this->_genCond($tp).$scopeRestriction,
551 'sql'=>'SELECT DISTINCT '.$fields.' FROM ('.$gp1['sql'].') AS r1 '.$join.' ('.$gp2['sql'].') AS r2 ON '.$intersect,
645 'sql'=>'SELECT * FROM ('.$gp['sql'].') r WHERE '.$filters,
673 'sql'=>'SELECT DISTINCT * FROM ('.$gp1['sql'].') r1 WHERE NOT EXISTS (SELECT * FROM ('.$gp2['sql'].') r2 WHERE '.$terms.')',
715 'sql'=>'SELECT DISTINCT '.$sa.' FROM ('.$gp1['sql'].') r1 LEFT OUTER JOIN ('.$gp2['sql'].') r2 ON (1=0) UNION SELECT DISTINCT '.$sb.' FROM ('.$gp2x['sql'].') r3 LEFT OUTER JOIN ('.$gp1x['sql'].') r4 ON (1=0)',
825 'sql'=>'SELECT DISTINCT '.$fields.' FROM ('.$gp['sql'].') r'.$ordering,
848 return array('sql'=>'<<INVALID QUERY NODE>>', 'terms'=>array());
857 return array($q['sql'], $this->literals, $this->projected, $this->grouped);