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=3) LEFT JOIN contatori_schede AS CONT ON ( WHERE SK.id_cat_geo IN (21491,21492,21494,21496,21497,21498,21499,21500,21501,21502,21503,21504,21505,21507,21509,21511,21514,21515,21516,21517,21518,21519,21520,21522,21527,21529,21530,21562,21572,21579,21584,21590,21593,21594,21637,21665,21780,21782,22251,22438,22888,25157,25588,25762,25993,26206,26276,26293,26406,26675) AND SK.id_cat_tip IN (19912) AND SK.abilitato='y' GROUP BY ORDER BY LISTA_RATING DESC,ZP DESC,GIUDIZIO DESC,nome_scheda ASC LIMIT 0, 10 ; Out of resources when opening file './portale/contatori_schede.MYD' (Errcode: 24)