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

Financial Professional Tests

Find resources to prepare for financial professional certification tests, such as study guides, practice tests, courses and more. There are many different certifications available for the financial professional. For more information, see Tests.com's Financial Professional Test Guide and specific sections.

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

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193654
CFA Exam

Chartered Financial Analyst Institute
(434) 951-5499

The Chartered Financial Analyst Exam is a series of three exams taken by people who want to pursue a career as a financial analyst.

select pagename from contactvendors where prodid=193636
CIA Exam

Institute of Internal Auditors
(407) 937-1111

The Certified Internal Auditor Exam is the only globally accepted certification to be a professional internal auditor.

select pagename from contactvendors where prodid=193657
CPA Exam

American Institute of Certified Public Accountants
(919) 402.4500

The Certified Public Accountant Exam is a requirement to receive a CPA certificate.

select pagename from contactvendors where prodid=193656
CMA Exam

Institute of Management Accountants, Inc.
(800) 638-4427

The Certified Management Accountant Exam is taken by everyone studying to become a certified account manager.

select pagename from contactvendors where prodid=193655
CFP Exam

Certified Financial Planner Board of Standards, Inc.
(202) 379-2200

The Certified Financial Planner Exam is taken by people who want to work as financial planners.

select pagename from contactvendors where prodid=194801
CFP Practice Exam

Tests.com

Free Certified Financial Planner Practice Test

Free

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

Bookmark Page