Search Results for 'vietnamese'

select count(*) as records, count(priority) as paid from product p, organization o, (select prodid, sum(weight) weight from (select prodid, weight*3 weight, word from keywords where word='vietnamese' union all select prodid, weight, word from keywords where word like 'vietnamese%') x group by prodid) w where p.orgid=o.id and w.prodid=p.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) order by weight desc
select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype from product p, organization o, (select prodid, sum(weight) weight from (select prodid, weight*3 weight, word from keywords where word='vietnamese' union all select prodid, weight, word from keywords where word like 'vietnamese%') x group by prodid) w where p.orgid=o.id and w.prodid=p.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) order by ifnull(priority,999), weight desc limit 0, 30

		Test Item	Organization	Description	Cost

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