-
489
-
-
-
-
-
-
-
-
-
-
-
-
------------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=155 or category_id in ('155','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','174','175','176','177','178','179','180','181','182','183','243')) ORDER BY c.category_orderby,p.modifyDate DESC
