ul txp smd_query query SELECT title FROM textpattern WHERE status LIMI

<ul>
<txp:smd_query query="SELECT title
     FROM textpattern
     WHERE status = 1
     LIMIT 0,10" >
<li>{title}</li>
</txp:smd_query>
</ul>