Versand & Zahlung
Warenkorb (0) | 0,00 EUR

KASSE
» Hats and caps

Steiff Kindermützen
STEIFF

Sizes:

Age Size Age Size
preemie 35 4 - 6 months 45
0 - 1 months 37 6 - 12 months 47 - 49
1 - 2 months 39 1 - 2 years 49 - 51
2 - 3 months 41 2 - 4 years 51 - 53
3 - 4 months 43 4 - 6 years 53 - 55

[ - - - ]

[ - - - ]

[ - - - ]

[ - - - ]
1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

select count(distinct p.products_id) as total from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials7 s on p.products_id = s.products_id and s.stores_id = '7' INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '7' and p.products_status = '1' and (pd.products_url like '%steiff%') and (pd.products_description like '%mütze%') and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_name like '%%' and pd.products_description like '%%' and pd.products_description like '%%' and pd.products_description like '%%' and pd.products_url like '%%' and pd.products_url like '%%' and pd.products_url like '%%' and pd.products_description like '%%' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2'

[TEP STOP]