Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM (SELECT SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_estimated") AS "Amount Estimated",
- SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_encumbered") AS "Amount Encumbered",
- SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_spent") AS "Amount Spent",
- "56ea0ee77c2c6efe0131dfeea01705f5"."state" AS "State",
- "56ea0ee77c2c6efe0131dfeea01705f5"."id" AS "Purchase Order ID",
- "f6422b231827b01bf4a6ffe0080beb05"."item_count" AS "Item Count",
- "3d4810701da515a9109943f830ba6cc4"."code" AS "Code",
- date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") AS "Creation Time",
- date("56ea0ee77c2c6efe0131dfeea01705f5"."order_date") AS "Order Date"
- FROM acq.purchase_order AS "56ea0ee77c2c6efe0131dfeea01705f5"
- INNER JOIN acq.provider AS "3d4810701da515a9109943f830ba6cc4" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."provider" = "3d4810701da515a9109943f830ba6cc4"."id")
- INNER JOIN actor.org_unit AS "6384d64cf75978fb7e6f1cd23ff5c037" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."ordering_agency" = "6384d64cf75978fb7e6f1cd23ff5c037"."id")
- LEFT OUTER JOIN acq.lineitem AS "f6422b231827b01bf4a6ffe0080beb05" ON ("56ea0ee77c2c6efe0131dfeea01705f5"."id" = "f6422b231827b01bf4a6ffe0080beb05"."purchase_order")
- WHERE date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") >= $_147912$2017-01-02$_147912$
- AND "6384d64cf75978fb7e6f1cd23ff5c037"."id" IN ($_147912$213$_147912$)
- GROUP BY 4, 5, 6, 7, 8, 9
- ORDER BY SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_estimated") ASC, SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_encumbered") ASC, SUM("56ea0ee77c2c6efe0131dfeea01705f5"."amount_spent") ASC, "56ea0ee77c2c6efe0131dfeea01705f5"."state" ASC, "56ea0ee77c2c6efe0131dfeea01705f5"."id" ASC, "f6422b231827b01bf4a6ffe0080beb05"."item_count" ASC, "3d4810701da515a9109943f830ba6cc4"."code" ASC, date("56ea0ee77c2c6efe0131dfeea01705f5"."create_time") ASC, date("56ea0ee77c2c6efe0131dfeea01705f5"."order_date") ASC
- ) limited_to_1048575_hits LIMIT 1048575
- Error is: DBD::Pg::st execute failed: ERROR: column 56ea0ee77c2c6efe0131dfeea01705f5.amount_estimated does not exist
- LINE 1: SELECT * FROM (SELECT SUM("56ea0ee77c2c6efe0131dfeea01705f5"...
- ^ at /openils/bin/clark-kent.pl line 255.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement