Advertisement
Guest User

Untitled

a guest
Jun 30th, 2014
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.26 KB | None | 0 0
  1. SELECT "ir_property".id AS id,COALESCE("ir_property".write_date, "ir_property".create_date) AS _datetime,"ir_property"."create_uid" AS "create_uid","ir_property"."create_date" AS "create_date","ir_property"."company" AS "company","ir_property"."write_uid" AS "write_uid","ir_property"."field" AS "field","ir_property"."write_date" AS "write_date",CAST(EXTRACT(EPOCH FROM (COALESCE("ir_property".write_date, "ir_property".create_date))) AS VARCHAR) AS _timestamp FROM "ir_property__history" AS "ir_property" WHERE (("ir_property"."field" IN (SELECT "ir_model_field".id AS id FROM "ir_model_field" WHERE (("ir_model_field"."name" IN (%s))))) AND (("ir_property"."res" IS NULL) OR ("ir_property"."res" IN (%s)))) AND (COALESCE("ir_property".write_date, "ir_property".create_date) <= %s) AND ("ir_property".id IN (SELECT "ir_property".id AS id FROM "ir_property__history" AS "ir_property" WHERE (((("ir_property"."company" = %s)) OR (("ir_property"."company" IS NULL))) AND %s) AND (COALESCE("ir_property".write_date, "ir_property".create_date) <= %s)))
  2. [u'cost_price', u'product.template,24', datetime.DATE(2014, 6, 30), 1, TRUE, datetime.DATE(2014, 6, 30)]
  3. SELECT id, write_date FROM "ir_property__history" WHERE ((id IN (%s)))AND (write_date IS NOT NULL AND create_date IS NULL)
  4. [56980]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement