SELECT cateid,htmlpath FROM xwm_info_cate order by dateline,sequence descSELECT cateid,htmlpath FROM xwm_product_cate order by dateline,sequence descSELECT cateid,htmlpath FROM xwm_static_cate order by dateline,sequence descSELECT cateid,htmlpath FROM xwm_info_cate order by dateline,sequence descSELECT cateid,htmlpath FROM xwm_product_cate order by dateline,sequence descSELECT cateid,htmlpath FROM xwm_static_cate order by dateline,sequence descSELECT TITLE,HTMLPATH FROM xwm_PRODUCT_CATE WHERE PARENTID <>0 AND PARENTID=20 ORDER BY SEQUENCE,CATEID LIMIT 10SELECT TITLE,HTMLPATH,PARENTID FROM xwm_PRODUCT_CATE WHERE PARENTID <>20 AND PARENTID != 0 ORDER BY SEQUENCE,CATEID LIMIT 50SELECT TITLE,SPIC,PIC,CONTENT,PARENTID,INFOID FROM xwm_INFO WHERE PARENTID=4 AND RECOMMEND=1 ORDER BY INFOID,SEQUENCE LIMIT 1SELECT TITLE,SPIC,PIC,CONTENT,DATELINE,PARENTID,INFOID FROM xwm_INFO WHERE PARENTID=4 AND RECOMMEND<>1 ORDER BY dateline DESC LIMIT 5SELECT PRODUCTID,TITLE,DESCRIPTION,PARENTID,SPIC,PIC FROM xwm_PRODUCT WHERE ISNEW= 1 ORDER BY SEQUENCE,DATELINE LIMIT 10SELECT PRODUCTID,TITLE,PARENTID,SPIC,PIC FROM xwm_PRODUCT WHERE RECOMMEND=1 ORDER BY SEQUENCE,DATELINE ASC LIMIT 5select * from xwm_product_cate where parentid=20 order by sequence,cateid Kripal Electric -- We are advancing everyday!