Template:DataTabSheet

{{#get_db_data:

db= vanisearch
|from= tran,trpr,vers
|where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}}
|data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text

}}

from	until	Id	Verse	Text {{#for_external_table:
{{{from}}}	{{{until}}}	{{{id}}}	{{{vref_s}}}	{{{text}}} }}