でも

SELECT dt_shop.wp_id,s_name,syubetuname,floorname,areaname,syubetugroup,sc_kind,open_date FROM dt_shop LEFT JOIN m_syubetu ON dt_shop.syubetuid=m_syubetu.syubetuid LEFT JOIN m_floor ON dt_shop.floorid=m_floor.id WHERE delflg=0 and comp<>1 ORDER BY dt_shop.open_date desc , m_syubetu.syubetugroup ,dt_shop.floorid ,dt_shop.s_kana LIMIT 5