Impossibile eseguire la query SELECT IF (INFO.flag_affiliazione IN ('1','3'),1,0) AS ZP , IF (PS.path IS NULL,'',PS.path) AS PERCORSO, AS IDSK, SK.list_rank AS LISTA_RATING, IF (CONT.id_scheda IS NULL, 0,n_recensioni_rating) AS NREC, IF (CONT.id_scheda IS NULL, 0, (CONT.n_recensioni_5+CONT.n_recensioni_4*2+CONT.n_recensioni_3*3+ CONT.n_recensioni_2*4+CONT.n_recensioni_1*5)/ (n_recensioni_rating) ) AS MEDREC, IF (CONT.id_scheda IS NULL,0,n_r) AS TOTREC, IF (CONT.id_scheda IS NULL,0,n_of) AS TOTOFF, IF (CONT.id_scheda IS NULL,0,n_f) AS TOTPHOTO, IF (CONT.id_scheda IS NULL,0,n_v) AS TOTVIDEO, IF (CONT.id_scheda IS NULL || CONT.giudizio<1,0,1) AS SIgiudizio, SK.user_ultimamod AS IDPROP , INFO.*, SK.id_cat_tip AS IDCAT_TIPO, SK.id_cat_geo AS IDCAT_GEO, CONT.giudizio AS GIUDIZIO FROM scheda AS SK JOIN info_companies AS INFO ON ( LEFT JOIN paths_schede AS PS ON ( AND PS.id_lingua=4) LEFT JOIN contatori_schede AS CONT ON ( WHERE SK.id_cat_geo IN (1571) AND SK.id_cat_tip IN (19908,19909,19910,19911,19912,19913,22417,22437,22529,22608,22711,22716,22718,22761,22949,22955,23041) AND SK.abilitato='y' GROUP BY ORDER BY LISTA_RATING DESC,ZP DESC,GIUDIZIO DESC,nome_scheda ASC LIMIT 0, 20 ; Out of resources when opening file '/tmp/#sql_57c5_119.MYD' (Errcode: 24)