Scenes by Model or Subscene

SELECT a.AssetPurityId, a.SessionUid, a.SceneUid, a.SceneId, a.SceneTypeCode, a.SceneSubTypeCode, a.ImageCount
FROM AssetPurity a
WHERE a.CreatedOn >= '2025-05-01'
AND a.IsDeleted = 0
AND a.ClientId = 425 --Henkel
and A.SceneTypeCode = 2
and SceneSubTypeCode in (14,13,9,8,6,5,1)

SELECT a.AssetPurityId, a.SessionUid, a.SceneUid, a.SceneId, a.SceneTypeCode, a.SceneSubTypeCode, a.ImageCount, a.CreatedOn
FROM AssetPurity a
WHERE a.CreatedOn >= '2025-05-01'
AND a.IsDeleted = 0
AND a.ClientId = 425 --Henkel
AND a.IRModelTypeId = 8
select * from IRModelType