select industry from clients where top=1 order by sno limit 10
select industry from clients where top=0 order by rand( ) limit 30
select title from dub_intr where mcity='doctrans'
select title,id from dub_project order by id desc limit 5
select title from dub_project where id< order by rand( ) limit 30
select linkage,sname from linkage where mcity='' order by sno
