500 - could not execute query [ select TOP (8) emcaproduc0_.Id as col_0_0_, emcacatego1_.Id as col_1_0_, emcacatego1_.Name as col_2_0_, emcacatego1_.CategoryNumber as col_3_0_, emcacatego1_.ItemId as col_4_0_, emcacatego1_.UserData1 as col_5_0_, emcacatego1_.UserData2 as col_6_0_, emcacatego1_.Description as col_7_0_, emcaproduc9_.Id as col_8_0_, emcaproduc9_.Identifier as col_9_0_, emcaproduc9_.Name as col_10_0_, emcaavaila10_.Id as col_11_0_, emcaavaila10_.Name as col_12_0_, emcaproduc0_.ItemId as col_13_0_, emcaproduc0_.CatalogueNumber as col_14_0_, emcaproduc0_.BarCodeEan as col_15_0_, emcaproduc0_.Title as col_16_0_, emcaproduc0_.UrlTitle as col_17_0_, emcaproduc0_.Description as col_18_0_, emcaproduc0_.DetailDescription as col_19_0_, emcaproduc0_.HtmlTitle as col_20_0_, emcaproduc0_.MetaKeywords as col_21_0_, emcaproduc0_.MetaDescription as col_22_0_, emcaproduc0_.Unit as col_23_0_, emcaproduc0_.Weight as col_24_0_, productpri11_.Price as col_25_0_, itemsvatcl8_.Id as col_26_0_, itemsvatcl8_.VatRate as col_27_0_, emcaproduc0_.SaleClass as col_28_0_, emcaproduc0_.Tags as col_29_0_, emcaproduc0_.IsActive as col_30_0_, emcaproduc0_.IsVariantSlave as col_31_0_, emcaproduc0_.IsVariantMaster as col_32_0_, emcaproduc3_.Id as col_33_0_, emcaproduc0_.VariantText as col_34_0_, emcaattrib2_.Id as col_35_0_, emcaproduc0_.TsCreated as col_36_0_, emcaproduc0_.TsModified as col_37_0_, emcaproduc0_.TsImportModified as col_38_0_, emcaproduc0_.ImportName as col_39_0_, emcaproduc0_.ExternalIdentifier as col_40_0_, emcaproduc0_.ImagesCount as col_41_0_, emcaproduc0_.HtmlViewCounter as col_42_0_, emcaproduc0_.UserData1 as col_43_0_, emcaproduc0_.UserData2 as col_44_0_, emcaproduc0_.UserDateTime1 as col_45_0_, emcaproduc0_.UserDateTime2 as col_46_0_, emcaproduc0_.UserInt1 as col_47_0_, emcaproduc0_.UserInt2 as col_48_0_, emcaproduc0_.UserDec1 as col_49_0_, emcaproduc0_.UserDec2 as col_50_0_, emcaproduc0_.UserText1 as col_51_0_, emcaproduc0_.UserText2 as col_52_0_, emcaproduc0_.UserText3 as col_53_0_, emcaproduc0_.UserText4 as col_54_0_, emcaproduc0_.UserText5 as col_55_0_, emcaproduc0_.XlData as col_56_0_, emcaavaila10_.XlData as col_57_0_ from EmCaProduct emcaproduc0_ left outer join EmCaCategory emcacatego1_ on emcaproduc0_.EmCaCategory=emcacatego1_.Id left outer join EmCaCategoryL emcacatego5_ on emcacatego1_.Id=emcacatego5_.EmCaCategory and (emcacatego5_.Lang=@p0) left outer join EmCaAttribute emcaattrib2_ on emcaproduc0_.VariantEmCaAttribute=emcaattrib2_.Id left outer join EmCaProduct emcaproduc3_ on emcaproduc0_.VariantMaster=emcaproduc3_.Id left outer join EmCaProductL emcaproduc4_ on emcaproduc0_.Id=emcaproduc4_.EmCaProduct and (emcaproduc4_.Lang=@p0) left outer join EmCaProductCategory productcat6_ on emcaproduc0_.Id=productcat6_.EmCaProduct left outer join EmScVatClass emscvatcla7_ on emcaproduc0_.EmScVatClass=emscvatcla7_.Id left outer join EmScDivisionVatClass itemsvatcl8_ on emscvatcla7_.Id=itemsvatcl8_.EmScVatClass and (itemsvatcl8_.EmScDivision=@p2) left outer join EmCaProductClass emcaproduc9_ on emcaproduc0_.EmCaProductClass=emcaproduc9_.Id left outer join EmCaAvailability emcaavaila10_ on emcaproduc0_.EmCaAvailability=emcaavaila10_.Id left outer join EmCaProductPrice productpri11_ on emcaproduc0_.Id=productpri11_.EmCaProduct and (productpri11_.EmScPriceList=@p3), EmCaCategory emcacatego12_ where productcat6_.EmCaCategory=emcacatego12_.Id and emcaproduc0_.IsValid=@p4 and productcat6_.EmCaCategory=@p5 and emcacatego12_.IsActive=@p6 and emcaproduc4_.IsActive=@p7 and emcaproduc0_.IsVariantSlave=@p8 and Price>@p9 and emcaproduc0_.EmCaAvailability=@p10 order by emcaproduc0_.HtmlViewCounter desc ] Name:wpar_1 - Value:True Name:wpar_2 - Value:fedd4481-7813-4498-a435-8bfacdb4cf5f Name:wpar_3 - Value:True Name:wpar_4 - Value:True Name:wpar_5 - Value:False Name:wpar_6 - Value:0 Name:wpar_7 - Value:1 Name:a_lang - Value:cs Name:a_DivisionId - Value:1 Name:a_PriceListDefault - Value:1 [SQL: select TOP (8) emcaproduc0_.Id as col_0_0_, emcacatego1_.Id as col_1_0_, emcacatego1_.Name as col_2_0_, emcacatego1_.CategoryNumber as col_3_0_, emcacatego1_.ItemId as col_4_0_, emcacatego1_.UserData1 as col_5_0_, emcacatego1_.UserData2 as col_6_0_, emcacatego1_.Description as col_7_0_, emcaproduc9_.Id as col_8_0_, emcaproduc9_.Identifier as col_9_0_, emcaproduc9_.Name as col_10_0_, emcaavaila10_.Id as col_11_0_, emcaavaila10_.Name as col_12_0_, emcaproduc0_.ItemId as col_13_0_, emcaproduc0_.CatalogueNumber as col_14_0_, emcaproduc0_.BarCodeEan as col_15_0_, emcaproduc0_.Title as col_16_0_, emcaproduc0_.UrlTitle as col_17_0_, emcaproduc0_.Description as col_18_0_, emcaproduc0_.DetailDescription as col_19_0_, emcaproduc0_.HtmlTitle as col_20_0_, emcaproduc0_.MetaKeywords as col_21_0_, emcaproduc0_.MetaDescription as col_22_0_, emcaproduc0_.Unit as col_23_0_, emcaproduc0_.Weight as col_24_0_, productpri11_.Price as col_25_0_, itemsvatcl8_.Id as col_26_0_, itemsvatcl8_.VatRate as col_27_0_, emcaproduc0_.SaleClass as col_28_0_, emcaproduc0_.Tags as col_29_0_, emcaproduc0_.IsActive as col_30_0_, emcaproduc0_.IsVariantSlave as col_31_0_, emcaproduc0_.IsVariantMaster as col_32_0_, emcaproduc3_.Id as col_33_0_, emcaproduc0_.VariantText as col_34_0_, emcaattrib2_.Id as col_35_0_, emcaproduc0_.TsCreated as col_36_0_, emcaproduc0_.TsModified as col_37_0_, emcaproduc0_.TsImportModified as col_38_0_, emcaproduc0_.ImportName as col_39_0_, emcaproduc0_.ExternalIdentifier as col_40_0_, emcaproduc0_.ImagesCount as col_41_0_, emcaproduc0_.HtmlViewCounter as col_42_0_, emcaproduc0_.UserData1 as col_43_0_, emcaproduc0_.UserData2 as col_44_0_, emcaproduc0_.UserDateTime1 as col_45_0_, emcaproduc0_.UserDateTime2 as col_46_0_, emcaproduc0_.UserInt1 as col_47_0_, emcaproduc0_.UserInt2 as col_48_0_, emcaproduc0_.UserDec1 as col_49_0_, emcaproduc0_.UserDec2 as col_50_0_, emcaproduc0_.UserText1 as col_51_0_, emcaproduc0_.UserText2 as col_52_0_, emcaproduc0_.UserText3 as col_53_0_, emcaproduc0_.UserText4 as col_54_0_, emcaproduc0_.UserText5 as col_55_0_, emcaproduc0_.XlData as col_56_0_, emcaavaila10_.XlData as col_57_0_ from EmCaProduct emcaproduc0_ left outer join EmCaCategory emcacatego1_ on emcaproduc0_.EmCaCategory=emcacatego1_.Id left outer join EmCaCategoryL emcacatego5_ on emcacatego1_.Id=emcacatego5_.EmCaCategory and (emcacatego5_.Lang=@p0) left outer join EmCaAttribute emcaattrib2_ on emcaproduc0_.VariantEmCaAttribute=emcaattrib2_.Id left outer join EmCaProduct emcaproduc3_ on emcaproduc0_.VariantMaster=emcaproduc3_.Id left outer join EmCaProductL emcaproduc4_ on emcaproduc0_.Id=emcaproduc4_.EmCaProduct and (emcaproduc4_.Lang=@p0) left outer join EmCaProductCategory productcat6_ on emcaproduc0_.Id=productcat6_.EmCaProduct left outer join EmScVatClass emscvatcla7_ on emcaproduc0_.EmScVatClass=emscvatcla7_.Id left outer join EmScDivisionVatClass itemsvatcl8_ on emscvatcla7_.Id=itemsvatcl8_.EmScVatClass and (itemsvatcl8_.EmScDivision=@p2) left outer join EmCaProductClass emcaproduc9_ on emcaproduc0_.EmCaProductClass=emcaproduc9_.Id left outer join EmCaAvailability emcaavaila10_ on emcaproduc0_.EmCaAvailability=emcaavaila10_.Id left outer join EmCaProductPrice productpri11_ on emcaproduc0_.Id=productpri11_.EmCaProduct and (productpri11_.EmScPriceList=@p3), EmCaCategory emcacatego12_ where productcat6_.EmCaCategory=emcacatego12_.Id and emcaproduc0_.IsValid=@p4 and productcat6_.EmCaCategory=@p5 and emcacatego12_.IsActive=@p6 and emcaproduc4_.IsActive=@p7 and emcaproduc0_.IsVariantSlave=@p8 and Price>@p9 and emcaproduc0_.EmCaAvailability=@p10 order by emcaproduc0_.HtmlViewCounter desc]

EasyWeb

Inner Exception(s) Message(s):
  Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.