該当するデータが一件もありませんでした。
SELECT
   c.campaign_text,
   c.riyou_jyouken,
   c.tokuten_naiyou,
   c.taiyou_kikan,
   b.bukken_name,
   b.bukken_name2,
   b.bukken_no
FROM
   campaign AS c
   LEFT OUTER JOIN gyousha AS g ON c.gyousha_cd = g.gyousha_cd
   LEFT OUTER JOIN bukken  AS b ON c.bukken_no = b.bukken_no
WHERE
   c.open_flg = 0 AND
   c.syubetsu = 0 AND
   c.gyousha_cd = '8015'
ORDER BY
   c.hyouji_no DESC,
   c.campaign_cd DESC