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 objectClass::Publication]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id='2398166' AND t1.o_id='218665')
  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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39const,const257Using 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:2
Query-Depth:1
Errors and Warnings
None
Page nameImageType
200 Years TogetherSolzhenytsin1.jpgbook
9-11/Commission/Report911report cover HIGHRES.pngreport
A Very British CoupBritishCoup.jpgTV series
America's Secret EstablishmentAmerica's Secret Establishment.jpgbook
American War MachineAmerican War Machine.jpgbook
Balfour Declaration of 1917Balfour Declaration.jpgletter
Basel IIIagreement
Berlingske TidendeBerlingske.jpgnewspaper
Boston Heraldnewspaper
Brave New WorldFiction
Brazil (film)Brazil (film).jpgfiction
Britannia UnchainedBritannia Unchained.jpgBook
British Briefingmagazine, secret
Budapest Memorandum on Security Assurances
Capricorn OneFiction
Cathy Don’t Go To The Supermarket TodayCathy Don’t Go To The Supermarket Today.jpg
Children of MenChildren of men.jpgfiction
Civil Contingencies Act 2004Civil Contingencies Act 2004.jpglegal
Commentary (magazine)magazine
Communist ManifestoCommunist Manifesto.pngmanifesto
Compromised: Clinton, Bush and the CIAMena-Compromised.jpgbook
Confessions of an Economic Hit ManEconomichitman.jpgbook
Confickersoftware
Conjuring HitlerConjuringHitler.jpgbook
Conspiracy FilesTV series
Conspiracy of Silencefilm
Control FactorControl Factor.jpgfiction
Convention on Certain Conventional Weaponstreaty
Convention on the Elimination of All Forms of Discrimination Against WomenConvention on the Elimination of All Forms of Discrimination Against Women.svg
Convention on the Rights of the ChildConvention on the Rights of the Child.svg
Corriere della Sera1938-Corriere.jpgDaily newspaper
CounterSpyCounterSpy.jpgmagazine
Coup d'etat in slow motionCoupdetatinslowmotion.jpgbook
CovertAction QuarterlyCAM.jpgmagazine
Craigie-Arita Agreementtreaty
Cypherpunks: Freedom and the Future of the InternetCypherpunks - Freedom and the Future of the Internet.jpgbook
Daily ExpressShoot all bombers.jpgnewspaper
Daily MailDaily Mail.jpgnewspaper
Daily MirrorDaily Mirror Sep 12.jpgnewspaper
Daily RecordThe Daily Record’s official Facebook page on 2022-01-05.jpgnewspaper
Dark AllianceDark Alliance.jpgbook
De Groene AmsterdammerGroeneAmst.pngIndependent
De TelegraafDe T.jpgCommercial
De Volkskrantnewspaper
Death with Interruptions (book)3018539.jpg
Defamation FactoryDefamation-factory-front-cover.jpgBook
Defence Online Engagement Strategydocument
Defrauding AmericaDefrauding America.jpginvestigation
Der SpiegelDer Spiegel 1982.jpgmagazine
Digital Economy Act 2017law
Retrieved from "https://wikispooks.com/wiki/Special:Ask"