phpcms v9 tag call, function, sql_PHP tutorial

1. Call a single piece of data from this system, example (call the information with ID 1, the title length does not exceed 25 Chinese characters, and display the update date):
{get sql="select * from phpcms_content where contentid=1" /}
Title: {str_cut($r[title], 50)} URL: {$r[url]} Update date: {date('Y-m-d', $r[updatetime])}
2. Call multiple pieces of data from this system, example (call 10 pieces of information that have passed the review with the column ID 1, the title length does not exceed 25 Chinese characters, and the update date is displayed):
{get sql="select * from phpcms_content where catid =1 and status=99 order by updatetime desc" rows="10"}
Title: {str_cut($r[title], 50)} URL: {$r[url]} Update date: {date(' Y-m-d', $r[updatetime])}
{/get}
3. With paging, example (call 10 pieces of information with column ID 1 that passed the review, the title length does not exceed 25 Chinese characters, display Update date, with paging):
{get sql="select * from phpcms_content where catid=1 and status=99 order by updatetime desc" rows="10" page="$page"}
Title: { str_cut($r[title], 50)} URL: {$r[url]} Update date: {date('Y-m-d', $r[updatetime])}
{/get}
Paging :{$pages}
4. Customize return variables, example (call 10 pieces of information that have passed the review with column ID 1, the title length does not exceed 25 Chinese characters, the update date is displayed, and the return variable is $v):
{get sql="select * from phpcms_content where catid=1 and status=99 order by updatetime desc" rows="10" return="v"}
Title: {str_cut($v[title], 50) } URL: {$v[url]} Update date: {date('Y-m-d', $v[updatetime])}
{/get}
5. Call other databases under the same account, example (Call the 10 latest topics whose database is bbs, category ID is 1, the topic length does not exceed 25 Chinese characters, and the update date is displayed):
{get dbname="bbs" sql="select * from cdb_threads where fid=1 order by dateline desc" rows="10"}
Subject: {str_cut($r[subject], 50)} URL: http://bbs.phpcms.cn/viewthread.php?tid={$r[ tid]} Update date: {date('Y-m-d', $r[dateline])}
{/get}
6. Calling external data, example (the calling data source is bbs, the classification ID is 1 The 10 latest topics, the topic length does not exceed 25 Chinese characters, and the update date is displayed):
{get dbsource="bbs" sql="select * from cdb_threads where fid=1 order by dateline desc" rows="10" }
Subject: {str_cut($r[subject], 50)} URL: http://bbs.phpcms.cn/viewthread.php?tid={$r[tid]} Update date: {date(' Y-m-d', $r[dateline])}
{/get}

I wonder if any friends have encountered when these methods cannot meet their needs?

For example: Take out the 3rd to 10th records with the most comments. Some people say that I am unnecessary. Generally, there is no reason not to take the first and second records with the most comments, because the thumbnails of PHPCMS are like 4:3. The size is better, but the thumbnail effect is not good for long strips (such as 3:4). In order to manually update the first and second records with the most comments, I don't want to automatically update and read the first two records.