SELECT t1.goods_id AS goods_id1, t2.goods_id AS goods_id2, COUNT(1) AS cnt
FROM
(
  SELECT member_id, goods_id
  FROM sales_slip
  WHERE member_id = '404779' AND time = 1387222945
) t1,
(
  SELECT member_id, goods_id
  FROM sales_slip
  WHERE member_id = '404779' AND time = 1387222945
) t2
WHERE t1.goods_id < t2.goods_id
GROUP BY t1.goods_id, t2.goods_id
ORDER BY cnt DESC