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) = TerraNova-Testing

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

TerraNovaTM Test Preparation

TerraNova Test Prep resources including TerraNova practice tests, TerraNova Testing Guide and more.  The TerraNova is used in grades K-12 to determine the level at which a student is performing. 
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=985 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=985 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=985 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=985 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=194314
Practice Questions to prepare for TerraNova®
Practice Questions to prepare for TerraNova®
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 build skills needed on the TerraNova Test®, including ITBS® and Woodcock Johnson Tests®. Get 100 free practice questions to get started. As low as $10.99/mo
select pagename from contactvendors where prodid=192156
CAT Multiple Assessments Test Books
CAT Multiple Assessments Test Books
Location: Monterey CA
Email: tmsupport@ctb.com
Phone: 831.393.0700

Organization: CTB/McGraw-Hill LLC
Address: 20 Ryan Ranch RoadMonterey USA CA 93940
Phone: 831.393.0700
Fax: 800.282.0266
CTB/McGraw-Hill LLC
831.393.0700
TerraNova CAT, for Grades 1-12, combines selected items with constructed-response items to allow students to produce short and extended responses. Both item formats are presented in contexts related to situations in and out of the classroom.
select pagename from contactvendors where prodid=193588
TerraNova, Third Edition
TerraNova, Third Edition
Location: Monterey CA
Email: tmsupport@ctb.com
Phone: 831.393.0700

Organization: CTB/McGraw-Hill LLC
Address: 20 Ryan Ranch RoadMonterey USA CA 93940
Phone: 831.393.0700
Fax: 800.282.0266
CTB/McGraw-Hill LLC
831.393.0700
A wide range of standardized achievement tests.


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