Error al obtener registro de la tabla <br>Disk full (/tmp/#sql-temptable-39f-1558-649.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br>La Consulta es: <br> <b>SELECT *
            FROM banner bc
            WHERE (cam_impcompradas = 0 OR (cam_impcompradas <> 0 AND (cam_impcompradas-1) >= cam_impresiones)) 
             AND  DATE_FORMAT('2024-04-16','%Y-%m-%d') BETWEEN DATE_FORMAT(cam_fechainicio,'%Y-%m-%d') AND DATE_FORMAT(cam_fechafin,'%Y-%m-%d') 
             AND cam_estado = 'a' AND bzo_id = 1  AND sec_id = 0 AND reg_id = 0 AND hzo_id = 1 AND camp_posicion = 1
             ORDER BY RAND()</b>