public
Created

  • Download Gist
gistfile1.txt
1 2 3 4 5
SELECT "health_quotes".* FROM "health_quotes" INNER JOIN "view_health_products" ON "view_health_products"."id" = "health_quotes"."health_product_id" AND "view_health_products"."type" IN ('HealthProduct') INNER JOIN "view_health_products" "extra_health_products_health_quotes" ON "extra_health_products_health_quotes"."id" = "health_quotes"."extra_health_product_id" AND "extra_health_products_health_quotes"."type" IN ('HealthProduct') WHERE (view_health_products.product_type_code = '1'
 
SELECT "health_quotes".* FROM "health_quotes" INNER JOIN "view_health_products" ON "view_health_products"."id" = "health_quotes"."health_product_id" AND "view_health_products"."type" IN ('HealthProduct') INNER JOIN "view_health_products" "extra_health_products_health_quotes" ON "extra_health_products_health_quotes"."id" = "health_quotes"."extra_health_product_id" AND "extra_health_products_health_quotes"."type" IN ('HealthProduct') WHERE "view_health_products"."product_type_code" = 1
 
SELECT "health_quotes".* FROM "health_quotes" INNER JOIN "view_health_products" ON "view_health_products"."id" = "health_quotes"."health_product_id" AND "view_health_products"."type" IN ('HealthProduct') INNER JOIN "view_health_products" "extra_health_products_health_quotes" ON "extra_health_products_health_quotes"."id" = "health_quotes"."extra_health_product_id" AND "extra_health_products_health_quotes"."type" IN ('HealthProduct') WHERE ("view_health_products"."product_type_code" = 1)

SELECT "health_quotes".* FROM "health_quotes" INNER JOIN "view_health_products" ON "view_health_products"."id" = "health_quotes"."health_product_id" AND "view_health_products"."type" IN ('HealthProduct') INNER JOIN "view_health_products" "extra_health_products_health_quotes" ON "extra_health_products_health_quotes"."id" = "health_quotes"."extra_health_product_id" AND "extra_health_products_health_quotes"."type" IN ('HealthProduct') WHERE ("view_health_products"."product_type_code" = 1)

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.