Thread: Change the Query for Featured Listing

Change the Query for Featured Listing

Hi,

I want to change the "Feature Query SQL" to list "5 Newly added ads"

In featured.php
query_posts( array('post__in' => get_option('sticky_posts'), 'post_type' => APP_POST_TYPE, 'post_status' => 'publish', 'orderby' => 'rand') );

How to change this to something like this
select * from wp_posts where post_type = 'ad_listing' and post_status = 'publish' order by date desc limit 5


Thanks for the help