TL_OBERTEIL_1SELECT 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 = '5000613' OR item_no = '')
AND category_code = 'TL_OBERTEIL_1'
GROUP BY code
ORDER BY design_order ASCArray
(
[0] => Array
(
[id] => 2300
[code] => 0
[view_title] =>
[category_code] => TL_OBERTEIL_1
[design_order] => 0
)
[1] => Array
(
[id] => 2301
[code] => 1
[view_title] =>
[category_code] => TL_OBERTEIL_1
[design_order] => 2
)
)
98500123327453305008SELECT 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 = '5000613' OR item_no = '')
AND category_code = '98500123327453305008'
GROUP BY code
ORDER BY design_order ASCArray
(
[0] => Array
(
[id] => 47785
[code] => 0
[view_title] =>
[category_code] => 98500123327453305008
[design_order] => 0
)
[1] => Array
(
[id] => 47786
[code] => 1
[view_title] =>
[category_code] => 98500123327453305008
[design_order] => 2
)
)
98500123327453305008SELECT 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 = '5000613' OR item_no = '')
AND category_code = '98500123327453305008'
GROUP BY code
ORDER BY design_order ASCArray
(
[0] => Array
(
[id] => 47785
[code] => 0
[view_title] =>
[category_code] => 98500123327453305008
[design_order] => 0
)
[1] => Array
(
[id] => 47786
[code] => 1
[view_title] =>
[category_code] => 98500123327453305008
[design_order] => 2
)
)
Gemachtigde vertegenwoordiger Raad van Bestuur::
INVULLEN A.U.B.
Handelsregister::
INVULLEN A.U.B.
BTW-nummer::
INVULLEN A.U.B.
Nota over geschillenbeslechting::
De Europese Commissie stelt een online-platform ter beschikking, dat u via volgende link kan raadplegen https://ec.europa.eu/consumers/odr. Wij zijn niet verplicht, noch bereid deel te nemen aan een geschillenbeslechtingsprocedure voor een bureau voor consumentengeschillenbeslechting.