select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=331
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=331
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=331
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=331
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=331 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=331 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=331 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=331
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=331 and enabled is not null
USMLE® Directory
USMLE test resources including USMLE prep materials, practice tests, informational guide and more. The United States Medical Licensing Examination is provided by the Federation of State Medical Boards of the United States, Inc.
![]() |
Test Item | Organization | Description | Cost | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select pagename from contactvendors where prodid=193671 USMLE
|
Federation of State Medical Boards of the United States, Inc. (817) 868-4000 |
The United States Medical Licensing Examination is taken by students planning on becoming licensed medical examiners in the United States. |
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=331 order by posn


