Save $100 when you sign up for emails

Enter your email below and receive a coupon for $100 off your next purchase of $1299 or more! Plus, you will receive email exclusive coupons, special offers and more from Critelli's Furniture!

Sign Up »
No Thanks

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

Critelli's Furniture & Mattress in St. Catharines, Ontario, Canada
|
|
|
(877) 322-1172 • (905) 684-8108
Unlimited Possibilities, Unbeatable Values
Living Room
Bedroom
Dining Room
Entertainment
Home Office
Accessories
Rugs
Mattresses
»
Selva

Selva

 

Narrow By

Category

Features

191 Items
(SELECT f.u_id, 
									f.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,						
									f.page,
									f.display_price AS price,
									f.sale_price AS sale_price,
									f.sale_price_start AS sale_price_start,
									f.sale_price_end AS sale_price_end,
									f.msrp_price AS msrpPrice,
									f.ecommerce_enabled_item AS ecommerce_enabled,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title,
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order
								FROM furniture AS f USE INDEX(u_id)
								JOIN knorrweb_NEWcatalog.furniture 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 furniture_brands AS fb ON f.brand_u_id = fb.u_id
								JOIN furniture_categories AS fc ON f.category_u_id = fc.u_id
								JOIN furniture_categories AS fsc ON f.sub_category_u_id = fsc.u_id
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fb.u_id='D7DU4LBMT6GNXM0G9Y4IU' AND fc.active='1' AND fsc.active='1'
								        
								GROUP BY u_id)
								UNION
								(SELECT f.u_id, 
									f.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,						
									f.page,
									f.display_price AS price,
									f.sale_price AS sale_price,
									f.sale_price_start AS sale_price_start,
									f.sale_price_end AS sale_price_end,
									f.msrp_price AS msrpPrice,
									f.ecommerce_enabled_item AS ecommerce_enabled,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title, 
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture_ashley' AS rtable,
									f.display_order
								FROM furniture_ashley AS f USE INDEX(u_id)
								JOIN furniture_brands AS fb ON f.brand_u_id = fb.u_id
								JOIN furniture_categories AS fc ON f.category_u_id = fc.u_id
								JOIN furniture_categories AS fsc ON f.sub_category_u_id = fsc.u_id
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.images > 0 AND f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fb.u_id='D7DU4LBMT6GNXM0G9Y4IU' AND fc.active='1' AND fsc.active='1'
								       
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, display_order = 0, display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button
Powered By KnorrWeb
Back To Top Button