SELECT a.lid, a.lecName, a.lecName2, a.image, a.costs, a.lectureMent, c.codeName as themeName FROM ssVOD_lecture a INNER JOIN ssVOD_course b ON b.cid = a.cid 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 = 'hannam') AND b.c1id = 4 AND ( b.c3id = 30 OR b.c3id = 34 OR b.c3id = 38 OR b.c3id = 42) ORDER BY a.serial ASC, a.lid DESC