'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_19af4a_15.MAI' (Errcode: 24 "Too many open files")'
!object(PDOStatement)#38 (1) { ["queryString"]=> string(1732) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND (g_prod.idcategoria IN ( SELECT IDcatprod FROM (select * from g_categ_prod order by pid, IDcatprod) products_sorted, (select @pv := 1155) initialisation where find_in_set(pid, @pv) and length(@pv := concat(@pv, ',', IDcatprod)) ) OR g_prod.idcategoria=1155 ) GROUP BY WMovement ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_19af4a_15.MAI' (Errcode: 24 "Too many open files")'
!object(PDOStatement)#38 (1) { ["queryString"]=> string(1733) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND (g_prod.idcategoria IN ( SELECT IDcatprod FROM (select * from g_categ_prod order by pid, IDcatprod) products_sorted, (select @pv := 1155) initialisation where find_in_set(pid, @pv) and length(@pv := concat(@pv, ',', IDcatprod)) ) OR g_prod.idcategoria=1155 ) GROUP BY WBraceletC ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_19af4a_7.MAD' (Errcode: 24 "Too many open files")'
!object(PDOStatement)#38 (1) { ["queryString"]=> string(1735) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND (g_prod.idcategoria IN ( SELECT IDcatprod FROM (select * from g_categ_prod order by pid, IDcatprod) products_sorted, (select @pv := 1155) initialisation where find_in_set(pid, @pv) and length(@pv := concat(@pv, ',', IDcatprod)) ) OR g_prod.idcategoria=1155 ) GROUP BY nome_metallo ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_19af4a_7.MAI' (Errcode: 24 "Too many open files")'
!object(PDOStatement)#39 (1) { ["queryString"]=> string(1733) "SELECT *,nomelang as nome,IF(prezzo_prodotto>0,prezzo_prodotto,prezzo_prodotto_3) AS prezzo_prodotto_listino,IF(prezzo_no_iva>0,prezzo_no_iva,prezzo_no_iva_3) AS prezzo_no_iva_listino FROM g_prod JOIN g_prodLang ON IDprod=idprodotto LEFT JOIN (SELECT idProd as id_prodotto_gemma,description as nome_gemma FROM prod_gems) gems ON g_prod.IDprod = gems.id_prodotto_gemma LEFT JOIN (SELECT id_prodotto as id_prodotto_occasione,valore as nome_occasione FROM g_prod_occasioni) occasioni ON g_prod.IDprod = occasioni.id_prodotto_occasione LEFT JOIN (SELECT prod_metals.idProd as id_prodotto_metallo,IF(prod_metals.metalDetail IS NULL,prod_metals.metalName,prod_metals.metalDetail) as nome_metallo FROM prod_metals) metals ON g_prod.IDprod = metals.id_prodotto_metallo JOIN (SELECT g_marchiLang.id_marchio as IDmarchio,g_marchiLang.permalink as permalink_marchio,g_marchiLang.nome as nome_marchio,g_marchiLang.descrizione as descrizione_marchio,g_marchiLang.seo_title as seo_title_marchio,g_marchiLang.seo_description as seo_description_marchio FROM g_marchiLang WHERE idlingua=:id_lingua AND mostra='SI') marchio ON g_prod.id_marchio = marchio.IDmarchio AND idlingua=:id_lingua LEFT JOIN watch_details ON g_prod.IDprod=watch_details.idProdotto WHERE g_prod.IDprod <> '' AND archivia!=1 AND visibile=1 AND idlingua=:id_lingua AND mostra=:mostra AND (g_prod.idcategoria IN ( SELECT IDcatprod FROM (select * from g_categ_prod order by pid, IDcatprod) products_sorted, (select @pv := 1155) initialisation where find_in_set(pid, @pv) and length(@pv := concat(@pv, ',', IDcatprod)) ) OR g_prod.idcategoria=1155 ) GROUP BY id_marchio ORDER BY IF(disponibile='SI',1,0) DESC,g_prod.data_inserimento DESC,principale DESC" }
