SELECT * FROM `blogs` LEFT JOIN `authors` ON `blogs`.`authorID` = `authors`.`authorID` WHERE `authors`.`authorURL` LIKE '%immodiagnostic.fr' AND `url` = '6-choses-à-faire-avant-de-louer-un-logement-à-un-locataire-'