1.0.348.verify.sql 185 B

1234567
  1. SELECT CASE
  2. WHEN COUNT(*) >= 1
  3. AND SUM(CASE WHEN `status` = 0 THEN 1 ELSE 0 END) = COUNT(*)
  4. THEN 1 ELSE 0
  5. END AS ok
  6. FROM `mdp_entity`
  7. WHERE `entity_code` = 'S3_INVENTORY';