select DISTINCT o.*,g.type_id from es_goods g, es_order o , es_order_items i w
select DISTINCT o.*,g.type_id from es_goods g, es_order o , es_order_items i
where o.disabled=0 and pay_status=1 and g.goods_id=i.goods_id and o.order_id=i.order_id

#20111130021916