Error en:
SELECT * FROM ( SELECT p.id_producto AS id, p.nombre, p.precio_venta, IF(descripcion LIKE 'paquete',1,0) AS es_paquete, p.descripcion, p.compuesto, IF( p.imagen LIKE 'http://%', p.imagen, CONCAT('https://terminus10.com/Proadel/', p.imagen) ) AS imagen, 1 AS tipo, p.orden_cat FROM sac_productos p WHERE p.oculto=0 AND p.precio_venta > 0 AND p.id_categoria=1 AND p.no_mostrar_web=0 UNION SELECT p.id_promocion AS id, p.nombre, p.precio_venta, 2 AS es_paquete, p.descripcion, '', IF( p.imagen LIKE 'http://%', p.imagen, CONCAT('https://terminus10.com/Proadel/', p.imagen) ) AS imagen, 2 AS tipo, 1000 AS orden_cat FROM sac_promociones p WHERE p.id_categoria=1 AND p.oculto=0 ) aux ORDER BY orden_cat
Descripcion:
Can't create/write to file '/var/tmp/#sql_6334_0.MAI' (Errcode: 28)
SELECT * FROM ( SELECT p.id_producto AS id, p.nombre, p.precio_venta, IF(descripcion LIKE 'paquete',1,0) AS es_paquete, p.descripcion, p.compuesto, IF( p.imagen LIKE 'http://%', p.imagen, CONCAT('https://terminus10.com/Proadel/', p.imagen) ) AS imagen, 1 AS tipo, p.orden_cat FROM sac_productos p WHERE p.oculto=0 AND p.precio_venta > 0 AND p.id_categoria=1 AND p.no_mostrar_web=0 UNION SELECT p.id_promocion AS id, p.nombre, p.precio_venta, 2 AS es_paquete, p.descripcion, '', IF( p.imagen LIKE 'http://%', p.imagen, CONCAT('https://terminus10.com/Proadel/', p.imagen) ) AS imagen, 2 AS tipo, 1000 AS orden_cat FROM sac_promociones p WHERE p.id_categoria=1 AND p.oculto=0 ) aux ORDER BY orden_cat
Descripcion:
Can't create/write to file '/var/tmp/#sql_6334_0.MAI' (Errcode: 28)