Changeset 23566
- Timestamp:
- 2014/07/08 23:29:37 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/pages/products/LC_Page_Products_List.php
r23546 r23566 231 231 $from = "$dtb_product_categories T2 JOIN dtb_category T3 ON T2.category_id = T3.category_id"; 232 232 $where = 'T2.product_id = alldtl.product_id'; 233 $objQuery->setOrder('T3.rank DESC, T2.rank DESC');234 233 $sub_sql = $objQuery->getSql($col, $from, $where); 235 $sub_sql = $objQuery->dbFactory->addLimitOffset($sub_sql, 1);236 234 237 235 $objQuery->setOrder("($sub_sql) DESC ,product_id DESC");
Note: See TracChangeset
for help on using the changeset viewer.