Denis Holub

select t1.*, t2.*
from table t1 join table t2 on (((t1.d_beg >= t2.d_beg and t1.d_beg <= t2.d_end) or (t1.d_end >= t2.d_beg and t1.d_end <= t2.d_end)) and t1.id_sotr <> t2.id_sotr)

select a.* 
from `article` as a 
         join `articleTag` AS aT ON(aT.articleID = a.id) 
         join `Tags` as t ON (aT.tagID = t.id) 
where t.alias = <условие>

Есть ли способ, чтобы не меняя связи сделать поиск не по tagID(в промежуточной таблице) а по alias? Или как-то конвертировать запросом выше из alias в id тега?

"SELECT * FROM `articleTag` AS aT LEFT JOIN `article` AS a ON(aT.articleID = a.id)
                                WHERE aT.tagID in (select aa.id from `Tags` as aa where aa.alias = <условие>)"