56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
*
FROM
t_product
WHERE
c_sid
IN
( SELECT
c_id
FROM
(SELECT c_id FROM t_shops AS result1 WHERE c_ditclass=17 LIMIT 随机数,5 )
AS result2
)
GROUP BY c_sid
#随机数查询语句:SELECT FLOOR(0+RAND()*(SELECT count(c_id) FROM t_shops WHERE c_ditclass=17)-1-0+1)