select id, url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where url=? and enabled is not null
field (s) = Pre-School-Test

PHP Error
Error number 8: Undefined index: guidetitle
Line 85 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php


PHP Error
Error number 8: Undefined index: guidemetadescription
Line 86 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select id, pagedataid from categories where id = 918
select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

PHP Error
Error number 8: Use of undefined constant categories_pagedataid - assumed 'categories_pagedataid'
Line 94 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select pagesize from settings
select qstnset, free from examset where free is not null

AJAX Debug:

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

Pre-School Standardized Test Preparation

Find resources to prepare your child for pre-school testing, with age suitalbe guides, practice tests and more. Some schools require a child to take pre-school evaluations to ensure the child is ready to enter pre-school or kindergarten. For more information, see Tests.com's Pre-school and Kindergarten 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=918 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=918 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=918 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=918 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=194316
Practice Questions for the WPPSI Test®
Practice Questions for the WPPSI Test®
Location: McKinney TX
Phone: (877) 609-6203
Location Type: Online

Organization: TestingMom.com
Address: 6841 Virginia ParkwayMcKinney USA TX 75071
Phone: (877) 609-6203
TestingMom.com
(877) 609-6203
Instantly view, download, and print over 50,000 Practice Questions to prepare for Preschool testing, including the WPPSI Test®. Get 100 free practice questions to get started. As low as 10.99/mo
select pagename from contactvendors where prodid=191989
Complete Pre-K & Kindergarten ERB/WPPSI™-III Practice Workbook
Complete Pre-K & Kindergarten ERB/WPPSI™-III Practice Workbook
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Featured in NY Times and New York magazine. Gives parents insight into the test and testing process.
Aristotle Circle
212-360-2301
Featured in NY Times and New York magazine. Gives parents insight into the test.
select pagename from contactvendors where prodid=192002
Verbal Subtests Bundle 2: Comprehension, Word Reasoning, and Similarities Verbal
Verbal Subtests Bundle 2: Comprehension, Word Reasoning, and Similarities Verbal
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Practice exercises and information for Comprehension, Word Reasoning and Similarities subtests.
Aristotle Circle
212-360-2301
Exercises and information for Comprehension, Word Reasoning and Similarities subtests.
select pagename from contactvendors where prodid=191992
Matrix Reasoning Subtest (ERB/WPPSI™-III)
Matrix Reasoning Subtest (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Includes detailed description of subtest, instructions, 50+ sample questions, using colorful images.
Aristotle Circle
212-360-2301
Includes detailed description of subtest, instructions and 50+ sample questions.
select pagename from contactvendors where prodid=192004
Vocabulary Subtest (ERB/WPPSI™-III)
Vocabulary Subtest (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Over 400 images and sample test questions. Includes all images required to score 99% on the test.
Aristotle Circle
212-360-2301
Over 400 images and sample questions. Includes all images required to score 99% on the test.
select pagename from contactvendors where prodid=191998
Block Design Subtest (ERB/WPPSI™-III)
Block Design Subtest (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Includes instructions and 45 practice exercises which ramp in difficulty to prepare 3-6 year olds.
Aristotle Circle
212-360-2301
Includes instructions and 45 practice exercises to prepare 3-6 year olds.
select pagename from contactvendors where prodid=191996
Coding Subtest (ERB/WPPSI™-III)
Coding Subtest (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Includes instructions and 70 practice exercises. Colorful images, B/W shapes to prepare 3-6 year olds.
Aristotle Circle
212-360-2301
Includes instructions and 70 practice exercises with colorful images.
select pagename from contactvendors where prodid=192006
Concept Groupings and Matching Activities (ERB/WPPSI™-III)
Concept Groupings and Matching Activities (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Includes supplemental materials to enhance understanding of common and abstract category groupings.
Aristotle Circle
212-360-2301
Includes materials to enhance understanding of common and abstract category groupings.
select pagename from contactvendors where prodid=191994
Picture Concepts Subtest (ERB/WPPSI™-III)
Picture Concepts Subtest (ERB/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: Includes detailed description of subtest including instructions and 100+ sample questions.
Aristotle Circle
212-360-2301
Includes detailed description of subtest including instructions and 100+ sample questions.
select pagename from contactvendors where prodid=192008
Picture Completion Subtest (WISC™-IV/WPPSI™-III)
Picture Completion Subtest (WISC™-IV/WPPSI™-III)
Location: New York NY
Email: info@aristotlecircle.com
Phone: 212-360-2301
Location Type: Online

Organization: Aristotle Circle
Address: 419 Lafayette StreetNew York USA NY 10003
Phone: 212-360-2301
Fax: 212-260-9959
Description: WPPSI-III subtest(typically not used in NYC, but used in other cities), ERB Grades 1-4 (all regions)
Aristotle Circle
212-360-2301
WPPSI-III subtest(typically not used in NYC, but used in other cities), ERB Grades 1-4 (all regions)


select linkname, url, template, examid, viewid, pageid from categorylinks where catid=918 order by posn
select name, value from publiccontent where page='home' or page='All Pages'