AUDI

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='audi' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [a3] => Array ( [NAME] => A3 [NAMEEN] => A3 [ORDER] => 9 [COUNT] => 0 ) )
• A3

  A3