CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- (
- SELECT *
- FROM `news` news
- INNER JOIN `category` cat ON cat.`id` = news.`category_id`
- WHERE news.`id` <12
- ORDER BY news.`id` DESC
- LIMIT 1
- )
- UNION (
- SELECT *
- FROM `news` news
- INNER JOIN `category` cat ON cat.`id` = news.`category_id`
- WHERE news.`id` =12
- LIMIT 1
- )
- UNION (
- SELECT *
- FROM `news` news
- INNER JOIN `category` cat ON cat.`id` = news.`category_id`
- WHERE news.`id` >12
- LIMIT 1
- )