Skip to content

Instantly share code, notes, and snippets.

@rtanglao
Last active Dec 14, 2015
Embed
What would you like to do?
FF17,FF18,FF19-ff20--top tags first week of Input
name num
crash 1014
freeze 402
website 89
keyboard 41
spam 16
slowness 2
add_ons 1
startup 1
name num
crash 195
freeze 95
website 59
slowness 30
spam 28
unknown 17
ui_issues 16
keyboard 16
flash 13
plugin 11
general 11
privacy 11
startup 9
bookmarks 5
memory 4
sync 3
name num
crash 130
ui_issues 129
unknown 105
website 104
slowness 93
flash 78
freeze 75
customize 51
bookmarks 36
keyboard 36
general 28
add_ons 20
sync 17
privacy 17
spam 15
download 12
memory 7
startup 5
plugin 2
options 2
manufacturer device num
asus Nexus 7 5
samsung GT-I9300 4
samsung SCH-I535 3
HTC ADR6350 3
samsung GT-P3113 3
asus Transformer TF101 3
HTC PC36100 3
LGE Nexus 4 3
samsung Nexus 10 2
samsung SGH-S959G 2
Yulong 5860E 2
asus ASUS Transformer Pad TF300T 2
unknown SoftwinerEvb 2
HTC HTC Wildfire S A510e 2
samsung SPH-D710BST 2
samsung GT-N7100 2
samsung SPH-D710 1
Sony Ericsson LT28at 1
NULL NULL 1
TOSHIBA AT300SE 1
unknown M701C 1
HTC HTC Sensation 1
HTC Nexus One 1
LGE LS670 1
motorola XT907 1
samsung GT-P1010 1
samsung GT-S7500 1
samsung SCH-I500 1
samsung SCH-S720C 1
samsung SPH-D600 1
Sony ST21i2 1
TOSHIBA AT100 1
asus ASUS Transformer Pad TF300TG 1
unknown M1005D 1
HKC P771A 1
YIFANG Next7P12 1
HTC Desire S 1
HTC HTCEVOV4G 1
LGE LG-MS840 1
motorola MB860 1
samsung GT-I9100 1
samsung GT-N8010 1
samsung SAMSUNG-SGH-I897 1
samsung SCH-R920 1
samsung SHW-M180S 1
Sony SGPT13 1
Sony Ericsson ST18a 1
unknown M10 1
GT-I9300 GT-I9300 1
HTC Desire HD 1
LENOVO IdeaTabA2109A 1
motorola DROID RAZR 1
samsung GT-I9003 1
samsung GT-N7105 1
samsung SAMSUNG-SGH-I747 1
samsung SCH-R530U 1
samsung SGH-T989 1
Sony Ericsson MT27i 1
alps Micromax A110 1
unknown GEM7112 1
unknown M710 1
HTC ADR6400L 1
zte X500_USA_General 1
HTC HTC Sensation 4G 1
samsung GT-I8160 1
samsung GT-P3100 1
manufacturer device num
asus Nexus 7 16
samsung GT-I9300 5
samsung GT-N7100 3
samsung Nexus 10 3
Acer A200 3
samsung SGH-I747M 3
motorola DROID RAZR 3
asus ASUS Transformer Pad TF300T 3
samsung GT-N8010 2
NULL NULL 2
motorola DROID2 GLOBAL 2
samsung Galaxy Nexus 2
Acer A500 2
samsung GT-P7510 2
HTC EVO 2
HTC HTC Glacier 2
ZTE Blade 1
motorola DROID BIONIC 1
motorola MB855 1
QMobile A6 1
samsung GT-I9100G 1
samsung GT-P6200 1
Acer A700 1
samsung SAMSUNG-SGH-I547 1
Barnes&Noble BNTV250 1
samsung SCH-R720 1
HKC P771A 1
samsung SGH-T889 1
HTC HTC Desire HD A9191 1
samsung SPH-D710BST 1
HTC HTC One X+ 1
Sony ST23i 1
HUAWEI HUAWEI U8815 1
unknown A13MID 1
LENOVO IdeaTab_A1107 1
unknown M006-Q 1
LGE LS670 1
MID Aurora-II 1
motorola XT901 1
samsung GT-P5113 1
asus Slider SL101 1
samsung SCH-I605 1
Hisense E860 1
samsung SGH-T679 1
HTC HTC Desire HD 1
samsung SPH-D710 1
HTC HTC One X 1
Sony LT30p 1
HTC PC36100 1
TOSHIBA AT100 1
LENOVO A1_07 1
unknown IRULU-AL101 1
LGE LG-P930 1
YIFANG Next7P12-8G 1
LGE VS920 4G 1
ZTE ZTE-Z990G 1
motorola DROID RAZR HD 1
Motorola XOOM 2 ME 1
rockchip MK808 1
samsung GT-P5110 1
samsung SCH-I535 1
Dell Inc. Dell Streak 7 1
samsung SGH-T999 1
Smartfren Andromax U 1
HTC HTCEVOV4G 1
Sony Ericsson ST25i 1
kyocera C5170 1
unknown iBall i6012 1
LGE LG-P925 1
unknown PLAIM900HC 1
ZTE ZTE-N910 1
motorola MZ601 1
rockchip MID 1
samsung GT-I9100P 1
samsung GT-N8013 1
Acer A100 1
Samsung GT-P6800 1
samsung SAMSUNG-SGH-I747 1
Dell Inc. Dell Streak 1
samsung SGH-I317M 1
HTC ADR6330VW 1
samsung SGH-T989 1
HTC HTC Desire X 1
samsung SPH-L710 1
HTC HTC Sensation 1
Sony Ericsson LT28at 1
huawei Prism 1
unknown cm_tenderloin 1
LENOVO ThinkPad Tablet 1
unknown M1050S 1
LGE Nexus 4 1
manufacturer device num
asus Nexus 7 5
samsung GT-N8013 3
samsung GT-P3100 3
TOSHIBA AT100 2
ZTE N860 2
LGE LG-LS970 2
samsung GT-I9300 2
samsung SCH-I800 2
asus ASUS Transformer Pad TF300T 2
samsung Nexus S 2
motorola DROID RAZR HD 2
motorola DROID RAZR 2
samsung Nexus 10 2
samsung SAMSUNG-SGH-I997 1
samsung SCH-S720C 1
samsung SPH-D710BST 1
unknown T02A 1
NULL NULL 1
HTC myTouch_4G_Slide 1
LGE S100(XtremeFlare) 1
motorola MB860 1
samsung GT-S7562 1
samsung SAMSUNG-SGH-I847 1
samsung SPH-D710 1
Sony Ericsson MT27i 1
unknown SoftwinerEvb 1
Yulong 5860E 1
HTC HTC Sensation 1
kyocera C5170 1
LGE Nexus 4 1
motorola MB855 1
samsung GT-I9070 1
samsung GT-N8010 1
samsung GT-P7510 1
samsung SCH-I605 1
samsung SGH-T999 1
samsung YP-G70 1
unknown Micromax P500(Funbook) 1
unknown X708S 1
alps X401 1
HTC HTC One X 1
HUAWEI MediaPad 10 FHD 1
lge LG-P990 1
samsung Galaxy Nexus 1
samsung GT-N7000 1
samsung GT-P5110 1
samsung SCH-I535 1
samsung SGH-T989 1
samsung SPH-L710 1
unknown M10 1
unknown TOUCHMATE 1
Acer A500 1
bn NookColor 1
huawei Huawei U8800-51 1
LGE LG-MS840 1
motorola XT907 1
samsung GT-I9300T 1
SELECT tc.manufacturer, tc.device, count(distinct(ti.comment_id)) as num
FROM input_comments.tags t
JOIN input_comments.tag_items ti ON ti.tag_id = t.id
JOIN input_comments.comments tc ON ti.comment_id = tc.id
WHERE
tc.created > "2013-02-19"
AND tc.created < "2013-02-25"
AND t.name = 'freeze'
AND tc.version = "19.0"
GROUP BY tc.manufacturer, tc.device ORDER BY num DESC;
SELECT t.name, count(distinct(ti.comment_id)) as num
FROM input_comments.tags t
JOIN input_comments.tag_items ti ON ti.tag_id = t.id
JOIN input_comments.comments tc ON ti.comment_id = tc.id
WHERE
tc.created > "2013-04-02"
AND tc.created < "2013-04-08"
AND tc.version = "20.0.0"
GROUP BY t.name ORDER BY num DESC;
name num
ui_issues 418
website 234
unknown 135
customize 113
crash 111
slowness 106
freeze 99
video_codecs 98
bookmarks 72
general 67
flash 57
keyboard 38
privacy 36
add_ons 27
download 24
sync 20
spam 10
plugin 5
memory 3
options 1
@iamjayakumars
Copy link

iamjayakumars commented Mar 5, 2013

My Mobile is Samsung S2 - Jelly Bean

*Website is loading slow

Not Crashed...

Loading

@rtanglao
Copy link
Author

rtanglao commented Mar 12, 2013

which website @iamjayakumars ?

Loading

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment