[08-Sep-2024 04:33:48] ERROR MYSQL
QUERY: SELECT
wmodelo.*
,if ( wmodelo.urb_force_nov_date IS NOT NULL AND wmodelo.urb_force_nov_date >= '2024-09-08', 1, 0 ) as es_novedad
,if ( ( wmodelo.alta >= '2024-03-08' and wmodelo.alta <= '2024-09-08' ), 1, ( if ( wmodelo.urb_force_nov_date IS NOT NULL AND wmodelo.urb_force_nov_date >= '2024-09-08', 1, 0 ) ) ) as es_novedad_old
,if ( gar.dto_web >= 35, 1, 0 ) as es_outlet
,gar.color as color
FROM
larpi_0000002570_ecomer.wmodelo
INNER JOIN larpi_0000002570_ecomer.gar ON gar.modelo = wmodelo.ref AND gar.stock > 0 AND gar.urb_activo = 1
LEFT JOIN larpi_0000002570_ecomer.urb_familias ON wmodelo.urb_fa = urb_familias.cod
LEFT JOIN larpi_0000002570_ecomer.urb_subfamilias ON wmodelo.urb_subfa = urb_subfamilias.cod
LEFT JOIN larpi_0000002570_ecomer.urb_categorias ON wmodelo.urb_cat = urb_categorias.cod
LEFT JOIN larpi_0000002570_ecomer.urb_tipo ON wmodelo.urb_tipo = urb_tipo.cod
LEFT JOIN larpi_0000002570_ecomer.marca ON wmodelo.marca = marca.cod
WHERE
( wmodelo.urb_activo = '1' ) and
( wmodelo.urb_fa = '0001' ) and
( wmodelo.urb_subfa = '01' ) and
( gar.dto_web IS NULL OR gar.dto_web < 35 )
GROUP BY gar.modelo, gar.color
ORDER BY
urb_tipo.urb_orden DESC
,wmodelo.urb_saltar_novedad DESC
,es_novedad DESC
,wmodelo.urb_orden DESC
,wmodelo.tempo DESC
LIMIT 1896, 12
ERROR (1021): Disk full (/tmp/#sql_4a5_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")