Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql_507_3.MAI' (Errcode: 28 "No space left on device") in /var/www/vhosts/cartoleria-pencil.it/httpdocs/includes/db.class.php on line 85
Fatal error: Uncaught Exception: Database error
SELECT * FROM (
(SELECT
COALESCE(pl.codpadre, p.codpadre) codpadre,
COALESCE(pl.pubblica, p.pubblica,1) is_enabled,
COALESCE(pl.is_offerta,0) is_offerta, COALESCE(pl.is_primopiano,0) is_primopiano,
COALESCE(pl.prezzoshop,0) prezzoshop,
COALESCE(pl.sconto_fisso,0) sconto_fisso,
COALESCE(pl.sconto_perc,0) sconto_perc,
p.prezzovp,
p.id,
ROUND((COALESCE(pl.prezzoshop,p.prezzovp)-COALESCE(pl.sconto_fisso,0))*(1-COALESCE(pl.sconto_perc,0)/100),2) price,
p.codart, p.descrart, p.descragg, p.descrpadre, p.unimis, p.aliiva, p.gruppomerc, p.marca, p.fornitore,
p.artfam1, p.artfam2, p.artvar1, p.artvar2,
i.img_url image,
COALESCE(vl.qta_min, pl.qta_min, 1) qta_min,
SUM(COALESCE(vl.giacenza, pl.giacenza, 1)) giacenza_totale,
pl.giacenza,
GROUP_CONCAT(ii.img_url SEPARATOR '///') images,
bi.logo_url brand_image,
'' ranking
FROM
{{main}}.articoli p
LEFT JOIN {{sub}}.articoli pl ON (p.codpadre = pl.co in /var/www/vhosts/cartoleria-pencil.it/httpdocs/includes/db.class.php on line 48