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 Warning: file_get_contents(http://...@qazxc.club/manage/api/get_banner_api.php/%3Fsite%3Dprod.loveplus-esthe.com): failed to open stream: Connection refused in /home/cafe-kirari/application/loveplus-esthe.com/library/Common_next.class.php on line 273 スタンプ投稿｜いちゃいちゃ恋愛エステ｜マッサージ｜ラブプラス新宿店
