select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=987
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=987
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=987
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=987
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=987 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=987 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=987 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=987
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=987 ) x order by ifnull(priority,999), freesort limit 0 , 10
|
|
|
|
|
|
|
|
|
|
select pagename from contactvendors where prodid=192205 Woodcock-Johnson® III Normative Update Tests of Cognitive Abilities
|
Riverside Publishing 800-323-9540 |
Provides a comprehensive system for measuring general intellectual ability, specific cognitive abilities, scholastic aptitude, oral language, and academic achievement. |
|
|
|
|
select pagename from contactvendors where prodid=192206 WJ III Tests of Cognitive Abilities with Normative Update - Canada
|
Nelson Education 800-268-2222 |
Training sessions are offered across Canada at various times each year. |
|
|
|
|
select pagename from contactvendors where prodid=192208 Essentials of WJ III Cognitive Abilities Assessment
|
M.D. Angus & Associates Ltd. 604-464-1466 |
Provides books on administering, scoring and interpreting the WJIII. |
|
|
|
|
select pagename from contactvendors where prodid=192207 Essentials of WJ III Cognitive Abilities Assessment, 2nd Edition
|
Wiley knowledge for generations™ 201.748.6000 |
The most widely used comprehensive assessment system—the Woodcock-Johnson—is separated into two distinct test batteries: Cognitive Abilities (COG) and Achievement (ACH). |
|
|