Upload Market images for venezuela

Step 1 - Get SceneTypeCodes and SceneSubTypeCodes

select SceneTypeCategory,SceneTypeCode,SceneTypeName,SceneSubTypeCode
from scenetype A with (NOLOCK)
join Client B with (nolock) on A.ClientID=B.ClientID
where  A.clientid = 173 and /*SceneTypeId = 6831*/ A.isdeleted = 0 --and RESceneType = 95
and SceneTypeName like '%Nevera%'
group by SceneTypeCategory,SceneTypeCode,SceneTypeName,SceneSubTypeCode
order by SceneTypeCode,SceneSubTypeCode asc



Step 2 - Get Scenes for every SceneTypeCode and SubSceneTypeCode

Select Distinct AD.sceneid, 
A.ImageCount, A.ImageStoragePath,A.SceneTypeCode, A.SceneSubTypeCode
from AssetPurityImage AD (NOLOCK)  
Inner join AssetPurity A(NOLOCK) on AD.assetpurityid=A.assetpurityid AND A.IsDeleted =0
where AD.IsDeleted = 0 
and A.SceneTypeCode = 2
and A.SceneSubTypeCode = 7
and A.ClientId = 173
and AD.CreatedOn >= '2024-03-01'
and AD.CreatedOn <= '2024-08-01'
order by AD.sceneid asc



Step 3 - Get Scenes for every SceneTypeCode and SubSceneTypeCode

Select distinct a.AssetPurityImageId, a.assetpurityid, a.filename, a.sceneid, a.puritydatetime, a.createdon, 
a.imagetypeid, b.ImageStoragePath, c.clientcode,a.imageid,a.GroupId,b.ImageCount
from assetpurityimage a join assetpurity b on a.assetpurityid=b.assetpurityid 
join client c on c.clientid=b.clientid
where a.isdeleted=0 and b.IsDeleted=0 and 
a.Sceneid in ()
order by a.sceneid, a.imageid asc

--------------------------------------------------