【西日暮里・池袋】
前立腺ﾏｯｻｰｼﾞ専門
もぐらのM性感

select 
		t_schedule.*,
		t_schedule.time_stt schedule_time_stt,
		t_schedule.time_end schedule_time_end,
		m_cast.*,
		m_shop.name shop_name,
		m_shop.background_color,
		m_shop.color
		 from t_schedule 
		LEFT JOIN m_cast
		ON m_cast.cast_id = t_schedule.cast_id

		LEFT JOIN m_shop
		ON m_shop.shop_id = m_cast.shop_id
		 WHERE  t_schedule.date = '2025/12/11' AND  t_schedule.del_login_id = 0 order by  m_cast.orderex