elijahlofgren@kubuntu:~/www/silverstripe-gsoc/sapphire/core/model$ grep FROM *
ComponentSet.php:                               DB::query("DELETE FROM `$this->tableName` WHERE $parentField = {$this->ownerObj->ID} AND $childField = {$item->ID}");
ComponentSet.php:                               DB::query("DELETE FROM `$this->tableName` WHERE $parentField = {$this->ownerObj->ID} AND $childField IN ($itemCSV)");
ComponentSet.php:               DB::query("DELETE FROM `$this->tableName` WHERE $parentField = {$this->ownerObj->ID} AND $filter");
ComponentSet.php:                       DB::query("DELETE FROM `$this->tableName` WHERE $parentField = {$this->ownerObj->ID}");
DatabaseAdmin.php:                      if(!DB::query("SELECT * FROM Member")->value()) {
DatabaseAdmin.php:                              $records = DB::query("SELECT * FROM `$baseClass`");
DatabaseAdmin.php:                                      $recordExists[$subclass] = DB::query("SELECT ID FROM `$subclass")->keyedColumn();
DatabaseAdmin.php:                                                      $sql = "DELETE FROM `$subclass` WHERE ID = $record[ID]";
DataObject.php:                         $hasData = (DB::query("SELECT ID FROM `".strtolower($baseClass)."`")->value());
DataObject.php.orig:                            $hasData = (DB::query("SELECT ID FROM `{$baseClass}`")->value());
Image.php:              $images = DB::query("SELECT * FROM _obsolete_Image");
MySQLDatabase.php:              $result = $this->query("SELECT MAX(ID)+1 FROM `".strtolower($table)."`")->value();
MySQLDatabase.php:              $changes = $this->query("SELECT ID, `$fieldName` FROM `$tableName`")->map();
SiteTree.php:                           $nextID = DB::query("SELECT ParentID FROM SiteTree WHERE ID = $nextID")->value();
SiteTree.php:                           "SELECT MAX(Sort) + 1 FROM SiteTree WHERE ParentID = $this->ParentID")->value();
SiteTree.php:           $badURLs = "'" . implode("', '", DB::query("SELECT URLSegment, count(*) FROM SiteTree GROUP BY URLSegment HAVING count(*) > 1")->column()) . "'";
SiteTree.php:           $badURLs = "'" . implode("', '", DB::query("SELECT URLSegment, count(*) FROM SiteTree GROUP BY URLSegment HAVING count(*) > 1")->column()) . "'";
SiteTree.php:           $pages = DB::query("SELECT *, SiteTree.ID FROM SiteTree LEFT JOIN Page ON Page.ID = SiteTree.ID WHERE  URLSegment IN ($badURLs)");
SiteTree.php:           return (DB::query("SELECT ID FROM `SiteTree_Live` WHERE ID = $this->ID")->value())
SiteTree.php:                           DB::query("SELECT Version FROM SiteTree WHERE ID = $this->ID")->value();
SiteTree.php:                           DB::query("SELECT Version FROM SiteTree_Live WHERE ID = $this->ID")->value();
SiteTree.php.orig:                              $nextID = DB::query("SELECT ParentID FROM SiteTree WHERE ID = $nextID")->value();
SiteTree.php.orig:                      $this->Sort = DB::query("SELECT MAX(Sort) + 1 FROM SiteTree WHERE ParentID = $this->ParentID")->value();
SiteTree.php.orig:              $badURLs = "'" . implode("', '", DB::query("SELECT URLSegment, count(*) FROM SiteTree GROUP BY URLSegment HAVING count(*) > 1")->column()) . "'";
SiteTree.php.orig:              $badURLs = "'" . implode("', '", DB::query("SELECT URLSegment, count(*) FROM SiteTree GROUP BY URLSegment HAVING count(*) > 1")->column()) . "'";
SiteTree.php.orig:              $pages = DB::query("SELECT *, SiteTree.ID FROM SiteTree LEFT JOIN Page ON Page.ID = SiteTree.ID WHERE  URLSegment IN ($badURLs)");
SiteTree.php.orig:              return DB::query("SELECT ID FROM `SiteTree_Live` WHERE ID = $this->ID")->value() ? true : false;
SiteTree.php.orig:                      $stageVersion = DB::query("SELECT Version FROM SiteTree WHERE ID = $this->ID")->value();
SiteTree.php.orig:                      $liveVersion = DB::query("SELECT Version FROM SiteTree_Live WHERE ID = $this->ID")->value();
SQLQuery.php:           $text .= " FROM " . implode(" ", $this->from);
Versioned.php:                          SELECT RecordID, max(Version) FROM {$baseTable}_versions
Versioned.php:                                  if(!DB::query("SELECT * FROM {$table}_$stage")->value()) {
Versioned.php:                                                  SELECT ID,$fieldList FROM `$table`");
Versioned.php:                  if(!DB::query("SELECT * FROM {$table}_versions")->value()) {
Versioned.php:                                  SELECT $fieldList, ID AS RecordID, 1 AS Version FROM `$table`");
Versioned.php:                          $data = DB::query("SELECT * FROM $table WHERE ID = $id")->record();
Versioned.php:                          if($id && !isset($nextVersion)) $nextVersion = DB::query("SELECT MAX(Version) + 1 FROM {$table}_versions WHERE RecordID = $id")->value();
Versioned.php:          return DB::query("SELECT $table1.Version = $table2.Version FROM $table1 INNER JOIN $table2 ON $table1.ID = $table2.ID WHERE $table1.ID = ".  $this->owner->ID)->value();
Versioned.php:          $stagesAreEqual = DB::query("SELECT if(`$table1`.Version=`$table2`.Version,1,0) FROM `$table1` INNER JOIN `$table2` ON `$table1`.ID = `$table2`.ID AND `$table1`.ID = {$this->owner->ID}")->value();