SELECT
a.`title`
FROM `article` AS a
INNER JOIN `article_category` AS ac
ON a.`id_article_category` = ac.`id`
WHERE
a.`deleted` IS NULL
AND
ac.`deleted` IS NULL
AND
a.`id` = 257801

SELECT
ac.`id` AS id_category,
ac.`name` AS category_title,
a.`title`,
a.`perex`,
a.`body`,
DATE_FORMAT(`show_from`, '%d.%m.%Y') AS show_from,
a.`author`
FROM `article` AS a
INNER JOIN `article_category` AS ac
ON a.`id_article_category` = ac.`id`
WHERE
a.`deleted` IS NULL
AND
ac.`deleted` IS NULL
AND
a.`id` = 257801

SELECT
`name`
FROM `article_category`
WHERE
`id` = 140

        SELECT
          `id`,
          `displayed`
        FROM `book`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
        ORDER BY `show_from` DESC
        LIMIT 9
      

        UPDATE `book` SET
          `displayed`  =  NOW()
        WHERE
          `id` = 0
      

        SELECT
          `id`,
          `id_article`,
          `url`,
          `title`,
          `perex`,
          `publisher`
        FROM `book`
        WHERE
          `id` = 0
       ORDER BY `displayed` DESC LIMIT 0, 1

        SELECT
          `id`,
          `name`,
          `url`,
          `location`,
          `publisher`,
          `highlighted`,
          DATE_FORMAT(`date`, '%d.%m.') AS date
        FROM `seminar`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          TO_DAYS(`date`) > TO_DAYS(NOW())
          AND
          `active` = 'Y'
          AND
          `highlighted` = 'Y'
        ORDER BY `seminar`.`date` ASC
        LIMIT 10
      

        SELECT
          `id`,
          `title`,
          `url`,
          `publisher`,
          `location`,
          `highlighted`,
          DATE_FORMAT(`show_from`, '%d.%m.') AS show_from
        FROM `job`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `show_till` >= NOW()
          AND
          `active` = 'Y'
          AND
          `highlighted` = 'Y'
        ORDER BY `job`.`show_from` DESC
        LIMIT 10