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
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
|
|
|
|
|
|
|
|
|
|
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 |
|
|