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

Business Tests

Find resources to get certified in your particluar specialty, sales, marketing or management. Certification can boost ones career and result in a promotion or additional pay. For more information, see Tests.com's Business Tests Guide and its sections on sales, marketing and management tests.

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

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193551
Sales Professional Test

SHL

This Sales Professional Test has 242 questions for entry to mid-level sales positions. Sample responsibilities include, but are not limited to: promoting product promotion, customer persuasion, and relationship building. Sales Test Specs

select pagename from contactvendors where prodid=192107
Six Sigma Certification

iSixSigma

A confirmation of an individual\'s capabilities with respect to specific competencies

select pagename from contactvendors where prodid=192108
Business Managers Certification

IBSGBM

Board certification in the business management area.

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

Bookmark Page