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}_versionsVersioned.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();