KrishnaSaysInBG: Difference between revisions
Yadasampati (talk | contribs) (Created page with "{{#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...") |
Yadasampati (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
|from= tran,trpr,vers | |from= tran,trpr,vers | ||
|where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} | |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} | ||
|data= | |data= tuplets=yadatest(tran_id),id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text | ||
}} | }} | ||
{| class="wikitable" style="width:70%; font-size:initial; border-radius:8px" | {| class="wikitable" style="width:70%; font-size:initial; border-radius:8px" | ||
! from | ! from | ||
! until | ! until | ||
! style="padding:5px; font-weight:bold"| | ! style="padding:5px; font-weight:bold"| Tuplets | ||
! style="padding:5px; font-weight:bold"| Verse | ! style="padding:5px; font-weight:bold"| Verse | ||
! style="padding:5px; font-weight:bold"| Translation {{#for_external_table:<nowiki /> | ! style="padding:5px; font-weight:bold"| Translation {{#for_external_table:<nowiki /> | ||
| Line 14: | Line 14: | ||
{{!}} class="cw_0" {{!}} {{{from}}} | {{!}} class="cw_0" {{!}} {{{from}}} | ||
{{!}} class="cw_0" {{!}} {{{until}}} | {{!}} class="cw_0" {{!}} {{{until}}} | ||
{{!}} class="cw_50" style=" | {{!}} class="cw_50" style="vertical-align:top; padding:0" {{!}} {{{tuplets}}} | ||
{{!}} class="cw_150" style="vertical-align:top; padding:0" {{!}} [https://vanisource.org/wiki/{{{vref_u}}}_(1972) {{{vref_s}}}] | {{!}} 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}}} | {{!}} class="cw_500" style="padding:0" {{!}} {{{text}}} | ||
}} | }} | ||
|} | |} | ||
Revision as of 09:35, 18 February 2023
The query SELECT yadatest(tran_id),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 yadatest(tran_id),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 | Tuplets | Verse | Translation |
|---|