
SUBARU
 
                
						
SQL
SELECT * ,SHA.URLNAME AS SHAURLNAME   FROM M_SHASHU SHA       LEFT OUTER JOIN M_MAKER MAK ON MAK.MAKCODE = SHA.MAKCODE WHERE MAK.URLNAME='subaru'    AND SHA.HYOJIFLG = 1  ORDER BY SHA.SORTORDER DESC,SHA.SHANAMEEN
Array
(
    [brz] => Array
        (
            [NAME] => 
            [NAMEEN] => BRZ
            [ORDER] => 14
            [COUNT] => 0
        )
    [wrx] => Array
        (
            [NAME] => 
            [NAMEEN] => WRX
            [ORDER] => 14
            [COUNT] => 1
        )
    [xv] => Array
        (
            [NAME] => 
            [NAMEEN] => XV
            [ORDER] => 14
            [COUNT] => 2
        )
    [exiga] => Array
        (
            [NAME] => エクシーガ
            [NAMEEN] => EXIGA
            [ORDER] => 14
            [COUNT] => 3
        )
    [impreza] => Array
        (
            [NAME] => インプレッサ
            [NAMEEN] => IMPREZA
            [ORDER] => 14
            [COUNT] => 4
        )
    [impreza_sport] => Array
        (
            [NAME] => インプレッサ スポーツ
            [NAMEEN] => IMPREZA SPORT
            [ORDER] => 14
            [COUNT] => 5
        )
    [exiga_crossover_7] => Array
        (
            [NAME] => クロスオーバー7
            [NAMEEN] => EXIGA CROSSOVER 7
            [ORDER] => 14
            [COUNT] => 6
        )
    [justy] => Array
        (
            [NAME] => ジャスティ
            [NAMEEN] => JUSTY
            [ORDER] => 14
            [COUNT] => 7
        )
    [forester] => Array
        (
            [NAME] => フォレスター
            [NAMEEN] => FORESTER
            [ORDER] => 14
            [COUNT] => 8
        )
    [legacy] => Array
        (
            [NAME] => レガシィ
            [NAMEEN] => LEGACY
            [ORDER] => 14
            [COUNT] => 9
        )
    [legacy_b4] => Array
        (
            [NAME] => レガシィB4
            [NAMEEN] => LEGACY B4
            [ORDER] => 14
            [COUNT] => 10
        )
    [legacy_outback] => Array
        (
            [NAME] => レガシィ アウトバック
            [NAMEEN] => LEGACY OUTBACK
            [ORDER] => 14
            [COUNT] => 11
        )
    [levorg] => Array
        (
            [NAME] => レヴォーグ
            [NAMEEN] => LEVORG
            [ORDER] => 14
            [COUNT] => 12
        )
    [lucra] => Array
        (
            [NAME] => ルクラ
            [NAMEEN] => LUCRA
            [ORDER] => 14
            [COUNT] => 13
        )
)
 
 
         
            - 
              
              
              BRZ 
              
               
              
              
             
 
         
            - 
              
              
              WRX 
              
               
              
              
             
 
         
            - 
              
              
              XV 
              
               
              
              
             
 
         
            - 
              
              
              EXIGA 
              
              エクシーガ
              
              
             
 
         
            - 
              
              
              IMPREZA 
              
              インプレッサ
              
              
             
 
         
            - 
              
              
              IMPREZA SPORT 
              
              インプレッサ スポーツ
              
              
             
 
         
            - 
              
              
              EXIGA CROSSOVER 7 
              
              クロスオーバー7
              
              
             
 
         
            - 
              
              
              JUSTY 
              
              ジャスティ
              
              
             
 
         
            - 
              
              
              FORESTER 
              
              フォレスター
              
              
             
 
         
            - 
              
              
              LEGACY 
              
              レガシィ
              
              
             
 
         
            - 
              
              
              LEGACY B4 
              
              レガシィB4
              
              
             
 
         
            - 
              
              
              LEGACY OUTBACK 
              
              レガシィ アウトバック
              
              
             
 
         
            - 
              
              
              LEVORG 
              
              レヴォーグ
              
              
             
 
         
            - 
              
              
              LUCRA 
              
              ルクラ