HONDA

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='honda' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [cr-v] => Array ( [NAME] => [NAMEEN] => CR-V [ORDER] => 17 [COUNT] => 0 ) [cr-z] => Array ( [NAME] => [NAMEEN] => CR-Z [ORDER] => 17 [COUNT] => 1 ) [n-box] => Array ( [NAME] => [NAMEEN] => N-BOX [ORDER] => 17 [COUNT] => 2 ) [n-box_plus] => Array ( [NAME] => [NAMEEN] => N-BOX+ [ORDER] => 17 [COUNT] => 3 ) [n-box_slash] => Array ( [NAME] => [NAMEEN] => N-BOXSLASH [ORDER] => 17 [COUNT] => 4 ) [n-one] => Array ( [NAME] => [NAMEEN] => N-ONE [ORDER] => 17 [COUNT] => 5 ) [n-van] => Array ( [NAME] => [NAMEEN] => N-VAN [ORDER] => 17 [COUNT] => 6 ) [n-wgn] => Array ( [NAME] => [NAMEEN] => N-WGN [ORDER] => 17 [COUNT] => 7 ) [nsx] => Array ( [NAME] => [NAMEEN] => NSX [ORDER] => 17 [COUNT] => 8 ) [s2000] => Array ( [NAME] => [NAMEEN] => S2000 [ORDER] => 17 [COUNT] => 9 ) [s660] => Array ( [NAME] => [NAMEEN] => S660 [ORDER] => 17 [COUNT] => 10 ) [accord] => Array ( [NAME] => アコード [NAMEEN] => ACCORD [ORDER] => 17 [COUNT] => 11 ) [elysion] => Array ( [NAME] => エリシオン [NAMEEN] => ELYSION [ORDER] => 17 [COUNT] => 12 ) [insight] => Array ( [NAME] => インサイト [NAMEEN] => INSIGHT [ORDER] => 17 [COUNT] => 13 ) [odyssey] => Array ( [NAME] => オデッセイ [NAMEEN] => ODYSSEY [ORDER] => 17 [COUNT] => 14 ) [vezel] => Array ( [NAME] => ヴェゼル [NAMEEN] => VEZEL [ORDER] => 17 [COUNT] => 15 ) [clarity_phev] => Array ( [NAME] => クラリティPHEV [NAMEEN] => CLARITY PHEV [ORDER] => 17 [COUNT] => 16 ) [grace] => Array ( [NAME] => グレイス [NAMEEN] => GRACE [ORDER] => 17 [COUNT] => 17 ) [civic-hatchback] => Array ( [NAME] => シビック ハッチバック [NAMEEN] => CIVIC HATCHBACK [ORDER] => 17 [COUNT] => 18 ) [civic-sedan] => Array ( [NAME] => シビック セダン [NAMEEN] => CIVIC SEDAN [ORDER] => 17 [COUNT] => 19 ) [civic-type-r] => Array ( [NAME] => シビック タイプR [NAMEEN] => CIVIC TYPE R [ORDER] => 17 [COUNT] => 20 ) [jade] => Array ( [NAME] => ジェイド [NAMEEN] => JADE [ORDER] => 17 [COUNT] => 21 ) [shuttle] => Array ( [NAME] => シャトル [NAMEEN] => SHUTTLE [ORDER] => 17 [COUNT] => 22 ) [stepwgn] => Array ( [NAME] => ステップワゴン [NAMEEN] => STEPWGN [ORDER] => 17 [COUNT] => 23 ) [stream] => Array ( [NAME] => ストリーム [NAMEEN] => STREAM [ORDER] => 17 [COUNT] => 24 ) [fit] => Array ( [NAME] => フィット [NAMEEN] => Fit [ORDER] => 17 [COUNT] => 25 ) [freed] => Array ( [NAME] => フリード [NAMEEN] => FREED [ORDER] => 17 [COUNT] => 26 ) [freed_plus] => Array ( [NAME] => フリード プラス [NAMEEN] => FREED＋ [ORDER] => 17 [COUNT] => 27 ) [vamos] => Array ( [NAME] => バモス [NAMEEN] => VAMOS [ORDER] => 17 [COUNT] => 28 ) [legend] => Array ( [NAME] => レジェンド [NAMEEN] => LEGEND [ORDER] => 17 [COUNT] => 29 ) )
• CR-V

   

• CR-Z

   

• N-BOX

   

• N-BOX＋

   

• N-BOX SLASH

   

• N-ONE

   

• N-VAN

   

• N-WGN

   

• NSX

   

• S2000

   

• S660

   

• ACCORD

  アコード

• ELYSION

  エリシオン

• INSIGHT

  インサイト

• ODYSSEY

  オデッセイ

• VEZEL

  ヴェゼル

• CLARITY PHEV

  クラリティPHEV

• GRACE

  グレイス

• CIVIC HATCHBACK

  シビック ハッチバック

• CIVIC SEDAN

  シビック セダン

• CIVIC TYPE R

  シビック タイプR

• JADE

  ジェイド

• SHUTTLE

  シャトル

• STEPWGN

  ステップワゴン

• STREAM

  ストリーム

• Fit

  フィット

• FREED

  フリード

• FREED＋

  フリード プラス

• VAMOS

  バモス

• LEGEND

  レジェンド