SELECT id, code, title as view_title, category_code 
                    ,(CASE
                        WHEN code =  0 THEN 0  /* Front */
                        WHEN code =  2 THEN 1  /* Side 1 */
                        WHEN code =  1 THEN 2  /* Back */
                        WHEN code =  4 THEN 3  /* Side 2 */
                        ELSE code
                    END) AS design_order
                    FROM shop_design_item_view
                    WHERE company = 'JAKO AG' 
                        AND shop_code = 'B2C' 
                        #AND language_code = 'NLB' 
                        AND (item_no = '5000826' OR item_no = '')
                        AND category_code = 'TL_OBERTEIL_1' 
                    GROUP BY code
                    ORDER BY design_order ASCArray
(
    [0] => Array
        (
            [id] => 18241
            [code] => 0
            [view_title] => 
            [category_code] => TL_OBERTEIL_1
            [design_order] => 0
        )

    [1] => Array
        (
            [id] => 18242
            [code] => 1
            [view_title] => 
            [category_code] => TL_OBERTEIL_1
            [design_order] => 2
        )

)

SELECT id, code, title as view_title, category_code 
                    ,(CASE
                        WHEN code =  0 THEN 0  /* Front */
                        WHEN code =  2 THEN 1  /* Side 1 */
                        WHEN code =  1 THEN 2  /* Back */
                        WHEN code =  4 THEN 3  /* Side 2 */
                        ELSE code
                    END) AS design_order
                    FROM shop_design_item_view
                    WHERE company = 'JAKO AG' 
                        AND shop_code = 'B2C' 
                        #AND language_code = 'NLB' 
                        AND (item_no = '5000826' OR item_no = '')
                        AND category_code = '42214032332747383109' 
                    GROUP BY code
                    ORDER BY design_order ASCArray
(
    [0] => Array
        (
            [id] => 46397
            [code] => 0
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 0
        )

    [1] => Array
        (
            [id] => 46398
            [code] => 2
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 1
        )

    [2] => Array
        (
            [id] => 46399
            [code] => 1
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 2
        )

    [3] => Array
        (
            [id] => 46400
            [code] => 3
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 3
        )

)

SELECT id, code, title as view_title, category_code 
                    ,(CASE
                        WHEN code =  0 THEN 0  /* Front */
                        WHEN code =  2 THEN 1  /* Side 1 */
                        WHEN code =  1 THEN 2  /* Back */
                        WHEN code =  4 THEN 3  /* Side 2 */
                        ELSE code
                    END) AS design_order
                    FROM shop_design_item_view
                    WHERE company = 'JAKO AG' 
                        AND shop_code = 'B2C' 
                        #AND language_code = 'NLB' 
                        AND (item_no = '5000826' OR item_no = '')
                        AND category_code = '42214032332747383109' 
                    GROUP BY code
                    ORDER BY design_order ASCArray
(
    [0] => Array
        (
            [id] => 46397
            [code] => 0
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 0
        )

    [1] => Array
        (
            [id] => 46398
            [code] => 2
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 1
        )

    [2] => Array
        (
            [id] => 46399
            [code] => 1
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 2
        )

    [3] => Array
        (
            [id] => 46400
            [code] => 3
            [view_title] => 
            [category_code] => 42214032332747383109
            [design_order] => 3
        )

)

JAKO Ziptop Challenge

Artikelnummer: 8621

Beschikbaar tot 2024

Individuele Verpakking Teambestelling

Kinderen

128

140

152

164

Unisex

S

M

L

XL

XXL

3XL

Verplichte bedrukkingsposities

Clublogo Climb Up

Sponsorlogo

Clublogo Climb Up + sponsor

vanaf € 44,99

Prijs incl. 21% BTW excl. verzendkosten

artikel onmiddellijk beschikbaar

Leverbaar binnen 8 werkdagen

niet beschikbaar

In de winkelwagen

Kinderen

Maat

-----Kinder128140152164UnisexSMLXLXXL3XL

Prijs

vanaf € 44,99

Aantal

Maat

-----Kinder128140152164UnisexSMLXLXXL3XL

Prijs

vanaf € 44,99

Aantal

Speler toevoegen Alles in het winkelmandje

 

Beschrijving

Perfect op maat en optimale bewegingsvrijheid
De ziptop Challenge is voorzien van een body met zachte fleece-binnenzijde. Dit maakt de ziptop bijzonder comfortabel om dragen. Voor de perfecte pasvorm en bewegingsvrijheid bij het sporten zorgen de mouwen, gemaakt van een zeer elastische polyester-elastaanmix. Ontdek nu de ziptop Challenge in de JAKO-Onlineshop.

Details

• Elastische contrasterende inzet aan taille- en mouwafsluiting
• Teamline label
• Contrasterende tape aan zijkanten
• Mouwen uit bijzonder elastische Polyester-Elasthan-mix
• Polyester-Stretch-Fleece
• Contrasterende tape aan schouders
• Body met zachte fleece binnenzijde
• Verlengde rug

Materiaal

• 100 % Polyester
• Materiaal mouwen: 90 % Polyester, 10 % Elasthan