SELECT * FROM `blogs` LEFT JOIN `authors` ON `blogs`.`authorID` = `authors`.`authorID` WHERE `authors`.`authorURL` LIKE '%dev.immodiagnostic.fr' AND `url` = 'je-suis-en-train-de-vendre-mes-diagnostics-immobiliers-sont-ils-encore-valables-'