select m_cast.*, m_shop.name shop_name, m_shop.background_color, m_shop.color from m_cast LEFT JOIN m_shop ON m_shop.shop_id = m_cast.shop_id WHERE m_cast.del_login_id = 0 order by orderex