SELECT DISTINCT ID,(SELECT (meta_value * 1) FROM wp_postmeta WHERE meta_key = 'case_ordem' AND wp_postmeta.post_id = ID) AS case_ordem FROM wp_posts INNER JOIN wp_postmeta ON ID = post_id INNER JOIN wp_term_relationships ON post_id=object_id WHERE post_type = 'post' AND term_taxonomy_id = 5 AND post_status = 'publish' AND (meta_key = 'case_categoria' AND wp_postmeta.post_id = ID AND meta_value LIKE '%ENDOMARKETING%') ORDER BY case_ordem ASC LIMIT 0,20