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

English Test

Find resources to prepare for English tests, with study guides, practice tests, flashcards and more. English tests come in many different forms testing different subjects such as grammer, writing composition and reading comprehension. For more information, see Tests.com's English 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=510 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=510 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=510 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=510 ) x order by ifnull(priority,999), freesort limit 0 , 10

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=193514
Grammar Practice Test

Tests.com

Take a free Grammar practice Test and see how well you know your grammar.

Free

select pagename from contactvendors where prodid=98261
Reading Detective Series

The Critical Thinking Co.™
800-458-4849

Standards-based critical thinking activities develop the analysis, synthesis, and vocabulary skills students need for exceptional reading comprehension.

$24.99

select pagename from contactvendors where prodid=193483
Live Person Grammer Test Tutoring

Liveperson.com

Get expert Grammer Test Tutoring for just .50 cents a minute

select pagename from contactvendors where prodid=193484
Live Person Literature Test Tutoring

Liveperson.com

Get expert Literature Test Tutoring for just .50 cents a minute

select pagename from contactvendors where prodid=82660
Exambusters English Vocabulary CD-Rom Study Cards

Ace Academics Inc.

English Vocabulary CD-Rom Study Cards

select pagename from contactvendors where prodid=190877
English Grammar

Permacharts™

Permacharts - English Grammar

select pagename from contactvendors where prodid=190886
The Basic Cozy English Grammar Course

Splashes From The River
800-201-2280

Basic English Grammar Course - Free Online Test

select pagename from contactvendors where prodid=190878
Test Time! Practice Books That Meet the Standards: Grammar & Usage

Walch Education®

Help students make the grade on state and national tests!

select pagename from contactvendors where prodid=190884
Master Essential English Grammar and Creative Writing Skills

Core Learning
800-270-4643

Language Arts Companion: English Grammar I - Master Essential Grammar Skills

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

Bookmark Page