SELECT  p.ID, p.post_author,
					CONVERT(um.meta_value, UNSIGNED INTEGER) AS package_id
                    
                    FROM
                    wp_posts as p

    

            INNER JOIN wp_postmeta AS pm ON p.ID = pm.post_id
            INNER JOIN wp_usermeta AS um ON p.post_author = um.user_id
            INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id
            INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
            INNER JOIN wp_terms AS t ON tt.term_id = t.term_id
            WHERE p.post_type = 'listing_type' AND `t`.`slug` ='carpet-wash'
            AND p.post_status = 'publish' AND um.meta_key = 'wlt_membership'

    
     GROUP by p.ID 
     ORDER BY `package_id` DESC, `p`.`ID` DESC limit 0,25