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
Debug output SQLStore
ASK Query
[[Post relates to::PvP]] [[Post:+]]
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
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_di_wikipage` AS t2
INNER JOIN
  `t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
  `smw_object_ids` AS t5 ON t2.s_id=t5.smw_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=139635
   AND (t5.smw_namespace=120)
  )
  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_lenrefrowsfilteredExtra
1SIMPLEt3ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt2refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, drwiki.t3.id1
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t2.s_id1Using where
1SIMPLEt5eq_refPRIMARY, smw_id, smw_namespacePRIMARY4drwiki.t2.s_id1Using where; Distinct
Auxilliary Tables
  • Temporary table t3
      Recursively computed hierarchy for element(s) (2021460).
      SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021460 LIMIT 1
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
 
2HE vs HE - 11/23/2012 - 00:45
A question for the experts - 09/14/2009 - 07:32
Best way to learn crossbow - 05/13/2013 - 13:09
Blood for the Gods? - 03/19/2012 - 23:43
Blood for the Gods? - 03/20/2012 - 14:56
Bolt Damage Question - 09/05/2015 - 20:20
Consent and Accuse - 4/7/2011 - 11:05:22
Consent based on guarding someone. - 08/20/2011 - 20:49
Consent based on guarding someone. - 08/20/2011 - 21:40
Consent based on guarding someone. - 08/20/2011 - 21:48
Consent based on guarding someone. - 08/20/2011 - 22:11
Consent based on guarding someone. - 08/21/2011 - 00:34
Glaring Holes? - 01/14/2015 - 07:48
Glaring Holes? - 01/14/2015 - 08:24
Halt v. Stun Foe - 9/10/2009 - 15:05:48
Killing an At-Level Opponent - 02/10/2013 - 11:08
Naphtha changes - 05/12/2013 - 11:24
Naphtha changes - 05/12/2013 - 11:40
Necomaners and the policy concerning consent and accusations - 1/12/2010 - 16:28:11
Necromancer Policy & System Changes (Please Read) - 05/07/2019 - 16:02
New Area-of-Effect Options - 02/15/2021 - 17:26
Oh Therengia - 06/09/2011 - 00:31
Oh Therengia - 06/09/2011 - 12:55
Oh Therengia - 06/09/2011 - 16:43
Oh Therengia - 06/11/2011 - 13:37
Oh Therengia - 06/11/2011 - 16:31
One guess what this thread is about! - 01/04/2015 - 10:12
One guess what this thread is about! - 01/04/2015 - 10:31
One guess what this thread is about! - 01/04/2015 - 10:47
One guess what this thread is about! - 01/04/2015 - 9:42
One guess what this thread is about! - 01/09/2015 - 11:56
One guess what this thread is about! - 12/28/2014 - 01:22
One guess what this thread is about! - 12/29/2014 - 11:51
One guess what this thread is about! - 12/29/2014 - 13:44
One guess what this thread is about! - 12/29/2014 - 21:19
Paladin Favored Enemies - 05/15/2014 - 09:45
PvP Profile: Closed (Default) - 08/26/2014 - 17:58
PvP and Soul - 02/20/2017 - 15:31
Re Justice Updates - 03/28/2015 - 14:50
SHNURUI(was: Consent and Accuse, or something) - 4/6/2011 - 20:57:18
SNIPE Change - 09/01/2020 - 14:45
School of PvP - 09/05/2011 - 15:42
Small weapons and special metals questions - 03/16/2015 - 16:31
Some SvS changes - 03/02/2015 - 14:56
Some SvS changes - 03/02/2015 - 15:36
TKS - 08/29/2011 - 01:52
Tactics is a huge problem. - 05/12/2013 - 11:38
Tactics. - 06/16/2013 - 11:34
Therengia Stance - 07/09/2011 - 09:28
Tuesday Tidings - 180 - Kirm Morzindu Updates - 08/01/2023 - 22:13