SELECT  TOP 1  model_uitvoering_low_price, model_uitvoering_low_price_ex, model_prijs_custom_1_ex, model_prijs_custom_1_vat, model_prijs_custom_2_ex, model_prijs_custom_2_vat, model_prijs_custom_3_ex, model_prijs_custom_3_vat, model_prijs_custom_4_ex, model_prijs_custom_4_vat,  model_prijs_ex, model_prijs_vat, model_artikel_id, model_titel_1, model_omschrijving_1, model_seo_title_1, model_seo_keywords_1, model_seo_description_1, model_status_1, model_prijs, model_vat_percent, model_product_type, model_date_modified, model_Nieuw, model_van_prijs, model_Afbeelding, model_vergelijk, model_huidige_voorraad, model_ijzeren_voorraad, model_naleverbaar, model_lev_code, model_backorder, model_klant_bestelling, model_barcode, model_magazijn_positie, model_inkoop_prijs, model_brand, model_popular_item, model_in_stock, model_offer_product, model_seo_robots, model_seo_manual, model_youtube, model_og_manual, model_og_title_1, model_og_description_1, model_og_picture_1, model_short_description_1, model_tip, model_external_image_1, model_prijs_custom_1, model_prijs_custom_2, model_prijs_custom_3, model_prijs_custom_4, model_prijs_vrije_invoer, model_prijs_keuze, model_aanbieding_titel_1, model_aanbieding_prijs, model_aanbieding_publish, model_aanbieding_unpublish, model_aanbieding_omschrijving_1, model_verpakt_per, model_mbh, model_maten, model_in_stock_overrule_text_1, model_not_in_stock_overrule_text_1, model_prijs_keuze_min, model_uitvoeringen_json, model_brand_title_1, model_protectedgroups, model_has_options, model_alternative_artikel_id, model_not_orderable, model_spotlight, model_cluster_code, model_video_algemeen, model_video_instructie, model_video_commercieel, model_typenumber, model_cluster_name_1, model_unit, model_unit_title, model_free_product, model_xml_articlenumber, model_xml_articlegtin, model_bruto_prijs, model_group_id, model_show_youtube_label, model_ezmix_brand_image, model_itemclass, model_ezbase_catalogus, model_deelfactor, model_opslagfactor, model_use_clusterspecs, model_use_clusterspecs_color, model_video_algemeen_alt_1, model_video_commercieel_alt_1, model_video_instructie_alt_1, model_ezbase_catalogus_description_1, model_product_campaign, model_product_campaign_title_1, model_points, model_custom_action_item, model_submodel_title_1, model_channable, model_search_words, model_custom_combi_item, model_weight, model_volume_weight, model_backorder_stock_text_1, model_normal_bundle_price, model_bundle_discount_price, model_customer, model_exact_stock, model_xml_footer_1, model_transport_tab_1, model_url_1, model_url_2, model_url_3, model_url_4, [cut_to_size].[min_length] AS cut_to_size_min_length, [cut_to_size].[max_length] AS cut_to_size_max_length, [cut_to_size].[min_width] AS cut_to_size_min_width, [cut_to_size].[max_width] AS cut_to_size_max_width, [cut_to_size].[lengths] AS cut_to_size_lengths, g.group_name_1 as gtm_group_name,mgtm_linked_model_titel_1 as gtm_head_model_titel ,mgtm_linked_model_brand_title_1 as gtm_head_model_brand_title   ,model_maxbh FROM  ab_modelsQuery_4_1 WITH (NOLOCK) LEFT JOIN ( SELECT grmod_artikel_id, MIN(group_item.group_name_1) AS group_name_1 FROM ab_groups AS group_item INNER JOIN ab_groups_modelsadd AS group_link ON group_item.group_id = group_link.grmod_group_id GROUP BY grmod_artikel_id ) g ON g.grmod_artikel_id = dbo.[ab_modelsQuery_4_1].model_artikel_id LEFT OUTER JOIN dbo.ab_modelsadd_gtm ON dbo.[ab_modelsQuery_4_1].model_artikel_id = dbo.ab_modelsadd_gtm.mgtm_model_artikel_id AND ab_modelsadd_gtm.mgtm_division_id = dbo.[ab_modelsQuery_4_1].model_division_id LEFT JOIN dbo.[ab_models_cut_to_size] AS [cut_to_size] ON [cut_to_size].[product_id] = dbo.[ab_modelsQuery_4_1].model_artikel_id   WHERE (model_url_1=N'/554735-knop-van-vastzethendel' AND model_product_type IN (1)  AND model_status_1 = '1'  AND  (model_specific_range <> 1 OR model_specific_range IS NULL)  AND  (model_division_id = '1')  AND (model_protectedgroups = '')) ORDER BY model_artikel_id