Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Constitutes::University]]OR[[Has posting::University]]
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
55
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
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 779 | 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='20828'
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='20828'
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None Page name | Type | Date | Author(s) | Subject(s) | Description |
---|---|---|---|---|---|
Boston College | Jesuit Catholic university.At the city, state and federal levels, BC graduates dominated Massachusetts politics for much of the 20th century. | ||||
Boston University | Big Boston university | ||||
Bournemouth University | Recognised for its work in the media industry | ||||
Boğaziçi University | Turkish elite university with strong ties to the American educational system. | ||||
Bradford University | Founded as the Bradford Mechanics Institute in 1832 | ||||
Bradley University | Midwestern private university | ||||
Brandeis University | Strong liberal arts focus, closely connected to the Jewish community | ||||
Breda University of Applied Sciences | University of applied sciences in the fields of tourism, leisure and hospitality. | ||||
Brigham Young University | 99 percent of the students are Mormons | ||||
Brown University | Ivy League, major deep state hub | ||||
Brunel University | London university | ||||
Bryn Mawr College | A private women's liberal arts college | ||||
Bucharest Polytechnic Institute | The largest technical university in Romania | ||||
CEU San Pablo University | Private Catholic university | ||||
Ca' Foscari University of Venice | From the outset conceived as a national rather than a regional institution | ||||
Cairo University | Most important university in Egypt. | ||||
California Institute of Technology | |||||
California State University | |||||
Calvin College | A private Christian (Calvinist) university | ||||
Cambridge University | British university with lots of ties to the UK and supranational deep states. | ||||
Canterbury Christ Church University | Anglican higher education institution | ||||
Cardiff University | One of the ten largest UK universities. | ||||
Carleton University | Public university in Ottawa, Ontario, Canada. | ||||
Carnegie Mellon University | |||||
Case Western Reserve University | Important research university with significant government ties | ||||
Catholic University of America | The school stays closely connected with the Catholic Church and Catholic organizations. | ||||
Catholic University of Argentina | One of the best private universities in Latin America | ||||
Catholic University of Guayaquil | Claims to be the leading university in Ecuador | ||||
Catholic University of Leuven | |||||
Catholic University of Portugal | Portuguese catholic university with reputation of being an "elite university". | ||||
Catholic University of the Sacred Heart | |||||
Central European University | Founded and financed by George Soros | ||||
Central Queensland University | Began as the Queensland Institute of Technology | ||||
Central University of Ecuador | Most national politicians have studied or worked here | ||||
Central Washington University | Small regional Washington State university | ||||
Chalmers University of Technology | Swedish university located in Gothenburg that focuses on research and education in technology, natural sciences, architecture, mathematics, maritime and other management areas. | ||||
Chaminade University of Honolulu | Catholic university with 66% Asian/Pacific Islander students | ||||
Chapman University | Private research university in California which conducts a yearly survey of what the US public fears. | ||||
Charles University | One of the top universities in Eastern Europe | ||||
Chernivtsi University | Founded in 1875 as the Austrian-Hungarian Franz-Josephs-Universität | ||||
City College of New York | |||||
City University (London) | |||||
City University of New York | |||||
Claremont Graduate University | |||||
Clausthal Technical University | Ranked among the Top German universities in engineering | ||||
Clemson University | South Carolina university with strong military recruitment presence | ||||
Cleveland State University | Cleveland, Ohio public university. | ||||
Colgate University | A private liberal arts college in Hamilton, New York State. | ||||
College of Europe | "An elite finishing school for aspiring Eurocrats". | ||||
College of William and Mary | The second-oldest institution of higher education in the United States |