Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - 84000Dict]] [[wylie::~*rnam shes*]]
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=966155
AND (
(MATCH(t4.o_text) AGAINST ('*rnam shes*' 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
50
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=966155
AND (
(MATCH(t4.o_text) AGAINST ('*rnam shes*' 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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | 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:3Query-Depth:1
Errors and Warnings
NoneWylie | Definition | English |
---|---|---|
dkar po rnam par mthong ba'i sa | Level of bright insight | |
dmag rnam pa gzhi dang ldan pa | Four-division army | |
dmigs pa med pa'i shes rab | Non-referential wisdom | |
gang zag la bdag med par phyogs gcig shes pa | Partial understanding of selflessness with respect to personal identity | |
glang po che cang shes | Thoroughbred elephant | |
gnas la yang gnas su yang dag pa ji lta ba bzhin du rab tu shes pa | Definitive knowledge that things which are possible are indeed possible | |
gnas ma yin pa la yang gnas ma yin par yang dag pa ji lta ba bzhin du rab tu shes pa | Definitive knowledge that things which are impossible are indeed impossible | |
gser 'od seng ge'i rnam par rol pa'i rgyal po | King of the Golden-Hued Lion’s Play | |
gser bzang po rnam par dag pa'i 'od | Śubhakanakaviśuddhiprabha | |
gsung dbyangs rnam pa drug bcu | Voice of the tathāgatas endowed with sixty aspects | |
gsung snyan cing rnam pa thams cad yongs su rdzogs pa | Speech is sweet and fully perfected | |
ji lta ba bzhin shes pa | Knowledge that is definitive | |
khang bzangs rnam par rgyal byed | Palace of Victory | |
kun 'byung ba shes pa | Knowledge of the origin of suffering | |
kun rdzob shes pa | Knowledge of relative appearances | |
kun shes kau N+Di nya | Ājñātakauṇḍinya | |
kun shes kauN Di nya | Ājñātakauṇḍinya | |
kun shes kauN+Din+ya | Ājñātakauṇḍinya | |
kun shes kauNDi nya | Ājñātakauṇḍinya | |
kun shes pa dang ldan pa'i dbang po | Faculties endowed with the knowledge of all things | |
kun shes pa'i dbang po | Faculties that acquire the knowledge of all things | |
kun tu rnam par bltas pa | Samantavilokitā | |
kun tu shes | Perceive | |
kun tu shes pa | Perceiving | |
kun tu snang ba gyul las rnam par gyal ba'i dpal | Samantāvabhāsavijitasaṃgrāmaśrī | |
lam gyi rnam pa shes pa | Understanding of the aspects of the path | |
lam gyi rnam pa shes pa nyid | Understanding of the aspects of the path | |
lam shes pa | Knowledge of the path | |
lce'i rnam par shes pa'i khams | Sensory element of gustatory consciousness | |
lha'i mig shes pa mngon sum du bya ba shes pa'i mngon par shes pa | Extrasensory power realizing knowledge of divine clairvoyance | |
lha'i rna ba shes pa mngon sum du bya ba shes pa'i mngon par shes pa | Extrasensory power realizing knowledge of divine clairaudience | |
lta ba'i rnam pa drug cu rtsa gnyis | Sixty-two false views | |
lta ba'i rnam pa'i gzhi can | Basis of the variety of false views (have the) | |
lus kyi las thams cad ye shes sngon du 'gro zhing ye shes kyi rjes su 'brang ba | All the activities of their bodies are preceded by pristine cognition and followed by pristine cognition | |
lus kyi rnam par shes pa'i khams | Sensory element of tactile consciousness | |
ma 'ongs pa'i dus la ma chags ma thogs pa'i ye shes gzigs par 'jug go | Engage in the perception of pristine cognition which is unobstructed and unimpeded with respect to the future | |
me long lta bu'i ye shes | Mirror-like wisdom | |
mgon par shes pa | Superknowledges | |
mi rtag pa'i 'du shes | Perception of impermanence | |
mi sdug pa'i 'du shes | Perception of unattractiveness | |
mi shes pa kun shes par byed pa'i dbang po | Faculties that will enable knowledge of all that is unknown | |
mi skye ba shes pa | Knowledge that contaminants will not be regenerated | |
mig gi rnam par shes pa'i khams | Sensory element of visual consciousness | |
mngon par shes pa | Extrasensory power Higher cognition Higher knowledge Superknowledges | |
mngon par shes pa drug | Six super-knowledges | |
mngon par shes pa lnga | Five extraordinary abilities Supernatural knowledge | |
mngon par shes pa'i me tog shin tu rgyas pa | Abhijñāpuṣpasuparipūrṇa | |
mngon par shes pa'i ye shes chen pos zil gyis gnon pa | Mahābhijñājñānābhibhū | |
mngon par shes par bya ba | Object of understanding | |
mngon par shes thob | Abhijñaprāpta |