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