블러링 통계

Object - bluring 개수 맞추기

select count(*) from report as a
JOIN job as b ON a.pvrid = b.pvrid 
WHERE a.job = 300 and a.state = 20;

• 4424 → 5176

select count(*) from report as a
JOIN job as b ON a.pvrid = b.pvrid 
WHERE a.job = 300 and a.state = 20 and b.state = 20;

• 2570 → 3861

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;

• 1374 → 698

a - b - c = 480→ 617

업게레이드 hidden 빼고

SELECT  * FROM pvr LEFT join
(SELECT a.* from report as a
JOIN job as b ON a.pvrid = b.pvrid 
WHERE a.job = 300 and a.state = 20) AS ad
ON pvr.pvrid = ad.pvrid
WHERE ad.pvrid IS NOT NULL
AND hidden = 0;

• 5017 → 5016 → 5014 → 5013 → 5086 → 5186 → 5231 → 5225

SELECT  * FROM pvr LEFT join
(select a.* from report as a
JOIN job as b ON a.pvrid = b.pvrid 
WHERE a.job = 300 and a.state = 20 and b.state = 20 GROUP BY pvrid) AS ad
ON pvr.pvrid = ad.pvrid
WHERE ad.pvrid IS NOT NULL
AND hidden = 0;

• 3862 → 3888 → 3910 → 3936 → 4042 → 4065 → 4238 → 4351

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;

• 647 → 636 → 597 → 557 → 514 → 605 → 450 → 396

a - b - c = 508 → 492 → 507 → 520 → 530 → 516 → 543 → 478

에러 스티칭 꼐속 나옴..

SELECT content, job.*  FROM job right join
(SELECT pvrid, content 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

• 9 →

스티칭 20못된녀석

SELECT * FROM report
WHERE
content = '이미지 손실 에러,'
AND
state = 0

• 1805 →