---

SELECT sb.*, DATE_FORMAT(sb.Tsp, '%d.%m.%Y') as lchange, IF(sb.Lifte = 0 OR sb.Lifte IS NULL, 'nein', 'ja') as Lift_gemeldet, IF(sb.Loipen = 0 OR sb.Lifte IS NULL, 'nein', 'ja') as Loipen_gemeldet, IF(DATE_ADD(sb.Tsp, INTERVAL 7 DAY) > NOW(), 'ja', 'nein') as schneeber_aktuell FROM db00007565.schneebericht as sb WHERE DATE_ADD(sb.Tsp, INTERVAL 7 DAY) > NOW() AND sb.aktiv = 1 AND (ID_Ort = 891) AND Loipen > 0 AND Lifte > 0 ORDER BY sb.Lifte DESC, sb.Loipen DESC, sb.Schneehoehe_bis DESC, sb.Schneehoehe_von DESC, sb.Tsp DESC

---

/index.php