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

select 
		t_schedule.*,
		t_schedule.time_stt schedule_time_stt,
		t_schedule.time_end schedule_time_end,
		m_cast.*,
		m_cast.del_login_id cast_del_login_id,
		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  date = '2025/12/02' AND  t_schedule.del_login_id = 0 order by  m_cast.orderex

Unknown column 'm_shop.background_color' in 'field list'