#
# old_revision [a1e9c333ea01ba1740a775e263ee586a43f5eddb]
#
# patch "pf/lib/pf/os.pm"
#  from [ca14f54db6eca66a86331969949b4a8d5e1863d9]
#    to [fc0c1e56057b51045b99a9d3582f8d747ecad4f7]
#
============================================================
--- pf/lib/pf/os.pm	ca14f54db6eca66a86331969949b4a8d5e1863d9
+++ pf/lib/pf/os.pm	fc0c1e56057b51045b99a9d3582f8d747ecad4f7
@@ -64,8 +64,15 @@ sub os_db_prepare {
 
     $os_statements->{'os_mapping_add_sql'} = get_db_handle()->prepare(qq [ INSERT INTO os_mapping(os_type,os_class) VALUES(?,?) ]);
 
-    $os_statements->{'dhcp_fingerprint_view_sql'} = get_db_handle()->prepare(
-        qq [ SELECT d.fingerprint,o.os_id,o.description as os,c.class_id,c.description as class FROM dhcp_fingerprint d LEFT JOIN os_type o ON o.os_id=d.os_id LEFT JOIN os_mapping m ON m.os_type=o.os_id LEFT JOIN os_class c ON  m.os_class=c.class_id WHERE d.fingerprint=? GROUP BY c.class_id ORDER BY class_id ]);
+    $os_statements->{'dhcp_fingerprint_view_sql'} = get_db_handle()->prepare(qq[
+         SELECT d.os_id AS id, d.fingerprint, o.description AS os, c.class_id AS classid, c.description AS class
+         FROM dhcp_fingerprint d 
+            LEFT JOIN os_type o ON o.os_id=d.os_id 
+            LEFT JOIN os_mapping m ON m.os_type=o.os_id 
+            LEFT JOIN os_class c ON  m.os_class=c.class_id 
+         WHERE d.fingerprint=? 
+         GROUP BY c.class_id 
+         ORDER BY class_id ]);
 
     $os_statements->{'dhcp_fingerprint_view_all_sql'} = get_db_handle()->prepare(qq[
         SELECT d.os_id AS id, d.fingerprint, o.description AS os, c.description AS class