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` ='house-hold-services'
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