SELECT
`name` AS title
FROM `article_category`
WHERE
`id` = 168
AND
`deleted` IS NULL

          SELECT
            tbl.`id`,
            tbl.`title`,
            tbl.`perex`,
            DATE_FORMAT(tbl.`show_from`, '%d.%m.%Y %H:%i') AS show_from
          FROM `article` AS tbl
          INNER JOIN `article_category_cross` AS `cross`
            ON `cross`.`id_article` = tbl.`id`
          WHERE
            tbl.`deleted` IS NULL
            AND
            tbl.`show_from` <= NOW()
            AND
            `cross`.`id_article_category` = 168
        

          SELECT
            `name` AS main_title
          FROM `article_category`
          WHERE
            `id` = 168
            AND
            `deleted` IS NULL
        

          SELECT
            tbl.`id`,
            tbl.`title`,
            tbl.`perex`,
            DATE_FORMAT(tbl.`show_from`, '%d.%m.%Y %H:%i') AS show_from
          FROM `article` AS tbl
          INNER JOIN `article_category_cross` AS `cross`
            ON `cross`.`id_article` = tbl.`id`
          WHERE
            tbl.`deleted` IS NULL
            AND
            tbl.`show_from` <= NOW()
            AND
            `cross`.`id_article_category` = 168
         ORDER BY `tbl`.`show_from` DESC LIMIT 0, 20

        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