-
365
-
-
-
-
-
-
-
-
-
-
-
-
------------SELECT * FROM rwd1296_product p (NOLOCK) LEFT JOIN rwd1296_product_category c (NOLOCK) ON p.prod_id=c.prod_id WHERE isOnline=1 AND (category_id=118 or category_id in ('118','241','242','120','121','122','123','124','125','126','127','128','244','240','129','130','131','133','135','136','134','137')) ORDER BY c.category_orderby,p.modifyDate DESC
