TSG / B2B Product Detail / ${data.article_name}

Article not found [${system.Parameter.query_vars.article}]

{ "page-url": "\/b2b-product-detail\/", "url": "\/b2b-product-detail\/" } { "query_vars": { "page": 0, "pagename": "b2b-product-detail", "error": "", "m": "", "p": 0, "post_parent": "", "subpost": "", "subpost_id": "", "attachment": "", "attachment_id": 0, "name": "b2b-product-detail", "page_id": 0, "second": "", "minute": "", "hour": "", "day": 0, "monthnum": 0, "year": 0, "w": 0, "category_name": "", "tag": "", "cat": "", "tag_id": "", "author": "", "author_name": "", "feed": "", "tb": "", "paged": 0, "meta_key": "", "meta_value": "", "preview": "", "s": "", "sentence": "", "title": "", "fields": "", "menu_order": "", "embed": "", "category__in": [], "category__not_in": [], "category__and": [], "post__in": [], "post__not_in": [], "post_name__in": [], "tag__in": [], "tag__not_in": [], "tag__and": [], "tag_slug__in": [], "tag_slug__and": [], "post_parent__in": [], "post_parent__not_in": [], "author__in": [], "author__not_in": [], "search_columns": [], "ignore_sticky_posts": false, "suppress_filters": false, "cache_results": true, "update_post_term_cache": true, "update_menu_item_cache": false, "lazy_load_term_meta": true, "update_post_meta_cache": true, "post_type": "", "posts_per_page": 10, "nopaging": false, "comments_per_page": "50", "no_found_rows": false, "order": "DESC" }, "atts": { "options": "{}", "id": "", "type": "ProductDetailB2B", "view": "Frame", "class": "", "category": "", "series_id": "", "series": "", "bar": "default bar", "post_id": 5395 }, "request": { "page-url": "\/b2b-product-detail\/", "url": "\/b2b-product-detail\/" } }
SELECT 
p.article_name AS s_name,
p.primary_image ,
p.product_group ,
p.article_name ,
p.retail_price_euro_1008 ,
p.special_offer ,
p.model ,
p.color ,
p.size ,
p.SKU_NR ,
p.SKU_SIZE ,
p.article_number,
p.SKU_COLOR ,
p.product_description ,
p.primary_image ,
p.features_fit ,
p.features_protection ,
p.features_comfort,
p.sw_skate,
p.sw_bike,
p.sw_snow,
p.sw_wake,
p.*

FROM shop_artikel AS p 
WHERE 
p.deleted=0 AND  (
 (  online_status!=0 AND storeview!=0 ) OR
  ( online_catalog_b2b = 1  AND online_status!=0 )) AND 
((article_number= '0' AND '0' = 0) 
  OR (article_number = '0' )
) 

ORDER BY RAND() LIMIT 1;