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 rab*]]
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 rab*' 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 ('*shes rab*' 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 |
---|---|---|
mngon par shes par gyur pas | {C}settle down in; adhere to | |
mngon sum gyis 'dren pa'i nges shes | {GD:476} an ascertaining consciousness induced by perception | |
mtshan ma'i 'du shes | {C}notion/perception of sign | |
nges par 'byed pa'i shes rab | {C}penetrating wisdom | |
nges par shes par bya'o | {C}one should know for certain | |
nges shes | {GD:494} perceptual judgement | |
nyi tshe ba'i ye shes | {C}definitely tangible; limited cognition; cognition limited in scope | |
pha rol gyi sems kyi spyod pa shes pa | {C}the knowledge of the thoughts and actions of others | |
phar shes pa | {C}honoring father | |
rab shes | {C}knows wisely | |
rab shes na | {C}when he wisely knows | |
rab tu mi shes | {C}not consider wisely | |
rab tu shes | {C}penetrates to; (is/can be) conceived; conceive; comes under the concept of; (one) can conceive; becomes/is conceivable; have a conception of; recognizes; asserts; claim | |
rab tu shes pa | {C}exercise of wisdom; wisely knowing | |
rang gi mngon par shes pa | {C}his own higher knowledge | |
rang gi mngon par shes pas rtul ba | {C}the courageous advance towards their own higher knowledge | |
rgyus shes bya ba'i phyir | {C}so as to get acquainted with | |
rnam par grol ba'i ye shes gzigs pa | {C}vision and cognition of emancipation | |
rnam par shes pa 'dra ba med pa | {C}his consciousness conforms to | |
rnam par shes pa gnas pa | {C}foundation of conscious life | |
rnam par shes pa phan tshun dang ldan pa | {C}mind on other things; his mind on other kinds of talk | |
rnam par shes pa;rnam shes;shes pa | {C}be aware of; cognized; known; discerned | |
rnam par shes par bgyid pa | {C}is informed about | |
rnam par shes par gyur pa | {C}discernible; distinct; should be known; one should understand/discern; belonging to consciousness | |
rnam shes mtha' | {C}infinite consciousness | |
rnam shes mtha' yas | {C}infinite consciousness | |
rnam shes mtha' yas skye mched | {C}sense-field of infinite consciousness | |
rngog legs pa'i shes rab | {GD:ix,xiii} N#gok-lek-b#ay-s#hay-rap (circa 11th c.), a G#a-dam-b#a author on epistemology | |
rngog lo tsa ba bol ldan shes rab | {GD:ix,xiii} N#gok Lo-d#za-wa L#o-den-s#hay-rap (1059-1109), a G#a-dam-b#a author on epistemology | |
rta can shes ltar | {C}like a thoroughbred stallion | |
rtog med log shes | {GD:543} deluded non-conceptual cognition | |
rtogs pa mngon par brjod can gyi shes pa | {GD:322} "that cognition which is [characterized by] words"; this is Kamalasila's interpretation of Dharmakirti's characterization of conceptual thought | |
sangs rgyas ye shes mchog tu rab byung | {C}exceedingly wonderful Buddha-cognition | |
sems kyi rnam grangs shes pa | {C}the cognition of others' mental make-up | |
sgra shes par bya ba la mkhas pa | {C}skill in the cognition of words | |
sgyu ma sgrub shes sgyu ma 'drar | {C}perfect in knowing the various forms of magical illusion | |
sgyu rtsal cho ga shes | {C}instructed in many arts | |
shes | {C}discern; be understood; notion; perception | |
shes bya | {C}cognized; cognizable; knowable; it is said; is spoken of; is called; one speaks of; is expounded | |
shes bya'i sgrib pa | obscurations of the knowable | |
shes byed | {C}feeler; one who experiences | |
shes bzhin | {C}full awareness; self-possession | |
shes bzhin dang ldan pa | {C}self-possessed; clearly conscious | |
shes bzhin med pa | {C}unaware of what he does | |
shes bzhin rab tu ldan | {C}fully conscious | |
shes mdzad | {C}intimator | |
shes myur | {C}bringing quick understanding | |
shes pa | {C}wisely knows; knows, in his wisdom; comprehends wisdom; wise cognition; is aware; becomes aware of; be aware of; known; discerned; follow; sagacity; known; cognized; is declared | |
shes pa ma lags pa | {C}in his ignorance; which cannot be cognized | |
shes pa med pa | {C}cannot be known [with apaśyaka: one who does not know]; unknowable; does not generate anything; without a cognizer; in his ignorance; which cannot be cognized |