SUBARU
SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='subaru' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array
(
[brz] => Array
(
[NAME] =>
[NAMEEN] => BRZ
[ORDER] => 14
[COUNT] => 0
)
[wrx] => Array
(
[NAME] =>
[NAMEEN] => WRX
[ORDER] => 14
[COUNT] => 1
)
[xv] => Array
(
[NAME] =>
[NAMEEN] => XV
[ORDER] => 14
[COUNT] => 2
)
[exiga] => Array
(
[NAME] => エクシーガ
[NAMEEN] => EXIGA
[ORDER] => 14
[COUNT] => 3
)
[impreza] => Array
(
[NAME] => インプレッサ
[NAMEEN] => IMPREZA
[ORDER] => 14
[COUNT] => 4
)
[impreza_sport] => Array
(
[NAME] => インプレッサ スポーツ
[NAMEEN] => IMPREZA SPORT
[ORDER] => 14
[COUNT] => 5
)
[exiga_crossover_7] => Array
(
[NAME] => クロスオーバー7
[NAMEEN] => EXIGA CROSSOVER 7
[ORDER] => 14
[COUNT] => 6
)
[justy] => Array
(
[NAME] => ジャスティ
[NAMEEN] => JUSTY
[ORDER] => 14
[COUNT] => 7
)
[forester] => Array
(
[NAME] => フォレスター
[NAMEEN] => FORESTER
[ORDER] => 14
[COUNT] => 8
)
[legacy] => Array
(
[NAME] => レガシィ
[NAMEEN] => LEGACY
[ORDER] => 14
[COUNT] => 9
)
[legacy_b4] => Array
(
[NAME] => レガシィB4
[NAMEEN] => LEGACY B4
[ORDER] => 14
[COUNT] => 10
)
[legacy_outback] => Array
(
[NAME] => レガシィ アウトバック
[NAMEEN] => LEGACY OUTBACK
[ORDER] => 14
[COUNT] => 11
)
[levorg] => Array
(
[NAME] => レヴォーグ
[NAMEEN] => LEVORG
[ORDER] => 14
[COUNT] => 12
)
[lucra] => Array
(
[NAME] => ルクラ
[NAMEEN] => LUCRA
[ORDER] => 14
[COUNT] => 13
)
)
-
BRZ
-
WRX
-
XV
-
EXIGA
エクシーガ
-
IMPREZA
インプレッサ
-
IMPREZA SPORT
インプレッサ スポーツ
-
EXIGA CROSSOVER 7
クロスオーバー7
-
JUSTY
ジャスティ
-
FORESTER
フォレスター
-
LEGACY
レガシィ
-
LEGACY B4
レガシィB4
-
LEGACY OUTBACK
レガシィ アウトバック
-
LEVORG
レヴォーグ
-
LUCRA
ルクラ