SELECT * FROM `blogs` LEFT JOIN `authors` ON `blogs`.`authorID` = `authors`.`authorID` WHERE `authors`.`authorURL` LIKE '%dev.immodiagnostic.fr' AND `url` = 'il-existe-depuis-le-18-decembre-1996-depuis-la-loi-dite-quotcarrezquot-relative-a-la-superficie-dun-bien-immobilier-'