Ignore:
Timestamp:
2012/01/06 19:54:03 (12 years ago)
Author:
kotani
Message:

Merge from version-2_11-dev

File:
1 edited

Legend:

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

    r21352 r21390  
    7474    function findProductIdsOrder(&$objQuery, $arrVal = array()) { 
    7575        $table = <<< __EOS__ 
    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 
     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 
    8381__EOS__; 
    8482        $objQuery->setGroupBy('alldtl.product_id'); 
     
    119117    function findProductCount(&$objQuery, $arrVal = array()) { 
    120118        $table = <<< __EOS__ 
    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 
     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 
    126124__EOS__; 
    127125        $objQuery->setGroupBy('alldtl.product_id'); 
Note: See TracChangeset for help on using the changeset viewer.