その他の用品

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=8) OR ( BNRCODE=3 AND CBNRCODE=4) OR ( BNRCODE=4 AND CBNRCODE=7) ) AND NOT COALESCE( CNT.COUNTS, '0') = 0 ORDER BY GRP.SORTORDER DESC, GRP.GRPNAME
Array ( [item00000043] => Array ( [NAME] => ラインストーン付 キラキラ・ライセンスフレーム [NAMEEN] => ラインストーン付 キラキラ・ライセンスフレーム [ORDER] => 50 [GRPURLNAME] => item00000043 [BRANAMEEN] => MovingCafeLabel [PRODUCTID] => 36 [COUNT] => 3 ) [item00000249] => Array ( [NAME] => ピタポン [NAMEEN] => ピタポン [ORDER] => 99 [GRPURLNAME] => item00000249 [BRANAMEEN] => G-CORPORATION [PRODUCTID] => 185 [COUNT] => 289 ) )
Array ( [productid] => 36 )
Array ( [productid] => 36 )
• 

  ラインストーン付 キラキラ・ライセンスフレーム

Array ( [productid] => 185 )
Array ( [productid] => 185 )
• 

  PitaPon.（ピタポン）