ステッカー系用品

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=5) OR ( BNRCODE=4 AND CBNRCODE=5) ) AND NOT COALESCE( CNT.COUNTS, '0') = 0 ORDER BY GRP.SORTORDER DESC, GRP.GRPNAME
Array ( [item00000067] => Array ( [NAME] => MovingCafeLabel ロゴテープ [NAMEEN] => MovingCafeLabel ロゴテープ [ORDER] => 50 [GRPURLNAME] => item00000067 [BRANAMEEN] => MovingCafeLabel [PRODUCTID] => 60 [COUNT] => 2 ) )
Array ( [productid] => 60 )
Array ( [productid] => 60 )
• 

  MovingCafeLabel ロゴテープ