Haikyuu 2×13 Reaction

SELECT SQL_CALC_FOUND_ROWS  wp1o_posts.*
					 FROM wp1o_posts  LEFT JOIN wp1o_term_relationships ON (wp1o_posts.ID = wp1o_term_relationships.object_id)  LEFT JOIN wp1o_term_relationships AS tt1 ON (wp1o_posts.ID = tt1.object_id)  LEFT JOIN wp1o_term_relationships AS tt2 ON (wp1o_posts.ID = tt2.object_id)
					 WHERE 1=1  AND ( 
  wp1o_term_relationships.term_taxonomy_id IN (4404,4405,4484,4578,5414,5415) 
  AND 
  tt1.term_taxonomy_id IN (1030) 
  AND 
  tt2.term_taxonomy_id IN (4484)
) AND wp1o_posts.post_type = 'video' AND ((wp1o_posts.post_status = 'publish'))
					 GROUP BY wp1o_posts.ID
					 ORDER BY CONVERT(REGEXP_REPLACE(wp1o_posts.post_title,'[^0-9]', ''), INT) ASC
					 LIMIT 0, 1000