Wenn Sie einen Kurs aus beruflichen Gründen besuchen, können Sie einen Zuschuss,
die so genannte Bildungsprämie erhalten.
Das gilt besonders für Angebote wie:
Xpert-Business-Kurse - Finanzbuchführung
EDV-Kurse
Englisch für den Beruf
Hier erhalten Sie weitere Infos zur Bildungsprämie
SELECT KNr, Gewichtung, Von, Bis FROM web_kurshighlights wk join kurse k on wk.knr = k.nr WHERE (('2017-06-28 00:00' >= wk.Von AND '2017-06-28 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2017-06-28 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2017-06-28 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and (wk.von is null or wk.von = '1899-12-30'))) and ifnull(k.internetaktiv, 'F') ='W' and ifnull(k.ausfall, 'F') <>'J' AND k.internetaktiv = 'W' AND (('2017-06-28' >=k.internetvon AND '2017-06-28' <= k.internetbis) or ('2017-06-28' >= k.internetvon and (k.internetbis is null or k.internetbis = '1899-12-30')) or ((k.internetvon is null or k.internetvon = '1899-12-30') and k.internetbis >= '2017-06-28') or ((k.internetvon is null or k.internetvon = '1899-12-30') and (k.internetbis is null or k.internetbis = '1899-12-30'))) AND k.typ != 'B' AND k.semester in ('1/17') AND k.nr in ('171A2405', '171A2406', '171A2403', '171A2404', '171A2401', '171A2402', '171A2401_O', '171A2406_1', '171A2409', '171A2410', '171A2407_O', '171A2408', '171A2409_O', '171A2408_2', '171A2411_O', '171A2412', '171A2413_O', '171A2414', '171A2415', '171A2416', '171A2417_O', '171A2418', '171A2419_O', '171A2420', '171A2421_O', '171A2422', '171A2423_O', '171A2424', '171A2406', '171A2440', '171A2430', '171A2431', '171A2406_1', '171A1301', '171A1302', '171A1303', '171A1304', '171A1312', '171A2111', '171A2103', '171A2109', '171A2113', '171A2107', '171A2101', '171A2105', '171A2103_1', '171A2105_1', '171A2301', '171A2302', '171A2310', '171A2311', '171A2312', '171A2313', '171A2314', '171A2315', '171A2316', '171A2317', '171A2318', '171A2319', '171A2330', '171A2331', '171A2332', '171A2333', '171A2334', '171A2335', '171A2336', '171A2337', '171A2345', '171A2346', '171A2345_1', '171A2359', '171A2352', '171A2353', '171A2354', '171A2355', '171A2356', '171A2357', '171A2358', '171A2374', '171A2360', '171A2358_1', '171A2374_1', '171A2301', '171A2302', '171A2352', '171A2353', '171A2354', '171A2355', '171A2356', '171A2357', '171A2358', '171A2360', '171A2358_1', '171A2374', '171A2376', '171A2374_1', '171A6012', '171A6013', '171A6014', '171A2201', '171A2310', '171A2311', '171A2312', '171A2313', '171A2314', '171A2315', '171A2316', '171A2317', '171A2318', '171A2319', '171A2356', '171A2357', '171A2330', '171A2331', '171A2332', '171A2333', '171A2334', '171A2335', '171A2336', '171A2337', '171A2341', '171A2470', '171A2359', '171A2345', '171A2346', '171A2345_1', '171A5702', '171A2371', '171A2380', '171A2382') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2017-06-28') AND ( (SELECT count(*) FROM belegung b WHERE b.knr = k.nr AND (b.status_1 in ('A','T','P',' ','') or b.status_1 is null)
) < k.teil_max ) ORDER BY Gewichtung DESC
Aktuell gibt es leider keine Kursvorschläge.
