|
|
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
|
|
|
| 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 |
|