SELECT t1.goods_id AS goods_id1, t2.goods_id AS goods_id2, COUNT(1) AS cnt
FROM
(
  SELECT member_id, goods_id, time
  FROM sales_slip
  WHERE TD_TIME_RANGE(time, '2013-12-17', '2013-12-18', 'JST')
  GROUP BY member_id, goods_id, time -- 同member_id，同timeの重複購入を排除 --
) t1,
(
  SELECT member_id, goods_id, time
  FROM sales_slip
  WHERE TD_TIME_RANGE(time, '2013-12-17', '2013-12-18', 'JST')
  GROUP BY member_id, goods_id, time -- 同member_id，同timeの重複購入を排除 --
) t2
WHERE t1.member_id = t2.member_id
AND t1.time = t2.time
AND t1.goods_id < t2.goods_id
GROUP BY t1.goods_id, t2.goods_id
ORDER BY cnt DESC