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) = Master-Electrician-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 = 580
select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=1105

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

Master Electrician Exam

Find master electrician exam resources such as electrician practice tests, electrician test preparation guides, test tips, courses and more. Master electrician candidates are required to take an exam in certain states for licensure. For more information, see Tests.com's Journeyman and Master Electrician 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=580 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=580 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=580 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=580 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=194049
Master Electrician Practice Tests
Master Electrician Practice Tests
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Ace your state Master Electrician License Exam using our 3 full-length, expert written practice exams with answers fully explained for ideal study. Choose the 2011 or 2014 NEC based version. 79.95
select pagename from contactvendors where prodid=194362
Master Electrician Practice Exam Kit 2014 NEC
Master Electrician Practice Exam Kit 2014 NEC
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
Ace your state Master Electrician License Exam using our 3 full-length, expert written practice exams with answers fully explained for ideal study. Covers the 2014 NEC. $89.95
select pagename from contactvendors where prodid=194791
Electrician's Practice Calculations Exams - 2014 NEC
Electrician's Practice Calculations Exams - 2014 NEC
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
A practice book of electrical calculations designed to give a clear and concise review of the basics of solving mathematical problems.
select pagename from contactvendors where prodid=194792
Practical Calculations for Electricians - 2014 NEC
Practical Calculations for Electricians - 2014 NEC
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
A practice book of electrical calculations designed to give a clear and concise review of the basics of solving mathematical problems.
select pagename from contactvendors where prodid=90842
2005 ELECTRICIANS HANDBOOK OF NEC QUESTIONS
2005 ELECTRICIANS HANDBOOK OF NEC QUESTIONS
Location: Carson City NV
Email: info@rayholderelectricalseminars.com
Phone: 800-632-7732

Organization: Nevada Tech Publishers
Address: 2533 N. Carson St, Suite N-203Carson City USA NV 89706
Phone: 800-632-7732
Nevada Tech Publishers
800-632-7732
BOOKS FOR ELECTRICIANS
select pagename from contactvendors where prodid=90823
2008 ELECTRICIANS EXAM BOOK
2008 ELECTRICIANS EXAM BOOK
Location: Carson City NV
Email: info@rayholderelectricalseminars.com
Phone: 800-632-7732

Organization: Nevada Tech Publishers
Address: 2533 N. Carson St, Suite N-203Carson City USA NV 89706
Phone: 800-632-7732
Nevada Tech Publishers
800-632-7732
BOOKS FOR ELECTRICIANS
select pagename from contactvendors where prodid=90830
2008 NATIONWIDE COMBO (INCLUDES 3 BOOKS)
2008 NATIONWIDE COMBO (INCLUDES 3 BOOKS)
Location: Carson City NV
Email: info@rayholderelectricalseminars.com
Phone: 800-632-7732

Organization: Nevada Tech Publishers
Address: 2533 N. Carson St, Suite N-203Carson City USA NV 89706
Phone: 800-632-7732
Nevada Tech Publishers
800-632-7732
BOOKS FOR ELECTRICIANS
select pagename from contactvendors where prodid=90787
SNAPZ Electrical Instructor PRO
SNAPZ Electrical Instructor PRO
Location: Hockessin DE
Email: support@snapz.com
Phone: 302-234-0402

Organization: Snapz®
Address: 25 Stuyvesant DriveHockessin USA DE 19707
Phone: 302-234-0402
Fax: 866-814-4026
Description: National Electrical Code Master Electrician Exam Preparation Software.
Snapz®
302-234-0402
Snapz Software Online


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