Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - 84000Dict]] [[wylie::~"ye 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 ('\"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 ('\"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
None- kun shes pa'i dbang po
- Faculties that acquire the knowledge of all things
- kun tu shes
- Perceive
- kun tu shes pa
- Perceiving
- 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
- 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
- mngon shes drug
- Six extrasensory powers, Six superknowledges
- mngon shes lnga
- Five extrasensory powers, Five superknowledges
- mngon shes ye shes zil gnon
- Abhijñājñānābhibhū
- mnyam pa nyid kyi ye shes
- Wisdom of equality
- nang gzugs med par 'du shes pas phyi rol gyi gzugs rnams la lta ba
- When formless beings endowed with internal perception observe external physical forms
- ngag gi las thams cad ye shes sngon du 'gro zhing ye shes kyi rjes su 'brang ba
- All the activities of their speech are preceded by pristine cognition and followed by pristine cognition
- pha rol gyi sems shes pa
- Knowledge of other minds
- pha rol gyi sems shes pa mngon sum du bya ba shes pa'i mngon par shes pa
- Extrasensory power realizing knowledge of other minds
- phyir mi ldog pa'i ye shes
- Irreversible pristine cognition
- rab tu shes
- Cognize, Fully aware (be)
- rdo rje lta bu'i ting nge 'dzin skad cig gcig dang ldan pa'i shes rab
- Wisdom that is instantaneously endowed with the adamantine meditative stability
- rdo rje lta bu'i ye shes
- Adamantine pristine cognition
- rgya mtsho mchog 'chang blo rnam par rol pa'i mngon par shes pa
- Sāgaravaradharabuddhivikrīḍitābhijña
- rjes su rtogs pa'i shes pa
- Subsequent knowledge
- rna ba'i rnam par shes pa'i khams
- Sensory element of auditory consciousness
- rnam pa zad mi shes pa
- Inexhaustible Cornucopia
- rnam par 'bus gzhigs pa'i 'du shes
- Contemplation of a worm-infested corpse
- rnam par 'thor ba'i 'du shes
- Contemplation of a dismembered corpse
- rnam par bam pa'i 'du shes
- Contemplation of a bloated corpse
- rnam par dmar ba'i 'du shes
- Contemplation of a bloody corpse
- rnam par grol ba nyams pa med pa'am rnam par grol ba'i ye shes mthong ba nyams pa med pa
- Do not degenerate in their liberation, nor in their perception of liberating pristine cognition
- rnam par grol ba'i shes pa
- Knowledge of liberation
- rnam par grol ba'i ye shes mthong ba
- Knowledge and vision of liberation
- rnam par grol ba'i ye shes mthong ba'i phung po
- Aggregate of the perception of liberating pristine cognition