title: How to build join with condition in Phalcon
body: <p>I have the following SQL:</p>
  
  <pre><code>SELECT  `settings`.*, `character_settings`.`value`
  FROM    `settings`
  LEFT JOIN 
         `character_settings` 
  ON     `character_settings`.`setting_id` = `settings`.`id`
          AND `character_settings`.`character_id` = '1'  
  </code></pre>
  
  <p>How the same query can be rewritten using Phalcon  CreateBuilder() ? </p>