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,
f.msrp_price,
f.sale_price,
f.sale_price_start,
f.sale_price_end,
IF(ab.display_title = '', ab.title, ab.display_title) AS b_title,
ac.folder AS c_f,
a_sc.folder AS sc_f,
'appliances/' AS catalog_folder,
'appliance' AS rtable
FROM appliance AS f
JOIN knorrweb_NEWcatalog.appliance AS ma ON f.u_id = ma.u_id AND ma.active='1' AND ma.expired='0'
JOIN appliance_brands AS ab ON f.brand_u_id = ab.u_id
JOIN appliance_categories AS ac ON f.category_u_id = ac.u_id AND ac.active = 1
JOIN appliance_categories AS a_sc ON f.sub_category_u_id = a_sc.u_id AND a_sc.active = 1 AND a_sc.u_id LIKE 'WLYEN8A39IF2ZLG63OMBX'
WHERE f.active='1' AND f.expired='0'
ORDER BY f.display_price = 0.00, display_price ASC, b_title ASC, title ASC
LIMIT 0, 48
Showing All Items For This Category
