Rfs2AKPF

1SELECT a1.*, ( SELECT COUNT(reg) FROM auction a2 WHERE reg = a1.reg) AS c1 FROM auction a1
2
3
4CREATE TABLE IF NOT EXISTS `db1` (
5  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
6  `adate` varchar(10) NOT NULL,
7  `lnu` int(4) NOT NULL,
8  `reg` varchar(9) NOT NULL,
9  `mk` varchar(50) NOT NULL,
10  `mod` varchar(50) NOT NULL,
11  `type` varchar(25) NOT NULL,
12  `ree` varchar(50) NOT NULL,
13  `co` varchar(50) NOT NULL,
14  `fu` varchar(20) NOT NULL,
15  `tran` varchar(20) NOT NULL,
16  `mt` varchar(9) NOT NULL,
17  `mile` int(6) NOT NULL,
18  `ree` int(6) NOT NULL,
19  `apv` int(6) NOT NULL,
20  `ds` int(2) NOT NULL,
21  `sr` varchar(50) NOT NULL,
22  `sen` int(10) NOT NULL,
23  `keep` int(2) unsigned NOT NULL,
24  `tmp` char(1) DEFAULT NULL,
25  `rk` varchar(100) DEFAULT NULL,
26  `st` varchar(3) DEFAULT NULL,
27  `dd` varchar(10) DEFAULT NULL,
28  PRIMARY KEY (`id`),
29  KEY `date` (`adate`)
30	
31SELECT a1.*, a2.totalCount
32FROM    auction a1
33        INNER JOIN 
34        (
35            SELECT reg, COUNT(*)  totalCount
36            FROM auction a2
37            GROUP BY reg
38        ) a2 
39            ON a2.reg = a1.reg
40	
41SELECT a1.*, a2.cnt
42FROM auction a1
43INNER JOIN
44(
45    SELECT COUNT(reg) cnt, reg
46    FROM auction
47    GROUP BY reg
48) a2
49    on a1.reg = a2.reg