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
[[page type::article]]
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, t5.o_sortkey
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
  `smw_fpt_mdat` AS t5 ON t0.smw_id=t5.s_id
WHERE
  (t1.p_id=6354 AND t1.o_id=6355)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t5.o_sortkey DESC
LIMIT
  25
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id5const38417.24Using where; Using temporary; Using filesort
1SIMPLEt5refs_ids_id4htyp_mw.t1.s_id1100.00
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4htyp_mw.t1.s_id183.76Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
ArticleModification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>.
HTML entity26 April 2021 21:15:32
PHP-GTK5 April 2021 16:21:09
The Schemers9 November 2020 21:17:19
MariaDB7 November 2020 19:41:33
nanotape28 October 2020 18:32:42
Dovecot23 October 2020 14:33:29
Fiat Fiendum13 October 2020 23:16:45
Signal29 September 2020 12:54:31
Free Pascal18 September 2020 14:18:08
Lazarus IDE18 September 2020 14:17:58
Schumacher/SC-7500A22 August 2020 00:05:24
Schumacher Electric21 August 2020 23:50:32
Honda5 August 2020 15:01:33
US/highway/15-5014 August 2020 20:57:08
House of Tulip30 July 2020 21:59:56
Tenacious Unicorn Ranch30 July 2020 21:45:30
Linux30 July 2020 13:54:24
Twitter29 July 2020 19:31:18
Semantic MediaWiki28 July 2020 21:04:16
Facebook27 July 2020 23:38:16