Warning: mysqli_query(): (HY000/1021): Disk full (/var/tmp/#sql_50c_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/vhosts/imoland.pt/public_html/classes/database.php on line 49
SELECT DISTINCT p.id, p.ref, p.preco_pvp, p.preco_promo, p.preco_antes, p.stock, p.ultimos, p.novidade, p.promocao, p.saldos, p.createdh, l.nome, l.seo, c.googletax, r.cat, p.sticker
,p.*
,
(SELECT path FROM media WHERE type = 'products' AND parent = p.id ORDER BY ord LIMIT 1) imagem,
IF(
((p.preco_promo IS NOT NULL AND p.preco_promo != 0)
),
p.preco_promo, p.preco_pvp) preco, IF(
(( p.promocao = 1 OR p.saldos = 1) OR (p.preco_promo != 0 AND p.preco_promo IS NOT NULL)
),
'Y', 'N') promo
FROM products p
LEFT JOIN products_lang l ON p.id = l.intid
LEFT JOIN relations r ON r.prod = p.id
LEFT JOIN categories c ON c.id = r.cat
LEFT JOIN categories_lang cl ON c.id = cl.intid
LEFT JOIN products_variations pv ON pv.product = p.id
WHERE l.idioma = '1' AND c.type = 'catalogo' AND p.deletedh IS NULL AND p.arquivado IS NULL AND p.status = 1 GROUP BY p.id ORDER BY p.createdh DESC LIMIT 0 ,12
Disk full (/var/tmp/#sql_50c_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0
Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0