SELECT goods_id1, goods_id2, cnt, total_cnt1, total_cnt2,
  1.0*cnt/IF(total_cnt1<total_cnt2,total_cnt1,total_cnt2) AS simpson_coeff,
  1.0*cnt/SQRT(total_cnt1*total_cnt2) AS cos_coeff,
  1.0*cnt/(total_cnt1+total_cnt2) AS dice_coeff
FROM
(
  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
) basket
JOIN
(
  SELECT goods_id, COUNT(DISTINCT(member_id, time)) AS total_cnt1
  FROM sales_slip
  WHERE TD_TIME_RANGE(time, '2013-12-17', '2013-12-18', 'JST')
  GROUP BY goods_id
) item1
ON basket.goods_id1 = item1.goods_id
JOIN
(
  SELECT goods_id, COUNT(DISTINCT(member_id, time)) AS total_cnt2
  FROM sales_slip
  WHERE TD_TIME_RANGE(time, '2013-12-17', '2013-12-18', 'JST')
  GROUP BY goods_id
) item2
ON basket.goods_id2 = item2.goods_id
ORDER BY cnt DESC