VOLKSWAGEN

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='volkswagen' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [golf7] => Array ( [NAME] => ゴルフ7 [NAMEEN] => GOLF7 [ORDER] => 8 [COUNT] => 0 ) )
• Golf7

  ゴルフ7