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

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

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

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

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

Nevada Tech Publishers
800-632-7732

BOOKS FOR ELECTRICIANS

select pagename from contactvendors where prodid=90823
2008 ELECTRICIANS EXAM BOOK

Nevada Tech Publishers
800-632-7732

BOOKS FOR ELECTRICIANS

select pagename from contactvendors where prodid=90830
2008 NATIONWIDE COMBO (INCLUDES 3 BOOKS)

Nevada Tech Publishers
800-632-7732

BOOKS FOR ELECTRICIANS

select pagename from contactvendors where prodid=90787
SNAPZ Electrical Instructor PRO

Snapz®
302-234-0402

Snapz Software Online

select linkname, url, template, examid, viewid, pageid from categorylinks where catid=580 order by posn

Bookmark Page