select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=349
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=349
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=349
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=349
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=349 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=349 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=349 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=349
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=349 and enabled is not null
CNOR® Exam
Find resources to become a certified operating room nurse, with practice tests, certification information, study guides and more. Certification is achieved by passing the CNOR exam administered by the Competency and Credentialing Institute. The CNOR Exam is administered by the Competency and Credentialing Institute. For more information, see Tests.com's CNOR Test Guide.
![]() |
Test Item | Organization | Description | Cost | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select pagename from contactvendors where prodid=193674 CNOR Exam
|
Competency and Credentialing Institute (303) 369-9566 |
The CNOR Exam is taken by anyone training to be an operating room nurse. |
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=349 order by posn


