LEXUS

SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME FROM M_SHASHU SHA LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='lexus' AND SHA.HYOJIFLG = 1 ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array ( [ct] => Array ( [NAME] => [NAMEEN] => CT [ORDER] => 20 [COUNT] => 0 ) [gs] => Array ( [NAME] => [NAMEEN] => GS [ORDER] => 20 [COUNT] => 1 ) [hs] => Array ( [NAME] => [NAMEEN] => HS [ORDER] => 20 [COUNT] => 2 ) [is] => Array ( [NAME] => [NAMEEN] => IS [ORDER] => 20 [COUNT] => 3 ) [lc] => Array ( [NAME] => [NAMEEN] => LC [ORDER] => 20 [COUNT] => 4 ) [ls] => Array ( [NAME] => [NAMEEN] => LS [ORDER] => 20 [COUNT] => 5 ) [lx] => Array ( [NAME] => [NAMEEN] => LX [ORDER] => 20 [COUNT] => 6 ) [nx] => Array ( [NAME] => [NAMEEN] => NX [ORDER] => 20 [COUNT] => 7 ) [rc] => Array ( [NAME] => [NAMEEN] => RC [ORDER] => 20 [COUNT] => 8 ) [rx] => Array ( [NAME] => [NAMEEN] => RX [ORDER] => 20 [COUNT] => 9 ) [es] => Array ( [NAME] => [NAMEEN] => ES [ORDER] => 20 [COUNT] => 10 ) [ux] => Array ( [NAME] => [NAMEEN] => UX [ORDER] => 20 [COUNT] => 11 ) )
• CT

   

• GS

   

• HS

   

• IS

   

• LC

   

• LS

   

• LX

   

• NX

   

• RC

   

• RX

   

• ES

   

• UX