SELECT DISTINCT clp.product_id FROM yklb_category_lv_product clp LEFT JOIN yklb_product p ON (p.product_id = p.product_id) WHERE clp.categoty_di = 6 AND p.status = 1 AND p.quantity > 0 AND p.price > 0 AND p.date_available <= NOW() ORDER BY RAND() LIMIT 0,6