Changeset 21390 for branches/version-2_12-dev/data/class/SC_Product.php
- Timestamp:
- 2012/01/06 19:54:03 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_Product.php
r21352 r21390 74 74 function findProductIdsOrder(&$objQuery, $arrVal = array()) { 75 75 $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 83 81 __EOS__; 84 82 $objQuery->setGroupBy('alldtl.product_id'); … … 119 117 function findProductCount(&$objQuery, $arrVal = array()) { 120 118 $table = <<< __EOS__ 121 122 JOIN dtb_product_categories AS T2123 ON alldtl.product_id = T2.product_id124 JOIN dtb_category125 ON T2.category_id = dtb_category.category_id119 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 126 124 __EOS__; 127 125 $objQuery->setGroupBy('alldtl.product_id');
Note: See TracChangeset
for help on using the changeset viewer.