Firm

8 Items
SELECT f.id,
f.u_id,
IF(f.display_title = '', f.title, f.display_title) AS title,
IF(f.retail_sku = '', f.brand_sku, f.retail_sku) AS public_sku,
IF(f.on_display = '1', '1', '0') AS available,
fb.u_id AS brand_u_id,
IF(fb.display_title='', fb.title, fb.display_title) AS b_title,
f.brand_u_id,
f.page,
f.twin,
f.twin_price,
f.twin_set_price,
f.twinxl,
f.twinxl_price,
f.twinxl_set_price,
f.full,
f.full_price,
f.full_set_price,
f.queen,
f.queen_price,
f.queen_set_price,
f.king,
f.king_price,
f.king_set_price,
f.california,
f.california_price,
f.california_set_price,
f.ecommerce_enabled_item AS ecommerce_enabled,
f.collection_id,
'mattresses/' AS catalog_folder,
'mattresses' AS rtable,
f.in_stock,
f.on_display,
f.display_order,
f.comfort_title,
mf.map_item,
mf.isFoundation,
f.materials_title
FROM mattresses AS f
JOIN knorrweb_NEWcatalog.mattresses AS mf ON ((f.u_id = mf.u_id AND f.on_display='0' AND mf.active='1' AND mf.expired='0') OR (f.u_id = mf.u_id AND f.on_display='1'))
JOIN mattress_brands AS fb ON f.brand_u_id=fb.u_id
WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND (f.comfort_id='3')
ORDER BY f.on_display DESC, f.display_order = 0, f.display_order ASC, available DESC, b_title ASC, title ASC
LIMIT 0, 16
Aireloom » Karpen Natural Latex
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Mattress 1st » Mattress 1st
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Mattress 1st » Mattress 1st
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Mattress 1st » Mattress 1st
Sizes Available
Twin, TwinXL, Full, Queen
Serta » iComfort by Serta
Sizes Available
TwinXL, Full, Queen, King, California King
Serta » iComfort by Serta
Sizes Available
TwinXL, Queen, King, California King
Simmons » Beautyrest Harmony Lux Carbon Series
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Tempur-Pedic » Tempur-Adapt
Sizes Available
Twin, TwinXL, Full, Queen, King, California King
Showing All Items For This Category