Home

Fix for KITTENS ZOMG

March 12, 2010 - 12:17pm — Anonymous
  1. SELECT
  2.     SUM(p.price) - COALESCE((SELECT sum(lid.discount) FROM {order_line_item_discounts} lid INNER JOIN {uc_orders} uopd ON uopd.order_id = lid.order_id AND uopd.order_status = "completed" WHERE p.nid = lid.nid ), 0) as total,
  3.     (SUM(p.price) - COALESCE((SELECT sum(lid2.discount) FROM {order_line_item_discounts} lid2 INNER JOIN {uc_orders} uopd2 ON uopd2.order_id = lid2.order_id AND uopd2.order_status = "completed" WHERE p.nid = lid2.nid), 0)) /
  4.     (SELECT count(1) FROM {uc_order_products} op2 INNER JOIN {uc_orders} uo2 WHERE op2.order_id = uo2.order_id AND uo2.order_status = 'completed' AND op2.nid = p.nid) as average,
  5.     p.nid,
  6.     p.title,
  7.     p.price
  8.     FROM {uc_order_products} p INNER JOIN {uc_orders} o ON o.order_id = p.order_id  WHERE o.order_status = 'completed' GROUP BY p.nid  ORDER BY  p.title DESC LIMIT 1000

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.