SELECT wafer.name, device.name
FROM product, specification, waferlot, wafer, testjob, device, devicetest
WHERE product.name = 'Sentirex'
  AND specification.name = 'Sentirex-Color-Experiment'
  AND devicetest.STATUS = 'FINISHED'
  AND waferlot.product_id = product.id
  AND wafer.waferlot_id = waferlot.id
  AND testjob.wafer_id = wafer.id
  AND testjob.specification_id = specification.id
  AND device.wafer_id = wafer.id
  AND devicetest.testjob_id = testjob.id
  AND devicetest.device_id = device.id
  AND (SELECT VALUE
         FROM devicetest_values_double
        WHERE variable = 'non_correctable_pixels_total'
          AND devicetest_id = devicetest.id
      ) <= 0
  AND (SELECT VALUE
         FROM devicetest_values_double
        WHERE variable = 'defect_pixels_total'
          AND devicetest_id = devicetest.id
      ) > 30000