Advertisement
Guest User

Untitled

a guest
Apr 20th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT
  2. v.sku,
  3. sum(s.quantity) AS quantity_sold
  4. FROM
  5. spree_variants v INNER JOIN
  6. spree_line_items s ON s.variant_id = v.id INNER JOIN
  7. spree_orders o ON s.order_id = o.id INNER JOIN
  8. WHERE
  9. o.completed_at > (CURRENT_DATE - 90) AND
  10. o.state = 'complete'
  11. GROUP BY
  12. v.sku
  13. ORDER BY
  14. sum(s.quantity) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement