スクデット

SQL
SELECT SER.*, BRA.*,ECH.PRODUCT_ID, GRP.URLNAME AS GRPURLNAME, SER.URLNAME AS SERURLNAME, SER.SORTORDER AS SERSORTORDER FROM M_SERIES SER LEFT OUTER JOIN M_BRAND BRA ON BRA.BRACODE = SER.BRACODE LEFT OUTER JOIN M_SHOHINGRP GRP ON GRP.SERCODE = SER.SERCODE AND GRP.BRACODE = SER.BRACODE AND GRP.HYOJIFLG = 1 LEFT OUTER JOIN M_ECHIN ECH ON ECH.GRPCODE = GRP.GRPCODE WHERE BRA.URLNAME ='scudetto' AND SER.HYOJIFLG = 1 ORDER BY SER.SORTORDER DESC, SER.SERNAME, SER.SERCODE
Array ( [ss-c] => Array ( [NAME] => SS-C（生産中止） [NAMEEN] => SS-C [ORDER] => 50 [BRANAME] => スクデット [BRANAMEEN] => SCUDETTO [COUNT] => 5 [PRODUCTID] => 17 ) )
• 

  SCUDETTO SS-C

  スクデット SS-C（生産中止）