Method getCategoryByProductId

/*
 * Obsolete
 */
public static function getCategoryByProductId($id)
{
    $db = Factory::getDBO();
    $query = 'SELECT a.catid' . ' FROM #__phocacart_products AS a' . ' WHERE a.id = ' . (int) $id . ' ORDER BY a.id' . ' LIMIT 1';
    $db->setQuery($query);
    $category = $db->loadRow();
    if (isset($category[0]) && $category[0] > 0) {
        return $category[0];
    }
    return 0;
}