show_related
SELECT cross_sell_match.*
FROM cross_sell_match
INNER JOIN import_product_category_products
ON import_product_category_products.company_id = cross_sell_match.company_id
AND import_product_category_products.product_id = 166199
AND import_product_category_products.group_id = cross_sell_match.category_id
/*AND import_product_category_products.type = 'category'*/
WHERE cross_sell_match.company_id = 130
AND cross_sell_match.show_related
AND cross_sell_match.category_id = import_product_category_products.group_id
AND (
cross_sell_match.product_group_id = 368266
OR cross_sell_match.product_group_id = 0
)
show_pdp
SELECT cross_sell_match.*
FROM cross_sell_match
INNER JOIN import_product_category_products
ON import_product_category_products.company_id = cross_sell_match.company_id
AND import_product_category_products.product_id = 166199
AND import_product_category_products.group_id = cross_sell_match.category_id
/*AND import_product_category_products.type = 'category'*/
WHERE cross_sell_match.company_id = 130
AND cross_sell_match.show_pdp
AND cross_sell_match.category_id = import_product_category_products.group_id
AND (
cross_sell_match.product_group_id = 368266
OR cross_sell_match.product_group_id = 0
)
Oil Seal - 42x52x5 - WA - 70 NBR NB70C401 - Dichtomatik - 49451122 - Packaging Unit 1 Order online at sealing Technologies, Freudenberg 49451122
We use cookies to improve user experience and display personalized advertisements. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy policy.
Click here.
Learn how Google uses personal data when you give consent. Click here.
This website uses cookies
We use cookies to improve user experience and display personalized advertisements. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy policy. Click here.
Strictly necessary
Strictly necessary cookies allow core website functionality such as user login and account management. The website cannot be used properly without strictly necessary cookies.
Cookie generated by applications based on the PHP language. This is a general purpose identifier used to maintain user session variables. It is normally a random generated number, how it is used can be specific to the site, but a good example is maintaining a logged-in status for a user between pages.
Performance
Performance cookies are used to see how visitors use the website, eg. analytics cookies. Those cookies cannot be used to directly identify a certain visitor.
Targeting cookies are used to identify visitors between different websites, eg. content partners, banner networks. Those cookies may be used by companies to build a profile of visitor interests or show relevant ads on other websites.
A cookie that holds the current session data. This ensues that subsequent requests within the session window will be attributed to the same Hotjar session.
A cookie that holds the current session data. This ensues that subsequent requests within the session window will be attributed to the same Hotjar session.
Unclassified
Unclassified cookies are cookies that do not belong to any other category or are in the process of categorization.
Cookies are small text files that are placed on your computer by websites that you visit. Websites use cookies to help users navigate efficiently and perform certain functions. Cookies that are required for the website to operate properly are allowed to be set without your permission. All other cookies need to be approved before they can be set in the browser.
You can change your consent to cookie usage at any time on our Privacy Policy page.
Click here.
Learn how Google uses personal data when you give consent.
Click here.
Nederlands 
Deutsch 
