DataTabSheet: Difference between revisions

Latest revision as of 21:26, 13 February 2023

The query SELECT trpr_from,trpr_until,tran.tran_id,vers_ref,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Template:1}' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT trpr_from,trpr_until,tran.tran_id,vers_ref,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} ).

from	until	Id	Verse	Translation

@@ Line 1: / Line 1: @@
 {{#get_db_data:
   db= vanisearch
-  |from= tran,trpr
+  |from= tran,trpr,vers
-  |where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}}
+  |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}}
-  |data= id=tran.tran_id,text=concat(concat("aap","noot"),tran_text)
+  |data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text
 }}
-{| class="wikitable" style="width:70%"
+{| class="wikitable" style="width:70%; font-size:initial; border-radius:8px"
+! from
+! until
 ! style="padding:5px; font-weight:bold"| Id
-! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki />
+! style="padding:5px; font-weight:bold"| Verse
+! style="padding:5px; font-weight:bold"| Translation {{#for_external_table:<nowiki />
 {{!}}-
-{{!}} style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}}
+{{!}} class="cw_0" {{!}} {{{from}}}
-{{!}} style="padding:0; width:500px" {{!}} {{{text}}}
+{{!}} class="cw_0" {{!}} {{{until}}}
+{{!}} class="cw_50" style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}}
+{{!}} class="cw_150" style="vertical-align:top; padding:0" {{!}} [https://vanisource.org/wiki/{{{vref_u}}}_(1972) {{{vref_s}}}]
+{{!}} class="cw_500" style="padding:0" {{!}} {{{text}}}
 }}
 |}