Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be 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

prefix:

Control display of namespace in printouts

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Category:External Dictionary - Hopkins2015]] [[wylie::~*shes bzhin*]]
 |?wylie#-hl=Wylie
 |?english-def#-hl=Definition
 |?english#-hl=English
 |format=broadtable
 |limit=50
 |offset=0
 |link=none
 |sort=
 |order=asc
 |mainlabel=-
 |searchlabel=11 match(es)
 |class=smwtable-clean th-left m-0 highlight
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:External Dictionary - Hopkins2015]] [[wylie::~*shes bzhin*]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.9084",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:External Dictionary - Hopkins2015]] [[wylie::~*shes bzhin*]]

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
`ry_smw_object_ids` AS t0
INNER JOIN
(`ry_smw_fpt_inst` AS t2
INNER JOIN
`ry_smw_ft_search` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=1256659
   AND (
   (MATCH(t4.o_text) AGAINST ('*shes bzhin*' IN BOOLEAN MODE) AND t4.p_id=842800)
  ))
  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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	fulltext	s_id, p_id, o_text	o_text	0		1	Using where; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	wiki.t4.s_id, const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	wiki.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Wylie	Definition	English
nyon mongs shes bya'i sgrib pa	afflictive obstructions and obstructions to omniscience
nyon sgrib spangs pa'i ye shes	pristine wisdom that has abandonned the afflictive obstructions
nyung shes shig	very few
pha rol gyi sems kyi spyod pa shes pa	cognition of the minds and actions of others
'og nas 'byung ba bzhin	as appears later [in the text]
pha rol tu phyin pa'i rang bzhing gyi dge ba	virtue of the nature of the perfections
phan pa'i 'du shes	conception of benefit; beneficial conception
phyi bzhin du	closely behind(C)
'phags pa shes pa	Superior cognition
phyin ci ma log pa de bzhin nyid	non-mistaken suchness
rab shes	(thoroughly) cognize; (thoroughly) know; highest consciousness
rab shes na	when (thoroughly) cognizing; if one (thoroughly) knows
'phags pa'i shes rab kyi dbang po skye	produce the first exalted wisdom of Superiors
'phags pa'i ye shes kyi spyod yul	realm of the exalted wisdom of Superiors; (T) objects of activity of a Superior's exalted wisdom
rab tu mi shes	not (thoroughly) know/cognize
rab tu shes	(thoroughly) know; (thoroughly) cognize; highest consciousness
rab tu shes pa	(thoroughly) know; (thoroughly) cognize; highest consciousness
rang 'byung gyi shes pa	self-arisen consciousness
rang byung gi ye shes rang bzhin gyis 'od gsal ba	naturally luminous self-arisen pristine wisdom
rang byung ye shes	self-arisen pristine wisdom
rang bzhin	naturally; nature; inherent existence; natural
rang bzhin 'od gsal	naturally luminous; natural luminescence
rang bzhin 'od gsal ba'i sems	natural mind of clear light
rang bzhin bab kyi chos nyid	naturally flowing noumenon
rang bzhin brgyad cu'i kun rtog	eighty indicative conceptions
rang bzhin bstan pa	naturally stable
rang bzhin can	inherently; naturally; having inherent existence
rang bzhin dang 'gal ba'i 'bras bu	effect contradictory with the nature
rang bzhin dri med	naturally stainless
rang bzhin du gnas pa	naturally abide
rang bzhin gcig pa	one nature; same nature
rang bzhin gnas rigs	naturally abiding lineage; natural lineage
rang bzhin gsum	three natures
rang bzhin gyi 'od	natural light
rang bzhin gyi dbang po rno ba nyid	naturally sharp faculties
rang bzhin gyi dkhyil 'khor	natural maṇḍala
rang bzhin gyi don	inherently existent object/meaning
rang bzhin gyi dri ma	natural defilements
rang bzhin gyi mdog	natural color
rang bzhin gyi rgyan	natural ornament
rang bzhin gyi rigs	natural lineage
rang bzhin gyi rnam par dag pa	natural purity
rang bzhin gyi rtags	nature sign
rang bzhin gyi rtog pa brgyad bcu	indicative conceptions
rang bzhin gyi rtog pa brgyad bcu	indicative conceptions
rang bzhin gyi rtog pa brgyad bcu	eighty indicative conceptions
rang bzhin gyi sku	nature body; inherently existent body
rang bzhin gyi tshul khrims	natural ethics
rang bzhin gyi yan lag	limbs of inherent existence
rang bzhin gyis	inherently

Semantic search

Query log

Navigation menu

Search