select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=402
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=402
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=402
union all
select adid, link, image, imgtitle, imgalt, rank+100, showgoogle
from ad
where status is null and rank is not null
order by rank limit 10
select guidelink from categories where id=402
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=402 and enabled is not null
select count(id) records from (
select p.id, p.priority from product p, organization o, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=402 and pending is null and (p.pricecheck is null or (p.pricecheck!=3 and p.pricecheck!=404))
union select p.id, p.priority from product p, organization o, categories c, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=c.id and c.parent=402 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=402
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=402 and enabled is not null
Color Test
Color test resources to help you understand personality. Color tests can be used in job assessment or for fun.
![]() |
Test Item | Organization | Description | Cost |
---|
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=402 order by posn


