query = """
    SELECT * FROM
        (SELECT * FROM
            (SELECT * FROM erc_meterstatuschange WHERE
                position IS NOT NULL AND
                TO_DAYS(CURRENT_DATE)-TO_DAYS(datetime)<1
                AND aspect = '%s'
            ORDER BY datetime DESC) AS sorted
        GROUP BY address_id, position) AS ch
    LEFT JOIN main_address AS addr ON addr.commonAddress = ch.address_id
    LEFT JOIN main_organization AS org ON org.id = addr.organization_id
    ORDER BY shortName, addressString
    """%(aspect,)