Index: branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php
===================================================================
--- branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php	(revision 22206)
+++ branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php	(revision 22232)
@@ -125,10 +125,10 @@
         $objProduct     = new SC_Product_Ex();
 
-        $objQuery->setOrder('create_date DESC');
-        $where = 'customer_id = ?';
+        $objQuery->setOrder('f.create_date DESC');
+        $where = 'f.customer_id = ? and p.status = 1';
         if (NOSTOCK_HIDDEN) {
             $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = dtb_customer_favorite_products.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
         }
-        $arrProductId  = $objQuery->getCol('product_id', 'dtb_customer_favorite_products', $where, array($customer_id));
+        $arrProductId  = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id));
 
         $objQuery       =& SC_Query_Ex::getSingletonInstance();