select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=630
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=630
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=630
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=630
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=630 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=630 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=630 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=630
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=630 and enabled is not null
PCAT® - Pharmacy College Admission Test
Find resources to prepare for the PCAT, with PCAT study guides, PCAT practice tests, PCAT flashcards, courses and more. The PCAT is an entrance exam for pharmacy schools. The PCAT is published by The American Association of Colleges of Pharmacy (AACP). For more information, see Tests.com's Guide to the Pharmacy College Admission Test.
![]() |
Test Item | Organization | Description | Cost | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select pagename from contactvendors where prodid=193615 The Pharmacy College Admissions Test
|
The American Association of Colleges of Pharmacy (703) 739-2330 |
The PCAT is taken by students applying to a pharmaceutical college in the United States. The PCAT is developed by the American Association of Colleges of Pharmacy. |
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=630 order by posn


