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

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 78 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 1117
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 115
4SELECT `VenueType`.`id`, `VenueType`.`pos`, `VenueType`.`name`, `VenueType`.`short_name` FROM `venue_types` AS `VenueType` WHERE `VenueType`.`id` = 1 112
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) 113
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`) 113
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) 004
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) 002
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`) 118
10SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 11713 LIMIT 1116
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 5516
12SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 11713 LIMIT 1116
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 553
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 < '2014-11-01 00:00:00' AND (ISNULL(`Date`.`end_date`) OR (`Date`.`end_date` >= '2014-09-16 00:00:00')) AND `Venue`.`id` = 60 AND `Location`.`lft` >= 323705 AND `Location`.`rght` <= 323706 GROUP BY `Event`.`id` HAVING Count(`Date`.`id`) > 0009
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 1111
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 1111
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