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 ブログランキング|いちゃいちゃ恋愛エステ|メンズエステ|ラブプラス新橋店
(=^x^=)
ますみ
3/12
えりん
こんにち〜一昨日は家帰ってから急に熱出てずっと寝てた〜体力なさすぎてす…

HOME / BLOGRANK
2019/03/25 (月)  人気の『るるあ』さん『ますみ』さん『おはな』さん登校♪ 2名様以上のご来店で【団体割】2000円引きです!! 
PAGE TOP