componentId - 22select distinct
cataloguec0_.ComponentId as Componen1_15_0_,
attachment1_.AttachmentId as Attachme1_21_1_,
attachment1_.AttachmentTypeId as Attachme2_21_1_,
attachment1_.ComponentId as Componen3_21_1_,
attachment2_.AttachmentId as Attachme1_4_2_,
additional3_.AdditionalSaleTypeId as Addition1_0_3_,
additional3_.SourceComponentId as SourceCo2_0_3_,
additional3_.TargetComponentId as TargetCo3_0_3_,
partcompon4_.ComponentId as Componen1_61_4_,
partcompon4_.DescriptionId as Descript2_61_4_,
partcompon4_.DescriptionTypeId as Descript3_61_4_,
cataloguec0_.AssemblyLevel as Assembly2_15_0_,
cataloguec0_.CatalogueId as Catalog13_15_0_,
cataloguec0_.CatalogueComponentTypeId as Catalogu3_15_0_,
cataloguec0_.ChangeIndicator as ChangeIn4_15_0_,
cataloguec0_.Code as Code15_0_,
cataloguec0_.ComponentPath as Componen6_15_0_,
cataloguec0_.DescriptionId as Descript7_15_0_,
cataloguec0_.HotspotKey as HotspotKey15_0_,
cataloguec0_.parentComponentId as parentCo9_15_0_,
cataloguec0_.ParentComponentId as ParentCo9_15_0_,
cataloguec0_.ItemId as ItemId15_0_,
cataloguec0_.Quantity as Quantity15_0_,
cataloguec0_.SequenceId as SequenceId15_0_,
cataloguec0_.VersionUpdate as Version12_15_0_,
attachment1_.SequenceId as SequenceId21_1_,
attachment1_.VersionUpdate as VersionU5_21_1_,
attachment1_.ComponentId as Componen3_0__,
attachment1_.AttachmentId as Attachme1_0__,
attachment1_.AttachmentTypeId as Attachme2_0__,
attachment2_.AttachmentLanguage as Attachme2_4_2_,
attachment2_.AttachmentLocal as Attachme3_4_2_,
attachment2_.AttachmentTitle as Attachme4_4_2_,
attachment2_.MIME as MIME4_2_,
attachment2_.URL as URL4_2_,
attachment2_.VersionUpdate as VersionU7_4_2_,
additional3_.DescriptionId as Descript4_0_3_,
additional3_.Quantity as Quantity0_3_,
additional3_.Rank as Rank0_3_,
additional3_.VersionUpdate as VersionU7_0_3_,
additional3_.SourceComponentId as SourceCo2_1__,
additional3_.AdditionalSaleTypeId as Addition1_1__,
additional3_.TargetComponentId as TargetCo3_1__,
partcompon4_.SequenceId as SequenceId61_4_,
partcompon4_.VersionUpdate as VersionU5_61_4_,
partcompon4_.ComponentId as Componen1_2__,
partcompon4_.DescriptionId as Descript2_2__,
partcompon4_.DescriptionTypeId as Descript3_2__
from CatalogueComponent cataloguec0_
left outer join ComponentAttachment attachment1_ on cataloguec0_.ComponentId=attachment1_.ComponentId
left outer join AttachmentData attachment2_ on attachment1_.AttachmentId=attachment2_.AttachmentId
left outer join AdditionalSale additional3_ on cataloguec0_.ComponentId=additional3_.SourceComponentId
left outer join PartComponentDescription partcompon4_ on cataloguec0_.ComponentId=partcompon4_.ComponentId, Market market5_
left outer join SupportContactInfo market5_1_ on market5_.marketID=market5_1_.marketId
where cataloguec0_.ParentComponentId=22
and market5_.marketID=1
and attachment1_.AttachmentTypeId = 3
and cataloguec0_.AssemblyLevel = 2
and ( not (exists (
select market7_.marketID
from CatalogueComponentToMarket markets6_, Market market7_
left outer join SupportContactInfo market7_1_ on market7_.marketID=market7_1_.marketId
where cataloguec0_.ComponentId=markets6_.ComponentId
and markets6_.MarketId=market7_.marketID))
or market5_.marketID in (
select market9_.marketID
from CatalogueComponentToMarket markets8_, Market market9_
left outer join SupportContactInfo market9_1_ on market9_.marketID=market9_1_.marketId
where cataloguec0_.ComponentId=markets8_.ComponentId
and markets8_.MarketId=market9_.marketID))
order by cataloguec0_.SequenceIdArray
(
[471446] => Bloc-moteur
[392307] => Zetec 1.7 DOHC EFI
[559263] => Puma 1997-2001 (CCE)
)