Search Results for 'vietnamese'
select a.link, a.image, a.imgtitle, a.imgalt, c.rank from ad a, (select adid, sum(rank) rank from (select adid, rank from adkeywords where keyword='vietnamese' union all select adid, rank from adkeywords where keyword like 'vietnamese%') x group by adid) c where a.adid=c.adid
union all
select link, image, imgtitle, imgalt, rank
from ad
where status is null and rank is not null
order by rank
limit 5