SELECT `s`.*, `dp`.`url` AS `url_provider`, `dp`.`image` AS `image_provider`, `r`.`avatar`, `r`.`name` FROM `SkitudeSnowReport` AS `s`
 LEFT JOIN `DataProvider` AS `dp` ON s.dataprovider_id = dp.id
 LEFT JOIN `Resorts_data_t` AS `r` ON s.id = r._id WHERE (s.id = '1683')