(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.u_id brand_u_id,
IF(sb.display_title='', sb.title, sb.display_title) AS sbtitle,
fb.title AS origTitle,
fb.hide_brand_name AS hideAbrand,
fc.folder AS c_f,
fsc.folder AS sc_f,
'furniture/' AS catalog_folder,
'furniture' AS rtable,
f.display_order,
f.brand_display_priority
FROM furniture AS f
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
LEFT JOIN furniture_brands sb ON f.sub_brand_u_id=sb.u_id
JOIN furniture_categories AS fc ON (f.category_u_id = fc.u_id AND fc.active='1')
JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
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 fsc.u_id LIKE '6PXW4S1VUVZ158K4BL1DS'
AND ((f.u_id NOT IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages)) OR (f.u_id IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages WHERE hide='0')))
AND (f.u_id NOT IN (SELECT u_id FROM furniture WHERE brand_u_id='R2OLCACI3S4M1KR2C9S6X' AND on_display=0 AND category_u_id='8Y3R93HZZNKLIRKLXRM37'))
GROUP BY u_id)
ORDER BY available DESC, available DESC, f.brand_display_priority = 0, f.brand_display_priority ASC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
LIMIT 0, 15
Millenium
$1,489.99
53% OFF $699.99
TEST
See it at: Topeka Mall, Olathe Mall
Millenium
$1,589.99
53% OFF $749.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$809.99
53% OFF $379.99
TEST
Ashley Furniture
$689.99
52% OFF $329.99
TEST
Ashley Furniture
$1,489.99
53% OFF $699.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$1,489.99
53% OFF $699.99
TEST
A. America
$1,909.99
53% OFF $899.99
TEST
A. America
$2,119.99
53% OFF $999.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$1,489.99
53% OFF $699.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$1,489.99
53% OFF $699.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$1,329.99
47% OFF $699.99
TEST
See it at: Topeka Mall, Olathe Mall
A. America
$1,379.99
53% OFF $649.99
TEST
Signature Design by Ashley
$919.99
53% OFF $429.99
TEST
See it at: Topeka Mall, Olathe Mall
Ashley Furniture
$1,169.99
53% OFF $549.99
TEST
See it at: Topeka Mall, Olathe Mall
A. America
$1,699.99
53% OFF $799.99
TEST
See it at: Topeka Mall, Olathe Mall
