$Breadcrumbs = parent::Breadcrumbs();
   if($Product = $this->getCurrentProduct())
   {
      $Parts = explode(SiteTree::$breadcrumbs_delimiter, $Breadcrumbs);
      $NumOfParts = count($Parts);
      $CategoryTitle = $Parts[$NumOfParts-1];
   }
   
      
   //Current product
   $query = new SQLQuery();
      
   $query->from('`product`');
   $query->select("product.* , sitetree.URLSegment AS SURLSegment");
   $query->innerJoin('categorypage_products', '(product.ID=categorypage_products.ProductID)');
   $query->innerJoin('sitetree', '(sitetree.ID=categorypage_products.CategoryPageID)');
   $query->where("product.Title = '" .$Product->Title ."' AND '". $CategoryTitle. "'= sitetree.Title" );
   //Doesn't work: $query->where = array('product.Title = '.$Product->Title, $CategoryTitle.'= sitetree.Title');

   $result = $query->execute();
   $CurrentProduct = singleton('product')->buildDataObjectSet($result);
      
   //Next product
   $query = new SQLQuery();
      
   $query->from('`product`');
   $query->select("product.* , sitetree.URLSegment AS SURLSegment");
   $query->innerJoin('categorypage_products', '(product.ID=categorypage_products.ProductID)');
   $query->innerJoin('sitetree', '(sitetree.ID=categorypage_products.CategoryPageID)');
      
   //Doesn't work: $query->where("( Title BETWEEN '" . $CurrentProduct->Title ."z' AND 'zzz') AND sitetree.Title = '" . $CurrentProduct->SURLSegment ."'" );

   $query->orderby('product.Title ASC');
   $query->limit(1);

   $result = $query->execute();
   $NextProduct = singleton('product')->buildDataObjectSet($result);