Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

Dzēst

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Issue of::Padomju Jaunatne]]
 |?Published on#ISO=Datums
 |?Published in year#-=Gads
 |?Issue number=Numurs
 |?Number of pages=Lappuses
 |format=table
 |limit=50
 |offset=100
 |sort=
 |order=asc
 |headers=plain
 |mainlabel=
 |default=Nav pievienots neviens numurs
 |class=wikitable smwtable
}}

Rezultāti 101 – 150 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Issue of::Padomju Jaunatne]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0263",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Issue of::Padomju Jaunatne]]

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
`wik2smw_object_ids` AS t0
INNER JOIN
`wik2smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='522' AND t1.o_id='610')
  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
100

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id_3	9	const,const	994	Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	bpd_wikiver2.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

	Datums	Gads	Numurs	Lappuses
PJ19860529	1986-05-29	1986	103	4
PJ19860530	1986-05-30	1986	104	4
PJ19860531	1986-05-31	1986	105	4
PJ19860603	1986-06-03	1986	106	4
PJ19860604	1986-06-04	1986	107	4
PJ19860605	1986-06-05	1986	108	4
PJ19860606	1986-06-06	1986	109	4
PJ19860607	1986-06-07	1986	110	4
PJ19860610	1986-06-10	1986	111	4
PJ19860611	1986-06-11	1986	112	4
PJ19860612	1986-06-12	1986	113	4
PJ19860613	1986-06-13	1986	114	4
PJ19860614	1986-06-14	1986	115	4
PJ19860617	1986-06-17	1986	116	4
PJ19860618	1986-06-18	1986	117	4
PJ19860619	1986-06-19	1986	118	4
PJ19860620	1986-06-20	1986	119	4
PJ19860621	1986-06-21	1986	120	4
PJ19860624	1986-06-24	1986	121	4
PJ19860625	1986-06-25	1986	122	4
PJ19860626	1986-06-26	1986	123	4
PJ19860627	1986-06-27	1986	124	4
PJ19860628	1986-06-28	1986	125	4
PJ19860701	1986-07-01	1986	126	4
PJ19860702	1986-07-02	1986	127	4
PJ19860703	1986-07-03	1986	128	4
PJ19860704	1986-07-04	1986	129	4
PJ19860705	1986-07-05	1986	130	4
PJ19860708	1986-07-08	1986	131	4
PJ19860709	1986-07-09	1986	132	4
PJ19860710	1986-07-10	1986	133	4
PJ19860711	1986-07-11	1986	134	4
PJ19860712	1986-07-12	1986	135	4
PJ19860715	1986-07-15	1986	136	4
PJ19860716	1986-07-16	1986	137	4
PJ19860717	1986-07-17	1986	138	4
PJ19860718	1986-07-18	1986	139	4
PJ19860720	1986-07-20	1986	140	4
PJ19860722	1986-07-22	1986	141	4
PJ19860723	1986-07-23	1986	142	4
PJ19860725	1986-07-25	1986	143	4
PJ19860726	1986-07-26	1986	144	4
PJ19860729	1986-07-29	1986	145	4
PJ19860730	1986-07-30	1986	146	4
PJ19860731	1986-07-31	1986	147	4
PJ19860801	1986-08-01	1986	148	4
PJ19860802	1986-08-02	1986	149	4
PJ19860805	1986-08-05	1986	150	4
PJ19860806	1986-08-06	1986	151	4
PJ19860807	1986-08-07	1986	152	4

Ieiet

Meklēt

Semantic search

Vārdtelpas

Vairāk

Lapas darbības

Query log

Navigācija

Navigācija

Wiki tools

Wiki tools

Ieiet

Meklēt

Semantic search

Query log

Navigācija

Wiki tools

Lapas rīki