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

College Placement Tests

College placement test resources including study guides, practice tests, tutoring and more. College placement tests are used for various purposes such as for advance placement credit and to place students in certain classes. For more information, see Tests.com's College Placement Test Guide.

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

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193502
202 Useful Exercises for IELTS

Adams & Austen Press Pty. Ltd.

202 Useful Exercises for IELTS ~ IELTS Test Preparation

select pagename from contactvendors where prodid=83070
101 Helpful Hints for IELTS

Adams & Austen Press Pty. Ltd.

IELTS Test Preparation - 101 Helpful Hints for IELTS Course Book

select pagename from contactvendors where prodid=83075
404 Essential Tests for IELTS

Adams & Austen Press Pty. Ltd.

IELTS Test Preparation - 404 Essential Study Materials

select pagename from contactvendors where prodid=193599
ACCUPLACER

The College Board
(212) 713-8000

The ACCUPLACER is published by The College Board and assesses a student's math, English, and reading abilities to determine the best course(s) to take in school.

select pagename from contactvendors where prodid=193600
ACCUPLACER

The College Board
(212) 713-8000

The ACCUPLACER is designed by College Board and assesses a students math, English, and reading abilities to determine the best course(s) to take in school.

select pagename from contactvendors where prodid=193601
AP Test

The College Board
(212) 713-8000

The Advanced Placement Test is published by The College Board and is taken as a final assessment by students enrolled in AP courses.

select pagename from contactvendors where prodid=192303
COMPASS

ACT, Inc
319-337-1270

The Computer-Adaptive Placement Assessment and Support System offers test modules in the subject areas most frequently used by postsecondary institutions to evaluate the skill levels of their incoming students. The test is published by ACT, Inc.

select pagename from contactvendors where prodid=193605
CLAST

Florida Department of Education
(850) 245-0505

The College-Level Academic Skills Test is published by the Florida Department of Education. It's taken by students of a public college or university in the state of Florida. The test is taken by students trying to receive an associates degree in arts, or a bachelors degree in arts or science.

select pagename from contactvendors where prodid=193606
CLEP

The College Board
(212) 713-8000

The CLEP is developed by the College Board. It's taken by students seeking college credit for independent study work that they've already completed.

select pagename from contactvendors where prodid=193498
Live Person TOEFL Tutoring

Liveperson.com

Get expert TOEFL Tutoring for just .50 cents a minute

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

Bookmark Page