Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::College]]OR[[Has posting::College]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_t1` AS t1 ON t0.smw_id=t1.id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
50
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_t1` AS t1 ON t0.smw_id=t1.id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 129 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t2.s_id FROM `mw_smw_di_wikipage` AS t2 WHERE t2.p_id='654' AND t2.o_id='334049'
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t5.s_id FROM `mw_smw_di_wikipage` AS t5 WHERE t5.p_id='1464816' AND t5.o_id='334049'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NonePage name | Description |
---|---|
Huntingdon College | Alabama college |
Illinois College | Part of the Clinton Global Initiative University Network to groom new leaders. |
Kenyon College | |
Knox College | Private liberal arts college in Illinois |
Lafayette College | |
Manhattan College | |
Merritt College | Public community college in Oakland, California. |
Metropolitan Community College (Missouri) | Community college system in the U.S. state of Missouri |
Middlebury College | |
Mississippi College | |
Mount Holyoke College | Exclusive Massachusetts women's college |
Naval War College | |
New College Durham | |
New College of Florida | Liberal arts college in Florida. In 2023, the state government overhauled its board of trustees in an attempt to transform the school into a "beacon of conservative values." |
Oberlin College | Prestigious Ohio college with many ruling class and deep state alumni |
Occidental College | |
Ohio Central College | In 1882, future president Warren G. Harding graduated from the college. |
Oxford University/All Souls College | A center of influence of the Milner Group, although less so than Balliol College |
Oxford University/Balliol College | Exposed by Carroll Quigley's Anglo-American Establishment as a major center of influence for the Milner Group. |
Oxford University/Brasenose College |