How to retrieve the sub-table fields from the Empire CMS list page?

To call the sub-table field content in the list template, you need to use "list.var support program code". The following is the list.var template code for reading the newstext field in the news subtable as an example:

$fr=$empire->fetch1("select newstext from {$dbtbpre}ecms_news_data_{$r[stb]} where id='$r[id]'");
$listtemp='<a href="[!---titleurl--]">[!---title--]</a> <br>副表内容字段：'.$fr[newstext].'<br><br>';

The codes for simultaneously calling two sub-table fields in the Empire CMS column page are as follows (source, author):

$fr=$empire->fetch1("select befrom,writer from {$dbtbpre}ecms_news_data_{$r[stb]} where id='$r[id]'");
$listtemp='<li><h2><a href="[!--titleurl--]">[!--title--]</a></h2><p>[!--smalltext--]</p> <div class=""><i>'.$fr[befrom].'</i><span>/   '.$fr[writer].'</span><em>[!--newstime--]</em></div></li>';