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

Pharmacy Test

Pharmacy test questions and other resources to help you pass your pharmacy exam.

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

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193534
Pharmacy Tech Practice Test

Tests.com

Take this free practice test to see how prepared you are for a pharmacy tech certification exam.

Free

select pagename from contactvendors where prodid=194090
Pharmacy Tech Certification Practice Test

Tests.com

Ace the Pharmacy Tech Certification Exam (PTCE and ExCPT) using this 400 question expert written practice exam with answers fully explained for ideal study. Peer reviewed to ensure quality. BONUS: Flash Card Study System.

29.95

select pagename from contactvendors where prodid=193676
NAPLEX

National Association of Boards of Pharmacy
(847) 391-4406

The North American Pharmacist Licensure Examination is taken by individuals training to become pharmacists in North America.

select pagename from contactvendors where prodid=193677
MPJE

National Association of Boards of Pharmacy
(847) 391-4406

The Multi-state Pharmacy Jurisprudence Examination is taken by individuals who want to work in the legal department of pharmaceuticals.

select pagename from contactvendors where prodid=193678
PTCE/ExCPT

Pharmacy Technician Certification Board
(800) 363-8012

The Pharmacy Technician Certification Exam enables technicians to work more effectively with pharmacists.

select pagename from contactvendors where prodid=193648
FPGEE

National Association of Boards of Pharmacy
(847) 391-4406

The Foreign Pharmacy Graduate Equivalency Examination is a requirement of the FPEGC Certification Program.

select pagename from contactvendors where prodid=8677
Pharmacy Technician Certification Print Book

Pharmacy Trainer
877-232-8324

PharmacyTrainer - Home of the Best Pharmacy Technician Training Courses

select pagename from contactvendors where prodid=8680
Pharmacy Technician Certification Interactive CD-ROM

Pharmacy Trainer
877-232-8324

PharmacyTrainer - Home of the Best Pharmacy Technician Training Courses

select pagename from contactvendors where prodid=8685
PharmacyTrainer Top 200 Drug Flash Cards

Pharmacy Trainer
877-232-8324

PharmacyTrainer - Home of the Best Pharmacy Technician Training Courses

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

Bookmark Page