SELECT * FROM `blogs` LEFT JOIN `authors` ON `blogs`.`authorID` = `authors`.`authorID` WHERE `authors`.`authorURL` LIKE '%dev.immodiagnostic.fr' AND `url` = 'lorsque-lon-evoque-les-differents-diagnostics-immobiliers-a-effectuer-lors-dune-acquisition-ou-location-des-professionnels-competents-mentionneront-au'