-
42
-
-
-
-
-
-
-
-
-
-
-
-
------------SELECT * FROM rwd1297_product p (NOLOCK) LEFT JOIN rwd1297_product_category c (NOLOCK) ON p.prod_id=c.prod_id WHERE isOnline=1 AND (category_id=140 or category_id in ('140','141','142','143','144','145','146','147')) ORDER BY c.category_orderby,p.modifyDate DESC
