[Done 1.3.9] function zen_categories_lookup SQL Error

[hardboiled]

In file: functions_lookups.php
ZC 1.3.8a

Doesn't return an error, but the SQL statement for function zen_categories_lookup() needs an extra line.

Currently:

  $category_lookup = $db->Execute("select " . $what_field . " as lookup_field
 from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
where c.categories_id ='" . (int)$categories_id . "'
and cd.language_id = '" . (int)$language . "'");

Needs to be:

  $category_lookup = $db->Execute("select " . $what_field . " as lookup_field
 from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
where c.categories_id ='" . (int)$categories_id . "'
and c.categories_id = cd.categories_id 
and cd.language_id = '" . (int)$language . "'");

Anyone with SQL experience will know what happens when you don't have the line 'and c.categories_id = cd.categories_id'!