취업준비강좌
-
aaaSELECT a.lid, a.lecName, a.lecName2, a.image, a.costs, a.lectureMent, b1.courseName as course1Name, b2.courseName as course2Name, c.codeName as themeName FROM ssVOD_lecture a INNER JOIN ssVOD_course b ON b.cid = a.cid INNER JOIN ssVOD_course b1 ON b1.cid = b.c1id LEFT OUTER JOIN ssVOD_course b2 ON b2.cid = b.c2id LEFT OUTER JOIN ssCodes c ON c.category = 'theme' AND c.code = a.theme WHERE a.onPublic = 'Y' AND a.lid IN (SELECT lid FROM ssVOD_lecture_shop WHERE shopId = 'cku') AND b.c1id = 1 AND a.isRecomm = 'Y' ORDER BY b1.serial ASC, b2.serial ASC, a.serial ASC, a.lid DESC