mysql> SELECT version_raw, COUNT(1) AS count FROM devices WHERE kang=1 GROUP BY version_raw HAVING count > 10 ORDER BY count DESC; +------------------------------------------------------------------------------+-------+ | version_raw | count | +------------------------------------------------------------------------------+-------+ | BOYPPC-SHIFTPDA | 5117 | | NULL | 1572 | | CyanogenMod-7.0.0-RC0-Thunderbolt-KANG | 1008 | | GSBv3.0-CyanogenMod-7.0.2-Eris | 688 | | Elelinux-7.0.0-Hero-v2.0 | 683 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7.02 HTC LEO 042711 | 662 | | CyanogenMod-7-Hiapk-Kievnfreedom | 568 | | HACKDROID-CM7 v.54 by Racht | 536 | | CyanogenMod-7.0.2-RC2-CLIQ-KANG | 518 | | CM7-Ascend-04162011 | 517 | | OpenEVE/CyanogenMod-7.0 | 506 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7.1 HTC LEO 050111 | 493 | | GSBv2.8-CyanogenMod-7.0.0-Eris | 486 | | Elelinux-7.0.0-Hero-v1.9 | 461 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 041311 | 424 | | CyanogenMod-7.0.0-RC0-CLIQXT-KANG | 385 | | XiaoQingGe_2.3_Final | 372 | | Elelinux-7.1.0-Hero-v2.1 | 313 | | xCyanogenPro By slade87 & owain94 | 291 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 041811 | 288 | | CyanogenMod-7.1.0-RC0-N1-KANG | 282 | | GSB v2.9-CyanogenMod-7.0.0-Eris | 263 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 041111 | 238 | | Srom-2.3.3Gingerbread-v1(x8) | 227 | | CyanogenMod-7.0.0-RC1-U8220-KANG | 220 | | samsampig_20110414_3G_MMS_CN | 215 | | CyanogenMod-7 10-Apr-11 by Racht | 214 | | CyanogenMod-7.0.0-RC4-Epic-KANG | 211 | | KTPassionMod V2.3 Stable | 208 | | MCCM GB V3.0 | 207 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 042311 | 206 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 040211 | 201 | | PassionMod CM V2.4 | 198 | | CM7-diyzn.net-c8500 | 197 | | CyanogenMod-7 [NDT GINGER V5.0] | 196 | | xCyanogenPro By Owain94 & Jerpelea | 185 | | CyanogenMod-7.0.0-U8220-KANG | 182 | | | 177 | | CM7-Ascend-04052011 | 176 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 042211 | 172 | | CyanogenMod-7.0.0-Fascinate-KANG | 171 | | odelay_Gingerbread_2.1_Based_on_CM7 | 165 | | CyanogenMod-7 v.41.2 by Racht | 163 | | xCyanogenPro By slade67 & owain94 | 159 | | CyanogenMod-7.0.0-Harmony-KANG | 152 | | Ginger Tazz s.r.e 19 | 147 | | CyanogenMod-7.0.0-RC0-LEO-KANG | 145 | | Spike CM-Gingerbread 7.0.0 Final Desire HD | 140 | | Gin-Tazz 22 | 139 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 041011 | 139 | | CleanDHD v1.20 GB | 138 | | CyanogenMod-7-v3.0.5-MAGLDR-GRI40 | 135 | | CyanogenMod-7.0.2-GALAXY5-KANG | 132 | | xCyanogenShakira By Owain94 & Slade87 | 132 | | samsampig_20110412_3G_MMS_CN | 131 | | CM_N57+Harley's_Kernel | 130 | | Elelinux-7.0.0-RC2-Hero-v1.6 | 130 | | CLIQ2.3-CM7-zyw0426 | 128 | | SoCooo-CM2.3-0422 | 123 | | CM-7.0.0-Desire_D2EXT-1.2.0-Talnaj | 122 | | CM-7.0.0-Desire_D2EXT-1.3.3-Talnaj | 121 | | odelay_Gingerbread_2.0_Based_on_CM7 | 120 | | Elelinux-7.0.0-Hero-3D-Maps | 118 | | Elelinux-7.0.0-RC4-Hero-v1.7.1 | 116 | | xCyanogenMini By Owain94 & Slade87 | 106 | | CyanogenMod-7.1.0-RC0-Optimus2X-KANG | 106 | | CLIQ2.3-CM7-zyw0423 | 104 | | CyanogenMod-CyanogenCARZ-7-6355Sapphire | 103 | | QioXan.G6.OQL.Luar3/GOAPK | 99 | | BOYPPC-SHIFTPDA-SERIES | 98 | | CM-7.0.0-Desire_D2EXT-1.3.2-Talnaj | 97 | | GSBv2.5-CM7.0.0-RC4-Eris | 96 | | Srom-2.3.3Gingerbread-v1 | 92 | | CLIQ2.3SL-CM7-zyw0502 | 92 | | Elelinux-7.0.0-RC4-Hero-v1.8 | 90 | | CLIQ2.3-CM7-zyw0501 | 88 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 040711 | 86 | | GSBv2.7-CyanogenMod-7.0.0-RC4-Eris | 84 | | CLIQ2.3SL-CM7-zyw0426 | 82 | | CyanogenMod-CyanogenCARZ-7-04232011-6355Sapphire | 82 | | meXdroidMod meXperia V2 FAST | 81 | | Pure Google Mod 0.8 (by @Amethystxx) | 79 | | CM4Morrison 2.3 | 77 | | CyanogenMod-7.0.2.1-Supersonic | 76 | | -=MDJ's CyanogenMod 7.1.0 RC0 v.1.0=- | 74 | | SoCooo-CM2.3-0424 | 73 | | GSB.v3.1-CyanogenMod-7.1.0-RC0-Eris | 73 | | odelay_Gingerbread_RC2.2_Based_on_CM7 | 71 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 032911 | 69 | | meXdroidMod meXperia V2 | 69 | | TehDuckUberDistro-7-04012011-NIGHTLY-Desire[TyphooN_v2.9.2-MAGLDR] | 68 | | CyanogenMod-CyanogenCARZ-7-04112011-NIGHTLY-DS | 68 | | JaguaralaniGB-CLEAN | 65 | | CLIQ2.3SL-CM7-zyw0423 | 64 | | CyanogenMod-7.1.0-RC0-G2x-KANG | 64 | | samsampig_20110425_3G_MMS_CN | 64 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 032611 | 63 | | xCyanogenPro By Owain94 & Slade87 | 62 | | HACKDROID-CM7-RC4 04-Apr-2011 by Racht | 62 | | CM7-Ascend-05022011 | 61 | | CM7-Ascend-05012011 | 58 | | CyanogenMod-7.0.1-N1-KANG | 57 | | CyanogenMod-7.0.2-N1-KANG | 57 | | Rock Steady (4-21-11) | 57 | | CleanDHD_v1.41 | 53 | | CyanogenMod-7.0.0-RC4-Betelgeuse-KANG | 52 | | CyanogenMod-7.0.0 | 51 | | GSBv2.2-CM7.0.0-RC0-Desirec | 51 | | CLIQ-CM2.3SL-zyw0419 | 51 | | CyanogenMod-7.0.0-N1-KANG | 49 | | CyanogenMod-7.1.0.t5-click | 47 | | CyanogenMod 6.1.3 pza | 46 | | CM-7.0.0-Desire_D2EXT-1.1.2-Talnaj | 46 | | CLIQ-CM2.3-zyw | 45 | | Junyo modified version, thanks to CM to provide, based on the CM41 | 44 | | CyanogenMod-7.0.1 - JRsoft 233GRI40-29/04/11 | 43 | | goapk_defy_2.3.3_v1.0 | 41 | | Elelinux-7.0.0-RC4-Hero-v1.7 | 41 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 042511 | 41 | | Kisoul-Patched-CM7-2.3.3-Stable | 41 | | CyanogenMod-7 v.41 by Racht | 41 | | CyanogenMod-7.1.0-RC0-Betelgeuse-KANG | 40 | | PassionMod CM V2.3 Stable+ | 40 | | GSBv2.6-CyanogenMod-7.0.0-RC4-Eris | 39 | | odelay_Gingerbread_RC1.3_Based_on_CM7 | 39 | | meXdroidMod meXperia remeX | 39 | | F1 CyanogenMod 7 V2 | 38 | | CyanogenMod-7-v3.1.0-[GRI40] | 38 | | CyanogenMod-7-MMuzzy-050111-Inc | 37 | | CyanogenMod-7.0.1 - JRsoft 233GRI40-24/04/11 | 36 | | samsampig_cn_20110411_3G | 36 | | CM-7.0.0-Desire_D2EXT-1.0-Talnaj | 35 | | GingerMod v1.0.1 | 35 | | CleanDHD_v1.40 | 35 | | SoCooo_CM2.3_0501 | 35 | | CLIQ2.3SL-CM7-zyw0501 | 35 | | ZeRoXS.V3 | 33 | | DragonCM-7.1.0-RC0-glacier-KANG | 33 | | Gingerbread 2.3.3 [NDT GINGER 2.3.3 V4.0] | 33 | | odelay_Gingerbread_RC1.5_Based_on_CM7 | 32 | | CyanogenMod-7.0.1 - JRsoft 233GRI40-17/04/11 | 32 | | Pure Google Mod 0.7 (by @Amethystxx) | 32 | | CyanogenMod-7.1.0-RC0-glacier-KANG | 32 | | samsampig-20110402-33-3G-768 | 32 | | CM7-PNK-Mighty.Nutella | 32 | | GSBv2.4-CM7.0.0-RC3-Eris | 31 | | sandroid-IRN-buzz-2.3 (SanGingeroid) | 31 | | samsampig_20110423_3G_MMS_CN | 31 | | CyanogenMod-7.0.2.1-N1 | 30 | | CyanogenMod-7.0.0-RC4-Ideos-KANG | 30 | | CyanogenMod-7.1.0-encore-KANG | 29 | | PyroMod 2.0 Auto-Speedy Wipe | 29 | | CM-7.0.2-RC1-XUYANG-ME501 | 28 | | MDJ's Ultimate Droid HD v.1.3 | 28 | | xCyanogenPro By slade87 & owain94 Tweaked | 27 | | F1 CyanogenMod 7 V1 | 27 | | CyanogenMod-7-v3.0.5 [GRI40] | 27 | | GingerMod v0.9 | 26 | | CyanogenMod-7.0.2.t2-click | 26 | | PyroMod 1.6 Auto-Speedy Ginger | 25 | | XiaoQingGe_2.3 | 25 | | CyanogenMod-7-PowerSave | 24 | | CM7-Ascend-04032011-BUILD1 | 23 | | Junyo special modified version 2011-04-27,Thanks CM | 23 | | CyanogenMod-7.0.0 - JRsoft 233GRI40-11/04/11 | 21 | | CLIQ2.3-CM7-zyw0417 | 21 | | CyanogenMod-7.0.2.1-Inc | 20 | | CyanogenMod-7-Final-Negro90-V.4-MAGLDR | 20 | | samsampig_20110421_3G_MMS_CN | 20 | | CleanDHD_CM_GB_v1.10 | 20 | | CyanogenMod-7.0.0-RC4-Harmony-KANG | 19 | | CyanogenMod-7.1.0-RC0-Blade-KANG | 19 | | CLIQ-CM2.3SL-zyw | 19 | | CyanogenMod-7.1.0-RC0-DesireHD-KANG | 19 | | Pure Google Mod 0.4 (by @Amethystxx) | 18 | | Rock Steady (5-1-11) | 18 | | CyanogenMod-7.0.0-U8120-KANG | 17 | | CyanogenMod-7.0.0-RC0-Vibrant-KANG | 17 | | CM-7.0.0-Desire_D2EXT-1.1.0-Talnaj | 17 | | TyphooN_v3.0.0-MAGLDR | 17 | | CyanogenMod-7.1.0-NS-KANG | 17 | | samsampig-20110329-30-3G | 16 | | CyanogenMod-7.0.2.1-Desire | 16 | | Ginger Tazz 18 | 16 | | CyanogenMod-7.1.0-RC0-Z71-KANG | 16 | | TehDuckUberDistro-7-04012011-NIGHTLY-Blade | 16 | | Ginger Tazz 15 | 16 | | Condemned CM7 V5 | 15 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7 HTC LEO 040611 | 15 | | PyroMod 2.0 Auto-Speedy NoWipe | 15 | | CyanogenMod-7.0.0-RC4-N1-KANG | 15 | | CyanogenMod-7.0.0-Supersonic-KANG | 15 | | CLIQ2.3-CM7-zyw0503 | 15 | | cope & warrenb present: AmeriCanAndroid GB233 CyanogenMod7.02 HTC LEO 042811 | 15 | | CyanogenMod-7.1.0-Droid-KANG | 14 | | CyanogenMod-7.0.2.1-Desire[TyphooN_v3.1.3-MAGLDR] | 14 | | CLIQ2.3SL-CM7-TWGX0424 | 14 | | CM-7.0.0-Desire_D2EXT-1.2.1-Talnaj | 14 | | CyanogenMod-7.0.0-GALAXY5-KANG | 14 | | CyanogenMod-7.1.0-RC0-vision-KANG | 13 | | Elelinux-7.0.0-RC2-Hero-3D maps | 13 | | CyanogenMod-7-Stable-2 | 13 | | CyanogenMod-CARZ-7.0.0-RC3-DS | 12 | | Ginger Tazz 17 | 12 | | odelay_Gingerbread_RC1.4_Based_on_CM7 | 12 | | CyanogenMod-7-v3.0.1 [GRI40] | 12 | | Gin-Tazz 20 | 12 | | TehDuckUberDistro-7-04012011-NIGHTLY-Droid | 12 | | JaguaralaniGB-Arabic | 12 | | GSBv2.3-CyanogenMod-7.0.0-RC2-Eris | 12 | | samsampig_20110411_3G_final | 12 | | Black_version_1 | 12 | | CM7-0425-NIGHTLY-CLIQXT | 12 | | Pirate Rum Gingerbread 2.3.286 | 11 | | CyanogenMod-CyanogenCARZ-7-RC4-6355Sapphire | 11 | | CyanogenMod-7.0.0-RC4-Inc-KANG | 11 | | BlazingDragon2x v0.1 | 11 | | MuMaYi_Rom_v1.5-CM7_RC4_Lite-Desire_HD | 11 | | samsampig-20110402-33-3G-691 | 11 | | CyanogenMod-CyanogenCARZ-7-04062011-NIGHTLY-DS | 11 | | CyanogenMod-7.0.2-Blade-KANG | 11 | +------------------------------------------------------------------------------+-------+