Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:External Dictionary - RangjungYeshe]] [[wylie::~*rig 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=910904
AND (
(MATCH(t4.o_text) AGAINST ('*rig*' 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
20
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=910904
AND (
(MATCH(t4.o_text) AGAINST ('*rig*' 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
20
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 |
---|---|---|
dbu ma'i bstan bcos rigs pa'i tshogs drug | klu sgrub: dbu ma rtsa ba'i tshig le'ur byas pa shes rab zhib mo rnam par 'thag pa stong nyid bdun cu pa brtsod pa bzlog pa rigs pa drug cu pa rgyal po la gdam bya ba rin chen phreng ba | |
dbu ma rigs pa'i thogs drug | the six logical works of the Madhyamika, 1) rtsa ba shes rab. 2) rigs pa drug cu pa 3) stong nyid bdun cu pa 4) zhib mo rnam 'tha' 5) rtsod ldog, rtsod ma bzlog pa 6) tha snyad bsgrub pa, rin chen phreng ba | |
dbu ma rigs pa'i thogs drug | the six logical works of the madhyamika [R] | |
dbu ma rigs tshogs drug | see dbu ma'i bstan bcos rigs pa'i tshogs drug | |
dbu ma rigs tshogs lnga | Five Collections of Madhyamaka Reasoning. Works of Nagarjuna | |
dbu rtse rigs gsum | Triple-storied Central Temple / (rim gsum). The central structure at the temple complex of Samye | |
dbu rtse rigs | rim gsum the three-storied, triple-styled central temple [of Samye near Lhasa] | |
de bzhin gshegs pa'i rigs | the tathagata family | |
de bzhin gshegs pa rdo rje'i rigs rnam | the Tathagatas of the Vajra Family | |
dge bsnyen rigs bdun | seven types of lay person | |
bde gshegs rigs lnga | Five families of sugatas. The five families or aspects of victorious ones; Vairochana, Akshobhya, Ratnasambhava, Amitabha, and Amoghasiddhi | |
dgra bcom pa'i rigs gsum | three kinds of arhathood | |
bden pa dang rigs pa brjod pa | you speak the truth: your words are truly wise | |
a rigs can | 'A' family [clan name] | |
dkor rigs | various property belongings to a monastery | |
bden zhing rigs sam snyam | Is this true or not? | |
dmangs rigs | commoner caste, the caste of commoners; servant class; Shudra caste. menial classes | |
dmangs rigs | commoner/ servant caste, sh'udra [R] | |
dngos rigs | articles | |
dngos rigs | thing, article [in a household]; thing, article | |
dngos stobs kyi rigs pa | the reasoning of the power of fact | |
'dod chags rigs bzhi | / tshul bzhi four kinds of desire | |
'dod khams rigs nyi shu | [TRS 26:1] | |
'dod lha rigs drug | six classes of desire gods. Mipham: rgyal chen bzhi'i ris, sum cu rtsa gsum pa, 'thab bral, dga' ldan, 'phrul dga', gzhan 'phrul dbang byed drug The six classes of desire gods abide in the abodes of the Four Great Kings, the Thirty-three, Conflict-Free, Tushita, Enjoying Creations, and Mastery Over Others' Creations | |
'dod lha rigs drug | [TRS 26:3]; 'dod lha drug. six levels of the gods of desire | |
don dam dpyod byed kyi rigs pas dpyad pa | analyzed with the reasoning that investigates the ultimate | |
don dam dpyod byed kyi rigs pa | the reasoning that investigates the ultimate | |
dong sprugs rigs bsdus | the condensed family of Narak Dongtruk; See also na rak dong sprugs | |
dpa' bo rigs bzhi | four families of dakas, four daka aspects | |
bdud rigs | maras, class / category of maras | |
dpyad pa'i rigs shes | analytical rational cognition | |
dpyod pa'i rigs shes | cognition | |
drag rigs | the nobility | |
dri med rigs pa | flawless / faultless reasoning | |
dri za ba'i rigs can | belong to the class of 'scent-eaters' | |
'du shes kyi phung po'i rigs kyi chos lnga | the fifteen aspects of the aggregate of conceptions | |
bgegs rigs | non-human beings; all varieties of obstructing spirits, harmful spirits | |
bgegs rigs stong phrag brgyad cu | 80,000 types of obstructers | |
gang du'ang ma nges pa'i rigs | the undetermined type / nature | |
gang 'dul rigs bzhi | four classes of appropriate tamers [of beings] | |
gang rigs pa | whatever is suitable / proper | |
gang rigs | whichever is suitable | |
gangs chen mtsho rigs lnga | five families of Buddha Immense Ocean | |
gang 'thad gang rigs | whatever is appropriate / suitable | |
gang zag bdag med sgrub pa rnam bdun shing rta'i rigs pa | the "sevenfold chariot reasoning" to prove the nonexistence of the personal identity | |
gang zag gi rigs dgu | the nine types of individuals. rab kyi rab, rab kyi 'bring, rab kyi tha ma, and so forth; the nine types of individuals: rab kyi rab, rab kyi 'bring, rab kyi tha ma, and so forth | |
gar mkhan gyi rigs | brahmin family | |
gcig du bral gyi rigs pa | the deductive formula that negates one or many self-entities of individuals | |
bha ga wAn pad ma'i 'od la sogs pad ma'i rigs bsam gyis mi khyab pa rnams | the Bhagavan Padmaprabha and all the innumerable Tathagatas of the Padma family | |
gdol rigs | outcasts, caste of --; lowest castes, untouchables |