Rsa97

SELECT `d`.*, `i`.`file_name` AS `face_foto`, `dif`.`filial_count`,
       IFNULL(`rw`.`reviews_count`, 0), IFNULL(`rw`.`doctor_rating`, 0)
  FROM (
    SELECT `df`.`doctor_id`, COUNT(*) AS `filial_count`
      FROM `clinic_filials` AS `cf`
      JOIN `doctor_in_filials` AS `df` ON `df`.`filial_id` = `cf`.`id`
      WHERE `cf`.`city_id` = 1
      GROUP BY `df`.`doctor_id`
  ) AS `dif`
  JOIN `doctors` AS `d` ON `d`.`id` = `dif`.`doctor_id`
  LEFT JOIN `images` AS `i` ON `i`.`doctor_id` = `d`.`id`
    AND `i`.`type` = "doctor_face"
  LEFT JOIN (
    SELECT `doctor_id`, COUNT(*) AS `reviews_count`, 
           AVG(`rating_doctor`) AS `doctor_rating`
      FROM `reviews`
      GROUP BY `doctor_id`
  ) AS `rw` ON `rw`.`doctor_id` = `d`.`id`

SELECT *
  FROM `cars` AS `c`
  JOIN `cars_attr` AS `ca1` ON `ca1`.`id_car` = `c`.`id` 
    AND `ca1`.`id_attr` = 4 AND `ca1`.`val` >= 2004 AND `ca1`.`val` <= 2008
  JOIN `cars_attr` AS `ca2` ON `ca2`.`id_car` = `c`.`id` 
    AND `ca1`.`id_attr` = 3 AND `ca1`.`val` >= 10000 AND `ca1`.`val` <= 90000
  JOIN `cars_attr` AS `ca` ON `ca`.`id_car` = `c`.`id` 
  JOIN `attr` AS `a` ON `a`.`id` = `ca`.`id_attr`
  WHERE `c`.`category` = 1

SELECT *
  FROM `cars` AS `c`
  JOIN `cars_attr` AS `ca` ON `ca`.`id_car` = `c`.`id` 
  JOIN `attr` AS `a` ON `a`.`id` = `ca`.`id_attr`
  WHERE `c`.`category` = 1
    AND `c`.`id` IN (
      SELECT `id_car` FROM `cars_attr` 
        WHERE `ca1`.`id_attr` = 4 AND `ca1`.`val` >= 2004 AND `ca1`.`val` <= 2008
    ) AND `c`.`id` IN (
      SELECT `id_car` FROM `cars_attr` 
        WHERE `ca1`.`id_attr` = 3 AND `ca1`.`val` >= 10000 AND `ca1`.`val` <= 90000
    )

$result = ($projectPriorityArray[0]['complete'] < $projectPriorityArray[1]['complete'] ? 
          $projectPriorityArray[0] : $projectPriorityArray[1])

SELECT `t`.`hour`, IFNULL(`t`.`site`, ''), IFNULL(`t`.`count`, 0), 
       IFNULL(`t`.`sum`, 0)
  FROM (
    SELECT 0 AS `hour`
    UNION SELECT 1
    UNION SELECT 2
    UNION SELECT 3
    UNION SELECT 4
    UNION SELECT 5
    UNION SELECT 6
  ) AS `h`
  LEFT JOIN (
    SELECT HOUR(`time_hour`) as `hour`, `site`, COUNT(`id`) as `count`, 
           SUM(`price_1`) as `sum`
      FROM `project` 
      WHERE `site`= 'weblancer' AND `date` = '2017-02-26' 
      GROUP BY HOUR(`time_hour`)
  ) AS `t` ON `t`.`hour` = `h`.`hour`

SELECT * 
  FROM `table`
  ORDER BY (MATCH `column1` AGAINST ('обучаемость, пунктуальность')) +
           (MATCH `column2` AGAINST ('курение, болтливость')) +
           (MATCH `column3` AGAINST ('Курск'))

3. Переводчик, составитель либо иной автор производного или составного произведения осуществляет свои авторские права при условии соблюдения прав авторов произведений, использованных для создания производного или составного произведения.
4. Авторские права переводчика, составителя и иного автора производного или составного произведения охраняются как права на самостоятельные объекты авторских прав независимо от охраны прав авторов произведений, на которых основано производное или составное произведение.