帝国cms 主表和副表关联写sql语句

[e:loop={'SELECT * FROM phome_ecms_news AS a LEFT JOIN phome_ecms_news_data_1 AS b ON a.id=b.id where a.classid in(1,2) order by UNIX_TIMESTAMP(a.zdy_time) desc limit 24',10,24,0}]
                  <li>
                    <p class="huodong_time1">
                    </p>
                    <p class="hz_naoke01"><a href="<?=$bqsr['titleurl']?>" target="_blank" title="<?=$bqr['title']?>"><img src="<?=$bqr['titlepic']?>" alt="<?=$bqr['title']?>" width="275" height="165"></a></p>
                    <p class="hz_naoke02"><a href="<?=$bqsr['titleurl']?>" target="_blank" title="<?=$bqr['title']?>"><?=$bqr['title']?></a></p>
                    <p class="hz_naoke03"><?=$bqr['zdy_dizhi']?></p>
                    <p class="hz_naoke04"><?=$bqr['zdy_shijian']?></p>
                    <p class="hz_naoke05"><a href="https://www.niuducj.com" rel="tag">牛犊财经</a></p>
                  </li>
[/e:loop]