Catalog » SPARE PARTS My Account    
Categories
Quick Find
Keyword(s):
Price Range:
to
Specials
View all
Manufacturers
Translate
 
Information
Contact
Tel
032 376-18-40
Tel
032 376-18-42
GSM
502 749 027
Open Hours
8-16
Who's online?
There currently are

 online.
SPARE PARTS
Categories
SPARE PARTS FOR MODELS - E-SKY
SPARE PARTS FOR MODELS - E-SKY
SPARE PARTS FOR MODELS - HENG LONG
SPARE PARTS FOR MODELS - HENG LONG
SPARE PARTS FOR MODELS - Lanyu
SPARE PARTS FOR MODELS - Lanyu
SPARE PARTS FOR BOATS
SPARE PARTS FOR BOATS
SPARE PARTS FOR ELECTRIC CARS
SPARE PARTS FOR ELECTRIC CARS
SPARE PARTS FOR DIESEL CARS
SPARE PARTS FOR DIESEL CARS
Aircraft spare parts
Aircraft spare parts
SPARE PARTS FOR HELICOPTERS
SPARE PARTS FOR HELICOPTERS
What's New Here?
Show:
Sort products by:
Show products:
Promotional Products:
Number of results per page: 
Displaying 1 to 9 (of 9 products) Result Pages:  1 
    Product Name   Manufacturer   Price   Buy Now 
 
      Price:
81,30 zł (excl. TAX)
100,00 zł (incl. TAX)

  
 
    HENG-LONG  Price:
4,88 zł (excl. TAX)
6,00 zł (incl. TAX)

  
 
    HENG-LONG  Price:
4,88 zł (excl. TAX)
6,00 zł (incl. TAX)

  
 
    HENG-LONG  Price:
4,88 zł (excl. TAX)
6,00 zł (incl. TAX)

  
 
    HENG-LONG  Price:
4,88 zł (excl. TAX)
6,00 zł (incl. TAX)

  
 
    LANYU  Price:
39,84 zł (excl. TAX)
49,00 zł (incl. TAX)
Sold
  
 
      Price:
20,33 zł (excl. TAX)
25,00 zł (incl. TAX)

  
 
      Price:
4,07 zł (excl. TAX)
5,00 zł (incl. TAX)

  
 
      Price:
3,25 zł (excl. TAX)
4,00 zł (incl. TAX)

  
Displaying 1 to 9 (of 9 products) Result Pages:  1 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-' at line 1

select distinct p.products_id, products_quantity, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s, categories c, products_to_categories p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and c.categories_id in (18,19,51,52,53,55,59,119,120,149,150,151,154,20,50,54,56,147,21,22,121,122,123,124,125,126,127,128,129,130,146,112,116,131,132,133,134,135,136,137,138,139,140,141,142,143,152,153,164,165,166,168,169,171,177,113,114,148,170,4) and pd.language_id = '2' and s.status = '1' and ((s.customers_id = '0' and s.customers_groups_id = '0') or (s.customers_id = '0' and s.customers_groups_id = '') or (s.customers_id = '0' and s.customers_groups_id = '0')) order by RAND() limit -

[TEP STOP]