Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [] 
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[Has fullPageName::+]]
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_smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id='2398164')
  AND 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
  1000
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,p_id,s_id_2p_id4const67090Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4wikispooks.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:1
Errors and Warnings
None
Page nameHas fullPageName
Dean AchesonDean Acheson
Achille Lauro hijackingAchille Lauro hijacking
Theodore AchillesTheodore Achilles
Tendayi AchiumeTendayi Achiume
Ann-Kristin AchleitnerAnn-Kristin Achleitner
Paul AchleitnerPaul Achleitner
Achnacarry AgreementAchnacarry Agreement
Josef AckermannJosef Ackermann
Ackworth SchoolAckworth School
Antony AclandAntony Acland
Alexander AcostaAlexander Acosta
Action Committee for the United States of EuropeAction Committee for the United States of Europe
Action Council for Peace in the BalkansAction Council for Peace in the Balkans
Action Counters TerrorismAction Counters Terrorism
Active Change FoundationActive Change Foundation
Active Change Foundation/CEOActive Change Foundation/CEO
Active Change Foundation/DirectorActive Change Foundation/Director
Active Measures Working GroupActive Measures Working Group
ActivistActivist
Activist PostActivist Post
Activist Teacher BlogActivist Teacher Blog
ActivityActivity
ActorActor
Ad hominemAd hominem
Allan AdairAllan Adair
Adam Smith InternationalAdam Smith International
Valdas AdamkusValdas Adamkus
Gerry AdamsGerry Adams
Iris AdamsIris Adams
James AdamsJames Adams
Jerome AdamsJerome Adams
John AdamsJohn Adams
John Bodkin AdamsJohn Bodkin Adams
Mike AdamsMike Adams
Sherman AdamsSherman Adams
Stanley AdamsStanley Adams
Clara Leach Adams-EnderClara Leach Adams-Ender
Gautam AdaniGautam Adani
AdbustersAdbusters
AddictAddict
David AddingtonDavid Addington
Adelaide ClubAdelaide Club
Adelaide EstablishmentAdelaide Establishment
Adelaide UniversityAdelaide University
Kenneth AdelmanKenneth Adelman
Adelphi UniversityAdelphi University
Sheldon AdelsonSheldon Adelson
Konrad AdenauerKonrad Adenauer
Debo AdesinaDebo Adesina
Adessium FoundationAdessium Foundation
Retrieved from "https://wikispooks.com/wiki/Special:Ask"