Vi beklager, en fejl er opstået. Fejlen vil blive undersøgt og løst hurtigst muligt.<br />Fejlbesked:<br />could not execute query
[ SELECT this_.id as id1_290_0_, this_.contains_quantity_from as contains2_290_0_, this_.contains_quantity_to as contains3_290_0_, this_.contains_quantity_unit_kind as contains4_290_0_, this_.measurement_size_from as measurement5_290_0_, this_.measurement_size_to as measurement6_290_0_, this_.measurement_size_unit_kind as measurement7_290_0_, this_.shipping_base_value as shipping8_290_0_, this_.shipping_vat_rate as shipping9_290_0_, this_.supplier_base_value as supplier10_290_0_, this_.supplier_vat_rate as supplier11_290_0_, this_.allow_customer_defined_price as allow12_290_0_, this_.created_at as created13_290_0_, this_.deleted_at as deleted14_290_0_, this_.detail_mode as detail15_290_0_, this_.distributable_package_volume_percentage as distributable16_290_0_, this_.granted_to_user_relation_kind as granted17_290_0_, this_.height as height18_290_0_, this_.is_new as is19_290_0_, this_.is_auto_captured as is20_290_0_, this_.is_campaign_only as is21_290_0_, this_.is_configuration_examples_disabled as is22_290_0_, this_.is_digital as is23_290_0_, this_.is_packaged_separately as is24_290_0_, this_.is_quantity_locked as is25_290_0_, this_.is_redeemable as is26_290_0_, this_.is_return_value_zero as is27_290_0_, this_.is_returns_disabled as is28_290_0_, this_.is_user_redeemable as is29_290_0_, this_.is_active as is30_290_0_, this_.is_deleted as is31_290_0_, this_.is_excluded_in_summations_of_quantity as is32_290_0_, this_.is_granting_sub_order_token as is33_290_0_, this_.is_hidden as is34_290_0_, this_.is_notified_of_end_of_delivery_period as is35_290_0_, this_.is_notified_of_end_of_order_period as is36_290_0_, this_.is_purchasing_disabled as is37_290_0_, this_.is_rebate_allowed as is38_290_0_, this_.is_restricted_to_providers as is39_290_0_, this_.is_restricted_to_specific_client_accounts as is40_290_0_, this_.is_shipping_value_per_order as is41_290_0_, this_.is_single_ticket_preferred as is42_290_0_, this_.is_tax_free as is43_290_0_, this_.is_system_managed as is44_290_0_, this_.is_template as is45_290_0_, this_.is_ticket_sent_before_payment as is46_290_0_, this_.is_user_required as is47_290_0_, this_.is_variants_disabled as is48_290_0_, this_.is_wizard_enabled as is49_290_0_, this_.length as length50_290_0_, this_.maximum_quantity_per_order as maximum51_290_0_, this_.minimum_quantity_per_order as minimum52_290_0_, this_.minimum_customer_age as minimum53_290_0_, this_.manufacture_duration as manufacture54_290_0_, this_.meta_data as meta55_290_0_, this_.number_of_preparation_days as number56_290_0_, this_.ordinal as ordinal57_290_0_, this_.owner_department_id as owner58_290_0_, this_.preparation_off_days_of_week as preparation59_290_0_, this_.preparation_start_earliest_time_of_day as preparation60_290_0_, this_.preparation_start_latest_time_of_day as preparation61_290_0_, this_.prepare_duration as prepare62_290_0_, this_.producer_id as producer63_290_0_, this_.product_type as product64_290_0_, this_.quantity_unit_kind as quantity65_290_0_, this_.required_customer_type as required66_290_0_, this_.required_package_kind as required67_290_0_, this_.template_id as template68_290_0_, this_.tax_category_id as tax69_290_0_, this_.updated_at as updated70_290_0_, this_.weight as weight71_290_0_, this_.width as width72_290_0_ FROM product this_ WHERE this_.is_template = @p0 and (this_.is_deleted = @p1 and (this_.owner_department_id is null or this_.owner_department_id in (SELECT this_0_.id as y0_ FROM departments this_0_ WHERE this_0_.is_deleted = @p2))) and this_.is_active = @p3 and this_.is_hidden = @p4 and (this_.id not in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p5 and this_0_.relation_key is null and this_0_.is_inverted = @p6 and this_0_.publish_time_span_id in (SELECT this_0_0_.id as y0_ FROM publish_time_spans this_0_0_ WHERE (this_0_0_.from_date is null or this_0_0_.from_date <= @p7) and (this_0_0_.`to_date` is null or this_0_0_.`to_date` >= @p8)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p9 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p10) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p11) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p12)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_) or this_0_.publish_time_span_id in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p13 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p14) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p15) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p16))))) and (this_.id not in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p17 and this_0_.relation_key is null and this_0_.is_inverted = @p18) or this_.id in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p19 and this_0_.relation_key is null and this_0_.is_inverted = @p20 and this_0_.publish_time_span_id in (SELECT this_0_0_.id as y0_ FROM publish_time_spans this_0_0_ WHERE (this_0_0_.from_date is null or this_0_0_.from_date <= @p21) and (this_0_0_.`to_date` is null or this_0_0_.`to_date` >= @p22)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p23 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p24) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p25) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p26)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_) or this_0_.publish_time_span_id in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p27 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p28) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p29) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p30))))))) and this_.id in (SELECT this_0_.product_id as y0_ FROM product_categories this_0_ WHERE this_0_.category_id in (@p31) and this_0_.campaign_id is null) ORDER BY (SELECT this_0_.base_value as y0_, this_0_.vat_rate as y1_ FROM entity_prices this_0_ WHERE this_0_.entity_type = @p32 and this_0_.entity_id = this_.id limit @p33) asc ]
  Name:cp0 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp1 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp2 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp3 - Value:True [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp4 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp5 - Value:Product [Type: NHibernate.Type.StringType (SqlType: String)]  Name:cp6 - Value:True [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp7 - Value:08-08-2026 13:24:26 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]  Name:cp8 - Value:08-08-2026 13:24:26 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]  Name:cp9 - Value:True [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp10 - Value:Saturday [Type: NHibernate.Type.EnumType`1[System.DayOfWeek] (SqlType: Int32)]  Name:cp11 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp12 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp13 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp14 - Value:Saturday [Type: NHibernate.Type.EnumType`1[System.DayOfWeek] (SqlType: Int32)]  Name:cp15 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp16 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp17 - Value:Product [Type: NHibernate.Type.StringType (SqlType: String)]  Name:cp18 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp19 - Value:Product [Type: NHibernate.Type.StringType (SqlType: String)]  Name:cp20 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp21 - Value:08-08-2026 13:24:26 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]  Name:cp22 - Value:08-08-2026 13:24:26 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]  Name:cp23 - Value:True [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp24 - Value:Saturday [Type: NHibernate.Type.EnumType`1[System.DayOfWeek] (SqlType: Int32)]  Name:cp25 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp26 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp27 - Value:False [Type: NHibernate.Type.BooleanType (SqlType: Boolean)]  Name:cp28 - Value:Saturday [Type: NHibernate.Type.EnumType`1[System.DayOfWeek] (SqlType: Int32)]  Name:cp29 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp30 - Value:13:24:26.0956162 [Type: NHibernate.Type.TimeSpanType (SqlType: Int64)]  Name:cp31 - Value:14 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp32 - Value:Product [Type: NHibernate.Type.StringType (SqlType: String)]  Name:take_33 - Value:1 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]
