SELECT * FROM `blogs` LEFT JOIN `authors` ON `blogs`.`authorID` = `authors`.`authorID` WHERE `authors`.`authorURL` LIKE '%dev.immodiagnostic.fr' AND `url` = 'diag-loi-boutin--le-diagnostic-quotloi-boutinquot-est-a-effectuer-obligatoirement-par-un-bailleur-et-ce-avant-signature'