Hand Roll Towel, 80m/Roll, 16 Rolls / Carton

  • (image for) Hand Roll Towel, 80m/Roll, 16 Rolls / Carton
Price Unavailable
SELECT p.products_id, p.products_image, p.master_categories_id, p.products_quantity, p.product_is_call, p.products_date_available, p.products_date_added, max(o.date_purchased) as date_purchased FROM orders_products opa, orders_products opb, orders o, products p WHERE opa.products_id = '6690' AND opa.orders_id = opb.orders_id AND opb.products_id != '6690' AND opb.products_id = p.products_id AND opb.orders_id = o.orders_id AND p.products_status = 1 GROUP BY p.products_id, p.products_image ORDER BY date_purchased desc, p.products_id