select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle from adsdesc where status is null and categoryid=53 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=53 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=53 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=53
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=53 and enabled is not null

Nursing Tests

Find resources to become a registered nurse or nurse specialist, with licensing information, nursing study guides, nursing practices tests, courses and more. To become licensed, you will have to take an exam. For more information, see Tests.com's Nursing Test Guide or the section covering your particular speciality.

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=53 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=53 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select id, url, name, orgname, type, price, phone, email, title, priority, price1, followlink, descr, city, state, address, orgcity, orgstate, zip, orgphone, fax, orgemail, country, loctype, showprice from ( 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, freesort from product p, organization o, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=53 union 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, freesort from product p, organization o, categories c, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=c.id and c.parent=53 ) x order by ifnull(priority,999), freesort limit 0 , 10

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=38539
Examination: CPTC, CCTC, Certified Clinical Transplant Nurse (CCTN)

American Board for Transplant Centification
913-895-4603

American Board for Transplant Certification

select pagename from contactvendors where prodid=193240
NCLEX-RN Practice Test

Tests.com

Take a free practice test to see how prepared you are for a registered nurse certification exam.

Free

select pagename from contactvendors where prodid=193567
TEAS Practice Test

Tests.com

Take this free practice test to see how prepared you are for the Test of Essential Academic Skills.

Free

select pagename from contactvendors where prodid=193896
NCLEX-RN Practice Exam

Tests.com

A 750 question practice test to help you prepare for the NCLEX-RN exam. The answers are fully explained. Use the TestSim platform to simulate the actual exam. You get an ebook version of the test as well, with online flashcards. Instant scoring and review.

49.95

select pagename from contactvendors where prodid=194281
HOBET Practice Exam

Tests.com

Pass the HOBET V using this complete practice exam kit with answers fully explained. Our online study test platform allows you to form tests that fit your study schedule and to simulate the actual exam. Also includes: flash cards, exam review and testing tips.

29.95

select pagename from contactvendors where prodid=193915
CNA Practice Exam

Tests.com

Ace the Certified Nursing Assistant (CNA) Exam using this full-length practice exam with answers fully explained for ideal study. Written by Alene Burke, RN, MSN, Nursing Educator and CNA Exam Preparation Guru.

29.95

select pagename from contactvendors where prodid=194203
Free CCRN Practice Exam

Tests.com

Take this free CCRN practice test to see how prepared you are for the CCRN exam.

Free

select pagename from contactvendors where prodid=194218
TEAS VI Complete Practice Test Kit

Tests.com

Ace the TEAS VI using this full-length practice exam with answers fully explained for ideal study. Tests.com is a leader in Nursing School Test Preparation with more than 40,000 practice tests delivered including: TEAS, NCLEx-RN, CCRN, CEN and more.

29.95

select pagename from contactvendors where prodid=194092
Free CEN Practice Test

Tests.com

Take this free practice test to see how prepared you are for the Certified Emergency Nurse exam.

Free

select pagename from contactvendors where prodid=194300
CHPN Practice Test

Tests.com

A 300 question practice test to help you prepare for the Certified Hospice and Palliative Nursing exam. Use the TestSim platform to simulate the actual test; it comes with an ebook version of the test, with online flashcards.

$59.95

select linkname, url, template, examid, viewid, pageid from categorylinks where catid=53 order by posn

Bookmark Page