フロアマット用品

SQL
SELECT * , GRP.URLNAME AS GRPURLNAME FROM M_SHOHINGRP GRP LEFT OUTER JOIN M_JYOKEN JYO ON JYO.GRPCODE = GRP.GRPCODE LEFT OUTER JOIN M_BRAND BRA ON BRA.BRACODE = GRP.BRACODE LEFT OUTER JOIN M_ECHIN ECH ON ECH.GRPCODE = GRP.GRPCODE 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.HYOJIFLG = 1 AND (( BNRCODE=1 AND CBNRCODE=13) OR ( BNRCODE=3 AND CBNRCODE=9) OR ( BNRCODE=4 AND CBNRCODE=10) ) AND NOT COALESCE( CNT.COUNTS, '0') = 0 ORDER BY GRP.SORTORDER DESC, GRP.GRPNAME
Array ( [item00000283] => Array ( [NAME] => GS-i プレミアムフロアマット for ノア/ヴォクシー（70系） [NAMEEN] => GS-i プレミアムフロアマット for ノア/ヴォクシー（70系） [ORDER] => 50 [GRPURLNAME] => item00000283 [BRANAMEEN] => GS-i [PRODUCTID] => 212 [COUNT] => 8 ) )
Array ( [productid] => 212 )
Array ( [productid] => 212 )
• 

  GS-i プレミアムフロアマット for ノア/ヴォクシー（70系 MC後）