select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=544
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=544
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=544
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=544
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=544 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=544 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=544 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=544
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=544 ) x order by ifnull(priority,999), freesort limit 0 , 10
|
|
|
|
|
|
|
|
|
|
select pagename from contactvendors where prodid=193492 Live Person Calculus Tutoring
|
Liveperson.com |
Get expert Calculus Test Tutoring for just .50 cents a minute |
|
|
|
|
select pagename from contactvendors where prodid=190906 Speedstudy Calculus
|
Selectsoft Publishing |
Welcome to Selectsoft Publishing - Speedstudy Calculus |
|
|
|
|
select pagename from contactvendors where prodid=190901 Calculus Integrals I
|
Permacharts™ 800-387-3626 |
Permacharts - Calculus Integrals I |
|
|
|
|
select pagename from contactvendors where prodid=190893 AP Calculus AB & BC - The Best Test Prep
|
REA Online 732-819-8880 |
REA Online - Making The World Smarter |
|
|
|
|
select pagename from contactvendors where prodid=190907 Introductory Calculus
|
Intelligent TutorTM 800-521-4518 |
Award-Winning Calculus Academic Instructional Review and Practice Software |
|
|
|
|
select pagename from contactvendors where prodid=190890 Struggling with Calculus? You arent alone
|
Omniac Education 602-903-6485 |
Calculus Tutoring, High School | Omniac Education |
|
|
|
|
select pagename from contactvendors where prodid=190908 Calculus tutor
|
Eduwizards |
Calculus Tutor, Calculus Homework Help : EduwizardS |
|
|
|
|
select pagename from contactvendors where prodid=190909 Calculus Tutors
|
Stepping Stone Tutors 888-303-8088 |
Calculus Tutor - Calculus Tutoring - Calculus Tutors |
|
|
|
|
select pagename from contactvendors where prodid=190892 Calculus 1st Edition Instructional CD-ROM
|
Digitalinteractive Video Education 936-372-9216 |
Dive Into Math |
|
|
|
|
select pagename from contactvendors where prodid=190910 Calculus 2nd Edition Instructional CD-ROM
|
Digitalinteractive Video Education 936-372-9216 |
Dive Into Math |
|
|