select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=814
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=814
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=814
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=814
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=814 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=814 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=814 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select guidelink from categories where id=814
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=814 and enabled is not null
Specialized High School Admissions Test - SHSAT®
Find resources to prepare for the Specialized High School Admissions Test, with study guides, practice tests and more. The SHSAT is used by the New York City school system to determine admissions to the cities' specialized high schools. Students are typically tested in eighth and ninth grades. The SHSAT is published by the NYC Department of Education.
![]() |
Test Item | Organization | Description | Cost | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select pagename from contactvendors where prodid=193618 The Specialized High School Admissions Test
|
NYC Department of Education (212) 639-9675 |
The SHSAT is taken by 8th and 9th graders in New York City, to determine which high school they will enroll in. The test is published by the NYC Department of Education. |
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=814 order by posn


