SELECT a.course_name, a.eligibility_cat, a.eligibility, a.duration, a.fees_cat, a.fees, a.course_slug, b.stream_name AS streamName FROM course a LEFT JOIN stream b ON a.stream_id = b.stream_id WHERE a.status = '1' AND a.course_id IN (65,123,5359,126,1531,4594,125,3364,1534,69,5381,1528,4597,8451,1524,77,135,1468,4598,3464,1498,246,1371,3402,1796,3568,1034,891,1243,8289,8278,632,7729,655,1973,1547,297,409,2054,999,1142,3784,3672,1020,1163,1738,3722,921,1064,1794,3721,4739,5096,1989,1563,358,466,2009,1583,370,478,1993,1567,5277,222,1,6571,916,1059,3412,3723,322,292,404,308,420,1009,4166,5227,5228,911,4819,67,79,3417,3404,1675,1542,1713,12212,12046,1380,1710,1678,1333,14420,13953,13025,12195,12085,1672,3915,1538,13290,14475,3418,13831,1382,1373,14047,13679,14060,14057,12314,12310,12284,13806,13289,12391,1391,3397,1548,14467,14284,13879,13079,13012,12861,12402,12019,12516,12235,12038,1631,13514,13113,12086,12053,1630,12667,12399,1526,3420,14089,13457,12259,12147,12042,3799,1628,13602,1358,14242,13174,12834,12205,6006,1345,12518,1352,12602,1348,14569,13718,12699,12063,1621,12060,1337,13567,1619,13900,13139,13029,12629,12591,12144,1615,1342,1674,13438,14405,1453,1448,14059,13309,13099,12440,12071,3381,3931,3933,3415,1600,13561,4906,14530,14269,) ORDER BY a.course_name ASC LIMIT 100