select Device.description, count(host_links.device_id) as cnt from host_links, Device where host_links.Device_id=Device.id and Device.class='VIDEO' group by host_links.device_id order by cnt desc limit 20;
Intel Corporation|Mobile 945GM/GMS/940GML Express Integrated Graphics Controller|102
Intel Corporation|82852/855GM Integrated Graphics Device|63
nVidia Corporation|NV34 [GeForce FX 5200]|61
Intel Corporation|Mobile 915GM/GMS/910GML Express Graphics Controller|54
ATI Technologies Inc|Rage XL|39
nVidia Corporation|NV11 [GeForce2 MX/MX 400]|39
nVidia Corporation|NV43 [GeForce 6600/GeForce 6600 GT]|31
Intel Corporation|82865G Integrated Graphics Controller|30
ATI Technologies Inc|Radeon R250 [Mobility FireGL 9000]|26
ATI Technologies Inc|Radeon Mobility M7 LW [Radeon Mobility 7500]|26
ATI Technologies Inc|RV350 [Mobility Radeon 9600 M10]|23
nVidia Corporation|NV43 [GeForce 6600]|23
nVidia Corporation|NV43 [GeForce 6600 GT]|23
Intel Corporation|82945G/GZ Integrated Graphics Controller|22
nVidia Corporation|G70 [GeForce 7600 GT]|22
ATI Technologies Inc|RV370 5B60 [Radeon X300 (PCIE)]|21
ATI Technologies Inc|RV370 [Radeon X300SE]|21
ATI Technologies Inc|Radeon RV100 QY [Radeon 7000/VE]|20
Intel Corporation|82915G/GV/910GL Integrated Graphics Controller|18
Matrox Graphics, Inc.|MGA G400/G450|17