MYSQL ERROR: Disk full (/tmp/#sql_404_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Query: SELECT *, COUNT(*) AS count, SUM(cart_qty) AS qty FROM ms_cart WHERE cart_photo_prod>'0' AND cart_session='323684620200710080453' AND cart_client='' AND cart_photo_prod_connect!='0' AND cart_order='0' GROUP BY cart_photo_prod_connect, cart_dis_on