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

Graduate Management Admissions Test - GMAT^®

Find resources to prepare for the GMAT, with GMAT study guides, GMAT practice tests, courses and more. The GMAT is an entrance exam for business school graduate programs and must be taken by a candidate to be considered for admission. The GMAT is published by the Graduate Management Admissions Council (GMAC). For more information, see Tests.com's Guide to the GMAT.

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

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193537
GMAT Preparation Tools & GMAT Samples

GMAT PREP

Ways of the GMAT Winners and the Winners\' Guide to GMAT Math: A complete list of GMAT formulae in one place. With comprehenisve theory, and over 100 questions

select pagename from contactvendors where prodid=193609
Graduate Management Admissions Test (GMAT)

Graduate Management Admissions Council
(703) 668-9600

The GMAT is published by the Graduate Management Admissions Council (GMAC). The GMAT measures the aptitude of students applying to graduate school.

select pagename from contactvendors where prodid=193497
Live Person GMAT Tutoring

Liveperson.com

Get expert GMAT Tutoring for just .50 cents a minute

select pagename from contactvendors where prodid=82531
Exambusters New GMAT Study Package

Ace Academics Inc.

New GMAT Study Package

select pagename from contactvendors where prodid=99596
GMAT Math Work Book - Topic wise Practice Tests

4GMAT.com
617-671-1209

GMAT Math Practice Tests, Math work Books - 4GMAT Math Preparation

select pagename from contactvendors where prodid=190004
The PowerScore GMAT Critical Reasoning Bible

PowerScore, Inc.

The PowerScore GMAT Critical Reasoning Bible

select pagename from contactvendors where prodid=190009
GMAT Test Preparation Course

PowerScore, Inc.
800-545-1750

GMAT Test Preparation Course

select pagename from contactvendors where prodid=190016
Self-Directed GMAT Study

PowerScore, Inc.
800-545-1750

The PowerScore GMAT Sentence Correction Bible

select pagename from contactvendors where prodid=190094
GMAT Test Preparation Tutoring

PowerScore, Inc.

GMAT Test Preparation Tutoring

select pagename from contactvendors where prodid=190096
The PowerScore GMAT Verbal Bible

PowerScore, Inc.

The PowerScore GMAT Verbal Bible

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

Bookmark Page

Graduate Management Admissions Test - GMAT®

Graduate Management Admissions Test - GMAT^®