List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| ' SELECT DISTINCT ?s WHERE { ?s ?p ?o . } ORDER BY ?s LIMIT ' . $limit . ' ' . ($offset ? 'OFFSET ' . $offset : '') . ' ' | 1 |
|
| ' SELECT G.g FROM ' . $tbl_prefix . 'g2t G LEFT JOIN ' . $tbl_prefix . 'triple T ON ( T.t = G.t ) WHERE T.t IS NULL LIMIT 1 ' | 1 |
|
| 'SELECT id, val FROM ' . $tbl . ' WHERE val LIKE "' . mysql_real_escape_string($old_uri, $con) . '%"' | 1 |
|
| "UPDATE " . $tbl . " SET val = '" . mysql_real_escape_string($new_val, $con) . "' WHERE id = " . $row['id'] | 1 |
|
| "UPDATE " . $this->store->getTablePrefix( ) . $t_tbl . " SET " . $t_col . " = " . $new_id . " WHERE " . $t_col . " = " . $row['id'] | 1 |
|
| "SELECT * WHERE {\n GRAPH ?g { ?s ?p ?o . }\n}\nLIMIT 10" | 1 |
|
| ' SELECT VS.val AS s, T.s_type AS `s type`, VP.val AS p, 0 AS `p type`, VO.val AS o, T.o_type AS `o type`, VLDT.val as `o lang_dt`, VG.val as g, 0 AS `g type` FROM ' . $prefix . 'triple T JOIN ' . $prefix . 's2val VS ON (T.s = VS.id) JOIN ' . $prefix . 'id2val VP ON (T.p = VP.id) JOIN ' . $prefix . 'o2val VO ON (T.o = VO.id) JOIN ' . $prefix . 'id2val VLDT ON (T.o_lang_dt = VLDT.id) JOIN ' . $prefix . 'g2t G2T ON (T.t = G2T.t) JOIN ' . $prefix . 'id2val VG ON (G2T.g = VG.id) ' | 1 |
|
| 'SELECT success FROM ' . $tmp_tbl | 1 |
|
| 'DELETE FROM ' . $tbl_prefix . 'g2t WHERE g = ' . $g_id | 1 |
|
| 'DELETE ' . $this->getTripleTable( ) | 1 |
|
| ' SELECT T.t FROM ' . $tbl_prefix . 'triple T LEFT JOIN ' . $tbl_prefix . 'g2t G ON ( G.t = T.t ) WHERE G.t IS NULL LIMIT 1 ' | 1 |
|
| 'DELETE ' . $tbl_prefix . 'triple' | 1 |
|
| 'DELETE ' . $tbl_prefix . 'o2val' | 1 |
|
| 'SELECT DISTINCT ?p WHERE { <' . $res . '> ?p ?o . }' | 1 |
|
| 'DELETE ' . $tbl_prefix . 's2val' | 1 |
|
| 'DELETE ' . $tbl_prefix . 'id2val' | 1 |
|
| 'INSERT INTO <' . $g . '> { ' . $this->toNTriples($doc, '', 1) . ' }' | 1 |
|
| 'DELETE FROM <' . $g . '>' | 1 |
|
| 'DELETE FROM <' . $g . '> { ' . $this->toNTriples($doc, '', 1) . ' }' | 1 |
|
| "SELECT MAX(t) AS `id` FROM " . $this->store->getTablePrefix( ) . "triple" | 1 |
|
| "SELECT id AS `id`, val AS `val` FROM " . $tbl_prefix . $sub_tbl . " WHERE val_hash = BINARY '" . $this->getValueHash($val) . "'" | 1 |
|
| "SELECT id AS `id` FROM " . $tbl_prefix . $sub_tbl . " WHERE val = BINARY '" . mysql_real_escape_string($val, $con) . "'" | 1 |
|
| "SELECT t FROM " . $this->store->getTablePrefix( ) . "triple WHERE s = " . $t['s'] . " AND p = " . $t['p'] . " AND o = " . $t['o'] . " AND o_lang_dt = " . $t['o_lang_dt'] . " AND s_type = " . $t['s_type'] . " AND o_type = " . $t['o_type'] . " LIMIT 1 " | 1 |
|
| "INSERT IGNORE INTO " . $this->store->getTablePrefix( ) . $tbl . " (t, s, p, o, o_lang_dt, o_comp, s_type, o_type) VALUES" | 1 |
|
| "INSERT IGNORE INTO " . $this->store->getTablePrefix( ) . $tbl . " (g, t) VALUES" | 1 |
|
| ' SELECT ?val WHERE { <' . $id . '> ?p ?val . FILTER(REGEX(str(?p), "(label|title|name|summary)$")) } LIMIT 1 ' | 1 |
|
| 'SELECT ?val WHERE {<' . $p . '> rdfs:range ?val . } LIMIT 1' | 1 |
|
| 'INSERT INTO <label-properties> { ' . $sub_q . ' }' | 1 |
|
| "DELETE FROM " . $tbl . " WHERE k = '" . md5($k) . "'" | 1 |
|
| 'DELETE FROM ' . $old_tbl . ' WHERE ' . $old_tbl . '.p = ' . $p_id | 1 |
|
| 'SELECT ?p COUNT(?p) AS ?pc WHERE { ?s ?p ?o } GROUP BY ?p ORDER BY DESC(?pc) LIMIT ' . $limit | 1 |
|
| 'INSERT INTO ' . $tbl . ' ' . "\n" . $q_sql | 1 |
|
| 'SHOW TABLE STATUS LIKE "' . $this->getTablePrefix( ) . 'setting"' | 1 |
|
| 'SHOW COLUMNS FROM ' . $tbl . ' LIKE "t"' | 1 |
|
| 'SHOW COLUMNS FROM ' . $tbl . ' LIKE "val_hash"' | 1 |
|
| 'SHOW INDEX FROM ' . $tbl | 1 |
|
| 'SHOW PROCESSLIST' | 1 |
|
| 'SHOW FULL PROCESSLIST' | 1 |
|
| "SELECT 1 FROM " . $tbl . " LIMIT 0" | 1 |
|
| "UPDATE " . $tbl . " SET val = '" . mysql_real_escape_string(serialize($v), $con) . "' WHERE k = '" . md5($k) . "'" | 1 |
|
| "INSERT INTO " . $tbl . " (k, val) VALUES ('" . md5($k) . "', '" . mysql_real_escape_string(serialize($v), $con) . "')" | 1 |
|
| "INSERT IGNORE INTO " . $this->store->getTablePrefix( ) . $tbl . "(" . $cols . ") VALUES " | 1 |
|
| "SELECT val FROM " . $this->getTablePrefix( ) . $tbl . " WHERE id = " . mysql_real_escape_string($id, $con) . " LIMIT 1" | 1 |
|
| 'DELETE FROM <label-properties>' | 1 |
|
| 'SELECT ?label WHERE { <' . $res . '> ?p ?label . ?p a <http://semsol.org/ns/arc#LabelProperty> } LIMIT 3' | 1 |
|
| 'SELECT GET_LOCK("' . $l_name . '", ' . $t_out_init . ') AS success' | 1 |
|
| 'SELECT IS_FREE_LOCK("' . $l_name . '") AS success' | 1 |
|
| 'SELECT COUNT(*) AS t_count WHERE { ?s ?p ?o}' | 1 |
|
| "SELECT id, val FROM " . $this->getTablePrefix( ) . $tbl . " WHERE val_hash = '" . $this->getValueHash($val) . "'" | 1 |
|
| 'INSERT IGNORE INTO ' . $new_prefix . $tbl . ' SELECT * FROM ' . $old_prefix . $tbl | 1 |
|
| "SELECT id FROM " . $this->getTablePrefix( ) . $tbl . " WHERE val = BINARY '" . mysql_real_escape_string($val, $con) . "' LIMIT 1" | 1 |
|
| ' INSERT IGNORE INTO ' . $new_tbl . ' SELECT * FROM ' . $old_tbl . ' WHERE ' . $old_tbl . '.p = ' . $p_id . ' ' | 2 |
|
| 'DELETE T' | 2 |
|
| 'DELETE ' . $tbl_prefix . 'g2t' | 2 |
|
| "SELECT val FROM " . $tbl . " WHERE k = '" . md5($k) . "'" | 2 |
|
| 'DELETE G' | 2 |
|
| 'SELECT DISTINCT ?type WHERE {?s <' . $p . '> ?o ; a ?type . }' | 2 |
|
| 'SELECT ?o WHERE { <' . $res . '> ?p ?o . FILTER(REGEX(str(?p), "(label|name)$", "i"))}' | 2 |
|
| 'DELETE V' | 3 |
|