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

SAT®

Find resources to help prepare for the SAT test, with prep materials, practice tests, tutoring, courses and guides. The SAT is used in the college admission process and consists of two parts, the reasoning test and the subject test. The SAT is published by the College Board. To learn more about the test, see Tests.com's Guide to the SAT.
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=368 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=368 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=368 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=368 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193495
Live Person SAT Test Tutoring
Live Person SAT Test Tutoring
Location Type: Online

Organization: Liveperson.com
Address: USA
Liveperson.com
Get expert SAT Test Tutoring for just .50 cents a minute
select pagename from contactvendors where prodid=193598
SAT
SAT
Location: New York NY
Phone: (212) 713-8000
Location Type: Online

Organization: The College Board
Address: 45 Columbus AvenueNew York City USA NY 10023-6917
Phone: (212) 713-8000
The College Board
(212) 713-8000
The SAT is published by The College Board, and is taken by high school students who wish to prove their aptitude to colleges.
select pagename from contactvendors where prodid=82491
Exambusters SAT II Math Study Package
Exambusters SAT II Math Study Package
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
SAT II Math Study Package
select pagename from contactvendors where prodid=82486
Exambusters New SAT Study Package
Exambusters New SAT Study Package
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 550 Durie AvenueCloster USA NJ 07624
Ace Academics Inc.
New SAT
select pagename from contactvendors where prodid=190929
Private SAT Tutoring Nationwide
Private SAT Tutoring Nationwide
Location: New York NY
Email: newyork@parliamenttutors.com
Phone: 877-873-0511

Organization: Parliament Tutors
Phone: 646-750-0202
Parliament Tutors
877-873-0511
Private Tutoring and Test Prep from the naion\'s leading home tutoring service.
select pagename from contactvendors where prodid=190386
SAT Platinum Test Preparation
SAT Platinum Test Preparation
Location: Chicago IL
Email: info@prepme.com
Phone: 877-773-7634
Location Type: Online

Organization: PrepMe LLC
Address: 207 E. Ohio StChicago USA IL 60611
Phone: 877-773-7634
PrepMe LLC
877-773-7634
Online SAT lessons, tests, top tutors & guaranteed score increase!
select pagename from contactvendors where prodid=190034
SAT II Math Study Package
SAT II Math Study Package
Location: Closter
Email: info@exambusters.com
Location Type: Online

Organization: Ace Academics Inc.
Address: 253 Closter Dock RoadCloster USA 07624
Description: A fast, focused review for SAT II- Math, Biology, Chemistry, Physics, Japanese, Hebrew, French, Chinese, Spanish, German, Italian, American/U.S. History, and World/European History.
Ace Academics Inc.
Over 1,000 Questions and Answers. Review the Basics!!! Made in USA.
select pagename from contactvendors where prodid=190343
SAT Admissions Counseling
SAT Admissions Counseling
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: SAT Admissions Counseling
PowerScore, Inc.
SAT Admissions Counseling
select pagename from contactvendors where prodid=190345
The Official SAT Study Guide TM
The Official SAT Study Guide TM
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: The Official SAT Study Guide TM
PowerScore, Inc.
The Official SAT Study Guide TM
select pagename from contactvendors where prodid=190340
SAT Test Preparation Course
SAT Test Preparation Course
Location: Charleston SC
Email: contact@powerscore.com
Phone: 800-545-1750
Location Type: Online

Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: SAT Test Preparation Course
PowerScore, Inc.
800-545-1750
SAT Test Preparation Course


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