Fehler bei der SQL-Abfrage: Not unique table/alias: 'bl_articles_type_events' SQL-Statement: # FETCH DATA WENN ROI ARTICLE_TYPE ID 1, 9, 11 ODER 12 UND CATEGORY_ID NICHT 771, 566, 726 SELECT SQL_CALC_FOUND_ROWS bl_articles_categories.article_id, bl_articles.zipcode, bl_articles.city, bl_articles.street, bl_categories_details.title AS category_title, bl_articles_categories.city_id as city_id, bl_articles.hbbildatlas, bl_articles.indexable, bl_articles_details.title as title, bl_articles.article_type_id, bl_articles_types_details.title AS article_type_title, bl_media.media_id, bl_media_details.title AS media_title, bl_media_details.rights AS media_rights, bl_media.extension, bl_media.content_url, bl_media.width, bl_media.height, bl_media.publish as mpublish, bl_articles_type_products.price_eur, bl_articles_type_products.rating, bl_articles_type_products.url as gygUrl, bl_articles.webpage as webpage, bl_articles.latitude, bl_articles.longitude, bl_articles_categories.highlight_level, bl_articles_categories.default_category, bl_articles_categories.unique_id, bl_articles.count_views as cview, bl_cities.title as city_title, bl_cities.seoUrl as org_city_seoUrl, coupon.article_id as cid, coupon.publish as cpub ,date_begin as date_begin, date_end, time_begin, time_end ,0 as distance, count(video_counter.media_id) as video_count FROM bl_articles_categories INNER JOIN bl_articles ON bl_articles.article_id = bl_articles_categories.article_id INNER JOIN bl_articles_details ON bl_articles_details.article_id = bl_articles_categories.article_id AND bl_articles_details.languagecode = 'ger' INNER JOIN bl_categories_details ON bl_categories_details.category_id = bl_articles_categories.category_id AND bl_categories_details.languagecode = 'ger' INNER JOIN bl_articles_types_details ON bl_articles_types_details.article_type_id = bl_articles.article_type_id AND bl_articles_types_details.languagecode = 'ger' LEFT JOIN bl_articles_sections ON bl_articles_sections.article_id = bl_articles_categories.article_id AND bl_articles_sections.languagecode = 'ger' AND bl_articles_sections.page = 1 LEFT JOIN bl_media ON bl_media.media_id = bl_articles.media_id LEFT JOIN bl_media_details ON bl_media_details.media_id = bl_media.media_id AND bl_media_details.languagecode = 'ger' LEFT JOIN bl_articles_details as bl_cities ON bl_cities.article_id = bl_articles_categories.city_id AND bl_cities.languagecode = 'ger' LEFT JOIN bl_articles_type_products ON bl_articles_type_products.article_id = bl_articles_categories.article_id LEFT JOIN bl_articles_categories as coupon_ref ON coupon_ref.city_id = bl_articles_categories.article_id AND coupon_ref.highlight_level = 10 LEFT JOIN bl_articles as coupon ON coupon.article_id = coupon_ref.article_id AND coupon.article_type_id = 150 AND coupon.publish = 'Y' LEFT JOIN bl_articles_type_events ON bl_articles.article_id = bl_articles_type_events.article_id # Zum Zählen von Videos LEFT JOIN bl_articles_gallery ON bl_articles.article_id = bl_articles_gallery.article_id LEFT JOIN bl_media as video_counter ON bl_articles_gallery.media_id = video_counter.media_id AND video_counter.extension = 'youtube' INNER JOIN bl_articles_type_events ON bl_articles_type_events.article_id = bl_articles.article_id WHERE bl_articles.publish = 'Y' AND ( bl_articles.publishdate_end IS NULL OR bl_articles.publishdate_end > CURDATE() ) AND ( bl_articles_type_events.date_end IS NULL OR bl_articles_type_events.date_end > CURDATE() ) AND bl_articles_categories.city_id IN (61816, 63630, 84673, 84490, 73834, 62799, 61744, 62388, 63565, 71888, 70906, 63545, 69456, 72020, 63552, 63671, 143930) AND bl_articles_categories.category_id = '17' AND (('2014-04-25' BETWEEN date_begin AND date_end) OR date_begin >= '2014-04-25' OR (date_begin >= '2014-04-25' AND date_end IS NULL )) AND bl_articles.publish = 'Y' GROUP BY bl_articles.article_id ORDER BY distance,cpub DESC,hbbildatlas, date_begin LIMIT 0,10 Nordamerika Veranstaltungen und Events Reiseführer
LOKALISIERE
Alles in Ihrer Umgebung
 
Darf beLocal Ihren Standort verwenden? So erhalten Sie
Umgebungsinformationen aus Ihrer Umgebung.
 Erlauben
Nein und Nordamerika als Standort beibehalten »
LOKALISIERE
Alles in Ihrer Umgebung
 
Nein und Nordamerika als Standort beibehalten »
 
 
 
Veranstaltungs-Newsletter
Unser Newsletter informiert Sie jeden Mittwoch bequem per E-Mail über die neuesten Veranstaltungen in Nordamerika  und Umgebung.
 
 

Hotel suchen

In Nordamerika übernachten
Anreisedatum
abreisedatum
 
 
 
 
 
 
©2014 beLocal GmbH. Alle Rechte vorbehalten. beLocal Nutzungsbedingungen und Datenschutz.