-- explain verbose
select class.id from operprim, class, oper, inst where
  class.code = operprim.primcode and
  oper.code = operprim.opercode and
  inst.code = operprim.instcode and
  oper.id = 'LAD2' and
  inst.id = 'PROD';