[SOLVED] Manufacturer name in meta_title - Help!

[Rabatkoder]

/* Manufacturers specifics meta tags */
elseif ($id_manufacturer = self::getValue('id_manufacturer'))
{
$row = Db::getInstance()->getRow('
SELECT `meta_title`, `meta_description`, `meta_keywords`, hl.`name` `manufacturer_name`
FROM `'._DB_PREFIX_.'manufacturer_lang` h
LEFT JOIN `'._DB_PREFIX_.'manufacturer` hl ON (hl.`id_manufacturer` = h.l`id_manufacturer`) 
WHERE hl.id_manufacturer = '.intval($id_manufacturer));
if ($row)
{
   if (empty($row['meta_description']))
   $row['meta_description'] = strip_tags($row['meta_description']);
   $row['meta_title'] = $row['meta_title'];
   return self::completeMetaTags($row, $row['meta_title'].' - '.$row['manufacturer_name']);
}
}

What is wrong with this code?
i'm trying to join ps_manufacturer to display the ps_manufacturer row called "name"

[rocky]

I can see one error. You are missing the AS keyword.

SELECT `meta_title`, `meta_description`, `meta_keywords`, hl.`name` `manufacturer_name`

should be:

SELECT `meta_title`, `meta_description`, `meta_keywords`, hl.`name` AS `manufacturer_name`

[Rabatkoder]

Yes. Thanks

But it still not works

[rocky]

Another error I noticed:

LEFT JOIN `'._DB_PREFIX_.'manufacturer` hl ON (hl.`id_manufacturer` = h.l`id_manufacturer`)

should be:

LEFT JOIN `'._DB_PREFIX_.'manufacturer` hl ON (hl.`id_manufacturer` = h.`id_manufacturer`)

[Rabatkoder]

thank you, thank you, thank you... THANK Y O U ! ! !

It finally works

Now i can call the manufacturer name as the $defaultValue

This should be std. in Prestashop ;-)