Ignore:
Timestamp:
2012/01/17 16:03:47 (11 years ago)
Author:
Seasoft
Message:

2.12系へマイルストーン変更となったチケット分を差し戻し
r21388 #1593
r21387 #1592
r21386 #1591
r21384 #1589,#1588
r21383 #1580

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_11-dev/data/class/SC_Product.php

    r21386 r21400  
    7474    function findProductIdsOrder(&$objQuery, $arrVal = array()) { 
    7575        $table = <<< __EOS__ 
    76             dtb_products AS alldtl 
    77             LEFT JOIN dtb_products_class 
    78                 ON alldtl.product_id = dtb_products_class.product_id 
    79             LEFT JOIN dtb_product_categories 
    80                 ON alldtl.product_id = dtb_product_categories.product_id 
     76                 dtb_products AS alldtl 
     77            JOIN dtb_products_class AS T1 
     78              ON alldtl.product_id = T1.product_id 
     79            JOIN dtb_product_categories AS T2 
     80              ON alldtl.product_id = T2.product_id 
     81            JOIN dtb_category 
     82              ON T2.category_id = dtb_category.category_id 
    8183__EOS__; 
    8284        $objQuery->setGroupBy('alldtl.product_id'); 
     
    117119    function findProductCount(&$objQuery, $arrVal = array()) { 
    118120        $table = <<< __EOS__ 
    119             dtb_products AS alldtl 
    120             LEFT JOIN dtb_products_class 
    121                 ON alldtl.product_id = dtb_products_class.product_id 
    122             LEFT JOIN dtb_product_categories 
    123                 ON alldtl.product_id = dtb_product_categories.product_id 
     121                 dtb_products AS alldtl 
     122            JOIN dtb_product_categories AS T2 
     123              ON alldtl.product_id = T2.product_id 
     124            JOIN dtb_category 
     125              ON T2.category_id = dtb_category.category_id 
    124126__EOS__; 
    125127        $objQuery->setGroupBy('alldtl.product_id'); 
Note: See TracChangeset for help on using the changeset viewer.