I need to sort (custom) posts by 2 custom field values...

custom field name 1: `is_sponsored` [ value can either be `1` or `0` ]

custom field name 2: `sfp_date` [ `timestamp` aka current post date in seconds ]

Posts whose "`is_sponsored`" value is 1 need to be on top, sorted by "`sfp_date`" in `DESC`ending order.
All other posts whose "`is_sponsored`" value is 0 should be listed below - in descending order (by "`sfp_date`") as well.

I have something like:

    $sfp_query_args = array(
    	'tax_query'   => array( 
            array( 
                'taxonomy' => 'sfp_posts',
                'terms'    => array( 1, 5, 8 )
            )
        ),
    	'post_type'   => 'sfpposts',
    	'post_status' => 'publish',
    	'showposts'   => 15,
    	'paged'       => $paged,
    	'meta_key'    => 'sfp_date', 
    	'orderby'     => 'meta_value_num', 
    	'order'       => 'DESC', 
        'meta_query'  => array(
            'key'          => 'is_sponsored',
            'value'        => 2,
            'type'         => 'NUMERIC',
            'compare'      => '<='
        )
    );
    $wp_q = new WP_Query( $sfp_query_args );

...but not working. Any ideas?


----------

*Editors Note:* This is a small plugin that should show how the query looks, as we likely don't have any data set available to test this.

    <?php
    /** Plugin Name: (#67600) Dump Query parts */
    function wpse67600_dump_query_parts( $pieces )
    {
        echo '<pre>'.var_export( $pieces, true ).'</pre>';
        return $pieces;
    }
    add_filter( 'posts_clauses', 'wpse67600_dump_query_parts' );

*OP PLEASE ADD OUTPUT OF PLUGIN HERE - use the "edit" link*.