FSE Academy

SELECT DISTINCT CAT.ID, CAT.fldNAME, CAT.fldNAMEALT, CAT.fldPAGEH2, Cast(CAT.fldPAGECONTENT1 AS nvarchar(4000)) AS fldSUMMARY, CAT.fldHEX1, CAT.fldHEX2, CAT.fldSEOURL, CAT.fldURL FROM nm_tbl_cate AS CAT INNER JOIN nm_tbl_cate_cate AS CCAT ON CAT.ID = CCAT.fldCID WHERE CAT.ID IN (SELECT fldCID FROM nm_tbl_cate_user_group WHERE fldUGID = 4 ) AND CCAT.fldCPID = 4676 AND (CAT.fldCTID = 1053 ) AND CAT.fldDELETE = 'n' ORDER BY CAT.fldNAME

Sponsored by

FSE Academy

Seminar Programme Coming Soon