VHS Landkreis Pfaffenhofen: Gesellschaft

Pfaffenhofen >> Gesellschaft

SELECT KNr, Gewichtung, Von, Bis FROM web_kurshighlights wk join kurse k on wk.knr = k.nr WHERE (('2018-04-19 00:00' >= wk.Von AND '2018-04-19 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2018-04-19 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2018-04-19 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-19' >=k.internetvon AND '2018-04-19' <= k.internetbis) or ('2018-04-19' >= 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-19') 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 ('172A7001', '172A2374', '172A2376', '172A2377', '172A2375', '181A2375', '181A2376', '181A2376_1', '172A1101', '172A1107', '172A1109', '172A1110', '181A1102', '181A1104', '181A1111', '181A1101', '181A1103', '181A1105', '181A1107', '181A1102_1', '172A6001', '172A6002', '172A6003', '172A4208', '172A4210', '172A4211', '172A4212', '172A4213', '172A4214', '172A1205', '172A1207', '172A1201', '172A2425', '181A6002', '181A6003', '181A2450', '181A1205', '181A1207', '181A1209', '181A4210', '181A4211', '181A4212', '181A4213', '181A4214', '181A4216', '181A4218', '172A1319', '172A1316', '172A2117', '172A2105', '172A1301', '172A1302', '172A1303', '172A1308', '172A1304', '172A1310', '172A1312', '172A1318', '172A1314', '172A1321', '172A1323', '172A1306', '172A2445', '172A1307', '181A1314', '181A2105', '181A1301', '181A1302', '181A1303', '181A2107', '181A1316', '181A1318', '181A1320', '181A1307', '181A1313', '181A1311', '181A1309', '181A1305', '172A1310_1', '181A1307_1', '172A5301', '172A1502', '172A1505', '172A1603', '172A1510', '172A1512', '172A1514', '172A5302', '172A5303', '172A1503', '181A1502', '181A1504', '181A1607', '181A1510', '181A1512', '181A1503', '181A5303', '181A5302', '172A1605', '172A2348', '172A1603', '172A1601', '172A1607', '172A1609', '172A1602', '172A1604', '181A1601', '181A1602', '181A1604', '181A1605', '181A1607', '181A1609', '172A1810', '172A1811', '172A1820', '172A1822', '172A1805', '172A1812', '181A1801', '181A1803', '181A1822', '181A1824', '181A1826', '181A1828', '181A1820', '181A1801_1', '172A5725', '172A5724', '172A1905', '172A1903', '172A1901', '181A1901') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2018-04-19') 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

Aktuelle Kursangebote - Gesellschaft

Aktuell gibt es leider keine Kursvorschläge.

Fachbereichsleitung

Michael Hagn
Telefon 08441 27445
E-Mail schreiben

Anmeldung

Eva Spindler
Telefon 08441 490480
E-Mail schreiben

Smartphone und Tablet (4)

Wirtschaft und Recht (8)

Pädagogik (13)

Psychologie (16)

Länderkunde (9)

Geschichte - Heimatgeschichte (6)

Ökologie (8)

Wissenschaft & Technik (1)

Aktuelle Kursangebote - Gesellschaft

Fachbereichsleitung

Anmeldung

Kurse in Ihrer Nähe