---
 
---
 
---
 
---
 
---
 
---
 
---
 
---
---
 
---
 
---
 
---
 
---
 
---
---

Protestantische Kirche - St. Andreas (evangelische Kirche)
Kirchheim an der Weinstraße (Bad Dürkheim / Rheinland-Pfalz)

Kirchenmusik-Eintrag

Allgemeine Informationen

Prospekt und Spieltisch der Hartung-Orgel 1750
Prospekt und Spieltisch der Hartung-Orgel 1750

Beschreibung

Die heutige Kirche wurde um 1500 erbaut und verfügt über einen Chorraum mit spätgotischem Netzgewölbe.Der Chorbogen stammt noch von der Vorgängerkirche aus dem 13. Jahrhundert.Der Altar wurde 1524 aufgestellt und war ursprünglich Teil einer Annaselbdrittgruppe. Das Jesuskind ist vermutlich im dreißigjährigen Krieg verloren gegangen. Auf dem Sockel des Altars ist das Schweisstuch der Veronika dargestellt. Weitere Kunstwerke in der Kirche sind das mittelalterliche Sakramentshäuschen sowie der denkmalgeschützte Orgelprospekt um 1750.

Orgel(n)

Johann Michael Hartung/Rekonstruktion Mönch II/24 ca. 1750/ rekonstruiert 1993 (mech.) ; Eine "Zwillingsorgel" befindet sich in Haßloch in der Christuskirche.

Führungen

Termine

M: Musik, K: Kunstführung

Änderung vorschlagen
Löschung vorschlagen
Für diesen Eintrag liegen bereits Änderungsvorschläge vor, die noch nicht von der Redaktion bearbeitet wurden. Deshalb ist dieser Eintrag momentan gesperrt.

