Phpcms V9 News content sort the calling code by the number of comments in the list

Phpcms V9 The list of news lists by number of comments in the specified column

Call a list of news items sorted by number of comments under a specified column

{pc:get sql= "select * from phpcms_comment where Commentid like ' content_ specified column catid% ' ORDER BY total desc" rows= "9" return= "Data"} {loop $data $r} {str_cut ($r [title],60, ')} {/loop} {/PC}

Call a list of all the sub-columns under a given column and sort by the number of comments

{pc:get sql= "select * from Phpcms_comment where Commentid REGEXP CONCAT (' Content_ (') (select Group_concat (CATID separator ' | ') From phpcms_category where parentid= specified column of catid), '). ORDER BY total desc "rows=" 9 "return=" data "} {loop $data $r} {str_cut ($r [title],60, ')} {/loop} {/PC}

Phpcms V9 News content sort the calling code by the number of comments in the list