[SQL: SELECT this_.id as id1_290_0_, this_.contains_quantity_from as contains2_290_0_, this_.contains_quantity_to as contains3_290_0_, this_.contains_quantity_unit_kind as contains4_290_0_, this_.measurement_size_from as measurement5_290_0_, this_.measurement_size_to as measurement6_290_0_, this_.measurement_size_unit_kind as measurement7_290_0_, this_.shipping_base_value as shipping8_290_0_, this_.shipping_vat_rate as shipping9_290_0_, this_.supplier_base_value as supplier10_290_0_, this_.supplier_vat_rate as supplier11_290_0_, this_.allow_customer_defined_price as allow12_290_0_, this_.created_at as created13_290_0_, this_.deleted_at as deleted14_290_0_, this_.detail_mode as detail15_290_0_, this_.distributable_package_volume_percentage as distributable16_290_0_, this_.granted_to_user_relation_kind as granted17_290_0_, this_.height as height18_290_0_, this_.is_new as is19_290_0_, this_.is_auto_captured as is20_290_0_, this_.is_campaign_only as is21_290_0_, this_.is_configuration_examples_disabled as is22_290_0_, this_.is_digital as is23_290_0_, this_.is_packaged_separately as is24_290_0_, this_.is_quantity_locked as is25_290_0_, this_.is_redeemable as is26_290_0_, this_.is_return_value_zero as is27_290_0_, this_.is_returns_disabled as is28_290_0_, this_.is_user_redeemable as is29_290_0_, this_.is_active as is30_290_0_, this_.is_deleted as is31_290_0_, this_.is_excluded_in_summations_of_quantity as is32_290_0_, this_.is_granting_sub_order_token as is33_290_0_, this_.is_hidden as is34_290_0_, this_.is_notified_of_end_of_delivery_period as is35_290_0_, this_.is_notified_of_end_of_order_period as is36_290_0_, this_.is_purchasing_disabled as is37_290_0_, this_.is_rebate_allowed as is38_290_0_, this_.is_restricted_to_providers as is39_290_0_, this_.is_restricted_to_specific_client_accounts as is40_290_0_, this_.is_shipping_value_per_order as is41_290_0_, this_.is_single_ticket_preferred as is42_290_0_, this_.is_tax_free as is43_290_0_, this_.is_system_managed as is44_290_0_, this_.is_template as is45_290_0_, this_.is_ticket_sent_before_payment as is46_290_0_, this_.is_user_required as is47_290_0_, this_.is_variants_disabled as is48_290_0_, this_.is_wizard_enabled as is49_290_0_, this_.length as length50_290_0_, this_.maximum_quantity_per_order as maximum51_290_0_, this_.minimum_quantity_per_order as minimum52_290_0_, this_.minimum_customer_age as minimum53_290_0_, this_.manufacture_duration as manufacture54_290_0_, this_.meta_data as meta55_290_0_, this_.number_of_preparation_days as number56_290_0_, this_.ordinal as ordinal57_290_0_, this_.owner_department_id as owner58_290_0_, this_.preparation_off_days_of_week as preparation59_290_0_, this_.preparation_start_earliest_time_of_day as preparation60_290_0_, this_.preparation_start_latest_time_of_day as preparation61_290_0_, this_.prepare_duration as prepare62_290_0_, this_.producer_id as producer63_290_0_, this_.product_type as product64_290_0_, this_.quantity_unit_kind as quantity65_290_0_, this_.required_customer_type as required66_290_0_, this_.required_package_kind as required67_290_0_, this_.template_id as template68_290_0_, this_.tax_category_id as tax69_290_0_, this_.updated_at as updated70_290_0_, this_.weight as weight71_290_0_, this_.width as width72_290_0_ FROM product this_ WHERE this_.is_template = @p0 and (this_.is_deleted = @p1 and (this_.owner_department_id is null or this_.owner_department_id in (SELECT this_0_.id as y0_ FROM departments this_0_ WHERE this_0_.is_deleted = @p2))) and this_.is_active = @p3 and this_.is_hidden = @p4 and (this_.id not in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p5 and this_0_.relation_key is null and this_0_.is_inverted = @p6 and this_0_.publish_time_span_id in (SELECT this_0_0_.id as y0_ FROM publish_time_spans this_0_0_ WHERE (this_0_0_.from_date is null or this_0_0_.from_date <= @p7) and (this_0_0_.`to_date` is null or this_0_0_.`to_date` >= @p8)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p9 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p10) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p11) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p12)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_) or this_0_.publish_time_span_id in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p13 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p14) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p15) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p16))))) and (this_.id not in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p17 and this_0_.relation_key is null and this_0_.is_inverted = @p18) or this_.id in (SELECT this_0_.entity_id as y0_ FROM entity_publish_time_spans this_0_ WHERE this_0_.entity_type = @p19 and this_0_.relation_key is null and this_0_.is_inverted = @p20 and this_0_.publish_time_span_id in (SELECT this_0_0_.id as y0_ FROM publish_time_spans this_0_0_ WHERE (this_0_0_.from_date is null or this_0_0_.from_date <= @p21) and (this_0_0_.`to_date` is null or this_0_0_.`to_date` >= @p22)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p23 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p24) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p25) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p26)) and (this_0_.publish_time_span_id not in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_) or this_0_.publish_time_span_id in (SELECT this_0_0_.time_span_id as y0_ FROM publish_days this_0_0_ WHERE this_0_0_.is_inverted = @p27 and (this_0_0_.day_of_week is null or this_0_0_.day_of_week = @p28) and (this_0_0_.from_time is null or this_0_0_.from_time <= @p29) and (this_0_0_.to_time is null or this_0_0_.to_time >= @p30))))))) and this_.id in (SELECT this_0_.product_id as y0_ FROM product_categories this_0_ WHERE this_0_.category_id in (@p31) and this_0_.campaign_id is null) ORDER BY (SELECT this_0_.base_value as y0_, this_0_.vat_rate as y1_ FROM entity_prices this_0_ WHERE this_0_.entity_type = @p32 and this_0_.entity_id = this_.id limit @p33) asc]<br /><br />Inner Exception:<br /><br /><br />Fejlbesked:<br />Operand should contain 1 column(s)