Confusing SQL query in article full view

There is a query in article full view which will return the id of the record, while the record id is already known ....

SELECT fv2.record_id 

  FROM hsb0a_js_res_record_values AS fv2 

  WHERE fv2.section_id = 1 

  AND fv2.field_key = 'k8a53d8bb2823a3b402d48ef0435779ab' 

  AND fv2.field_value IN (SELECT fv1.field_value 

  FROM hsb0a_js_res_record_values fv1 

  WHERE fv1.field_key = 'k8a53d8bb2823a3b402d48ef0435779ab' 

  AND  fv1.record_id = 96762)