Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
prefix:

Control display of namespace in printouts
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category:External Dictionary - RichardBarron]] [[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=1308173
   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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4fulltexts_id, p_id, o_texto_text01Using where; Using temporary; Using filesort
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_29wiki.t4.s_id, const1Using index
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4wiki.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
WylieDefinitionEnglish
mig gi rnam par shes pavisual consciousness
mig gi rnam shesvisual consciousness; mig gi rnam par shes pa visual consciousness
mkhyen pa'i ye shesknowing quality of timeless awareness
mngon par shes pamngon shes sublime state of perception
mngon par shes pa lngafive sublime states of perception
mngon shesmngon par shes pa sublime state of perception
mngon shes lngafive sublime states of perception
mnyam nyid ye shesmnyam pa nyid kyi ye shes timeless awareness as equalness/ of (the) equalness (of all phenomena)
mnyam pa nyid kyi ye shestimeless awareness as equalness/ of (the) equalness (of all phenomena)
mthong lam gyi shes pa brgyadeight degrees of knowledge pertaining to the path of seeing
mtshan nyid 'dzin pa'i ye shestimeless awareness that/ as it exhibits attributes [cf. CYDz 133.b.1; note reference to extended treament in TCDz]
nges shescertainty/ certain knowledge
ngo shesto recognize; recognition
ngo shes pato recognize; recognition
ngo tsha shes pashame; modesty; self-respect
nyon mongs pa can gyi yid kyi rnam par shes pa(emotionally) affected/ biased/ tainted consciousness based on conceptual mind
nyon mongs pa'i yid kyi rnam par shes pa(emotionally) affected/ biased/ tainted consciousness based on conceptual mind
nyon yid kyi rnam shesnyon mongs pa can gyi yid kyi rnam par shes pa (emotionally) affected/ biased/ tainted consciousness based on conceptual mind
rabs chad pocut-off family; a (blood)line that has died out
rang byung gi ye shesnaturally/ self-occurring timeless awareness
rang ngo shes pato recognize the very essence; to recognize (something) for what it (truly) is; to recognize the true nature (of something)
rang rig ye shesself-knowing timeless awareness
rig pa ye shesrig pa'i ye shes awareness—timeless awareness; recognition of timeless awareness*; isc. to recognize timeless awareness; isc. one's personal experience of timeless awareness
rig pa'i ye shesawareness—timeless awareness; recognition of timeless awareness*; isc. to recognize timeless awareness; isc. one's personal experience of timeless awareness
rjes shessubsequent knowledge; rjes su shes pa; after-knowledge/ subsequent awareness. subsequent knowledge subsequent knowledge (itself)
rjes su shes pasubsequent knowledge (itself)
rjes su shes pa'i bzod papatient acceptance producing subsequent knowledge
rna ba'i rnam par shes paauditory consciousness
rna ba'i rnam shesauditory consciousness; rna ba'i rnam par shes pa auditory consciousness
rnam par 'bus gzhig pa'i 'du shesperception of a maggot-ridden corpse
rnam par 'thor ba'i 'du shesperception of a corpse scattered in pieces
rnam par 'tshig pa'i 'du shesperception of a corpse being cremated
rnam par bam pa'i 'du shesperception of a decomposing corpse
rnam par dmar ba'i 'du shesperception of a mottled corpse
rnam par gnag pa'i 'du shesperception of a putrefying corpse
rnam par rnag pa'i 'du shesperception of a putrefying corpse
rnam par rul ba'i 'du shesperception of a disintegrating corpse
rnam par shes paconsciousness; (ordinary) consciousness (one of twelve links of interdependent connection)
rnam par sngo ba'i 'du shesperception of a rotting corpse
rnam par sngos pa'i 'du shesperception of a rotting corpse
rnam par zos pa'i 'du shesperception of a corpse devoured by wild animals
rnam shesrnam par shes pa; rnam par shes pa (ordinary) consciousness (one of twelve links of interdependent connection)
rnam shes kyi phung poaggregate of (ordinary) consciousness
rnam shes mtha' yas kyi skye mchedfield of infinite consciousness" (2nd of 4 states in formless realm)
rnam shes mtha' yas skye mchedinfinite consciousness; rnam shes mtha' yas kyi skye mched field of infinite consciousness" (2nd of 4 states in formless realm)
rnam shes tshogs brgyadeight modes/ avenues of (ordinary) consciousness
rnam shes tshogs drugsix modes/ avenues of (ordinary) consciousness
rus pa'i 'du shesperception of bones (from a corpse)
sdud pa'i shes rabconsolidating sublime knowing/ wisdom/ transcendent knowledge
sdug bsngal chos shessdug bsngal la chos shes pa knowledge of the phenomenon of suffering (specifically in the desire realm)