Nuert Pompe, GWS Global Water Service

Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/jhblfdro/shop-old.gwsonline.eu/includes/functions/compatibility.php on line 46

Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/jhblfdro/shop-old.gwsonline.eu/includes/functions/compatibility.php on line 22

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; shoppingCart has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/shopping_cart.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; navigationHistory has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/navigation_history.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; currencies has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/currencies.php on line 16

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; PriceFormatter has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/PriceFormatter.php on line 21

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; PriceFormatterStore has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/PriceFormatterStore.php on line 15

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; mime has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/mime.php on line 18

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; email has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/email.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; language has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/language.php on line 16

Warning: Use of undefined constant ENTRY_GROUP_NAME_MIN_LENGTH - assumed 'ENTRY_GROUP_NAME_MIN_LENGTH' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/languages/english.php on line 173

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; actionRecorder has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/action_recorder.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; alertBlock has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/alertbox.php on line 12

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; messageStack has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/message_stack.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; splitPageResults has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/split_page_results.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; tableBox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; infoBox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 75

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; infoBoxHeading has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 100

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; contentBox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 132

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; contentBoxHeading has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 148

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; errorBox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 165

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; productListingBox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/boxes.php on line 172

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; oscTemplate has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/osc_template.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; breadcrumb has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/classes/breadcrumb.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_shopping_cart has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_shopping_cart.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_professionalonly has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_professionalonly.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_search has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_search.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_categories has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_categories.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_manufacturers has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_manufacturers.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_card_acceptance has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_card_acceptance.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_manufacturer_info has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_manufacturer_info.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_product_notifications has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_product_notifications.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_product_social_bookmarks has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_product_social_bookmarks.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bm_specials has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/boxes/bm_specials.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_alternate has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_alternate.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_manufacturer_title has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_manufacturer_title.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_category_title has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_category_title.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_product_title has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_product_title.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_canonical has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_canonical.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_robot_noindex has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_robot_noindex.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_datepicker_jquery has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_datepicker_jquery.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_google_analytics has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_google_analytics.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_grid_list_view has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_grid_list_view.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_table_click_jquery has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_table_click_jquery.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_product_colorbox has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_product_colorbox.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ht_noscript has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/header_tags/ht_noscript.php on line 13
Nuert Pompe, GWS Global Water Service

JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_buttons has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_buttons.php on line 13

Warning: Use of undefined constant MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION - assumed 'MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_buttons.php on line 27

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_logo has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_logo.php on line 13

Warning: Use of undefined constant MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION - assumed 'MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_logo.php on line 27

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_search has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_search.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_text has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_text.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_flags has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_flags.php on line 13

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; cm_header_breadcrumb has a deprecated constructor in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_breadcrumb.php on line 13

Warning: Use of undefined constant MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION - assumed 'MODULE_CONTENT_BOOTSTRAP_ROW_DESCRIPTION' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/cm_header_breadcrumb.php on line 27

Warning: Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/templates/logo.php on line 1
>

Warning: Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/templates/search.php on line 1
>

Are you a Professional?
Sign up and start purchasing!

Warning: Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/modules/content/header/templates/breadcrumb.php on line 1
>

Warning: Use of undefined constant php - assumed 'php' (this will throw an Error in a future version of PHP) in /home/jhblfdro/shop-old.gwsonline.eu/includes/template_top.php on line 148
class="hasShadow">

List Products By Brand

List Products By Category

List Products By Application

1054 - Unknown column 'p2c.sort_order' in 'SELECT'

select p.products_image, p2c.sort_order, pd.products_name, p.products_min_order_qty, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '3' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '31' order by p2c.sort_order, pd.products_name limit 0, 20

[TEP STOP]