Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - Hopkins Others' English 2015]] [[wylie::~*sems 'byung ba*]]
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 ('*sems byung*' 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=1379562
AND (
(MATCH(t4.o_text) AGAINST ('*sems byung*' 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 |
---|---|---|
nges par 'byung ba | {C}goes forth; come into being; issued from; gone forth; removal; support | |
nges par 'byung ba dang bcas pa | {C}with escape; which includes the possibility of escape | |
nges par 'byung ba med pa | {C}without support | |
nges par 'byung ba;nges 'byung | {C}escape; going forth; freedom from faults | |
nges par 'byung bar 'gyur te | {C}will come forth | |
nges par mi 'byung | {C}absence of going forth; not going forth | |
nges par sems pa | {C}meditation; pacification | |
pha rol gyi sems kyi spyod pa shes pa | {C}the knowledge of the thoughts and actions of others | |
phan pa dang bde ba'i sems | {C}a thought which is directed towards the benefit and ease | |
phan pa'i sems | {C}mind interested only in the welfare (of all beings); with a thought of benevolence; mind which is well-disposed | |
phan par sems pa | {C}solicitude | |
phung po thams cad nges par 'dor ba dang 'byung bar dang | {C}rejection of all substrata | |
rab tu 'byung | {C}is kept going; has spread; goes out into | |
rab tu 'byung ba | come to pass; takes up the homeless life | |
rab tu 'byung bar 'gyur ro | {C}recluse; left the world | |
rab tu dad par byung ba | {C}finds faith in | |
'khrug pa'i sems | {C}watchfulness | |
'khrug pa'i sems 'ga' tsam yang skyed par mi byed de | {C}does not get angry even in his mind | |
rang 'byung | {C}Self-existent; cognition of the Self-existent | |
rang byung gi chos | {C}dharmas of the Self-existent | |
rang dbang du 'byung ba'i phyir | {C}it occurs as an independent reality | |
rdo rje lta bu'i sems | {C}adamantine thought | |
'khrul pa'i sems | {C}confused thought | |
re ba med sems | {C}his mind free from hesitation | |
'byung | {C}has come into being; gives rise to; come into being; depart; go off; come out of; leave (home life); brought about; origin; which has arisen; issued; manifestation; comes to be manifest; are brought along; are assembled | |
rgyu las byung ba | {C}because of; the cause of | |
rin po che'i 'byung gnas | {C}source of wealth; jewel-mine | |
'byung 'gyur | {C}be present; have at one's disposal; exist potentially; can possibly be; produce; proceeds | |
rjes su byung ba'i rtog pas ling po | {GD:151} arising later than the perception of the collection | |
rjes su byung ba'i rtog pas ling po gcig tu bzung ba | {C}cataract; covering; membrane | |
rjes su yi rang ba'i mod las byung ba | {C}connected with jubilation | |
rlom sems | {C}feel conceited; feel superior to; mental attitude; thinks; fancies (himself for); thinks of; minds about; thinks about; thinks with regard to; minds; puts his mind to; sets above; cares about; conceit; vain conceit; minding; conceitedness; self-conscio | |
rlom sems dang brnyas pa | {C}contemptuousness | |
rlom sems dang brnyas pa'i sems bskyed pa | {C}production of a proud thought | |
rlom sems kyi ltung ba'i gnas | {C}offence of conceitedness | |
rlom sems med pa | {C}to be devoid of mental acts | |
rlom sems su byas | {C}put his mind to | |
rlom sems su byed | {C}despise; feel conceited; feel superior to; looks down upon | |
rlom sems su byed brnyas par byed | {C}looks down upon | |
rlom sems su gyur pa | {C}imagining | |
rlom sems su mi 'gyur ba | {C}no conceit | |
'byung 'gyur ba | {C}be present; have at one's disposal; exist potentially; can possibly be; attains; comes; come forth | |
rlom sems su mi bya ba | {C}no conceit; does not put his mind to conceit; absence of conceit | |
'byung ba | {C}produce; has had; (has been) produced; has arisen; raised; appearance (in the world); leading forth; leaving home; (has been) begotten (by); be the offspring of becomes; stands; takes place; occurs; comes about; source; there can be; possibility; possi | |
rnam par g.yeng ba med pa'i sems | {C}undisturbed (in his) thought; with undistracted mind | |
rnam par rtog pa las byung ba | {C}arisen from discrimination | |
rnam par smin pa las byung ba | {C}born of karma-result | |
'byung ba ma mchis pa | {C}not coming into being | |
'phral du 'byung ba | {C}(something) adventitious | |
'byung ba mchis pa | {C}coming into being |