Vc4fRqCM

1Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.002120) DROP TABLE IF EXISTS "users"
2Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.001219) DROP TABLE IF EXISTS "addresses"
3Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.003135) CREATE TABLE "users" ( "id" SERIAL NOT NULL PRIMARY KEY, "username" VARCHAR(50) NOT NULL, "age" SMALLINT NOT NULL )
4Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.002443) CREATE TABLE "addresses" ( "id" SERIAL NOT NULL PRIMARY KEY, "user_id" INTEGER NOT NULL, "street" VARCHAR(50) NOT NULL, "zipcode" VARCHAR(10) NOT NULL, "city" VARCHAR(50) NOT NULL )
5Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.000816) INSERT INTO "users" ("id", "username", "age") VALUES (1, 'John', 18)
6Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.000443) INSERT INTO "users" ("id", "username", "age") VALUES (2, 'Jane', 21)
7Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.000532) INSERT INTO "addresses" ("id", "user_id", "street", "zipcode", "city") VALUES (1, 1, 'Street 1/2', 'Chicago', '12345')
8Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.000463) INSERT INTO "addresses" ("id", "user_id", "street", "zipcode", "city") VALUES (2, 2, 'Street 2/4', 'Boston', '67890')
9Tue, 14 Feb 2012 14:56:18 GMT ~ debug ~ (0.001570) SELECT "age", "username", "id", "street", "zipcode", "user_id", "city" FROM (SELECT * FROM "users" AS "left" NATURAL JOIN (SELECT * FROM "addresses" WHERE "city" = 'Boston') AS "right") AS "users_addresses" WHERE "city" = 'Boston'