Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - RichardBarron]] [[wylie::~*tha mal gyi shes pa*]]
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=1308173
AND (
(MATCH(t4.o_text) AGAINST ('*tha mal gyi 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
0
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=1308173
AND (
(MATCH(t4.o_text) AGAINST ('*tha mal gyi 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
0
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 |
---|---|---|
'byed med shes rab | (one of the shes rab lnga) inalienable sublime knowing/ wisdom/ transcendent knowlege; profound knowing/ wisdom/ transcendent knowledge that cannot be fragmented | |
'du shes | perception; idea; concept | |
'du shes gsum ldan | endowed/ infused with/ within the context of three authentic perceptions | |
'du shes kyi phung po | aggregate of perceptions | |
'du shes med 'du shes med min skye mched | realm of neither perception nor nonperception | |
'du shes med pa | without/ devoid of perception | |
'gog pa chos shes | 'gog pa la chos shes pa knowledge of the phenomenon of the cessation of suffering [specifically in the desire realm] | |
'gog pa rjes shes | 'gog pa la rjes su shes pa subsequent knowledge of the cessation of suffering [specifically in the two higher realms] | |
bdag med rtogs pa'i shes rab | sublime knowing/ wisdom/ transcendent knowledge realizing the nonexistence/ absence of identity (in self and phenomena) | |
bya ba grub pa'i ye shes | timeless awareness as spontaneous fulfillment/ of ensured fulfillment/ in which everything is spontaneously fulfilled | |
chog shes | chog shes pa - (to know/ have) contentment | |
chos dbyings ye shes | timeless awareness as/ of the basic space of phenomena | |
chos shes pa shes pa'i bzod pa | patient acceptance producing knowledge of a phenomenon | |
dbang po'i shes pa | sense consciousness | |
dbang shes | dbang po'i shes pa sense consciousness | |
don gyi ye shes | true/ actual timeless awareness | |
dpe'i ye shes | anticipatory timeless awareness | |
dran shes | mindful consciousness; isc. (merely) consciousness/ conscious awareness | |
gzhan lus shes rab | another's body as the source of sublime knowing/ wisdom/ transcendent knowledge [euph. for karmamudra] | |
gzhi gnas kyi ye shes | timeless awareness as it abides in the ground of being [cf. CYDz 133.b.1; note reference to extended treament in TCDz] | |
ji lta ba mkhyen pa'i ye shes | timeless awareness of what simply is/ that knows/ perceives reality just as it is/ | |
ji lta ba shes pa'i shes rab | ji lta bar mkhyen pa'i shes rab sublime knowing/ wisdom/ transcendent knowledge that knows/ perceives reality just as it is/ just how things are/ the real nature of things just as it is | |
ji lta bar mkhyen pa'i shes rab | ji lta bar shes pa'i shes rab sublime knowing/ wisdom/ transcendent knowledge that knows/ perceives reality just as it is/ just how things are/ the real nature of things just as it is | |
ji lta bar mkhyen pa'i ye shes | timeless awareness of what simply is/ that knows/ perceives reality just as it is/ just how things are/ the real nature of things just as it is | |
ji snyed pa gzigs pa'i ye shes | ji snyed pa mkhyen pa'i ye shes timeless awareness of all that there is/ that knows/ discerns/ perceives all that there is/ the multiplicity of things/ of things in (all) their multiplicity/ as many things as there are | |
ji snyed pa mkhyen pa'i shes rab | sublime knowing/ wisdom/ transcendent knowledge that knows/ discerns/ perceives all that there is/ the multiplicity of things/ of things in (all) their multiplicity | |
ji snyed par gzigs pa'i ye shes | ji snyed par mkhyen pa'i ye shes timeless awareness of all that there is/ that knows/ discerns/ perceives all that there is/ the multiplicity of things/ of things in (all) their multiplicity/ as many things as there are | |
ji snyed par mkhyen pa'i shes rab | sublime knowing/ wisdom/ transcendent knowledge that knows/ discerns/ perceives all that there is/ the multiplicity of things/ of things in (all) their multiplicity | |
khyab byed kyi shes rab | pervasive sublime knowing/ wisdom/ transcendent knowledge | |
kun 'byung chos shes | kun 'byung la chos shes pa knowledge of the phenomenon of the all-pervasive origin of suffering [specifically in the desire realm] | |
kun 'byung rjes shes | kun 'byung la rjes su shes pa subsequent knowledge of the all-pervasive origin of suffering [specifically in the two higher realms] | |
kun gzhi'i rnam shes | consciousness as the basis/ ground of all (ordinary) experience; conscious aspect of the basis/ ground of all experience | |
kun shes | all-knowing awareness | |
lam chos shes | lam la chos shes pa knowledge of the phenomenon of the path (specifically in the desire realm) | |
lam la chos shes pa | knowledge of the phenomenon of the path (specifically in the desire realm) | |
lam la rjes su shes pa | subsequent knowledge of the path (specifically in the two higher realms) | |
lam la rjes su shes pa'i bzod pa | patient acceptance producing subsequent knowledge of the path (specifically in the two higher realms) | |
lam rjes shes | lam la rjes su shes pa subsequent knowledge of the path (specifically in the two higher realms) | |
lce'i rnam par shes pa | gustatory consciousness | |
lce'i rnam shes | gustatory consciousness | |
lhan cig skyes pa'i ye shes | innate/ coemergent timeless awareness; timeless awareness coemergent with being itself | |
lhan skyes ye shes | lhan cig skyes pa'i ye shes innate/ coemergent timeless awareness; timeless awareness coemergent with being itself | |
lta bas chog mi shes pa | I couldn't take my eyes off it | |
lus kyi rnam par shes pa | tactile consciousness | |
lus kyi rnam shes | lus kyi rnam par shes pa; tactile consciousness; lus kyi rnam par shes pa lus kyi rnam par shes pa | |
me long lta bu'i ye shes | mirror-like timeless awareness | |
mi gtsang ba'i 'du shes dgu | nine perceptions of uncleanness | |
mi skye ba shes pa | knowledge that suffering no longer occurs | |
mig gi rnam par shes pa | visual consciousness | |
mig gi rnam shes | visual consciousness; mig gi rnam par shes pa visual consciousness |