←
Call Now:
Toll-Free:

Mcdonnell Miller Bronze Liquid Level Reflex Site Glass & Valve Kit for Water Columns 157 , 193, & 194 Series.

Other Recommended Products:
Additional Information

Key Features:

  1. Durable Construction: The sight glass sets are constructed from bronze, ensuring durability and longevity in demanding industrial environments.

  2. Pressure and Temperature Ratings: They are designed to handle pressures up to 300 WSP (Water, Steam, Pressure) at 450°F and 600 WOG (Water, Oil, Gas), making them suitable for a variety of applications​​​​.

  3. ASME Compliance: These kits comply with Boiler and Pressure Vessel Code Section 1 and ASME B31.1, ensuring they meet strict safety and performance standards​​.

  4. Complete Kits: Each kit includes a bronze reflex liquid level sight glass along with upper and lower slow-opening or quick-opening valves. The valves are designed with 1/2" NPT (National Pipe Thread) ports, and the kits are available in different sizes to fit specific model requirements:

    • Model 897 Bronze Size 5: Maintains 11-1/2" center-to-center distance for McDonnell Miller 157 series.
    • Model 899 Bronze Size 7: Maintains 11-1/2", 12-3/4", and 12-7/8" center-to-center distances for McDonnell Miller 193 and 194 series​​​​.
  5. Customization and Shipping: BoilerSupplies.com offers customization options to ensure you get the exact size and configuration needed for your system. They also provide same-day shipping for in-stock items, with express shipping options available​​​​.

 _showSql
