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

Jakobuskirche Auenstein (evangelische Kirche)
Ilsfeld (Heilbronn / Baden-Württemberg)

Kirchenkunst-Eintrag

Was Sie hier erwartet

Schulstr. 2
74360 Auenstein

Tel. 07062 61865
Fax




Führungen

Termine

M: Musik, K: Kunstführung

 

Orgeln in Deutschland

18 queries took 37 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` = 742 LIMIT 1112
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` = 552 111
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 (742) 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 (555) AND `OrganBuildersOrgan`.`organ_builder_id` = `OrganBuilder`.`id`) 221
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 (742) 003
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 (742) 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 (742) AND `ImagesVenue`.`image_id` = `Image`.`id`) 004
10SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 552 LIMIT 1111
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` <= 16448 AND `Location`.`rght` >= 16449 ORDER BY `Location`.`lft` asc 553
12SELECT `Location`.`lft`, `Location`.`rght` FROM `locations` AS `Location` WHERE `Location`.`id` = 552 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` <= 16448 AND `Location`.`rght` >= 16449 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 < '2014-11-01 00:00:00' AND (ISNULL(`Date`.`end_date`) OR (`Date`.`end_date` >= '2014-09-30 00:00:00')) AND `Venue`.`id` = 742 AND `Location`.`lft` >= 16448 AND `Location`.`rght` <= 16449 GROUP BY `Event`.`id` HAVING Count(`Date`.`id`) > 00010
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` = 742 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` = 742 LIMIT 1001
17SELECT id FROM deletions WHERE model = 'venue' AND model_id = 742001
18SELECT `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` = 0 AND `active` = 1 111