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-07-22 00:00' >= wk.Von AND '2017-07-22 00:00' <= wk.Bis) or ((wk.von is null or wk.von = '1899-12-30') and wk.bis >= '2017-07-22 00:00') or ((wk.bis is null or wk.bis = '1899-12-30') and wk.von <= '2017-07-22 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-07-22' >=k.internetvon AND '2017-07-22' <= k.internetbis) or ('2017-07-22' >= 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-07-22') 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 ('171A4013', '171D4000', '171A4201', '171A4001', '171A4015', '171A4005', '171A4017', '171A4007', '171A4019', '171A4009', '171A4011', '171A4103', '171A4101', '171A4102', '171A4106', '171A4112', '171A4178', '171A4182', '171A4104', '171A4105', '171A4147', '171A4106_1', '171A4120', '171A4122', '171A4124', '171A4126', '171A4128', '171A4130', '171A4132', '171A4134', '171A4136', '171A4138', '171A4140', '171A4142', '171A4144', '171A4146', '171A4150', '171A4152', '171A4154', '171A4155', '171A4147', '171A4154_1', '171A4158', '171A4162', '171A4164', '171A4166', '171A4168', '171A4174', '171A4176', '171A4162_1', '171A4164_1', '171A4174_1', '171A4156', '171A4180', '171A4201', '171A4220', '171A4222', '171A4224', '171A4226', '171A4228', '171A4230', '171A4210', '171A4211', '171A4212', '171A4213', '171A4208', '171A4214', '171A4553', '171A4552', '171A4430', '171A4431', '171A4433', '171A4434', '171A4439', '171A4437', '171A4440', '171A4442', '171A4443', '171A4445', '171A4446', '171A4447', '171A4448', '171A4450', '171A4454', '171A4455', '171A4456', '171A4452', '171A4458', '171A4459', '171A4460', '171A4461', '171A4462', '171A4466', '171A4470', '171A4471', '171A4478', '171A4477', '171A4476', '171A4475', '171A4485', '171A4486', '171A4487', '171A4501', '171A4540', '171A4541', '171A4542', '171A4543', '171A4544', '171A4550', '171A4551', '171A4432', '171A4469', '171A4444', '171A4449', '171A4451', '171A4467', '171A4502', '171A4441', '171A4560', '171A6051', '171A4435', '171A4463', '171A4464', '171A4436', '171A4472', '171A4465', '171A4453', '171A4438', '171A4468', '171A4457', '171E4501', '171A4475-', '171A4490', '171A4401', '171A4402', '171A4403', '171A4404', '171A4405', '171A4406', '171A4412', '171A4411', '171A4414', '171A4415', '171A4416', '171A4417', '171A4418', '171A4419', '171A4420', '171A4421', '171A4422', '171A4413', '171A4410', '171A4503', '171A4504', '171A4505', '171A4506', '171A4485', '171A4486', '171A4487') AND ( (SELECT max(datum) FROM kurstage kurst WHERE kurst.knr = k.nr) >= '2017-07-22') 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 (11)

Entspannung - Meditation (11)

Yoga (20)

Qi-Gong -Tai Chi (10)

Körpererfahrung (2)

Ernährung (13)

Fitness & Sport (66)

Bewegung & Gesundheit (19)

Selbstverteidigung (4)

Senioren (3)

Aktuelle Kursangebote - Gesundheit & Fitness

Fachbereichsleitung

Anmeldung

Kurse in Ihrer Nähe