Massman Posted January 12, 2017 Share Posted January 12, 2017 Kaby Lake Statistics 964 overclocking results 132 overclockers [table=head]{colsp=2}Hardware Statistics Top-5 Motherboard Brands | ASUS, GIGABYTE, MSI Top-5 Mainboards (users) | GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Formula, ASUS ROG Maximus IX Hero, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Apex Top-5 Mainboards (submissions) | GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Apex, ASUS ROG Maximus IX Formula, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Hero Top-5 Memory Brand (users) | G.SKILL, Corsair, Samsung, Kingston, GALAX Top-5 CPU SKU | Core i7 7700K, Core i7 7500U, Core i5 7600K, Core i5 7200U, Core i3 7350K Top-5 CPU Cooling | Liquid Nitrogen (50.65%), AIO Water (15.45%), Water cooling (10.94%), Air cooling (6.91%), Cascade (3.17%)[/table] Last updated: 15/11/2016 [table=head]{colsp=2}Community Statistics Most Active User | topyoyoguybest, 41 submissions Most Active Team | PURE, 51 submissions Most Active Country | United States, 241 submissions Highest Variety CPUs by User | Overclockers.com, 3 CPUs Highest Variety CPUs by Country | 4 countries, 40 CPUs Highest Variety Motherboards by User | [flag]id.png" > Bboyjezz, 3 motherboards Highest Variety Motherboards by Team | Hardwareluxx.de, 5 motherboards Highest Variety Motherboards by Country | Germany, 14 motherboards[/table] SELECT COUNT(*), COUNT(DISTINCT user_id), COUNT(DISTINCT result.mb_model_id) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219; SELECT COUNT(*), COUNT(DISTINCT mb_model.manufacturer_id) FROM mb_model WHERE mb_model.chipset_id=6391; SELECT manufacturer.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY manufacturer_id ORDER BY COUNT(*) DESC; SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC; SELECT mb_model.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(*) DESC; SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id=6391 AND result.cpucooling_id=9) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC; SELECT result_data.memory_vendor, COUNT(*) FROM result JOIN result_data USING (data_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY memory_vendor ORDER BY COUNT(*) DESC; SELECT cpu_model.model, COUNT(*) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cpu_id ORDER BY COUNT(*) DESC; SELECT cooling.name, COUNT(*)/1321 FROM result JOIN cooling ON (result.cpucooling_id = cooling.cooling_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cooling.cooling_id ORDER BY COUNT(*) DESC; SELECT user.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(*) DESC; SELECT team.teamname, COUNT(*) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(*) DESC; SELECT country.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(*) DESC; SELECT user.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT cpu_id) DESC; SELECT team.teamname, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT cpu_id) DESC; SELECT country.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT cpu_id) DESC; SELECT user.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC; SELECT team.teamname, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC; SELECT country.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.