select
col1被り数,col2被り数,col3被り数,
code1,code2,code3
from
(
select code, count(code) as col1被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a
group by code ) c1,
(
select code, count(code) as col2被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a
group by code ) c2,
(
select code, count(code) as col3被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a
group by code ) c3,
parts p
where
p.code1=c1.code and
p.code2=c2.code and
p.code3=c3.code
order by p.no;
c2VsZWN0CiBjb2wx6KKr44KK5pWwLGNvbDLooqvjgormlbAsY29sM+iiq+OCiuaVsCwKIGNvZGUxLGNvZGUyLGNvZGUzIApmcm9tIAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wx6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMxLAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wy6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMyLAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wz6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMzLApwYXJ0cyBwCndoZXJlCiBwLmNvZGUxPWMxLmNvZGUgYW5kCiBwLmNvZGUyPWMyLmNvZGUgYW5kCiBwLmNvZGUzPWMzLmNvZGUgCm9yZGVyIGJ5IHAubm87Cg==