query="""
        SELECT
            erc_meter.id,
            main_organization.shortName AS organization,
            main_geoarea.shortName AS shortName,
            main_address.prefix AS prefix,
            main_address.street AS street,
            main_address.buildNo AS buildNo,
            main_address.add AS `add`,
            erc_meter.position AS position,
            lastdate
        FROM erc_meter
        LEFT JOIN main_address ON main_address.commonAddress=erc_meter.address_id
        LEFT JOIN main_geoarea ON main_address.geoarea_id=main_geoarea.id
        LEFT JOIN main_organization ON main_organization.id=main_address.organization_id
        LEFT JOIN
            (SELECT meter_id, MAX(date) AS lastdate
                FROM erc_meterdata WHERE 1
                GROUP BY meter_id ORDER BY date DESC, meter_id) AS lastData
            ON lastData.meter_id=erc_meter.id
        WHERE erc_meter.active=1 AND erc_meter.address_id IN (SELECT commonAddress FROM main_addr$
        ORDER BY organization, street, buildNo
        """%(childOrgs)