mysql - LEFT JOIN 3 tables sql OpenCart -

i need join table in function name vendors, possible

public function getproducts($data = array()) {       $sql = "select * " . db_prefix . "product p left join " . db_prefix . "product_description pd on (p.product_id = pd.product_id) pd.language_id = '" . (int)$this->config->get('config_language_id') . "'"; 

  $sql = "   select c.olumns, y.ou, a.ctually, w.ant      product p      join product_description pd        on pd.product_id = p.product_id     join vendors v       on v.product_id = p.product_id    pd.language_id = ?    order        p.product_id;    "; 

now see prepared statements