SELECT
      DISTINCT `tours_periods_pools_prices`.*
    FROM
         `tours`
    LEFT JOIN
        `tours_periods`
    ON
        `tours_periods`.`tour_id` = `tours`.`id`
    LEFT JOIN
       `tours_periods_transfer_tariffs`
    ON
       `tours_periods_transfer_tariffs`.`period_id` = `tours_periods`.`id` AND `tours_periods_transfer_tariffs`.`tour_day` = 1
    LEFT JOIN
       transfer_tariffs_dates_stops
    ON
        (tours_periods_transfer_tariffs.transfer_tariffs_dates_id = transfer_tariffs_dates_stops.tt_dates_id)
    LEFT JOIN
      `transfer_tariffs_stops`
    ON
      `transfer_tariffs_stops`.`id` = `transfer_tariffs_dates_stops`.`tt_stop_id`
    LEFT JOIN
      `reference_city`
    ON
      `reference_city`.`id` = `transfer_tariffs_stops`.`reference_city_id`
    LEFT JOIN
      `tours_periods_pools`
    ON
      `tours_periods_pools`.`period_id` = `tours_periods`.`id`
    LEFT JOIN
      `tours_periods_pools_prices`
    ON
      `tours_periods_pools_prices`.`pool_id` = `tours_periods_pools`.`id`
    WHERE
      `tours`.`id` = '25'
    AND
       (
        (`tours_periods`.`date_start` = DATE_ADD(str_to_date("2018-12-28","%Y-%m-%d"), INTERVAL -(`transfer_tariffs_dates_stops`.`departure_day`-1) DAY) and `tours_periods`.`full_set` = 0)
            or
        (
                `tours_periods`.`full_set` = 1
            and
                `tours_periods`.`date_start` <= DATE_ADD(str_to_date("2018-12-28","%Y-%m-%d"), INTERVAL -(`transfer_tariffs_dates_stops`.`departure_day`-1) DAY)
            and
                `tours_periods`.`date_to` >= DATE_ADD(str_to_date("2018-12-28","%Y-%m-%d"), INTERVAL -(`transfer_tariffs_dates_stops`.`departure_day`-1) DAY)
            and
                `tours_periods`.`week_day` LIKE CONCAT ('%', WEEKDAY(DATE_ADD(str_to_date("2018-12-28","%Y-%m-%d"), INTERVAL -(`transfer_tariffs_dates_stops`.`departure_day`-1)+1 DAY)), '%')
        )
       )
     AND `reference_city`.`id` = '465'