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

Carbon Monoxide Test

Find carbon monoxide testing products and services with expert interviews, informative guide and more.

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=583 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=583 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=583 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=583 ) x order by ifnull(priority,999), freesort limit 0 , 10

Test Item

Organization

Description

Cost

select pagename from contactvendors where prodid=6792
Carbon Monoxide Testing Kit

Testcountry.com
800-656-0745

Test For Carbon Monoxide at Home - Health Hazards at Home Test kits

select pagename from contactvendors where prodid=50883
Carbon Monoxide Detector, The Do It Yourself Test Kit

SafetyCentral
707 472-0280

Carbon Monoxide Detector, Carbon Monoxide Test Kit, Carbon Monoxide Testing

select pagename from contactvendors where prodid=50937
Carbon Monoxide Test Kit Professional Quality at Home

The Healthy Home Mall
888-855-3545

Carbon Monoxide Test Kit Professional Quality at Home - Tankless Water Heaters - DIY Home

select pagename from contactvendors where prodid=50989
Carbon Monoxide Test Kit Professional Quality at Home

Testing Kits
888-855-3545

Carbon Monoxide Test Kit Professional Quality at Home - Testing Kits

select pagename from contactvendors where prodid=63916
Carbon Monoxide Test Kit

Pro-Lab®
800-427-0550

Carbon Monoxide Test Kits for Home and Office by PRO-LAB

select pagename from contactvendors where prodid=125170
Carbon Monoxide Testing

Dunbar Home Inspections
800 686-9214

Dunbar Home Inspections and Environmental Testing - CO, Lead, Mold, Pests, Radon, and Wate

select pagename from contactvendors where prodid=29027
Basic Battery Operated Carbon Monoxide Alarm

FirstAlertStore.com!
847-991-4385

First Alert Store - Carbon Monoxide Alarm, Carbon Monoxide Detector, Basic Battery Operate

select pagename from contactvendors where prodid=29035
Battery Operated Carbon Monoxide Alarm with Backlit Digital Display

FirstAlertStore.com!
847-991-4385

First Alert Store - Carbon Monoxide Detector, CO2 Detector, Battery Operated Carbon Monoxi

select pagename from contactvendors where prodid=29040
Basic Plug-In Carbon Monoxide Alarm

FirstAlertStore.com!
847-991-4385

First Alert Store - Carbon Monoxide Alarm, Carbon Monoxide Detector, First Alert Basic Plu

select pagename from contactvendors where prodid=29049
Plug-In Carbon Monoxide Alarm with Battery Backup

FirstAlertStore.com!
847-991-4385

First Alert Store - carbon monoxide detector, plug in carbon monoxide detector, Plug-In Ca

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

Bookmark Page