Spezialangebote - Bootstouren & Hausboote

: SELECT khid,hn,REPEAT('*',hk) AS hk,if(ln=zn,ln,CONCAT(ln,' / ',zn)) AS reg,if (zn NOT LIKE CONCAT('%',sn,'%'),sn,'') AS sn,alt_well,giata_kataloginhalt.si FROM `giata_kataloginhalt` JOIN giata_kataloge USING (cid) JOIN giata_laender ON giata_kataloginhalt.lc=giata_laender.lc JOIN giata_zielgebiete ON giata_kataloginhalt.zi=giata_zielgebiete.zi JOIN giata_staedte ON giata_kataloginhalt.si=giata_staedte.si where (kurz LIKE '%BH%') and book='online' AND cat<>'' and se>NOW() GROUP BY if(gid IN (-1,0,38292,38295,38297,41830,72287,72288,72289,73254,73255,73256,73257,73258,73259,73260,73268,73274,73280,73282,73332,73544,73824,73879,73919,73976,78731,90215,91127),oc,gid) ORDER BY giata_laender.ln COLLATE latin1_german1_ci,giata_zielgebiete.zn COLLATE latin1_german1_ci,giata_staedte.sn COLLATE latin1_german1_ci,hn DESC;