모니터링 오류 및 남은거 SQL문

(select a.pvrid
  FROM 
  (SELECT pvrid FROM blur_residue) as a
  LEFT OUTER JOIN blur_process as b
  ON a.pvrid = b.pvrid WHERE b.touch IS NULL order by RAND());

  (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 = 30) AS bp
  ON bp.pvrid = pvr.pvrid
  WHERE pvr.hidden = 0);

• 오류 스티칭

select object.* from pvr left join
(SELECT job.* FROM job right join
(SELECT pvrid from
(SELECT *, COUNT(*), AVG(touch) as t from
(SELECT bp.*, g.content from blur_process AS bp left join
(SELECT pvrid, content from
(SELECT a.pvrid, a.content from report AS a
JOIN job as b ON a.pvrid = b.pvrid
WHERE a.job = 300 and a.state = 20)
AS a
) AS g
ON bp.pvrid = g.pvrid
WHERE g.pvrid IS not NULL
ORDER BY bp.pvrid) AS final
group BY pvrid HAVING COUNT(*) = 1) AS fi
WHERE t = 20) AS object
ON job.pvrid=object.pvrid
WHERE object.pvrid IS not NULL
AND state = 40) as object

on pvr.pvrid = object.pvrid
where object.pvrid is not NULL
and pvr.hidden = 0