SELECT
    b.userid,
    l.name AS location,
    c.anzahl_views,
    e.datum_ts,
    s.name as shooter,

    /** das eigentlich problem **/
    CEILING((UNIX_TIMESTAMP() - b.aufnahmezeit_ts)/(3600*24)) as countdays,
    ROUND(c.anzahl_views / countdays) AS viewsperday
    /** ende davon ;) **/

FROM
    bilder.bilder b,
    bilder.counts c,
    bilder.events e,
    bilder.locations l,
    bilder.shooter s
WHERE
        s.id = b.shooter
    AND	b.event = e.id
    AND	e.location = l.id
    AND b.id = c.id
    AND	e.datum_ts BETWEEN $start AND $stopp
    AND	countdays > 4
ORDER BY
    viewsperday    DESC,
    c.anzahl_views DESC
LIMIT
    0,10