Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - Hopkins Others' English 2015]] [[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=1379562
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
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=1379562
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 | 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 |
---|---|---|
bslabs pa ji bzhin | {C}in accordance with their training | |
byang ba'i rang bzhin thams cad shes par gyis shig | {C}may you come to the state which is free from all passing away | |
byas pa shes pa | {C}gratitude | |
bye brag shes pa | {C}makes a distinction | |
bzhin | {C}just like; similar to; face; mouth; door | |
bzhin du | nature; {C}thus; comparable; equal; similar to; as if it were just | |
bzhin gyi mdog | {C}features | |
bzhin gyi mdog kyang 'gyur bas | {C}burns away; will be consumed | |
bzod pa dang shes pa | {C}patient acceptance of cognition | |
bzod shes | {C}acceptance of the cognition of dharma; acceptance of subsequent cognition | |
cang shes pa | {C}wise; thorough-bred; well-born | |
chags par 'gyur bzhin | {C}be won over | |
ched bzhin | {C}according to the program | |
'dod pa bzhin | {C}as one desires | |
chog mi shes pa | {C}glorified | |
chog shes | {C}contentment | |
chog shes pa | {C}easily contented | |
'dod pa bzhin ma | {C}not as one desires | |
chos bzod shes | {C}acceptance of the recognition of Dharma | |
chos kyi rang bzhin | {C}the essential original nature of dharmas | |
chos nyan pa rang bzhin | {C}pupil; one worthy to listen | |
chos rnams rang bzhin | {C}the essential original nature of dharmas | |
chos shes | {C}cognition of Dharma | |
dbang po rab dang tha ma shes par bya ba | {C}cognition of the higher and lower faculties (of others) | |
de bzhin | {C}likewise | |
de bzhin du | {C}in the same way; just thus; just so; such; likewise; further; and so; thereupon; in consequence also; and so is | |
de bzhin gshegs | {C}the Great Bull; the mightiest of men | |
de bzhin gshegs pa nyid | {C}Tathāgatahood | |
de bzhin gshegs pa snying po can | {C}womb/embryo of the Tathāgata | |
de bzhin gshegs pa'i sprul pa | {C}a magical creation of the Tathāgata | |
de bzhin gshegs pas gsungs pa bzhin smra ba | {C}one who correctly preaches the Tathāgata-truth | |
de bzhin kyang | {C}but if; although | |
de bzhin nyid du gsung ba | {C}he speaks of what is | |
de bzhin nyid ma gtogs par | {C}distinct from suchness; shut out from suchness | |
de bzhin nyid ma yin pa | {C}no-suchness | |
de lta bu'i rang bzhin du | {C}such as; his | |
de yi 'du shes | {C}notion of I | |
de'i rang bzhin can | {C}has the same own-being | |
dga' ba'i rang bzhin can bde ba'i rang bzhin can | {C}dear and pleasant forms ('things' would be better) | |
dge slong du shes pa | {C}honoring recluses | |
dngos po'i rang bzhin bral pas | {C}in its own-being without existence | |
dngos po'i rang bzhin mkhas | {C}skilled in seeing the own-being of existence (existents?) | |
'dris pa shes pa | {C}cognition of mastery | |
dran shes | {GD:524} recollection | |
'dris pa ye shes | {C}cognition of mastery | |
'du shes | {C}perception; notion; mental associations; ideation; motivation; conviction; cognize; perceive | |
'du shes med 'du shes med min skye mched | sense-field of neither cognition nor non-cognition | |
gnam bzhin | {C}space; sky | |
'du shes med pa yin | {C}no act of perceiving | |
gnas dang gnas ma yin pa bstan pa shes par bya ba | {C}exposition of what can be and what cannot be |