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 (1059,1100,1060,1064,1247,404,6406,1163,1175,3794,1037,2,405,457,3612,1142,621,1034,5131,1173,3384,409,419,475,4951,1799,1794,1796,2057,1738,1734,3412,6956,760,761,3723,3721,3722,4906,1373,1631,1468,1308,3402,6957,1087,4808,2054,1999,4941,1628,1573,6941,4847,477,4729,11083,11091,3417,3404,1675,1542,1713,12212,12046,1380,1710,1678,1333,14420,13953,13025,12195,12085,1672,3915,1538,13290,14475,3418,13831,1382,14047,13679,14060,14057,12314,12310,12284,1534,13806,13289,12391,1391,3397,1548,1547,14467,14284,13879,13079,13012,12861,12402,12019,1531,1371,12516,12235,12038,13514,13113,12086,12053,1630,12667,12399,1526,3420,14089,13457,12259,12147,12042,3799,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,14530,14269,14004,13738,12716,12330,5544,3399,1461,13997,12534,1450,3811,14220,13218,13208,12987,3672,12080,14363,14) ORDER BY a.course_name ASC LIMIT 100