SELECT * FROM `match` WHERE `published` = '1' AND `m_id` IN #вывести сюда
(SELECT `id` FROM `matchday` WHERE `s_id` IN
(SELECT `s_id` FROM `seasons` WHERE `s_name` LIKE '%2015%' AND `t_id` IN
(SELECT `id` FROM `tournament` WHERE `published` = 1))) #Значение id отсюда
ORDER BY `match`.`date` DESC