SELECT distinct wposts.* FROM wp_posts wposts, wp_postmeta wpostmeta, wp_postmeta wpostmeta2 WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key='closed' AND wpostmeta.meta_value='0' AND wposts.ID = wpostmeta2.post_id AND wpostmeta2.meta_key='featured' AND wpostmeta2.meta_value='1' AND wposts.post_status = 'publish' AND wposts.post_type = 'auction' ORDER BY wposts.post_date DESC LIMIT 28