SELECT e.qstnset, e.pagename, e.testcomment, e.free, e.metatitle, e.metadesc, e.keywordsdesc,
ifnull(a.name,e.authorname1) authorname1, e.authorname2,
ifnull(a.email, e.authoremail) authoremail, ifnull(a.website,e.authorwebsite) authorwebsite,
a.bio, e.categoryid, e.completionmsg, e.authorwebtitle, e.authortitle, e.version, c.name catname, c.guideurl, c.dirtitle, c.dhtmltitle, c.htmldesciption, c.metadescription, c.keywordsdesc, c.categorydesc, c.htmldesciption, c.practicetesturl, c.toppagelinks, e.examname, e.copyright
FROM examset e
left outer join categories c on e.categoryid=c.id
left outer join examauthors a on e.authorid=a.authorid
WHERE e.offline is null and e.setname=? field (s) = plumbing-practice-test SELECT q.qstnid, q.position, q.datatype, q.image, q.alignment, q.question, q.answerposn, q.answer, q.explanation, q.explainimage, q.section sectionid, s.name section, q.ad, q.storyid, x.title, x.story, x.image storyimage, x.imagealt storyalt
FROM examqstn q
LEFT OUTER JOIN examsections s on q.qstnset=s.qstnset and q.section=s.id
LEFT OUTER JOIN examstories x on q.qstnset=x.qstnset and q.storyid=x.storyid
WHERE q.qstnset=5 and (q.qstntype=3 or q.qstntype=1) and q.offline is null and q.disabled is null and q.datatype='1' ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=150 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62597 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62571 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62572 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62573 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62574 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62575 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62576 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62577 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62578 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62579 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62580 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62581 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62582 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62583 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62584 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62585 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62586 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62587 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62588 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62589 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62590 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62591 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62592 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62593 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=62594 ORDER BY position select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=446
select page from pagedata where template like 'productpage%' and category=446
select name, value from publiccontent where page='All Pages' or page='All Pages'
select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle
from adsdesc
where status is null and categoryid=446
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=446
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=446
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=446 2023 Edition
Plumbing Practice Test
This free plumbing practice test will give you an idea of the types of questions that appear on actual plumbing licensing exams. Plumbing exams vary by state but most all states and local plumbing jurisdictions have adopted either the IPC or the UPC plumbing codes. Typical exam sections include: fixtures, sanitary drainage systems, administrative policies, venting, indirect and special wastes, etc.
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=446 order by posn
was a master plumber and gas fitter for over 30 years. He built his own plumbing business and has trained countless plumbers. In addition to being a field plumber and contractor, Woodson served as adjunct faculty at Central Maine Technical College where he taught both plumbing licensing preparation courses and plumbing apprenticeship courses. As R. Dodge Woodson, he is a best-selling author and is the most prolific plumbing author in print with McGraw-Hill. He is often referred to as America’s Plumber.
Charles Redecker
was a master plumber instructor and education director with the National Center for Construction Education and Research. Charles taught plumbing with the NCCER for over 10 years. Prior to working with the NCCER, Charles taught plumbing at the Rankin Technical College. Charles owned and run various plumbing businesses since 1979 in St. Louis, Missouri.
John Richardson
is a master plumber who has been in the plumbing business since 1977. He is a certified continuing education instructor for plumbing in Texas and teaches CPE classes to journeyman and master plumbers to renew their licenses. John holds a B.A. degree in English from Texas A&M University. He owns State-Wyed Plumbing and Septic in Katy, Texas.
Terry Lunt
is a plumbing and master craft instructor with Associated Builders and Contractors in Southern California. He has also been a core curriculum instructor and subject matter expert in plumbing with the National Center for Construction Education and Research. Terry has worked in the plumbing industry for over 30 years.
Joseph Cromwell
is a master plumber in Illinois and Indiana. He was a continuing education instructor and apprentice instructor for over twenty years with the United Association of Plumbers and Pipefitters.