G-CORPORATION

車種から選択

Array ( [slug] => g-corporation [brand_code] => 11 )
SQL
SELECT MAK.* , SHA.* , SHA.URLNAME SHAURLNAME , SHA.URLNAME SHAURLNAME , GRP.GRPNAME FROM M_SHOHINGRP GRP LEFT OUTER JOIN M_JYOKEN JYO ON JYO.GRPCODE = GRP.GRPCODE LEFT OUTER JOIN M_MAKER MAK ON JYO.MAKCODE = MAK.MAKCODE LEFT OUTER JOIN M_SHASHU SHA ON JYO.MAKCODE = SHA.MAKCODE AND JYO.SHACODE = SHA.SHACODE LEFT OUTER JOIN ( SELECT GRPCODE, COUNT(HINCODE) AS COUNTS FROM M_HIN WHERE ECTORIFLG = 1 AND HINTEISHI IS NULL GROUP BY GRPCODE ) CNT ON CNT.GRPCODE = GRP.GRPCODE WHERE GRP.BRACODE = 11 AND GRP.HYOJIFLG = 1 AND NOT COALESCE( CNT.COUNTS, '0') = 0 GROUP BY SHA.MAKCODE , SHA.SHACODE ORDER BY SHA.SORTORDER DESC
Array ( [vellfire] => Array ( [NAME] => ヴェルファイア [NAMEEN] => VELLFIRE [ORDER] => 90 [BRACODE] => 11 [COUNT] => 0 ) [vitz] => Array ( [NAME] => ヴィッツ [NAMEEN] => Vitz [ORDER] => 90 [BRACODE] => 11 [COUNT] => 1 ) [voxy] => Array ( [NAME] => ヴォクシー [NAMEEN] => VOXY [ORDER] => 90 [BRACODE] => 11 [COUNT] => 2 ) [alphard] => Array ( [NAME] => アルファード [NAMEEN] => ALPHARD [ORDER] => 90 [BRACODE] => 11 [COUNT] => 3 ) [noah] => Array ( [NAME] => ノア [NAMEEN] => NOAH [ORDER] => 50 [BRACODE] => 11 [COUNT] => 4 ) [freed] => Array ( [NAME] => フリード [NAMEEN] => FREED [ORDER] => 40 [BRACODE] => 11 [COUNT] => 5 ) [prius] => Array ( [NAME] => プリウス [NAMEEN] => PRIUS [ORDER] => 40 [BRACODE] => 11 [COUNT] => 6 ) [hiace] => Array ( [NAME] => ハイエース [NAMEEN] => HIACE [ORDER] => 40 [BRACODE] => 11 [COUNT] => 7 ) [march] => Array ( [NAME] => マーチ [NAMEEN] => MARCH [ORDER] => 30 [BRACODE] => 11 [COUNT] => 8 ) [regiusace] => Array ( [NAME] => レジアスエース [NAMEEN] => REGIUSACE [ORDER] => 10 [BRACODE] => 11 [COUNT] => 9 ) [] => Array ( [NAME] => [NAMEEN] => [ORDER] => [BRACODE] => 11 [COUNT] => 10 ) )
• VELLFIRE

  ヴェルファイア

• Vitz

  ヴィッツ

• VOXY

  ヴォクシー

• ALPHARD

  アルファード

• NOAH

  ノア

• FREED

  フリード

• PRIUS

  プリウス

• HIACE

  ハイエース

• MARCH

  マーチ

• REGIUSACE

  レジアスエース