SELECT * 
FROM ( SELECT * 
       FROM `tours`.`destination` AS d 
         LEFT JOIN `tours`.`lodge` AS ldg ON ldg.`ldg_destID` = d.`destID` 
WHERE ( `d`.`destID` = 818  ) 
     ) AS ldg 
  LEFT JOIN `tours`.`lodge_sub` lc ON lc.`ldgSubID` = ldg.`ldgID`