SELECT
      DISTINCT `tours_periods_pools_prices`.*, `tours_periods_pools`.`id`
    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)
    AND
        (tours_periods_transfer_tariffs.tt_stop_from = transfer_tariffs_dates_stops.tt_stop_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` = '10'
    AND
       (
        (`tours_periods`.`date_start` = '2019-04-16' and `tours_periods`.`full_set` = 0)
            or
        (
                `tours_periods`.`full_set` = 1
            and
                `tours_periods`.`date_start` <= '2019-04-16'
            and
                `tours_periods`.`date_to` >= '2019-04-16'
            and
                `tours_periods`.`week_day` LIKE '%2;%'
        )
       )