Help with RIGHT JOIN conversion?

@nfoboy,

For future reference.

Query binding allows you to write a full sql statement with or without any variables that are needed to complete the query.

$sql = "SELECT p.id, p.lat, l.FK_Property FROM property as p LEFT JOIN liked_property as l ON l.FK_Property = p.id and l.FK_Renter = 2";
$this->db->query($sql);