SELECT * 
                              FROM shop_design_item_category
                              WHERE company = 'JAKO AG' 
                              AND shop_code = 'B2C' 
                              #AND language_code = 'EN' 
                              AND item_no = '5000372' 
                               
                              ORDER BY case when code like '%DIVERSE%' then 1 else 0 end, creator_user_id, id
                              LIMIT 1

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 = 'EN' 
                        AND (item_no = '5000372' OR item_no = '')
                        AND category_code = '' 
                    GROUP BY code
                    ORDER BY design_order ASC

Step back

JAKO Socks Lazio

Item No.: 3866 - Available until 2025

Want 30% off your next order? Become a member now

chili red/white

Team order

Size chart

Please choose size

Größe

3 (35-38)

€10.99

+

-
4 (39-42)

€10.99

+

-
5 (43-46)

€10.99

+

-

30 days right of return
Fast processing

Description

Adjust your outfit for football from head to toe. You will succeed with the sock LAZIO from JAKO. The material nestles perfectly to your calves. The 16 different colours perfectly match the various JAKO jerseys. Available in sizes 31-34, 35-38, 39-42 and 43-46, the sock fits children and adults.

Details