gistfile1.txt

sqlite> select s.id, ips.used_by_tenant_id from quark_ip_addresses ips join quark_subnets s on s.id = ips.subnet_id where ips._deallocated != 1 and ips.used_by_tenant_id in (123);
sqlite> select s.id, ips.used_by_tenant_id from quark_ip_addresses ips join quark_subnets s on s.id = ips.subnet_id where ips._deallocated != 1 and ips.used_by_tenant_id = (123);
id|used_by_tenant_id
1|123
1|123
sqlite> 
amir@devbox:~/rackerlabs/quark/quark/tests/functional$ sqlite3 --version
3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212