Mit der Bildungsprämie nur die Hälfte zahlen!
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
Wie funktioniert die Bildungsprämie ?
SELECT KNr, Gewichtung, Von, Bis FROM web_kurshighlights wk join kurse k on wk.knr = k.nr WHERE (('2018-04-25 00:00' >= wk.Von AND '2018-04-25 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2018-04-25 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2018-04-25 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 (('2018-04-25' >=k.internetvon AND '2018-04-25' <= k.internetbis) or ('2018-04-25' >= 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 >= '2018-04-25') 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/18') AND k.nr in ('172A2301', '172A2302', '181A2301', '181A2302', '172A2310', '172A2311', '172A2312', '172A2314', '172A2315', '172A2317', '172A2316', '172A2313', '181A2310', '181A2311', '181A2312', '181A2313', '181A2314', '181A2315', '181A2316', '181A2317', '172A2330', '172A2331', '172A2334', '172A2336', '172A2337', '172A2333', '181A2330', '181A2331', '181A2333', '181A2334', '181A2336', '181A2337', '172A2345', '172A2346', '172A2344', '181A2344', '181A2346', '172A2343', '181A2343', '172A2352', '172A2353', '172A2354', '172A2355', '172A2356', '172A2357', '172A2358', '181A2353', '181A2354', '181A2355', '181A2356', '181A2357', '181A2358', '172A2301', '172A2302', '172A2352', '172A2353', '172A2354', '172A2355', '172A2356', '172A2357', '172A2358', '181A2301', '181A2302', '181A2353', '181A2354', '181A2355', '181A2356', '181A2357', '181A2358', '181A2304', '172A2374', '172A2376', '172A2375', '172A2377', '181A2375', '181A2376', '181A2376_1', '172A6012', '172A6013', '181A6012', '181A6013', '172A2201', '172A2310', '172A2311', '172A2312', '172A2314', '172A2315', '172A2317', '172A2316', '172A2313', '172A2356', '172A2357', '181A2201', '181A2310', '181A2311', '181A2312', '181A2313', '181A2314', '181A2315', '181A2316', '181A2317', '181A2356', '181A2357', '172A2330', '172A2331', '172A2334', '172A2336', '172A2337', '172A2333', '172A2338', '172A2470', '172A2475', '181A2330', '181A2331', '181A2333', '181A2334', '181A2336', '181A2337', '181A2338', '172A2343', '181A2343', '172A2345', '172A2346', '172A2344', '181A2344', '181A2346', '172A5707', '172A5711', '172A5709', '181A5707', '172A2371', '172A2380', '172A2382', '181A2380', '181A2382', '181A2401_A', '181A2401_B', '181A2401_T', '181A2403_P', '181A2403_T', '181A2404_P', '181A2404_T', '172A2401_A', '172A2401_B', '172A2401_T', '172A2403_P', '172A2403_T', '172A2404_P', '172A2404_T', '172A2403OT', '181A2405_P', '181A2405_T', '172A2407_P', '172A2407_T', '181A2408_P', '181A2409_T', '181A2420_O', '181A2421_T', '181A2422_O', '181A2422_T', '181A2423_O', '181A2423_T', '172A2402_O', '172A2402_T', '172A2403_O', '181A2424_O', '181A2424_T', '181A2425_O', '181A2425_T', '181A2426_O', '181A2426_T', '172A2405_O', '172A2405_T', '172A2406_O', '172A2406_T', '181A2427_O', '181A2427_T', '172A2408_O', '172A2408_T', '181A2428_O', '181A2428_T', '172A2409_O', '172A2409_T', '181A2429_O', '181A2429_T', '172A2410_O', '172A2410_T', '181A2430_O', '181A2430_T', '172A2411_O', '172A2411_T', '181A2431_O', '181A2431_T', '172A2412_O', '172A2412_T', '181A2432_O', '181A2432_T', '172A2413_O', '172A2413_T', '181A2433_O', '181A2433_T', '172A2414_O', '172A2414_T', '172A2425', '181A2450', '172A2445', '172A2430', '172A2431', '181A2454', '181A2452', '181A2451', '172A1316', '172A2117', '172A2105', '172A2101', '172A2109', '172A2115', '172A2119', '172A2107', '172A2113', '172A2103', '172A2111', '172A1301', '172A1302', '172A1303', '172A1307', '181A2103', '181A2113', '181A2115', '181A2105', '181A1301', '181A1302', '181A1303', '181A2109', '181A2107', '181A2101', '181A2111', '181A2456') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2018-04-25') 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.
