SELECT * FROM `wp_postmeta` AS `pm1` LEFT JOIN `wp_posts` ON `ID` = `pm1`.`post_id` LEFT JOIN `wp_term_relationships` ON `ID` = `object_id` LEFT JOIN `wp_postmeta` AS `pm2` ON `ID` = `pm2`.`post_id` WHERE `pm1`.`meta_key` LIKE 'ep_season' AND `pm1`.`meta_value` = '1' AND `post_type` = 'episodes' AND `term_taxonomy_id` = '6947' AND `pm2`.`meta_key` LIKE 'ep_number' ORDER BY CAST(`pm2`.`meta_value` AS UNSIGNED) ASC, `post_title` ASC