Mercedes-Benz
SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='mercedes-benz' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array
(
[a_class] => Array
(
[NAME] => Aクラス
[NAMEEN] => A-Class
[ORDER] => 11
[COUNT] => 0
)
[b_class] => Array
(
[NAME] => Bクラス
[NAMEEN] => B-Class
[ORDER] => 11
[COUNT] => 1
)
[c_class] => Array
(
[NAME] => Cクラス
[NAMEEN] => C-Class
[ORDER] => 11
[COUNT] => 2
)
[c_classwagon] => Array
(
[NAME] => Cクラス ステーションワゴン
[NAMEEN] => C-Class Stationwagon
[ORDER] => 11
[COUNT] => 3
)
[cla_class] => Array
(
[NAME] => CLAクーペ
[NAMEEN] => CLA Coupe
[ORDER] => 11
[COUNT] => 4
)
[cla_shootingbrake] => Array
(
[NAME] => CLAシューティングブレーク
[NAMEEN] => CLA Shooting Brake
[ORDER] => 11
[COUNT] => 5
)
[cls_class] => Array
(
[NAME] => CLSクーペ
[NAMEEN] => CLS Coupe
[ORDER] => 11
[COUNT] => 6
)
[cls_shootingbrake] => Array
(
[NAME] => CLSシューティングブレーク
[NAMEEN] => CLS Shooting Brake
[ORDER] => 11
[COUNT] => 7
)
[e_class] => Array
(
[NAME] => Eクラス
[NAMEEN] => E-Class
[ORDER] => 11
[COUNT] => 8
)
[glc_class] => Array
(
[NAME] => GLC
[NAMEEN] => GLC
[ORDER] => 11
[COUNT] => 9
)
[glk_class] => Array
(
[NAME] => GLK
[NAMEEN] => GLK
[ORDER] => 11
[COUNT] => 10
)
[s_classcoupe] => Array
(
[NAME] => Sクラス クーペ
[NAMEEN] => S-Class Coupe
[ORDER] => 11
[COUNT] => 11
)
[s_class] => Array
(
[NAME] => Sクラス セダン
[NAMEEN] => S-Class Sedan
[ORDER] => 11
[COUNT] => 12
)
[slc_class] => Array
(
[NAME] => SLC
[NAMEEN] => SLC
[ORDER] => 11
[COUNT] => 13
)
[v_class] => Array
(
[NAME] => Vクラス
[NAMEEN] => V-Class
[ORDER] => 11
[COUNT] => 14
)
)
-
A-Class
Aクラス
-
B-Class
Bクラス
-
C-Class
Cクラス
-
C-Class Stationwagon
Cクラス ステーションワゴン
-
CLA Coupe
CLAクーペ
-
CLA Shooting Brake
CLAシューティングブレーク
-
CLS Coupe
CLSクーペ
-
CLS Shooting Brake
CLSシューティングブレーク
-
E-Class
Eクラス
-
GLC
GLC
-
GLK
GLK
-
S-Class Coupe
Sクラス クーペ
-
S-Class Sedan
Sクラス セダン
-
SLC
SLC
-
V-Class
Vクラス
車種別検索
