SELECT SQL_CALC_FOUND_ROWS * FROM
((SELECT g.gallery_id,GetNombreTPL(f.base),g.description,f.time_video,g.thumbnails,f.promocion,f.video_spon,g.date_added AS Fecha,"video" AS Tipo
FROM (tx_galleries AS g,tx_gallery_fields AS f,turbo_xnostars AS t1,turbo_xnostars_gi AS t2)
WHERE g.gallery_id=f.gallery_id
AND g.gallery_id=t2.IdGI AND t2.IdXnostar=t1.Id AND t1.nombreTPL='chloe-couture' AND t2.Tipo='video'
AND g.gallery_id<>0
)
UNION
(SELECT g.gallery_id,GetNombreTPL(f.base),g.description,f.time_video,g.thumbnails,f.promocion,f.video_spon,g.date_added AS Fecha,"trailer" AS Tipo
FROM (tx_galleries AS g,tx_gallery_fields AS f,turbo_xnostars AS t1,turbo_xnostars_gi AS t2)
WHERE g.gallery_id=f.gallery_id
AND g.gallery_id=t2.IdGI AND t2.IdXnostar=t1.Id AND t1.nombreTPL='chloe-couture' AND t2.Tipo='trailer'
AND g.gallery_id<>0
)) AS c
ORDER BY Fecha DESC
Error: query: Disk full (/tmp/#sql_1552_25.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT g.gallery_id,f.base,g.description,DATE(g.date_added) AS Fecha,IF(NOT f.trailer<=>1,"video","trailer") AS Tipo,f.time_video AS Extra,g.date_added AS FechaYHora
FROM (tx_galleries AS g,tx_gallery_fields AS f)
WHERE g.gallery_id=f.gallery_id
AND g.status='disabled'
AND f.base LIKE '/videos/%'
AND g.categories LIKE (SELECT CONCAT('%',c.tag,'%') FROM tx_categories c WHERE c.name='Chloe Couture')
ORDER BY FechaYHora DESC
Error: query: Disk full (/tmp/#sql_1552_25.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")