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

Medical Technician Tests

Find resources to prepare for medical technician tests, with medical tech study guides, medical tech practice tests, courses and more. All medical tech positions have organizations that offer certification in their respective fields. For more information, see Tests.com's Medical Technician's Test Guide.

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=51 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=51 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=51 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=51 ) x order by ifnull(priority,999), freesort limit 0 , 10

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193879
Medical Assistant Practice Exam

Tests.com

Ace the CMA, RMA or NCMA Medical Assistant Exam using this 750 question, expert written practice exam with answers fully explained for ideal study. Complete Practice of Actual Exam Topics: General: Medical Terminology, Anatomy and Physiology, etc. Clinical: Infection Control, Patient Preparation, Specimen Collection, First Aid, etc. Administrative: Filing, Billing, Coding, Accounting, etc.

39.95

select pagename from contactvendors where prodid=193238
Medical Assistant Practice Test

Tests.com

Take a free practice test to see how prepared you are for a medical assistant certification exam.

Free

select pagename from contactvendors where prodid=193880
Medical Assistant Practice Exam Questions

Tests.com

26 Free Medical Assistant Practice Questions organized by exam sections that match actual exam topics.

Free

select pagename from contactvendors where prodid=193658
Asthma SAE

National Asthma Educator Certification Board
(877) 408-0072

The Asthma Educator Self Assessment Exam is taken by anyone studying to be an asthma educator.

select pagename from contactvendors where prodid=193642
PANCE

National Commission on Certification of Physicians Assistants
(678) 417-8100

The Physician Assistant National Certifying Exam is taken by anyone pursuing a degree as a physician's assistant.

select pagename from contactvendors where prodid=194798
Sonography Practice Test

Tests.com

Sonography Practice Test

Free

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

Bookmark Page