荒野を走破

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 ='loungelizard' AND SER.HYOJIFLG = 1 ORDER BY SER.SORTORDER DESC, SER.SERNAME, SER.SERCODE
Array ( [lz-1] => Array ( [NAME] => LZ-1（生産中止） [NAMEEN] => LZ-1 [ORDER] => 50 [BRANAME] => ラウンジリザード [BRANAMEEN] => LOUNGELIZARD [COUNT] => 5 [PRODUCTID] => 18 ) )
• 

  LOUNGE LIZARD LZ-1

  ラウンジリザード LZ-1（生産中止）