NISSAN

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='nissan' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [gt-r] => Array ( [NAME] => [NAMEEN] => GT-R [ORDER] => 18 [COUNT] => 0 ) [elgrand] => Array ( [NAME] => エルグランド [NAMEEN] => ELGRAND [ORDER] => 18 [COUNT] => 1 ) [wingroad] => Array ( [NAME] => ウイングロード [NAMEEN] => WINGROAD [ORDER] => 18 [COUNT] => 2 ) [x-trail] => Array ( [NAME] => エクストレイル [NAMEEN] => X-TRAIL [ORDER] => 18 [COUNT] => 3 ) [cube] => Array ( [NAME] => キューブ [NAMEEN] => CUBE [ORDER] => 18 [COUNT] => 4 ) [cube_cubic] => Array ( [NAME] => キューブキュービック [NAMEEN] => CUBE CUBIC [ORDER] => 18 [COUNT] => 5 ) [nv350_caravan] => Array ( [NAME] => NV350 キャラバン [NAMEEN] => NV350 CARAVAN [ORDER] => 18 [COUNT] => 6 ) [skyline_crossover] => Array ( [NAME] => クロスオーバー [NAMEEN] => SKYLINE CROSSOVER [ORDER] => 18 [COUNT] => 7 ) [cima] => Array ( [NAME] => シーマ [NAMEEN] => CIMA [ORDER] => 18 [COUNT] => 8 ) [juke] => Array ( [NAME] => ジューク [NAMEEN] => JUKE [ORDER] => 18 [COUNT] => 9 ) [serena] => Array ( [NAME] => セレナ [NAMEEN] => SERENA [ORDER] => 18 [COUNT] => 10 ) [skyline] => Array ( [NAME] => スカイライン [NAMEEN] => SKYLINE [ORDER] => 18 [COUNT] => 11 ) [sylphy] => Array ( [NAME] => シルフィ [NAMEEN] => SYLPHY [ORDER] => 18 [COUNT] => 12 ) [days] => Array ( [NAME] => デイズ [NAMEEN] => DAYS [ORDER] => 18 [COUNT] => 13 ) [dayz_roox] => Array ( [NAME] => デイズルークス [NAMEEN] => DAYZ ROOX [ORDER] => 18 [COUNT] => 14 ) [teana] => Array ( [NAME] => ティアナ [NAMEEN] => TEANA [ORDER] => 18 [COUNT] => 15 ) [tiida] => Array ( [NAME] => ティーダ [NAMEEN] => TIIDA [ORDER] => 18 [COUNT] => 16 ) [note] => Array ( [NAME] => ノート [NAMEEN] => NOTE [ORDER] => 18 [COUNT] => 17 ) [fairlady_z] => Array ( [NAME] => フェアレディ Z [NAMEEN] => FAIRLADY Z [ORDER] => 18 [COUNT] => 18 ) [fuga] => Array ( [NAME] => フーガ [NAMEEN] => FUGA [ORDER] => 18 [COUNT] => 19 ) [presage] => Array ( [NAME] => プレサージュ [NAMEEN] => PRESAGE [ORDER] => 18 [COUNT] => 20 ) [march] => Array ( [NAME] => マーチ [NAMEEN] => MARCH [ORDER] => 18 [COUNT] => 21 ) [murano] => Array ( [NAME] => ムラーノ [NAMEEN] => MURANO [ORDER] => 18 [COUNT] => 22 ) [lafesta] => Array ( [NAME] => ラフェスタ [NAMEEN] => LAFESTA [ORDER] => 18 [COUNT] => 23 ) [leaf] => Array ( [NAME] => リーフ [NAMEEN] => LEAF [ORDER] => 18 [COUNT] => 24 ) [kicks] => Array ( [NAME] => キックス [NAMEEN] => KICKS [ORDER] => 18 [COUNT] => 25 ) [roox] => Array ( [NAME] => ルークス [NAMEEN] => ROOX [ORDER] => 18 [COUNT] => 26 ) )
• GT-R

   

• ELGRAND

  エルグランド

• WINGROAD

  ウイングロード

• X-TRAIL

  エクストレイル

• CUBE

  キューブ

• CUBE CUBIC

  キューブキュービック

• NV350CARAVAN

  NV350 キャラバン

• SKYLINE CROSSOVER

  クロスオーバー

• CIMA

  シーマ

• JUKE

  ジューク

• SERENA

  セレナ

• SKYLINE

  スカイライン

• SYLPHY

  シルフィ

• DAYS

  デイズ

• DAYZ ROOX

  デイズルークス

• TEANA

  ティアナ

• TIIDA

  ティーダ

• NOTE

  ノート

• FAIRLADY Z

  フェアレディ Z

• FUGA

  フーガ

• PRESAGE

  プレサージュ

• MARCH

  マーチ

• MURANO

  ムラーノ

• LAFESTA

  ラフェスタ

• LEAF

  リーフ

• ROOX

  ルークス