SELECT routerl3agentbindings.id AS routerl3agentbindings_id, routerl3agentbindings.router_id AS routerl3agentbindings_router_id, routerl3agentbindings.l3_agent_id AS routerl3agentbindings_l3_agent_id
FROM routerl3agentbindings, agents
WHERE agents.heartbeat_timestamp < '2014-08-20 23:21:27.289744' AND agents.admin_state_up;
Current code was emitting queries like this.
SELECT routerl3agentbi ndings. id AS routerl3agentbi ndings_ id, routerl3agentbi ndings. router_ id AS routerl3agentbi ndings_ router_ id, routerl3agentbi ndings. l3_agent_ id AS routerl3agentbi ndings_ l3_agent_ id ndings, agents heartbeat_ timestamp < '2014-08-20 23:21:27.289744' AND agents. admin_state_ up;
FROM routerl3agentbi
WHERE agents.