union hidden 미포함 실수

SELECT pvr.pvrid FROM pvr RIGHT join
  (SELECT pvrid FROM
  (SELECT *, COUNT(*), AVG(touch) AS t from blur_process AS bp
  group by pvrid having COUNT(*) > 0 ORDER BY RAND())
  AS a WHERE t = 3) AS bp
ON bp.pvrid = pvr.pvrid
WHERE pvr.hidden = 0