4.5.1. The a element
...
Content model:
Transparent, but there must be no interactive content or a element descendants.
{
"1 сезон": {
"1 серия": {
"Лостфилм": "cyx793so9kodfhdwiktl0r6b/212164"
},
"2 серия": {
"Kinogo": "cyx793so9kodfhdwiktl0r6b/252865",
"Амедиа": "cyx793so9kodfhdwiktl0r6b/252865"
},
"3 серия": {
"Лостфилм": "cyx793so9kodfhdwiktl0r6b/264972"
}
},
"2 сезон": {
"1 серия": {
"Лостфилм": "cyx793so9kodfhdwiktl0r6b/212164"
},
"2 серия": {
"Kinogo": "cyx793so9kodfhdwiktl0r6b/252865"
}
},
"3 сезон": {
"1 серия": {
"Kinogo": "cyx793so9kodfhdwiktl0r6b/264972"
}
}
}
SELECT `i1`.`i`, `i1`.`o`, `i2`.`i`, `i2`.`o`,
(IF(`i1`.`o` > `i2`.`o`, `i2`.`o`, `i1`.`o`)
- IF(`i1`.`i` > `i2`.`i`, `i1`.`i`, `i2`.`i`)) AS `crosstime`
FROM `table` AS `i1`
JOIN `table` AS `i2` ON `i2`.`id` > `i1`.`id`
AND `i1`.`i` < `i2`.`o` AND `i2`.`i` < `i1`.`o`