17 queries took 71 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'01
2SELECT `Venue`.`id`, `Venue`.`original_id`, `Venue`.`venue_type_id`, `Venue`.`name`, `Venue`.`address1`, `Venue`.`address2`, `Venue`.`zip`, `Venue`.`city`, `Venue`.`phone`, `Venue`.`fax`, `Venue`.`homepage`, `Venue`.`email`, `Venue`.`description`, `Venue`.`ensembles`, `Venue`.`program`, `Venue`.`events`, `Venue`.`route`, `Venue`.`contact`, `Venue`.`courses`, `Venue`.`location_id`, `Venue`.`parent_id`, `Venue`.`transaction_id`, `Venue`.`user_id`, `Venue`.`created`, `Venue`.`modified`, `Venue`.`tmp`, `Location`.`id`, `Location`.`parent_node`, `Location`.`lft`, `Location`.`rght`, `Location`.`title`, `Location`.`prefix`, `Location`.`old_id`, `Location`.`depth`, `Location`.`has_related_entries`, `Location`.`venues_count`, `VenueType`.`id`, `VenueType`.`pos`, `VenueType`.`name`, `VenueType`.`short_name` FROM `venues` AS `Venue` LEFT JOIN `locations` AS `Location` ON (`Venue`.`location_id` = `Location`.`id`) LEFT JOIN `venue_types` AS `VenueType` ON (`Venue`.`venue_type_id` = `VenueType`.`id`) WHERE `Venue`.`id` = 60 LIMIT 1113
3SELECT `Location`.`id`, `Location`.`parent_node`, `Location`.`lft`, `Location`.`rght`, `Location`.`title`, `Location`.`prefix`, `Location`.`old_id`, `Location`.`depth`, `Location`.`has_related_entries`, `Location`.`venues_count` FROM `locations` AS `Location` WHERE `Location`.`id` = 11713 113
4SELECT `VenueType`.`id`, `VenueType`.`pos`, `VenueType`.`name`, `VenueType`.`short_name` FROM `venue_types` AS `VenueType` WHERE `VenueType`.`id` = 1 111
5SELECT `Organ`.`id`, `Organ`.`original_id`, `Organ`.`venue_id`, `Organ`.`type`, `Organ`.`notes`, `Organ`.`description`, `Organ`.`created`, `Organ`.`modified`, `Organ`.`user_id`, `Organ`.`tmp` FROM `organs` AS `Organ` WHERE `Organ`.`venue_id` IN (60) 111
6SELECT `OrganBuilder`.`id`, `OrganBuilder`.`original_id`, `OrganBuilder`.`name`, `OrganBuilder`.`created`, `OrganBuilder`.`modified`, `OrganBuilder`.`tmp`, `OrganBuildersOrgan`.`organ_id`, `OrganBuildersOrgan`.`organ_builder_id` FROM `organ_builders` AS `OrganBuilder` JOIN `organ_builders_organs` AS `OrganBuildersOrgan` ON (`OrganBuildersOrgan`.`organ_id` IN (810) AND `OrganBuildersOrgan`.`organ_builder_id` = `OrganBuilder`.`id`) 112
7SELECT `Role`.`id`, `Role`.`original_id`, `Role`.`person_id`, `Role`.`occupation_id`, `Role`.`ensemble_id`, `Role`.`venue_id`, `Role`.`event_id` FROM `roles` AS `Role` WHERE `Role`.`venue_id` IN (60) 002
8SELECT `GuidedTour`.`id`, `GuidedTour`.`original_id`, `GuidedTour`.`venue_id`, `GuidedTour`.`guide_id`, `GuidedTour`.`title`, `GuidedTour`.`description`, `GuidedTour`.`transaction_id`, `GuidedTour`.`created`, `GuidedTour`.`modified`, `GuidedTour`.`user_id`, `GuidedTour`.`parent_id`, `GuidedTour`.`tmp` FROM `guided_tours` AS `GuidedTour` WHERE `GuidedTour`.`venue_id` IN (60) 001
9SELECT `Image`.`id`, `Image`.`original_id`, `Image`.`title`, `Image`.`hash`, `Image`.`type`, `Image`.`name`, `Image`.`transaction_id`, `Image`.`user_id`, `Image`.`tmp`, `Image`.`created`, `Image`.`modified`, `ImagesVenue`.`image_id`, `ImagesVenue`.`venue_id` FROM `images` AS `Image` JOIN `images_venues` AS `ImagesVenue` ON (`ImagesVenue`.`venue_id` IN (60) AND `ImagesVenue`.`image_id` = `Image`.`id`) 114
10SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 11713 LIMIT 1114
11SELECT `Location`.`id`, `Location`.`parent_node`, `Location`.`lft`, `Location`.`rght`, `Location`.`title`, `Location`.`prefix`, `Location`.`old_id`, `Location`.`depth`, `Location`.`has_related_entries`, `Location`.`venues_count` FROM `locations` AS `Location` WHERE 1 = 1 AND `Location`.`lft` <= 323705 AND `Location`.`rght` >= 323706 ORDER BY `Location`.`lft` asc 5520
12SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 11713 LIMIT 1111
13SELECT `Location`.`id`, `Location`.`parent_node`, `Location`.`lft`, `Location`.`rght`, `Location`.`title`, `Location`.`prefix`, `Location`.`old_id`, `Location`.`depth`, `Location`.`has_related_entries`, `Location`.`venues_count` FROM `locations` AS `Location` WHERE 1 = 1 AND `Location`.`lft` <= 323705 AND `Location`.`rght` >= 323706 ORDER BY `Location`.`lft` asc 551
14 SELECT `Event`.*, `Venue`.`id`, `Venue`.`name`, `Venue`.`city`, `Location`.`id`, `Location`.`depth`, `Location`.`title` FROM `events` AS `Event` LEFT JOIN `guided_tours` AS `GuidedTour` ON `GuidedTour`.`id` = `Event`.`guided_tour_id` LEFT JOIN `venues` AS `Venue` ON (`Venue`.`id` = `Event`.`venue_id`) OR (`Venue`.`id` = `GuidedTour`.`venue_id`) LEFT JOIN `locations` AS `Location` ON `Location`.`id` = `Venue`.`location_id` LEFT JOIN `dates` AS `Date` ON `Event`.`id` = `Date`.`event_id` WHERE `Event`.`tmp` = 0 AND `Date`.`tmp` = 0 AND `Event`.`parent_id` IS NULL AND GuidedTour.parent_id IS NULL AND Date.start_date IS NOT NULL AND Date.start_date < '2015-02-01 00:00:00' AND (ISNULL(`Date`.`end_date`) OR (`Date`.`end_date` >= '2014-12-21 00:00:00')) AND `Venue`.`id` = 60 AND `Location`.`lft` >= 323705 AND `Location`.`rght` <= 323706 GROUP BY `Event`.`id` HAVING Count(`Date`.`id`) > 00016
15SELECT `Venue`.`id`, `Venue`.`original_id`, `Venue`.`venue_type_id`, `Venue`.`name`, `Venue`.`address1`, `Venue`.`address2`, `Venue`.`zip`, `Venue`.`city`, `Venue`.`phone`, `Venue`.`fax`, `Venue`.`homepage`, `Venue`.`email`, `Venue`.`description`, `Venue`.`ensembles`, `Venue`.`program`, `Venue`.`events`, `Venue`.`route`, `Venue`.`contact`, `Venue`.`courses`, `Venue`.`location_id`, `Venue`.`parent_id`, `Venue`.`transaction_id`, `Venue`.`user_id`, `Venue`.`created`, `Venue`.`modified`, `Venue`.`tmp` FROM `venues` AS `Venue` WHERE `Venue`.`id` = 60 LIMIT 1118
16SELECT `Venue`.`id`, `Venue`.`original_id`, `Venue`.`venue_type_id`, `Venue`.`name`, `Venue`.`address1`, `Venue`.`address2`, `Venue`.`zip`, `Venue`.`city`, `Venue`.`phone`, `Venue`.`fax`, `Venue`.`homepage`, `Venue`.`email`, `Venue`.`description`, `Venue`.`ensembles`, `Venue`.`program`, `Venue`.`events`, `Venue`.`route`, `Venue`.`contact`, `Venue`.`courses`, `Venue`.`location_id`, `Venue`.`parent_id`, `Venue`.`transaction_id`, `Venue`.`user_id`, `Venue`.`created`, `Venue`.`modified`, `Venue`.`tmp` FROM `venues` AS `Venue` WHERE `Venue`.`parent_id` = 60 LIMIT 1112
17SELECT `Ad`.`id`, `Ad`.`active`, `Ad`.`kirchkunst`, `Ad`.`url`, `Ad`.`image_id`, `Image`.`id`, `Image`.`original_id`, `Image`.`title`, `Image`.`hash`, `Image`.`type`, `Image`.`name`, `Image`.`transaction_id`, `Image`.`user_id`, `Image`.`tmp`, `Image`.`created`, `Image`.`modified` FROM `ads` AS `Ad` LEFT JOIN `images` AS `Image` ON (`Ad`.`image_id` = `Image`.`id`) WHERE `kirchkunst` = 1 AND `active` = 1 001