array(1) {
  [0]=>
  array(18) {
    ["id"]=>
    string(4) "7224"
    ["company"]=>
    string(7) "JAKO AG"
    ["shop_code"]=>
    string(3) "B2C"
    ["language_code"]=>
    string(2) "DE"
    ["item_no"]=>
    string(7) "5002097"
    ["code"]=>
    string(11) "HOSE_LANG 4"
    ["title"]=>
    string(11) "Vorschlag 4"
    ["is_editable"]=>
    string(1) "1"
    ["creator_user_id"]=>
    string(1) "0"
    ["customer_no"]=>
    string(0) ""
    ["template_item_no"]=>
    string(0) ""
    ["template_color"]=>
    string(0) ""
    ["preview_image"]=>
    NULL
    ["hidden"]=>
    string(1) "0"
    ["configurator"]=>
    string(1) "0"
    ["configuration_price"]=>
    string(4) "0.00"
    ["model"]=>
    string(0) ""
    ["to_delete"]=>
    string(1) "0"
  }
}

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 = '5002097' OR item_no = '')
                        AND category_code = 'HOSE_LANG 4' 
                    GROUP BY code
                    ORDER BY design_order ASC