ALBO ® Shopfitting
Polski English
Shopfitting & Gastronomy Trade Supply Wednesday, 07 January 2009
Catalog All products
Categories
Kitchen Tools (144)Table service (112)Accessories for pizza (39)Kitchen disches (159)Cooling devices (101)Equipment for bar (92)Urządzenia grzewcze (462)Food processing equipment (159)Other devicesDishwashers and Brewers (32)Chemical resources (12)Pojemniki termoizolacyjne (34)Shop furniture (25)Shop Accesories (19)Shop equipment (15)
Full List Of Categories

Use keywords to find the product you are looking for.

Advanced Search
? I cannot find, but I want ask you ...
Specials more
Calyx for coctail ; 440 cc
Calyx for coctail ; 440 cc
11.99zł
10.36zł
Show all
BAKING PAN (40x26x9)
BAKING PAN (40x26x9)
280.00zł
250.00zł
Show all
Bestsellers
1.Ewer; cap. 1.00 l
2.Glass for water / juice / drink; 286 cc
3.Glass for juice / water; 290 cc
4.Steamtable Pan 2/1 (650x530)
5.BAKING PAN (60x35x9)
All products
1054 - Unknown column 'p.products_id' in 'on clause'

SELECT p.products_id, pd.products_name, c.categories_id, c.parent_id FROM products p , categories c, products_to_categories p2c LEFT JOIN products_description pd on p.products_id = pd.products_id and pd.language_id = '5' WHERE p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' ORDER by pd.products_name asc

[TEP STOP]

Name of product