SELECT
          DISTINCT cq.id
        FROM `consulting_question` AS cq
        INNER JOIN `consulting_answer` AS ca
          ON ca.id_consulting_question = cq.id
        WHERE
          ca.`active` = 'Y'
          AND
          cq.`active` = 'Y'
          AND
          ca.`deleted` IS NULL
          AND
          cq.`deleted` IS NULL
        ORDER BY cq.`inserted` DESC
        LIMIT 7
      

        SELECT
          `description`
        FROM `article_category`
        WHERE
          `id` = 10
      

        SELECT
          `article`.`id`,
          `title`,
          `perex`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 10
        ORDER BY `show_from` DESC
        LIMIT 1
      

        SELECT
          `article`.`id`,
          `title`,
          DATE_FORMAT(article.`show_from`, '%d.%m.') AS `date`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 10
          AND
          `article`.`id` != 0
       ORDER BY `show_from` DESC LIMIT 0, 3

        SELECT
          `article`.`id` AS id,
          `title`,
          `perex`,
          `author`,
          DATE_FORMAT(`show_from`, '%d.%m.') AS show_from
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 14
       ORDER BY `article`.`show_from` DESC LIMIT 0, 6

        SELECT
          a.`id`,
          a.`name`
        FROM `article_category` AS a
        WHERE
          a.`deleted` IS NULL
          AND
          a.`active` = 'Y'
          AND
          a.`id_parent` = 15
       ORDER BY `a`.`shift` DESC LIMIT 0, 2

        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`,
          `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` = 'N'
        ORDER BY `seminar`.`date` ASC
        LIMIT 10
      

        SELECT
          `id`,
          `header`,
          `body`,
          `url`
        FROM `advertising`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
       ORDER BY `show_from` DESC LIMIT 0, 2

        SELECT
          `description`
        FROM `article_category`
        WHERE
          `id` = 11
      

        SELECT
          `article`.`id`,
          `title`,
          `perex`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 11
        ORDER BY `show_from` DESC
        LIMIT 1
      

        SELECT
          `article`.`id`,
          `title`,
          DATE_FORMAT(article.`show_from`, '%d.%m.') AS `date`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 11
          AND
          `article`.`id` != 0
       ORDER BY `show_from` DESC LIMIT 0, 3

        SELECT
          `article`.`id` AS id,
          `title`,
          `perex`,
          `author`,
          DATE_FORMAT(`show_from`, '%d.%m.') AS show_from
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 13
       ORDER BY `article`.`show_from` DESC LIMIT 0, 10

        SELECT
          a.`id`,
          a.`title`,
          a.`url`,
          a.`inserted`,
          DATE_FORMAT(a.`show_from`, '%d.%m.%Y %H:%i') AS show_from
        FROM `law_collection` AS a
        WHERE
          a.`deleted` IS NULL
       ORDER BY `a`.`show_from` DESC LIMIT 0, 5

          SELECT
            cq.`id`,
            cq.`title` AS question
          FROM `consulting_question` AS cq
          WHERE
            `id` IN(0)
       ORDER BY `cq`.`inserted` DESC LIMIT 0, 7

        SELECT
          `description`
        FROM `article_category`
        WHERE
          `id` = 12
      

        SELECT
          `article`.`id`,
          `title`,
          `perex`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 12
        ORDER BY `show_from` DESC
        LIMIT 1
      

        SELECT
          `article`.`id`,
          `title`,
          DATE_FORMAT(article.`show_from`, '%d.%m.') AS `date`
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 12
          AND
          `article`.`id` != 0
       ORDER BY `show_from` DESC LIMIT 0, 3

        SELECT
          `article`.`id` AS id,
          `title`,
          `perex`,
          `author`,
          DATE_FORMAT(`show_from`, '%d.%m.') AS show_from
        FROM `article`
        INNER JOIN `article_category_cross`
          ON `article_category_cross`.`id_article` = `article`.`id`
        WHERE
          `deleted` IS NULL
          AND
          `show_from` <= NOW()
          AND
          `article_category_cross`.`id_article_category` = 16
       ORDER BY `article`.`show_from` DESC LIMIT 0, 6

        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
      

        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` = 'N'
        ORDER BY `job`.`show_from` DESC
        LIMIT 10