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) = LSAT-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 = 470
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:
  
Contact

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

Law School Admissions Test - LSAT®

Find resources to prepare for the LSAT, with LSAT study guides, LSAT practice tests, courses and more. The LSAT is an entrance exam to law school and must be taken by a candidate to be considered for admission The LSAT is published by the Law School Admissions Council (LSAC). For more information, see Tests.com's Guide to the Law School Admissions Test.
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=470 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=470 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=470 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=470 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=190002
PowerScore LSAT Game Type Training
PowerScore LSAT Game Type Training
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
 PowerScore, Inc.
800-545-1750 		The PowerScore LSAT Logic Games Bible
select pagename from contactvendors where prodid=190046
The PowerScore LSAT Bible Trilogy
The PowerScore LSAT Bible Trilogy
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
 PowerScore, Inc.
800-545-1750 		The PowerScore LSAT Bible Trilogy
select pagename from contactvendors where prodid=190049
The PowerScore LSAT Logical Reasoning Bible
The PowerScore LSAT Logical Reasoning Bible
Location Type: Online
Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: The PowerScore LSAT Logical Reasoning Bible
 PowerScore, Inc.
 The PowerScore LSAT Logical Reasoning Bible
select pagename from contactvendors where prodid=190095
LSAT Admissions Counseling
LSAT Admissions Counseling
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: LSAT Admissions Counseling
 PowerScore, Inc.
800-545-1750 		LSAT Admissions Counseling
select pagename from contactvendors where prodid=190150
The PowerScore LSAT Reading Comprehension Bible
The PowerScore LSAT Reading Comprehension Bible
Location Type: Online
Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
 PowerScore, Inc.
 The PowerScore LSAT Reading Comprehension Bible
select pagename from contactvendors where prodid=190248
LSAT Test Preparation Tutoring
LSAT Test Preparation Tutoring
Location Type: Online
Organization: PowerScore, Inc.
Address: 57 Hasell StreetCharleston USA SC 29401
Phone: 800-545-1750
Fax: 843-414-6999
Description: LSAT Test Preparating Tutoring
 PowerScore, Inc.
 LSAT Test Preparation Tutoring
select pagename from contactvendors where prodid=190350
LSAT Prep Course
LSAT Prep Course
Email: support@knewton.com
Phone: 888-563-9866
Organization: Knewton
Phone: 888-563-9866
Description: Only Knewton has every real LSAT question online-so you can practice wherever, whenever. Knewton tracks your performance on hundreds of LSAT skills, strategies, and trends to adapt the course to satisfy your needs.
 Knewton
888-563-9866 		Score 5 Points Higher on the LSAT or Your Money Back - Knewton LSAT Prep


select linkname, url, template, examid, viewid, pageid from categorylinks where catid=470 order by posn
    Tests.com BBB Business Review
    Bookmark Page
    select name, value from publiccontent where page='home' or page='All Pages'