select * from (
SELECT       dm.id_entregable, dm.dataProjectReference, dm.seisAcquisitionType, dm.seisEnvironment, dm.seisAreaName, dm.dataStudyName, dm.sdmStandardsVersion, dm.dataShipID, dm.sdmConsecutivo, dm.dataShipID AS itemKey , count(dmr.itemkey)        AS mediaCount
FROM         catalog_DeliverableMetadata      AS DM
INNER JOIN   catalog_DeliverableMediaRelation AS DMR
ON           DMR.sdmShipmentDeliverableID      = DM.sdmShipmentDeliverableID
WHERE        (dm.SdmDeliverableStatus     IN
                    ('Ready to load',
                     'Ready for More Data',
                     'Ready to QC',
                     'Ready For Data QC')
             )
GROUP BY     dm.dataShipID
) AS WORKROUND WHERE 1=1