Hi, I have an inheritance hierarchy mapped in Hibernate using union-subclass and I have noticed that the generated sql queries for any one of the subclasses ends up including absolutely everything from all of the mapped subclasses. I'd like for just the needed properties to be selected. I've include the main mapping file below as well as one of the generated queries. Thanks in advance for any suggestions.

Hibernate version: 3.2.6ga

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-access="field" default-lazy="false">
<class name="collective.md.image.BaseVersionedAsset" abstract="true" optimistic-lock="version">
<id name="id" unsaved-value="null">
<generator class="hilo" />
</id>
<version name="ver" />
<set name="assetGroups" table="AssetGroupAssignments" lazy="true">
<key column="assetId" />
<many-to-many class="collective.md.image.group.AssetGroup" column="groupId" />
</set>

<set name="assetVersions" lazy="true" cascade="all">
<key column="parentAsset"/>
<one-to-many class="collective.md.image.AssetVersion"/>
</set>

<union-subclass name="collective.md.image.Asset" table="DirectorAsset" >
<property name="filename" not-null="true" index="filename"/>
<property name="releaseDate" index="idx_releaseDate" />
<property name="expirationDate" index="idx_expirationDate" />
<property name="dateDeleted"/>

<many-to-one name="currentVersion" class="collective.md.image.AssetVersion" />

<property name="conversionStatus" type="collective.dataaccess.enumtypes.AssetConversionStatusType" />

<property name="updateLinkSystem" />

<set name="categories" table="AssetCategoryAssignments" lazy="true" >
<key column="asset_id"/>
<many-to-many class="collective.search.category.AssetCategory" column="category_id" />
</set>

<many-to-one name="assetProducer" class="collective.md.image.AssetProducer" />

<property name="starred" />
<property name="locked" />
</union-subclass>

<union-subclass name="collective.md.image.ProofAsset" table="ProofAsset">
<property name="filename" not-null="true" index="filename"/>
<property name="releaseDate" index="idx_releaseDate" />
<property name="expirationDate" index="idx_expirationDate" />
<property name="dateDeleted"/>

<many-to-one name="currentVersion" class="collective.md.image.AssetVersion" access="field"/>

<property name="conversionStatus" type="collective.dataaccess.enumtypes.AssetConversionStatusType" />
<many-to-one name="proof" class="collective.mc.Proof"/>

<property name="updateLinkSystem" />
</union-subclass>

<union-subclass name="collective.md.image.PhotoAsset" table="PhotoAsset">
<property name="filename" not-null="true" index="filename"/>
<property name="releaseDate" index="idx_releaseDate" />
<property name="expirationDate" index="idx_expirationDate" />
<property name="dateDeleted"/>

<many-to-one name="currentVersion" class="collective.md.image.AssetVersion"/>
<many-to-one name="photo" class="collective.pa.Photo"/>

<property name="conversionStatus" type="collective.dataaccess.enumtypes.AssetConversionStatusType" />

<property name="updateLinkSystem" />
</union-subclass>

<filter name="excludeDeleted" condition="dateDeleted is null"/>
</class>
<filter-def name="excludeDeleted"/>
</hibernate-mapping>

Name and version of the database you are using: SQL Server 2005

