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
NonePage name | Started | Location | Description |
---|---|---|---|
Boston College | 1863 | Boston Massachusetts | Jesuit Catholic university.At the city, state and federal levels, BC graduates dominated Massachusetts politics for much of the 20th century. |
Boston University | 1839 | Big Boston university | |
Bournemouth University | 1992 | Bournemouth UK | Recognised for its work in the media industry |
Boğaziçi University | 1863 | Turkey Istanbul | Turkish elite university with strong ties to the American educational system. |
Bradford University | 1966 | Bradford | Founded as the Bradford Mechanics Institute in 1832 |
Bradley University | 1897 | US Illinois Peoria | Midwestern private university |
Brandeis University | 1948 | US Boston Massachusetts | Strong liberal arts focus, closely connected to the Jewish community |
Breda University of Applied Sciences | 1 September 1966 | Netherlands Breda | University of applied sciences in the fields of tourism, leisure and hospitality. |
Brigham Young University | 1875 | US Utah Salt Lake City | 99 percent of the students are Mormons |
Brown University | US Rhode Island | Ivy League, major deep state hub | |
Brunel University | 1966 | London United Kingdom | London university |
Bryn Mawr College | 1885 | US Pennsylvania | A private women's liberal arts college |
Bucharest Polytechnic Institute | 1818 | Romania Bucharest | The largest technical university in Romania |
CEU San Pablo University | 1993 | Spain Madrid | Private Catholic university |
Ca' Foscari University of Venice | 1868 | Italy Venice | From the outset conceived as a national rather than a regional institution |
Cairo University | 1908 | Egypt Cairo | Most important university in Egypt. |
California Institute of Technology | |||
California State University | |||
Calvin College | 1876 | US Michigan Grand Rapids | A private Christian (Calvinist) university |
Cambridge University | 1209 JL | Cambridge | British university with lots of ties to the UK and supranational deep states. |
Canterbury Christ Church University | 2005 | Canterbury UK | Anglican higher education institution |
Cardiff University | 1883 | Wales Cardiff | One of the ten largest UK universities. |
Carleton University | 1942 | Canada Ottawa Ontario | Public university in Ottawa, Ontario, Canada. |
Carnegie Mellon University | |||
Case Western Reserve University | 1826 | US Ohio Cleveland | Important research university with significant government ties |
Catholic University of America | 1887 | The school stays closely connected with the Catholic Church and Catholic organizations. | |
Catholic University of Argentina | 1958 | Argentina | One of the best private universities in Latin America |
Catholic University of Guayaquil | 1962 | Ecuador Guayaquil | Claims to be the leading university in Ecuador |
Catholic University of Leuven | Belgium | ||
Catholic University of Portugal | 1967 | Portugal Lisbon | Portuguese catholic university with reputation of being an "elite university". |
Catholic University of the Sacred Heart | Milan | ||
Central European University | 1991 | Vienna | Founded and financed by George Soros |
Central Queensland University | 1967 | Australia Queensland | Began as the Queensland Institute of Technology |
Central University of Ecuador | 1620 | Ecuador Quito | Most national politicians have studied or worked here |
Central Washington University | 1891 | US Washington State | Small regional Washington State university |
Chalmers University of Technology | 1829 | Sweden Gothenburg | 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 | 1955 | US Hawaii Honolulu | Catholic university with 66% Asian/Pacific Islander students |
Chapman University | 1861 | Orange California. | Private research university in California which conducts a yearly survey of what the US public fears. |
Charles University | 1348 JL | One of the top universities in Eastern Europe | |
Chernivtsi University | 1875 | Ukraine | Founded in 1875 as the Austrian-Hungarian Franz-Josephs-Universität |
City College of New York | 1847 | New York US | |
City University (London) | |||
City University of New York | New York US | ||
Claremont Graduate University | |||
Clausthal Technical University | 1775 | Germany | Ranked among the Top German universities in engineering |
Clemson University | 1889 | US South Carolina | South Carolina university with strong military recruitment presence |
Cleveland State University | 1964 | US Ohio Cleveland | Cleveland, Ohio public university. |
Colgate University | 1819 | New York State | A private liberal arts college in Hamilton, New York State. |
College of Europe | 1949 | Belgium Poland Warsaw Bruges | "An elite finishing school for aspiring Eurocrats". |
College of William and Mary | 1693 | US Virginia Williamsburg | The second-oldest institution of higher education in the United States |