cPath
keywords
order by
sort
page
od
cena_od
cena_do
age_from
size
color
category
character
brand
qs

» Opieka nad dzieckiem

Opieka nad dzieckiem Canpol Babies

TOTAL_SALE

1.

NIANIA VTECH VM 5255 VIDEO   
W magazynie    
672.59 zł
 
2.
377.93 zł
 
4.

INNOGIO GIO-370 Podgrzewacz do butelek   
W magazynie    
268.62 zł
 
5.
260.69 zł
 
6.
250.00 zł
 
7.

KINDERKRAFT Nosidełko HUGGY GREY stars   
W magazynie    
228.79 zł
 
8.
204.66 zł
 
9.
186.72 zł
 
10.
162.41 zł
 
11.

Nocnik edukacyjny z dzwiękiem   
W magazynie    
126.38 zł 83.28 zł
USETRITE: 43.10 zł
12.

PIELUCHA TETRA 80/80 LUX (1 opak - 20 szt)   
W magazynie    
120.52 zł
 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND p.products_delivery = 'ihned' AND pd.products_name <> '' AND' at line 13

SELECT DISTINCT p.suppliers_prefered, p.products_id, p.products_delivery, pd.products_name, pd.products_description, p.products_delivery, p.products_image, p.manufacturers_id, p.size, p.age_from, p.age_to, IFNULL(pp.products_tax_class_id, p.products_tax_class_id) AS products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price FROM products p LEFT JOIN products_prices pp ON pp.products_id = p.products_id AND pp.language_id = '10' LEFT JOIN specials s on p.products_id = s.products_id, products_description pd, products_to_categories_active p2c, categories c WHERE ( p2c.categories_id = 557 ) AND pd.language_id = '10' AND ( ) AND p.products_delivery = 'ihned' AND pd.products_name <> '' AND p.products_status = '1' AND p.products_id = pd.products_id AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id ORDER BY p.suppliers_prefered desc, p.products_ordered_last_3_month desc, pd.products_name limit 6

[TEP STOP]