► 09:03 8.6 Publicado:
Nota actual: 10,0
Tu puntuación
Síguela
Query Debug:
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='daisy-stone' 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='daisy-stone' AND t2.Tipo='trailer'
AND g.gallery_id<>0
)) AS c
ORDER BY Fecha DESC
Error:
query: Disk full (/tmp/#sql_1552_44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
► 09:03 8.6 Publicado:
► 42:41 8.0 Publicado:
► 07:58 8.1 Publicado:
► 10:11 8.5 Publicado:
► 10:12 8.4 Publicado:
► 12:00 8.0 Publicado:
► 10:24 8.3 Publicado:
► 09:14 8.4 Publicado:
► 10:19 7.9 Publicado:
► 09:17 8.4 Publicado:
► 10:25 8.1 Publicado:
► 09:55 8.3 Publicado:
► 09:12 8.3 Publicado:
Query Debug:
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='Daisy Stone')
ORDER BY FechaYHora DESC
Error:
query: Disk full (/tmp/#sql_1552_44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")