select ( (rubrik LIKE '%medien%')*2 + (keyw LIKE '%medien%')*2 + (rubrik LIKE '%medienwatch%')*12 +(rubrik2 LIKE '%medienwatch%')*12 + (titel LIKE '%medienwatch%')*5 + (comment LIKE '%medienwatch%')*2 + (keyw LIKE '%medienwatch%')*5 + (btext LIKE '%medienwatch%')*1 + (length(btext)>20)*10)*2+(level*6) + ((time0/1000000 - 20050000)/verfall*5 + (comment LIKE '%%')*55 ) as rank , id, titel,titel2, rubrik, comment, btext, rubrik2, autor, quelle, time0, url,bereich,level,count,keyw,verfall from links where rubrik like '%medienwatch%' and rubrik not like '%hamburg%' and (rubrik = 'medienwatch' or rubrik2 = 'medienwatch' or keyw like '%medienwatch%') and rubrik !='lhh' and (rubrik like '%medienwatch%' or rubrik2 like '%medienwatch%' or titel like '%medienwatch%' or comment like '%medienwatch%' or keyw like '%medienwatch%' ) having (rank > (level+2) and level>10) order by rank desc limit 12 RSS-Feed wurde erstellt: http://news.web-hh.de/Medienwatch/news-medienwatch-medienwatch.xml		Wetter Hamburg Hamburg Aachen Amsterdam Antalya Athen Barcelona Berlin Bremen Budapest Emden Dresden Dublin Düsseldorf Flensburg Frankfurt-M Frankfurt-O London Hamburg Hannover Istanbul Karlsruhe Kassel Kopenhagen Köln Konstanz Las Palmas Lima Lissabon Los Angeles Magdeburg Marseille Mexico City Moskau Münster Murmansk New York Nürnberg Paris Passau Rio de Janeiro Rom Rostock Saarbrücken Shanghai Stockholm Stuttgart Teheran Tokio Tromsö Ulm Wismar Warschau Jakarta © meteo24.de Radar: aktuelle Nässe (WetterOnline) Termine select eid, title,eventDate, startTime, endTime,endDate ,rubrik from nuke_events where endDate >= '2010-09-03' and eventDate = endDate and (rubrik like '%medien%' or rubrik like '%%') and ort like '%%' and level > 5 order by endDate ASC Termine eintragen

1 select keyw,rubrik, rubrik2 from links where (keyw like '%medienwatch%' or rubrik like '%medienwatch%' or rubrik2 like '%medienwatch%' or rubrik like '%%' or keyw like '%%' or rubrik like '%%' or rubrik2 like '%%' or keyw like '%%' or rubrik like '%%' or rubrik2 like '%%' or keyw like '%%' or rubrik like '%%' or rubrik2 like '%%' ) and (rubrik !='lhh') order by id desc limit 250kein DB-Connect??http://altona.web-hh.de/blocks/block-termin.php?xx=xxx&rubrik=medienwatch&extfull=&eid=&e_url=

select titel,id,rubrik, (level*100+1000/(time0-time)+ id + (rubrik like '%medien%')*20 + (rubrik like '%medienwatch%') *20 + (rubrik like '%medienwatch%')*(20/verfall)) as rank from links where ((rubrik like '%medienwatch%') or (rubrik like '%medienwatch%') or (rubrik like '%medienwatch%') or (rubrik2 like '%medienwatch%')) and level > 30 order by rank desc limit 45