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) = Intelligence-Tests

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

Intelligence Test Resources

Intelligence test preparation resources including intelligence practice tests and an Intelligence Testing 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=97 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=97 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=97 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=97 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=107826
Critical Thinking Book One
Critical Thinking Book One
Email: service@CriticalThinking.com
Phone: 800-458-4849

Organization: The Critical Thinking Co.™
Phone: 800-458-4849
The Critical Thinking Co.™
800-458-4849
The Critical Thinking Co.™ - Critical Thinking Book One $22.99
select pagename from contactvendors where prodid=194306
Practice Questions for the Stanford-Binet Test®
Practice Questions for the Stanford-Binet 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 including the Stanford Binet Test®. Get 100 free practice questions to get started. As low as $10.99/mo
select pagename from contactvendors where prodid=193679
ASSESSMENT with the WAIS-IV
ASSESSMENT with the WAIS-IV
Location: La Mesa CA
Phone: (888) 815-2898

Organization: Jerome M. Sattler, Publisher, Inc.
Address: P.O. Box 1060La Mesa USA CA 91944
Phone: (888) 815-2898
Jerome M. Sattler, Publisher, Inc.
(888) 815-2898
Assessment with the WAIS–IV is both a teaching text and a reference source for students and professionals providing an analysis of a major instrument useful for the cognitive assessment of adults and older adolescents.
select pagename from contactvendors where prodid=194315
Practice Questions for the ITBS Test®
Practice Questions for the ITBS 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 25,000 Intelligence Test Practice Questions for kids ages 4 to 12. Get 100 free practice questions to get started. As low as 10.99/mo
select pagename from contactvendors where prodid=193680
Assessment of Children: Cognitive Foundations
Assessment of Children: Cognitive Foundations
Location: La Mesa CA
Phone: (888) 815-2898

Organization: Jerome M. Sattler, Publisher, Inc.
Address: P.O. Box 1060La Mesa USA CA 91944
Phone: (888) 815-2898
Jerome M. Sattler, Publisher, Inc.
(888) 815-2898
Both a teaching text and a reference source for students and professionals. Highlights: issues related to intelligence, assessment ethical guidelines, laws pertaining to children with disabilities, the Differential Ability Scales–Second Edition (DAS–II), the Stanford-Binet Intelligence Scales–Fifth Edition (SB5), and brief intelligence tests.
select pagename from contactvendors where prodid=193681
Assessment of Children: Behavioral, Social, and Clinical Foundations, Fifth Edition
Assessment of Children: Behavioral, Social, and Clinical Foundations, Fifth Edition
Location: La Mesa CA
Phone: (888) 815-2898

Organization: Jerome M. Sattler, Publisher, Inc.
Address: P.O. Box 1060La Mesa USA CA 91944
Phone: (888) 815-2898
Jerome M. Sattler, Publisher, Inc.
(888) 815-2898
An independent text in such courses as child clinical assessment, personality assessment, and behavioral assessment.
select pagename from contactvendors where prodid=190257
Verbal Reasoning
Verbal Reasoning
Email: os@assessmentday.co.uk

Organization: Assessment Day
Description: Verbal reasoning selection tests conducted by employers almost exclusively take the form of a written passage and a series of questions with possible True, False or Cannot Say responses.
Assessment Day
Verbal Reasoning | Free Verbal Reasoning Practice Tests
select pagename from contactvendors where prodid=190259
Verbal Reasoning
Verbal Reasoning
Email: os@assessmentday.co.uk

Organization: Assessment Day
Description: Verbal reasoning selection tests conducted by employers almost exclusively take the form of a written passage and a series of questions with possible True, False or Cannot Say responses.
Assessment Day
Verbal Reasoning | Free Verbal Reasoning Practice Tests
select pagename from contactvendors where prodid=190261
Verbal Reasoning
Verbal Reasoning
Email: os@assessmentday.co.uk

Organization: Assessment Day
Description: Verbal reasoning selection tests conducted by employers almost exclusively take the form of a written passage and a series of questions with possible True, False or Cannot Say responses.
Assessment Day
Verbal Reasoning | Free Verbal Reasoning Practice Tests
select pagename from contactvendors where prodid=190263
Verbal Reasoning
Verbal Reasoning
Email: os@assessmentday.co.uk

Organization: Assessment Day
Description: Verbal reasoning selection tests conducted by employers almost exclusively take the form of a written passage and a series of questions with possible True, False or Cannot Say responses.
Assessment Day
Verbal Reasoning | Free Verbal Reasoning Practice Tests


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