0.0002288818359375SET @@collation_connection = @@collation_database
0.00015115737915039SET NAMES utf8
0.001655101776123SELECT *
FROM information_schema.tables
WHERE table_schema = 'boiler' AND table_name = 'settings'
LIMIT 1;
0.00039196014404297SELECT code, val
FROM settings
0.00056219100952148SELECT ip_address
FROM blocked_ips
0.0022690296173096SHOW COLUMNS
FROM catalog_categories
0.0010330677032471SELECT id, parent_id, title, short_title, description, meta_title, meta_kw, template_id, hs_list_id, url, pos, meta_description, meta_tags, status, own_page, `groups`, img, additional_info, image_box_text, natpos, image_box_image, code, shipping_length, shipping_height, shipping_width, shipperhq_group, vendor_id, shipperhq_packing_rule
FROM catalog_categories
WHERE url="mcdonnell-miller-water-column-sight-glass-sets"
0.0013120174407959SHOW COLUMNS
FROM content_pages
0.00070691108703613SELECT p.id, meta_title, meta_descr, meta_kw, p.html, t.html AS tpl, t.id AS tpl_id, p.title as title, t.title as tpl_title
FROM content_pages AS p
INNER JOIN content_templates AS t ON (p.template_id=t.id)
WHERE p.alias="products" AND p.page_type=""
LIMIT 1
0.00033211708068848SELECT *
FROM catalog_categories
WHERE id=374 AND status=1
ORDER BY pos
0.00030183792114258SELECT *
FROM catalog_categories
WHERE id=374 AND status=1
ORDER BY pos
0.00035190582275391SELECT *
FROM catalog_categories
WHERE id=78 AND status=1
ORDER BY pos
0.0021729469299316SHOW COLUMNS
FROM products
0.0010437965393066SHOW COLUMNS
FROM additional_categories
0.0010490417480469SHOW COLUMNS
FROM catalog_categories_groups
0.035333156585693SELECT (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) AS additional_categories, (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) AS additional_subcategories, pos AS pos, is_glass AS is_glass, show_image_in_public AS show_image_in_public, `products`.id AS id, title AS title, `products`.category_id AS category_id, image_box_text AS image_box_text, image_box_image AS image_box_image, url AS url, is_rfq AS is_rfq, has_price AS has_price, status AS status, manufacturer_id AS manufacturer_id, del_status AS del_status, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = `products`.category_id),"") AS category, IFNULL((
SELECT s.title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory, IFNULL((
SELECT s.short_title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory_short_title, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS category_url, `products`.category_id AS subcategory_id, IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS subcategory_url, IFNULL((
SELECT k.pos
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_pos, IFNULL((
SELECT c.short_title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title_full, IFNULL((
SELECT k.id
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_id_list, IFNULL((
SELECT CASE WHEN parent_id=0 THEN "1" WHEN parent_id > 0 THEN "0" ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS without_subcategory, IFNULL((
SELECT g.`groups`
FROM catalog_categories AS g
WHERE g.id = `products`.category_id),"") AS category_groups, IFNULL((
SELECT n.group_id
FROM catalog_categories_groups AS n
WHERE n.id = category_groups),"no-groups") AS subcategory_groups, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =`products`.category_id),"") AS subcategory_own_page

FROM products
WHERE 1 AND (`products`.category_id =374 OR ((
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '374' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '374,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,374,%' OR (
SELECT GROUP_CONCAT(acat.category_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,374') OR ((
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '374' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '374,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,374,%' OR (
SELECT GROUP_CONCAT(acat.subcategory_id)
FROM additional_categories AS acat
WHERE `products`.id = acat.product_id GROUP BY acat.product_id) LIKE '%,374') ) AND status =1 AND del_status =1
ORDER BY pos ASC,title ASC
0.0017879009246826SHOW COLUMNS
FROM files
0.00055503845214844SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1058
0.0003969669342041SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1058
ORDER BY cdate DESC
LIMIT 1
0.00034213066101074SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1060
0.00036096572875977SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =1060
ORDER BY cdate DESC
LIMIT 1
0.0010631084442139SHOW COLUMNS
FROM product_positions
0.00047779083251953SELECT COUNT(*)
FROM product_positions
WHERE 1 AND category_id =374
0.0010881423950195SHOW COLUMNS
FROM recommended_products
0.012718915939331SELECT IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 374 AND rp.category_id = 0
LIMIT 1), 0) AS recommended_id, pos AS pos, is_glass AS is_glass, show_image_in_public AS show_image_in_public, `products`.id AS id, title AS title, `products`.category_id AS category_id, image_box_text AS image_box_text, image_box_image AS image_box_image, url AS url, is_rfq AS is_rfq, has_price AS has_price, status AS status, manufacturer_id AS manufacturer_id, del_status AS del_status, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = `products`.category_id),"") AS category, IFNULL((
SELECT s.title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory, IFNULL((
SELECT s.short_title
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS subcategory_short_title, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = `products`.category_id),"") AS category_url, `products`.category_id AS subcategory_id, IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS category_id_new, IFNULL((
SELECT s.url
FROM catalog_categories AS s
WHERE s.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS subcategory_url, IFNULL((
SELECT k.pos
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_pos, IFNULL((
SELECT c.short_title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title, IFNULL((
SELECT c.title
FROM catalog_categories AS c
WHERE c.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_title_full, IFNULL((
SELECT k.id
FROM catalog_categories AS k
WHERE k.id = IFNULL((
SELECT CASE WHEN parent_id=0 THEN id WHEN parent_id > 0 THEN parent_id ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"")),"") AS category_id_list, IFNULL((
SELECT CASE WHEN parent_id=0 THEN "1" WHEN parent_id > 0 THEN "0" ELSE "no matter" END AS category
FROM catalog_categories AS d
WHERE d.id=`products`.category_id),"") AS without_subcategory, IFNULL((
SELECT g.`groups`
FROM catalog_categories AS g
WHERE g.id = `products`.category_id),"") AS category_groups, IFNULL((
SELECT n.group_id
FROM catalog_categories_groups AS n
WHERE n.id = category_groups),"no-groups") AS subcategory_groups, IFNULL((
SELECT n.own_page
FROM catalog_categories AS n
WHERE n.id =`products`.category_id),"") AS subcategory_own_page

FROM products
WHERE 1 AND status =1 AND del_status =1 AND IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 374 AND rp.category_id = 0
LIMIT 1), 0) > 0
ORDER BY IFNULL((
SELECT rp.id
FROM recommended_products AS rp
WHERE rp.product_id = `products`.id AND rp.for_subcategory_id = 374 AND rp.category_id = 0
LIMIT 1), 0) ASC , title ASC
0.00037312507629395SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =994
0.00037384033203125SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =994
ORDER BY cdate DESC
LIMIT 1
0.0012011528015137SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =259
0.0012490749359131SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =259
ORDER BY cdate DESC
LIMIT 1
0.0015850067138672SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =265
0.0013580322265625SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =265
ORDER BY cdate DESC
LIMIT 1
0.0019831657409668SELECT COUNT(*)
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =266
0.0014739036560059SELECT id AS id, element_id AS element_id, element_type AS element_type, file_category AS file_category, title AS title, filename AS filename, repository_file_id AS repository_file_id, cdate AS cdate, description AS description, status AS status, alt_text AS alt_text, is_zoom AS is_zoom
FROM files
WHERE 1 AND element_type =1 AND file_category =1 AND element_id =266
ORDER BY cdate DESC
LIMIT 1
0.0014221668243408SHOW COLUMNS
FROM ads
0.00037789344787598SELECT COUNT(*)
FROM ads
WHERE 1 AND status =1
0.00047492980957031SELECT id, url, category_id
FROM products
WHERE id = '994' OR url = '994'
LIMIT 1
0.00027894973754883SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '372'
LIMIT 1
0.00025415420532227SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '77'
LIMIT 1
0.00039100646972656SELECT id, url, category_id
FROM products
WHERE id = '259' OR url = '259'
LIMIT 1
0.00026202201843262SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '92'
LIMIT 1
0.00027799606323242SELECT url, title, own_page, parent_id
FROM catalog_categories
WHERE id = '89'
LIMIT 1
0.00037121772766113SELECT id, url, category_id
FROM products
WHERE id = '265' OR url = '265'
LIMIT 1
0.00036406517028809SELECT id, url, category_id
FROM products
WHERE id = '266' OR url = '266'
LIMIT 1
0.0011518001556396SHOW COLUMNS
FROM megamenu
0.00080490112304688SELECT COUNT(*)
FROM megamenu
WHERE 1
0.00035309791564941SELECT id AS id, title AS title, href AS href, type AS type, parent_id AS parent_id, pos AS pos
FROM megamenu
WHERE 1
ORDER BY id
0.00027918815612793SELECT title
FROM catalog_categories
WHERE id=374
0.00026297569274902SELECT title
FROM catalog_categories
WHERE id=374
0.00025606155395508SELECT title
FROM catalog_categories
WHERE id=374
0.00025391578674316SELECT title
FROM catalog_categories
WHERE id=374
0.00025105476379395SELECT id, parent_id, description, meta_description, short_title, url, title
FROM catalog_categories
WHERE id = '374'
LIMIT 1
Total: 0.085370779037476

 _showPOST
POST is empty