select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=622
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=622
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=622
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=622
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=622 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=622 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=622 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=622
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=622 and enabled is not null
Professional Human Resources Exam - PHR®
Find resources to become a human resources specialist, such as practice tests, certification information, study guides and courses. The PHR credential demonstrates one's knowledge and competence in the field of human resources. The Professional Human Resources Exam is published by the Human Resources Certification Institute (HRCI). For more information, see Tests.com's PHR Test Guide.
![]() |
Test Item | Organization | Description | Cost | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select pagename from contactvendors where prodid=193639 PHR Certification
|
Human Resources Certification Institute (866) 898-4724 |
The Professional Human Resources Exam is taken by anyone who wants to be a certified HR manager. |
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=622 order by posn


