JEEP

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='jeep' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [cherokee] => Array ( [NAME] => チェロキー [NAMEEN] => Cherokee [ORDER] => 7 [COUNT] => 0 ) [compass] => Array ( [NAME] => コンパス [NAMEEN] => Compass [ORDER] => 7 [COUNT] => 1 ) [grandcherokee] => Array ( [NAME] => グランドチェロキー [NAMEEN] => GrandCherokee [ORDER] => 7 [COUNT] => 2 ) [patriot] => Array ( [NAME] => パトリオット [NAMEEN] => Patriot [ORDER] => 7 [COUNT] => 3 ) [wrangler] => Array ( [NAME] => ラングラー [NAMEEN] => Wrangler [ORDER] => 7 [COUNT] => 4 ) )
• Cherokee

  チェロキー

• Compass

  コンパス

• GrandCherokee

  グランドチェロキー

• Patriot

  パトリオット

• Wrangler

  ラングラー