SELECT r.studreise_id AS studreise_id, r.title AS title, r.head_desc AS head_desc, r.reise_info_einleitung AS reise_info_einleitung, r.reise_info_alg AS reise_info_alg, r.reise_info_leistungen AS reise_info_leistungen, r.reise_info_leistungen_zusatz AS reise_info_leistungen_zusatz, r.reise_info_intern AS reise_info_intern, r.reise_import_note AS reise_import_note, r.teilnehmer_min AS teilnehmer_min, r.teilnehmer_max AS teilnehmer_max, r.dauer AS dauer, r.reisetyp AS reisetyp, r.flug AS flug, r.ab_preis AS ab_preis, r.main_pic AS main_pic, r.main_pic_title AS main_pic_title, r.landkarte_pic AS landkarte_pic, r.landkarte_pic2 AS landkarte_pic2, r.pub AS pub, r.fk_veranstalter_id AS fk_veranstalter_id, r.katalog_site as katalog_site, r.internet_site as internet_site, r.finished as finished, r.pub_gruppenreise AS pub_gruppenreise, r.pub_only_studienreisen AS pub_only_studienreisen, r.pic_locked AS pic_locked, r.garantierte_durchfuehrung AS garantierte_durchfuehrung, r.buchcode AS buchcode, r.staedtereise AS staedtereise, r.online_buchbar AS online_buchbar, r.individual AS individual, r.vorabkatalog AS vorabkatalog, r.saisonabhaengig AS saisonabhaengig, r.main_pic_proferia_recht AS main_pic_proferia_recht, r.individual AS individual, r.studienreisen_de AS studienreisen_de, r.kulturreisen_de AS kulturreisen_de, r.singlereisen_net AS singlereisen_net, r.silvesterreisen_de AS silvesterreisen_de, r.fk_opernhaeuser_id AS fk_opernhaeuser_id, r.cleared as cleared, r.termine_vorhanden AS termine_vorhanden, r.stempeltext AS stempeltext, r.stempeltextoverlay AS stempeltextoverlay, r.setPreisAufAnfrage AS setPreisAufAnfrage, r.zeitraum_text AS zeitraum_text, studienreisen_id_2_kulturreisen_id.fk_kulturreisen_id AS fk_kulturreisen_id, studienreisen_de_googleIndex, kulturreisen_de_googleIndex, singlereisen_net_googleIndex, keine_Lizenznehmer, googleIndexFest, CanonicalID, CanonicalIDKulturreisen, r.ab_bis AS ab_bis , s2o.fk_ops_id , v.label_name AS veranstaltername, v.busreisen AS busreisen, v.aenderungen_vorbehalten AS aenderungen_vorbehalten, v.pub_fluegeonline AS pub_fluegeonline, v.fk_kulturreisen_veranstalter_id AS fk_kulturreisen_veranstalter_id, v.singlereisen_net AS ver_singlereisen_net, v.veranstalter_seite AS veranstalter_seite, v.img_logo AS img_logo, v.pub AS veranstalter_pub FROM studreise r INNER JOIN studienreisen_id_2_kulturreisen_id ON studienreisen_id_2_kulturreisen_id.fk_studienreisen_id = r.studreise_id AND studienreisen_id_2_kulturreisen_id.fk_kulturreisen_id = '312812' LEFT JOIN veranstalter v ON r.fk_veranstalter_id = v.veranstalter_id LEFT JOIN sr_2_ops s2o ON r.studreise_id = s2o.fk_studienreisen_id WHERE 1 AND r.kulturreisen_de = '1' AND r.cleared != '1' SELECT fk_studienreisen_id FROM studienreisen_id_2_kulturreisen_id WHERE fk_kulturreisen_id = '312812'SELECT b.file_2, b.bildtext, b.width, b.height, b.fileExists FROM bilder b where fk_typ_id='281841' AND typ='r' AND fileExists = '1' ORDER BY numSELECT veranstalter_id, num, name, pub, label_pub, label_name, datei_name, veranstalter_seite, footer_pub, busreisen, prio, reisetyp, teaser_header, teaser_text, teaser_text_rundreisen, img_logo, meta_desc, title_prefix, meta_keys, aktuelle_reisen, letzter_check, set_sortiment, aenderungen_vorbehalten, notiz, bildquelle, studienreisen_de, kulturreisen_de, singlereisen_net, fk_kulturreisen_veranstalter_id, kulturreisen_teaser_header, kulturreisen_teaser_text, kulturreisen_img_logo, hasHistory, url_agb, hideName FROM veranstalter WHERE fk_kulturreisen_veranstalter_id = '101' AND kulturreisen_de = '1' SELECT fk_studienreisen_id FROM studienreisen_id_2_kulturreisen_id WHERE fk_kulturreisen_id = '312812' SELECT text FROM studreise_fruehbuch WHERE fk_studreise_id='281841' AND date_von <= NOW() AND date_bis >= NOW() SELECT t.text, t2s.FKTextbausteineID, t2s.FKStudreiseID FROM Textbausteine t INNER JOIN Textbausteine2Studreise t2s ON t2s.FKTextbausteineID = t.TextbausteineID WHERE t2s.FKStudreiseID = '281841' SELECT studreise_termin.*, reisetyp.* FROM studreise_termin INNER JOIN studreise ON studreise.studreise_id = studreise_termin.fk_studreise_id LEFT JOIN reisetyp ON fk_reisetyp_id = reisetyp_id WHERE studreise_termin.fk_studreise_id ='281841' AND (studreise_termin.pub='1' or studreise_termin.vormerktermin='1') AND ((studreise_termin.dat_von >= NOW() AND studreise.saisonabhaengig = 0) OR (studreise_termin.dat_bis >= NOW() AND studreise.saisonabhaengig = 1)) ORDER BY dat_von SELECT fk_studienreisen_id FROM studienreisen_id_2_kulturreisen_id WHERE fk_kulturreisen_id = '312812'SELECT * FROM studreise_2_kulturreisen_themen INNER JOIN kulturreisen_themen on fk_kulturreisen_themen_id = id WHERE fk_studreise_id = 281841