[code="mysql"]
select a.title title,a.url url,a.thumb thumb,a.tjtitle tjtitle,a.description description from v9_news a left join v9_category b on a.catid=b.catid left join v9_category c on b.catcode like concat('%',c.catcode,'%') left join v9_position_data d on a.id=d.id where c.catid=249 and a.status=99 and d.posid=54 and a.thumb!='' order by a.updatetime desc
[/code]
a.title title是什么意思?
from v9_news a 是什么意思?
水平比较菜,大家别喷