VHS Landkreis Pfaffenhofen: Gesundheit

Pfaffenhofen >> Gesundheit & Fitness

SELECT KNr, Gewichtung, Von, Bis FROM web_kurshighlights wk join kurse k on wk.knr = k.nr WHERE (('2017-09-23 00:00' >= wk.Von AND '2017-09-23 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2017-09-23 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2017-09-23 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-09-23' >=k.internetvon AND '2017-09-23' <= k.internetbis) or ('2017-09-23' >= 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-09-23') 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 ('2/17') AND k.nr in ('172A4013', '172A4001', '172A4005', '172A4007', '172A4009', '172A4011', '172A4015', '172A4019', '172A4102', '172A4106', '172A4112', '172A4178', '172A4182', '172A4101', '172A4104', '172A4105', '172A4136', '172A4130', '172A4128', '172A4150', '172A4152', '172A4120', '172A4122', '172A4126', '172A4132', '172A4134', '172A4124', '172A4142', '172A4144', '172A4146', '172A4138', '172A4140', '172A4141', '172A4175', '172A4158', '172A4162', '172A4164', '172A4166', '172A4174', '172A4176', '172A4175', '172A4168', '172A4156', '172A4180', '172A4175', '172A4220', '172A4222', '172A4234', '172A4232', '172A4224', '172A4226', '172A4228', '172A4230', '172A4208', '172A4210', '172A4211', '172A4212', '172A4213', '172A4214', '172A4430', '172A4432', '172A4434', '172A4442', '172A4435', '172A4437', '172A4438', '172A4439', '172A4440', '172A4441', '172A4446', '172A4447', '172A4448', '172A4451', '172A4454', '172A4455', '172A4456', '172A4457', '172A4466', '172A4468', '172A4470', '172A4471', '172A4472', '172A4475', '172A4476', '172A4477', '172A4485', '172A4486', '172A4487', '172A4540', '172A4541', '172A4542', '172A4543', '172A4544', '172A4550', '172A4551', '172A4552', '172A4553', '172A4560', '172A4465', '172A4452', '172A4474', '172A4478', '172A4479', '172A4453', '172A4462', '172A4401', '172A4402', '172A4403', '172A4404', '172A4405', '172A4406', '172A4411', '172A4412', '172A4413', '172A4414', '172A4415', '172A4416', '172A4417', '172A4418', '172A4419', '172A4420', '172A4421', '172A4422', '172A4502', '172A4505', '172A4506', '172A4503', '172A4501', '172A4175', '172A4507', '172A4485', '172A4486', '172A4487') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2017-09-23') 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 - Gesundheit & Fitness

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

Medizinische Themen - Naturheilkunde (8)

Entspannung - Meditation (8)

Yoga (18)

Qi-Gong -Tai Chi (8)

Körpererfahrung (3)

Ernährung (14)

Fitness & Sport (46)

Bewegung & Gesundheit (18)

Selbstverteidigung (7)

Senioren (3)

Aktuelle Kursangebote - Gesundheit & Fitness

Fachbereichsleitung

Anmeldung

Kurse in Ihrer Nähe