The generated SQL (show_sql=true):
select assets0_.portfolioId as portfoli1_45_, assets0_.assetId as assetId45_, assets0_.idx as idx45_, asset1_.id as id86_0_, asset1_.ver as ver86_0_, asset1_.filename as filename88_0_, asset1_.releaseDate as releaseD2_88_0_, asset1_.expirationDate as expirati3_88_0_, asset1_.dateDeleted as dateDele4_88_0_, asset1_.currentVersion as currentV5_88_0_, asset1_.conversionStatus as conversi6_88_0_, asset1_.updateLinkSystem as updateLi7_88_0_, asset1_.assetProducer as assetPro8_88_0_, asset1_.starred as starred88_0_, asset1_.locked as locked88_0_, assetversi2_.id as id77_1_, assetversi2_.ver as ver77_1_, assetversi2_.originalFile as original3_77_1_, assetversi2_.metadataId as metadataId77_1_, assetversi2_.legacyId as legacyId77_1_, assetversi2_.defaultView as defaultV6_77_1_, assetversi2_.dateAdded as dateAdded77_1_, assetversi2_.dateUpdated as dateUpda8_77_1_, assetversi2_.originalFilename as original9_77_1_, assetversi2_.parentAsset as parentA10_77_1_, assetversi2_.archived as archived77_1_, assetversi2_.versionNumber as version12_77_1_, assetversi2_.profileOverridesId as profile13_77_1_, assetversi2_.dateDeleted as dateDel14_77_1_, originalfi3_.id as id96_2_, originalfi3_1_.dateDeleted as dateDele2_96_2_, originalfi3_1_.filepathUNC as filepath3_96_2_, originalfi3_1_.filepathMAC as filepath4_96_2_, originalfi3_1_.location as location96_2_, originalfi3_1_.dateCreated as dateCrea6_96_2_, originalfi3_1_.dateProcessed as dateProc7_96_2_, originalfi3_1_.dateConfirmed as dateConf8_96_2_, originalfi3_1_.errorMessage as errorMes9_96_2_, originalfi3_1_.fileSize as fileSize96_2_, originalfi3_1_.fileCreateDate as fileCre11_96_2_, originalfi3_1_.fileModifiedDate as fileMod12_96_2_, originalfi3_1_.fileFormat as fileFormat96_2_, originalfi3_1_.parentFile as parentFile96_2_, originalfi3_1_.conversion as conversion96_2_, originalfi3_1_.XmpID as XmpID96_2_, originalfi3_.filename as filename97_2_, originalfi3_.uploadProfile as uploadPr3_97_2_, originalfi3_.uploader as uploader97_2_, originalfi3_.uploadDate as uploadDate97_2_, originalfi3_.uploadSetKey as uploadSe6_97_2_, fileondisk4_.id as id96_3_, fileondisk4_.dateDeleted as dateDele2_96_3_, fileondisk4_.filepathUNC as filepath3_96_3_, fileondisk4_.filepathMAC as filepath4_96_3_, fileondisk4_.location as location96_3_, fileondisk4_.dateCreated as dateCrea6_96_3_, fileondisk4_.dateProcessed as dateProc7_96_3_, fileondisk4_.dateConfirmed as dateConf8_96_3_, fileondisk4_.errorMessage as errorMes9_96_3_, fileondisk4_.fileSize as fileSize96_3_, fileondisk4_.fileCreateDate as fileCre11_96_3_, fileondisk4_.fileModifiedDate as fileMod12_96_3_, fileondisk4_.fileFormat as fileFormat96_3_, fileondisk4_.parentFile as parentFile96_3_, fileondisk4_.conversion as conversion96_3_, fileondisk4_.XmpID as XmpID96_3_, fileondisk4_1_.filename as filename97_3_, fileondisk4_1_.uploadProfile as uploadPr3_97_3_, fileondisk4_1_.uploader as uploader97_3_, fileondisk4_1_.uploadDate as uploadDate97_3_, fileondisk4_1_.uploadSetKey as uploadSe6_97_3_, fileondisk4_2_.expirationDate as expirati2_98_3_, fileondisk4_2_.regenerateFile as regenera3_98_3_, fileondisk4_3_.originalFilename as original2_100_3_, fileondisk4_4_.filename as filename101_3_, fileondisk4_4_.metadataFileType as metadata3_101_3_, case when fileondisk4_1_.id is not null then 1 when fileondisk4_2_.id is not null then 2 when fileondisk4_3_.id is not null then 3 when fileondisk4_4_.id is not null then 4 when fileondisk4_.id is not null then 0 end as clazz_3_, conversion5_.id as id214_4_, conversion5_.dateDeleted as dateDele3_214_4_, conversion5_.description as descript4_214_4_, conversion5_.displayName as displayN5_214_4_, conversion5_.displayOrder as displayO6_214_4_, conversion5_.lookupKey as lookupKey214_4_, conversion5_.daysRetention as daysRete8_214_4_, conversion5_.hosted as hosted214_4_, conversion5_.embedded as embedded214_4_, conversion5_.amount as amount214_4_, conversion5_.displayamount as display12_214_4_, conversion5_.targetUse as targetUse214_4_, conversion5_.mediaType as mediaType214_4_, conversion5_.isInstant as isInstant214_4_, conversion5_.isInstantDownload as isInsta16_214_4_, conversion5_.permissionSet as permiss17_214_4_, xmpmetadat6_.id as id104_5_, xmpmetadat6_.xmp as xmp104_5_, uploadprof7_.id as id16_6_, uploadprof7_.dateDeleted as dateDele3_16_6_, uploadprof7_.displayName as displayN4_16_6_, uploadprof7_.client as client16_6_, uploadprof7_.releaseDate as releaseD6_16_6_, uploadprof7_.expirationDate as expirati7_16_6_, uploadprof7_.hotFolderEnabled as hotFolde8_16_6_, uploadprof7_.hotFolderAvailableOnAppliance as hotFolde9_16_6_, uploadprof7_.autoResolveInDirector as autoRes10_16_6_, uploadprof7_.sendReleasedEmail as sendRel11_16_6_, uploadprof7_.billable as billable16_6_, uploadprof7_.metadataId as metadataId16_6_, uploadprof7_.permissionSet as permiss14_16_6_, uploadprof7_.defaultHotFolderUser as default15_16_6_, uploadprof7_.autoReleaseProject as autoRel16_16_6_, uploadprof7_.autoVersionInCollaborator as autoVer17_16_6_, uploadprof7_.globalRoute as globalR18_16_6_, uploadprof7_.daysUntilProofDue as daysUnt19_16_6_, uploadprof7_.ownergroup_id as ownergroup20_16_6_, uploadprof7_.routegroup_id as routegroup21_16_6_, uploadprof7_.matcher as matcher16_6_, uploadprof7_.photoScript as photoSc23_16_6_, uploadprof7_.class as class16_6_, user8_.id as id141_7_, user8_.username as username141_7_, user8_.guid as guid141_7_, user8_.hashedPassword as hashedPa5_141_7_, user8_.dateDeleted as dateDele6_141_7_, user8_.pageSize as pageSize141_7_, user8_.listViewPageSize as listView8_141_7_, user8_.clearCart as clearCart141_7_, user8_.forcePasswordChange as forcePa10_141_7_, user8_.receiveRegistrationEmail as receive11_141_7_, user8_.receiveOrderApprovalEmail as receive12_141_7_, user8_.receiveUploadedAssetsEmail as receive13_141_7_, user8_.receiveAssetUploadConflictsEmail as receive14_141_7_, user8_.receiveProjectNotificationsEmail as receive15_141_7_, user8_.expirationDate as expirat16_141_7_, user8_.passwordChangeDate as passwor17_141_7_, user8_.passwordExpirationDays as passwor18_141_7_, user8_.creationDate as creatio19_141_7_, user8_.defaultApplication as default20_141_7_, user8_.photoApprovalDefaultAccountPage as photoAp21_141_7_, user8_.locale as locale141_7_, user8_.orderReferenceNumber as orderRe23_141_7_, user8_.directorViewObject as directo24_141_7_, user8_.frozenUntil as frozenU25_141_7_, user8_.lastLoggedSkin as lastLog26_141_7_, user8_.cart as cart141_7_, user8_.address as address141_7_, user8_.metadataId as metadataId141_7_, user8_.defaultAssetCategory as default30_141_7_, user8_.defaultTemplateCategory as default31_141_7_, user8_.defaultContentCategory as default32_141_7_, user8_.class as class141_7_, cart9_.id as id202_8_, cart9_.displayName as displayN2_202_8_, cart9_.description as descript3_202_8_, cart9_.owner_id as owner4_202_8_, address10_.id as id1_9_, address10_.firstName as firstName1_9_, address10_.lastName as lastName1_9_, address10_.email as email1_9_, address10_.company as company1_9_, address10_.department as department1_9_, address10_.title as title1_9_, address10_.streetAddress as streetAd8_1_9_, address10_.city as city1_9_, address10_.state as state1_9_, address10_.zip as zip1_9_, address10_.country as country1_9_, address10_.phone as phone1_9_, assetcateg11_.id as id154_10_, assetcateg11_.root as root154_10_, assetcateg11_.title as title154_10_, assetcateg11_.dateDeleted as dateDele5_154_10_, assetcateg11_.legacyId as legacyId154_10_, assetcateg11_.description as descript7_154_10_, assetcateg11_.parent as parent154_10_, assetcateg11_.previewAsset as previewA9_154_10_, asset12_.id as id86_11_, asset12_.ver as ver86_11_, asset12_.filename as filename88_11_, asset12_.releaseDate as releaseD2_88_11_, asset12_.expirationDate as expirati3_88_11_, asset12_.dateDeleted as dateDele4_88_11_, asset12_.currentVersion as currentV5_88_11_, asset12_.conversionStatus as conversi6_88_11_, asset12_.updateLinkSystem as updateLi7_88_11_, asset12_.assetProducer as assetPro8_88_11_, asset12_.starred as starred88_11_, asset12_.locked as locked88_11_, assetprodu13_.id as id76_12_, assetprodu13_.photo as photo76_12_, assetprodu13_.proof as proof76_12_, assetprodu13_.version as version76_12_, assetprodu13_.preEntry as preEntry76_12_, assetprodu13_.producerType as producer2_76_12_, photo14_.id as id115_13_, photo14_.version as version115_13_, photo14_.dateAdded as dateAdded115_13_, photo14_.dateTaken as dateTaken115_13_, photo14_.dateDeleted as dateDele5_115_13_, photo14_.updateStatus as updateSt6_115_13_, (select max(event3.id) from PhotoEvents event3 where event3.id in (select eventz.id from PhotoHistories history inner join PhotoEvents eventz on history.event=eventz.id where history.date=( select max(histories3_.date) from Photos photo inner join PhotoHistories histories3_ on photo.id=histories3_.photo_id where photo.id=photo14_.id and histories3_.event is not null) and history.photo_id=photo14_.id ) ) as formula0_13_, assetversi15_.id as id77_14_, assetversi15_.ver as ver77_14_, assetversi15_.originalFile as original3_77_14_, assetversi15_.metadataId as metadataId77_14_, assetversi15_.legacyId as legacyId77_14_, assetversi15_.defaultView as defaultV6_77_14_, assetversi15_.dateAdded as dateAdded77_14_, assetversi15_.dateUpdated as dateUpda8_77_14_, assetversi15_.originalFilename as original9_77_14_, assetversi15_.parentAsset as parentA10_77_14_, assetversi15_.archived as archived77_14_, assetversi15_.versionNumber as version12_77_14_, assetversi15_.profileOverridesId as profile13_77_14_, assetversi15_.dateDeleted as dateDel14_77_14_, assetview16_.id as id0_15_, assetview16_1_.ver as ver0_15_, assetview16_.dateDeleted as dateDele2_78_15_, assetview16_.displayName as displayN3_78_15_, assetview16_.aspectRatio as aspectRa4_78_15_, assetview16_.assetVersionId as assetVer5_78_15_, assetview16_.alternatePreview as alternat6_78_15_, assetview16_.convertedFileSet as converte7_78_15_, assetview16_2_.coordinates as coordina2_79_15_, assetview16_3_.pathName as pathName80_15_, case when assetview16_2_.id is not null then 5 when assetview16_3_.id is not null then 6 when assetview16_4_.id is not null then 7 when assetview16_.id is not null then 4 end as clazz_15_, assetversi17_.id as id77_16_, assetversi17_.ver as ver77_16_, assetversi17_.originalFile as original3_77_16_, assetversi17_.metadataId as metadataId77_16_, assetversi17_.legacyId as legacyId77_16_, assetversi17_.defaultView as defaultV6_77_16_, assetversi17_.dateAdded as dateAdded77_16_, assetversi17_.dateUpdated as dateUpda8_77_16_, assetversi17_.originalFilename as original9_77_16_, assetversi17_.parentAsset as parentA10_77_16_, assetversi17_.archived as archived77_16_, assetversi17_.versionNumber as version12_77_16_, assetversi17_.profileOverridesId as profile13_77_16_, assetversi17_.dateDeleted as dateDel14_77_16_, baseversio18_.id as id86_17_, baseversio18_.ver as ver86_17_, baseversio18_.filename as filename88_17_, baseversio18_.releaseDate as releaseD2_88_17_, baseversio18_.expirationDate as expirati3_88_17_, baseversio18_.dateDeleted as dateDele4_88_17_, baseversio18_.currentVersion as currentV5_88_17_, baseversio18_.conversionStatus as conversi6_88_17_, baseversio18_.updateLinkSystem as updateLi7_88_17_, baseversio18_.assetProducer as assetPro8_88_17_, baseversio18_.starred as starred88_17_, baseversio18_.locked as locked88_17_, baseversio18_.filename as filename90_17_, baseversio18_.releaseDate as releaseD2_90_17_, baseversio18_.expirationDate as expirati3_90_17_, baseversio18_.dateDeleted as dateDele4_90_17_, baseversio18_.currentVersion as currentV5_90_17_, baseversio18_.conversionStatus as conversi6_90_17_, baseversio18_.proof as proof90_17_, baseversio18_.updateLinkSystem as updateLi8_90_17_, baseversio18_.filename as filename91_17_, baseversio18_.releaseDate as releaseD2_91_17_, baseversio18_.expirationDate as expirati3_91_17_, baseversio18_.dateDeleted as dateDele4_91_17_, baseversio18_.currentVersion as currentV5_91_17_, baseversio18_.photo as photo91_17_, baseversio18_.conversionStatus as conversi7_91_17_, baseversio18_.updateLinkSystem as updateLi8_91_17_, baseversio18_.clazz_ as clazz_17_, assetversi19_.id as id77_18_, assetversi19_.ver as ver77_18_, assetversi19_.originalFile as original3_77_18_, assetversi19_.metadataId as metadataId77_18_, assetversi19_.legacyId as legacyId77_18_, assetversi19_.defaultView as defaultV6_77_18_, assetversi19_.dateAdded as dateAdded77_18_, assetversi19_.dateUpdated as dateUpda8_77_18_, assetversi19_.originalFilename as original9_77_18_, assetversi19_.parentAsset as parentA10_77_18_, assetversi19_.archived as archived77_18_, assetversi19_.versionNumber as version12_77_18_, assetversi19_.profileOverridesId as profile13_77_18_, assetversi19_.dateDeleted as dateDel14_77_18_, uploadprof20_.id as id24_19_, uploadprof20_.autoResolveInDirector as autoReso2_24_19_, uploadprof20_.billable as billable24_19_, uploadprof20_.autoReleaseInDirector as autoRele4_24_19_, uploadprof20_.autoVersionInCollaborator as autoVers5_24_19_, uploadprof20_.projectPriority as projectP6_24_19_, uploadprof20_.projectDueDate as projectD7_24_19_, assetprodu21_.id as id76_20_, assetprodu21_.photo as photo76_20_, assetprodu21_.proof as proof76_20_, assetprodu21_.version as version76_20_, assetprodu21_.preEntry as preEntry76_20_, assetprodu21_.producerType as producer2_76_20_, proof22_.id as id64_21_, proof22_.title as title64_21_, proof22_.description as descript3_64_21_, proof22_.closed as closed64_21_, proof22_.dateDeleted as dateDele5_64_21_, proof22_.globalRoute as globalRo6_64_21_, proof22_.closedDate as closedDate64_21_, proof22_.creationDate as creation8_64_21_, proof22_.internal as internal64_21_, proof22_.priority as priority64_21_, proof22_.permissionSet as permiss11_64_21_, version23_.id as id71_22_, version23_.assetVersion as assetVer2_71_22_, version23_.ptc as ptc71_22_, version23_.dateDeleted as dateDele4_71_22_, version23_.dueDate as dueDate71_22_, version23_.dateAdded as dateAdded71_22_, version23_.emailsSent as emailsSent71_22_, version23_.proof_id as proof8_71_22_, version23_.acrobatReviewCommentFolder as acrobatR9_71_22_, ptc24_.id as id285_23_, ptc24_.dateDeleted as dateDele2_285_23_, ptc24_.displayName as displayN3_285_23_, ptc24_.legacyId as legacyId285_23_, ptc24_.pdfPreviewFilepath as pdfPrevi5_285_23_, ptc24_.inDesignFilepath as inDesign6_285_23_, ptc24_.legacyDBIDString as legacyDB7_285_23_, ptc24_.exportStatus as exportSt8_285_23_, ptc24_.reviewStatus as reviewSt9_285_23_, ptc24_.catalogId as catalogId285_23_, ptc24_.oldCatalogId as oldCata11_285_23_, ptc24_.indesignTemplateId as indesig12_285_23_, ptc24_.version as version285_23_, catalog25_.id as id277_24_, catalog25_.dateDeleted as dateDele2_277_24_, catalog25_.displayName as displayN3_277_24_, catalog25_.legacyId as legacyId277_24_, catalog25_.miscExport as miscExport277_24_, catalog25_.catalogType as catalogT6_277_24_, catalog25_.year as year277_24_, catalog25_.active as active277_24_, catalog26_.id as id277_25_, catalog26_.dateDeleted as dateDele2_277_25_, catalog26_.displayName as displayN3_277_25_, catalog26_.legacyId as legacyId277_25_, catalog26_.miscExport as miscExport277_25_, catalog26_.catalogType as catalogT6_277_25_, catalog26_.year as year277_25_, catalog26_.active as active277_25_, indesignte27_.id as id299_26_, indesignte27_.dateDeleted as dateDele3_299_26_, indesignte27_.structure as structure299_26_, indesignte27_.indd_doc as indd5_299_26_, indesigndo28_.id as id298_27_, indesigndo28_.dateDeleted as dateDele2_298_27_, indesigndo28_.displayName as displayN3_298_27_, indesigndo28_.originalFile as original4_298_27_, indesigndo28_.convertedFileSet as converte5_298_27_, originalfi29_.id as id96_28_, originalfi29_1_.dateDeleted as dateDele2_96_28_, originalfi29_1_.filepathUNC as filepath3_96_28_, originalfi29_1_.filepathMAC as filepath4_96_28_, originalfi29_1_.location as location96_28_, originalfi29_1_.dateCreated as dateCrea6_96_28_, originalfi29_1_.dateProcessed as dateProc7_96_28_, originalfi29_1_.dateConfirmed as dateConf8_96_28_, originalfi29_1_.errorMessage as errorMes9_96_28_, originalfi29_1_.fileSize as fileSize96_28_, originalfi29_1_.fileCreateDate as fileCre11_96_28_, originalfi29_1_.fileModifiedDate as fileMod12_96_28_, originalfi29_1_.fileFormat as fileFormat96_28_, originalfi29_1_.parentFile as parentFile96_28_, originalfi29_1_.conversion as conversion96_28_, originalfi29_1_.XmpID as XmpID96_28_, originalfi29_.filename as filename97_28_, originalfi29_.uploadProfile as uploadPr3_97_28_, originalfi29_.uploader as uploader97_28_, originalfi29_.uploadDate as uploadDate97_28_, originalfi29_.uploadSetKey as uploadSe6_97_28_, user30_.id as id141_29_, user30_.username as username141_29_, user30_.guid as guid141_29_, user30_.hashedPassword as hashedPa5_141_29_, user30_.dateDeleted as dateDele6_141_29_, user30_.pageSize as pageSize141_29_, user30_.listViewPageSize as listView8_141_29_, user30_.clearCart as clearCart141_29_, user30_.forcePasswordChange as forcePa10_141_29_, user30_.receiveRegistrationEmail as receive11_141_29_, user30_.receiveOrderApprovalEmail as receive12_141_29_, user30_.receiveUploadedAssetsEmail as receive13_141_29_, user30_.receiveAssetUploadConflictsEmail as receive14_141_29_, user30_.receiveProjectNotificationsEmail as receive15_141_29_, user30_.expirationDate as expirat16_141_29_, user30_.passwordChangeDate as passwor17_141_29_, user30_.passwordExpirationDays as passwor18_141_29_, user30_.creationDate as creatio19_141_29_, user30_.defaultApplication as default20_141_29_, user30_.photoApprovalDefaultAccountPage as photoAp21_141_29_, user30_.locale as locale141_29_, user30_.orderReferenceNumber as orderRe23_141_29_, user30_.directorViewObject as directo24_141_29_, user30_.frozenUntil as frozenU25_141_29_, user30_.lastLoggedSkin as lastLog26_141_29_, user30_.cart as cart141_29_, user30_.address as address141_29_, user30_.metadataId as metadataId141_29_, user30_.defaultAssetCategory as default30_141_29_, user30_.defaultTemplateCategory as default31_141_29_, user30_.defaultContentCategory as default32_141_29_, user30_.class as class141_29_, templateca31_.id as id154_30_, templateca31_.root as root154_30_, templateca31_.title as title154_30_, templateca31_.dateDeleted as dateDele5_154_30_, templateca31_.legacyId as legacyId154_30_, templateca31_.description as descript7_154_30_, templateca31_.parent as parent154_30_, templateca31_.previewAsset as previewA9_154_30_, contentcat32_.id as id154_31_, contentcat32_.root as root154_31_, contentcat32_.title as title154_31_, contentcat32_.dateDeleted as dateDele5_154_31_, contentcat32_.legacyId as legacyId154_31_, contentcat32_.description as descript7_154_31_, contentcat32_.parent as parent154_31_, contentcat32_.previewAsset as previewA9_154_31_, convertedf33_.id as id95_32_, version34_.id as id71_33_, version34_.assetVersion as assetVer2_71_33_, version34_.ptc as ptc71_33_, version34_.dateDeleted as dateDele4_71_33_, version34_.dueDate as dueDate71_33_, version34_.dateAdded as dateAdded71_33_, version34_.emailsSent as emailsSent71_33_, version34_.proof_id as proof8_71_33_, version34_.acrobatReviewCommentFolder as acrobatR9_71_33_, preentryas35_.id as id82_34_, preentryas35_.ver as ver82_34_, preentryas35_.releaseDate as releaseD1_83_34_, preentryas35_.expirationDate as expirati2_83_34_, preentryas35_.filename as filename83_34_, preentryas35_.dateDeleted as dateDele4_83_34_, preentryas35_.metadataId as metadataId83_34_, proof36_.id as id64_35_, proof36_.title as title64_35_, proof36_.description as descript3_64_35_, proof36_.closed as closed64_35_, proof36_.dateDeleted as dateDele5_64_35_, proof36_.globalRoute as globalRo6_64_35_, proof36_.closedDate as closedDate64_35_, proof36_.creationDate as creation8_64_35_, proof36_.internal as internal64_35_, proof36_.priority as priority64_35_, proof36_.permissionSet as permiss11_64_35_, photo37_.id as id115_36_, photo37_.version as version115_36_, photo37_.dateAdded as dateAdded115_36_, photo37_.dateTaken as dateTaken115_36_, photo37_.dateDeleted as dateDele5_115_36_, photo37_.updateStatus as updateSt6_115_36_, (select max(event3.id) from PhotoEvents event3 where event3.id in (select eventz.id from PhotoHistories history inner join PhotoEvents eventz on history.event=eventz.id where history.date=( select max(histories3_.date) from Photos photo inner join PhotoHistories histories3_ on photo.id=histories3_.photo_id where photo.id=photo37_.id and histories3_.event is not null) and history.photo_id=photo37_.id ) ) as formula0_36_, photoevent38_.id as id119_37_, photoevent38_.dateDeleted as dateDele2_119_37_, photoevent38_.displayName as displayN3_119_37_, photoevent38_.inTooltip as inTooltip119_37_, photoevent38_.inListContainer as inListCo5_119_37_, photoevent38_.icon as icon119_37_, photoevent38_.batchable as batchable119_37_, photoevent38_.category as category119_37_, alternatep39_.id as id93_38_, alternatep39_.originalFile as original2_93_38_, alternatep39_.convertedFileSet as converte3_93_38_, originalfi40_.id as id96_39_, originalfi40_1_.dateDeleted as dateDele2_96_39_, originalfi40_1_.filepathUNC as filepath3_96_39_, originalfi40_1_.filepathMAC as filepath4_96_39_, originalfi40_1_.location as location96_39_, originalfi40_1_.dateCreated as dateCrea6_96_39_, originalfi40_1_.dateProcessed as dateProc7_96_39_, originalfi40_1_.dateConfirmed as dateConf8_96_39_, originalfi40_1_.errorMessage as errorMes9_96_39_, originalfi40_1_.fileSize as fileSize96_39_, originalfi40_1_.fileCreateDate as fileCre11_96_39_, originalfi40_1_.fileModifiedDate as fileMod12_96_39_, originalfi40_1_.fileFormat as fileFormat96_39_, originalfi40_1_.parentFile as parentFile96_39_, originalfi40_1_.conversion as conversion96_39_, originalfi40_1_.XmpID as XmpID96_39_, originalfi40_.filename as filename97_39_, originalfi40_.uploadProfile as uploadPr3_97_39_, originalfi40_.uploader as uploader97_39_, originalfi40_.uploadDate as uploadDate97_39_, originalfi40_.uploadSetKey as uploadSe6_97_39_, convertedf41_.id as id95_40_, convertedf42_.id as id95_41_, coordinate43_.id as id92_42_, coordinate43_.dateDeleted as dateDele2_92_42_, coordinate43_.topLeftXPercent as topLeftX3_92_42_, coordinate43_.topLeftYPercent as topLeftY4_92_42_, coordinate43_.bottomRightXPercent as bottomRi5_92_42_, coordinate43_.bottomRightYPercent as bottomRi6_92_42_, coordinate43_.imageHeight as imageHei7_92_42_, coordinate43_.imageWidth as imageWidth92_42_, ownergroup44_.id as id69_43_, ownergroup44_.dateDeleted as dateDele2_69_43_, ownergroup44_.displayName as displayN3_69_43_, ownergroup44_.permissionSet as permissi4_69_43_, routinggro45_.id as id66_44_, routinggro45_.dateDeleted as dateDele2_66_44_, routinggro45_.displayName as displayN3_66_44_, routinggro45_.permissionSet as permissi4_66_44_ from PortfolioAssets assets0_ left outer join DirectorAsset asset1_ on assets0_.assetId=asset1_.id left outer join AssetVersion assetversi2_ on asset1_.currentVersion=assetversi2_.id left outer join OriginalFiles originalfi3_ on assetversi2_.originalFile=originalfi3_.id left outer join FilesOnDisk originalfi3_1_ on originalfi3_.id=originalfi3_1_.id left outer join FilesOnDisk fileondisk4_ on originalfi3_1_.parentFile=fileondisk4_.id left outer join OriginalFiles fileondisk4_1_ on fileondisk4_.id=fileondisk4_1_.id left outer join ConvertedFiles fileondisk4_2_ on fileondisk4_.id=fileondisk4_2_.id left outer join ProcessingFiles fileondisk4_3_ on fileondisk4_.id=fileondisk4_3_.id left outer join ManifestFiles fileondisk4_4_ on fileondisk4_.id=fileondisk4_4_.id left outer join Conversions conversion5_ on fileondisk4_.conversion=conversion5_.id left outer join XMPMetadata xmpmetadat6_ on fileondisk4_.XmpID=xmpmetadat6_.id left outer join UploadProfiles uploadprof7_ on fileondisk4_1_.uploadProfile=uploadprof7_.id left outer join Users user8_ on uploadprof7_.defaultHotFolderUser=user8_.id left outer join Cart cart9_ on user8_.cart=cart9_.id left outer join Addresses address10_ on user8_.address=address10_.id left outer join Category assetcateg11_ on user8_.defaultAssetCategory=assetcateg11_.id left outer join DirectorAsset asset12_ on assetcateg11_.previewAsset=asset12_.id left outer join AssetProducers assetprodu13_ on asset12_.assetProducer=assetprodu13_.id left outer join Photos photo14_ on assetprodu13_.photo=photo14_.id left outer join AssetVersion assetversi15_ on photo14_.version=assetversi15_.id left outer join AssetViews assetview16_ on assetversi15_.defaultView=assetview16_.id left outer join OrderableItem assetview16_1_ on assetview16_.id=assetview16_1_.id left outer join Crops assetview16_2_ on assetview16_.id=assetview16_2_.id left outer join ClipPaths assetview16_3_ on assetview16_.id=assetview16_3_.id left outer join StandardAssetView assetview16_4_ on assetview16_.id=assetview16_4_.id left outer join AssetVersion assetversi17_ on assetview16_.assetVersionId=assetversi17_.id left outer join ( select dateDeleted, expirationDate, null as proof, releaseDate, ver, null as photo, id, assetProducer, updateLinkSystem, starred, filename, currentVersion, conversionStatus, locked, 1 as clazz_ from DirectorAsset union select dateDeleted, expirationDate, proof, releaseDate, ver, null as photo, id, null as assetProducer, updateLinkSystem, null as starred, filename, currentVersion, conversionStatus, null as locked, 2 as clazz_ from ProofAsset union select dateDeleted, expirationDate, null as proof, releaseDate, ver, photo, id, null as assetProducer, updateLinkSystem, null as starred, filename, currentVersion, conversionStatus, null as locked, 3 as clazz_ from PhotoAsset ) baseversio18_ on assetversi17_.parentAsset=baseversio18_.id left outer join AssetVersion assetversi19_ on baseversio18_.currentVersion=assetversi19_.id left outer join UploadProfileOverrides uploadprof20_ on assetversi19_.profileOverridesId=uploadprof20_.id left outer join AssetProducers assetprodu21_ on baseversio18_.assetProducer=assetprodu21_.id left outer join Proofs proof22_ on assetprodu21_.proof=proof22_.id left outer join Versions version23_ on assetprodu21_.version=version23_.id left outer join PTCs ptc24_ on version23_.ptc=ptc24_.id left outer join Catalogs catalog25_ on ptc24_.catalogId=catalog25_.id left outer join Catalogs catalog26_ on ptc24_.oldCatalogId=catalog26_.id left outer join InDesignDocumentHolders indesignte27_ on ptc24_.indesignTemplateId=indesignte27_.id left outer join InDesignDocuments indesigndo28_ on indesignte27_.indd_doc=indesigndo28_.id left outer join OriginalFiles originalfi29_ on indesigndo28_.originalFile=originalfi29_.id left outer join FilesOnDisk originalfi29_1_ on originalfi29_.id=originalfi29_1_.id left outer join Users user30_ on originalfi29_.uploader=user30_.id left outer join Category templateca31_ on user30_.defaultTemplateCategory=templateca31_.id left outer join Category contentcat32_ on user30_.defaultContentCategory=contentcat32_.id left outer join ConvertedFileSets convertedf33_ on indesigndo28_.convertedFileSet=convertedf33_.id left outer join Versions version34_ on ptc24_.version=version34_.id left outer join PreEntryAsset preentryas35_ on assetprodu21_.preEntry=preentryas35_.id left outer join Proofs proof36_ on baseversio18_.proof=proof36_.id left outer join Photos photo37_ on baseversio18_.photo=photo37_.id left outer join PhotoEvents photoevent38_ on (select max(event3.id) from PhotoEvents event3 where event3.id in (select eventz.id from PhotoHistories history inner join PhotoEvents eventz on history.event=eventz.id where history.date=( select max(histories3_.date) from Photos photo inner join PhotoHistories histories3_ on photo.id=histories3_.photo_id where photo.id=photo37_.id and histories3_.event is not null) and history.photo_id=photo37_.id ) ) =photoevent38_.id left outer join AlternatePreviews alternatep39_ on assetview16_.alternatePreview=alternatep39_.id left outer join OriginalFiles originalfi40_ on alternatep39_.originalFile=originalfi40_.id left outer join FilesOnDisk originalfi40_1_ on originalfi40_.id=originalfi40_1_.id left outer join ConvertedFileSets convertedf41_ on alternatep39_.convertedFileSet=convertedf41_.id left outer join ConvertedFileSets convertedf42_ on assetview16_.convertedFileSet=convertedf42_.id left outer join Coordinates coordinate43_ on assetview16_2_.coordinates=coordinate43_.id left outer join OwnerGroups ownergroup44_ on uploadprof7_.ownergroup_id=ownergroup44_.id left outer join RoutingGroups routinggro45_ on uploadprof7_.routegroup_id=routinggro45_.id where assets0_.portfolioId in (@P0, @P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9)