select distinct search.products_id, search.products_image, search.products_video, search.manufacturers_id, search.manufacturers_name, search.products_name, search.products_price, search.products_tax_class_id, UNIX_TIMESTAMP(search.products_date_activation) as datum_activation, IF(search.specials, search.specials_price, NULL) as specials_new_products_price, IF(search.specials, search.specials_price, search.products_price) as final_price, search.categories_id, search.products_ps_brandneu from products_search_detail as search JOIN products AS pro on search.products_id = pro.products_id where search.categories_status = '1' and FIND_IN_SET(27, color) and MATCH(search.ps_search_detailtag) AGAINST('_Sneakers_') AND pro.stock > 0 AND pro.products_status = 1 group by search.products_id order by search.products_date_activation desc, search.products_name
1) Only for orders placed on working days. You can find more information about our delivery times here.
2) Valid only for first registration.
3) Obligatory field.
4) 14 cents per minute (including VAT) from German landlines - 42 cents per minute (including VAT) from mobile phones. Prices may vary when calling from outside Germany.