(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,
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 'LKHX39K0QUOXNBZN7OBO0'
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')))
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
Nest Home Collections
000000366563
Ashley Furniture
000000357680
Signature Design by Ashley
000000053330
International Furniture Direct
000000180720
Crestview Collection
000000135210
Crestview Collection
000000135160
Crestview Collection
CVFZR1258
Hillsdale Furniture
5845-1064W
International Furniture Direct
IFD864CONS
International Furniture Direct
IFD3031BUFFET
International Furniture Direct
IFD9912CNS
Crestview Collection
CVFNR510
Crestview Collection
CVFNR636