85dKjchj

1DROP TABLE IF EXISTS `DB`.`tblNew`;
2CREATE TABLE  `DB`.`tblNew` (
3 `NumberPK` int(10) unsigned NOT NULL,
4 `Count` int(10) unsigned NOT NULL,
5 PRIMARY KEY (`NumberPK`)
6) ENGINE=MyISAM DEFAULT CHARSET=latin1;
7	
8DROP TABLE IF EXISTS `DB`.`tblPrev`;
9CREATE TABLE  `DB`.`tblPrev` (
10 `NumberPK` int(10) unsigned NOT NULL,
11 `Count` int(10) unsigned NOT NULL,
12 PRIMARY KEY (`NumberPK`)
13) ENGINE=MyISAM DEFAULT CHARSET=latin1;
14	
15SELECT
16 gvNew.NumberPK
17FROM
18 tblNew AS gvNew
19LEFT OUTER JOIN
20 tblPrev AS gvPrev ON gvNew.NumberPK = gvPrev.NumberPK
21ORDER BY gvNew.Count - IFNULL(gvPrev.Count, 0) DESC
22LIMIT 10