Get updates on our latest styles & savings!
We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.
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.california-king='1') ORDER BY f.on_display DESC, f.display_order = 0, f.display_order ASC, available DESC, b_title ASC, title ASC LIMIT 0, 16