SELECT STAFF_MST.* ,SHOP_INFORMATION.SHOP_NAME ,SHOP_INFORMATION.SHOP_ROME ,SHOP_INFORMATION.SHOP_PP ,SHOP_INFORMATION.SHOP_COLOR FROM STAFF_MST LEFT JOIN ( SELECT SHOP_ID, SHOP_NAME, SHOP_ROME, SHOP_PP, SHOP_COLOR FROM SHOP_INFORMATION ) AS SHOP_INFORMATION ON STAFF_MST.SHOP_ID = SHOP_INFORMATION.SHOP_ID WHERE DELETE_DATE IS NULL AND OPEN_FLAG = 1 AND NOT ( FLAG & 1 ) AND ENTERY_DATE >= DATE_FORMAT( ADDDATE(NOW(), interval -2 MONTH), '%Y%m%d' ) ORDER BY ENTERY_DATE DESC ラブプラス｜メンズエステ｜いちゃいちゃ恋愛エステlove+｜マッサージ