Advertisement
TDCustmerSupportJP

Untitled

Aug 6th, 2017
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.50 KB | None | 0 0
  1. SELECT t1.goods_id AS goods_id1, t2.goods_id AS goods_id2, COUNT(1) AS cnt
  2. FROM
  3. (
  4.   SELECT member_id, goods_id
  5.   FROM sales_slip
  6.   WHERE TD_TIME_RANGE(time, '2013-12-01', '2014-01-01', 'JST')
  7.   GROUP BY member_id, goods_id
  8. ) t1,
  9. (
  10.   SELECT member_id, goods_id
  11.   FROM sales_slip
  12.   WHERE TD_TIME_RANGE(time, '2013-12-01', '2014-01-01', 'JST')
  13.   GROUP BY member_id, goods_id
  14. ) t2
  15. WHERE t1.member_id = t2.member_id
  16. AND t1.goods_id < t2.goods_id
  17. GROUP BY t1.goods_id, t2.goods_id
  18. ORDER BY cnt DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement