SELECT c.id_comment,c.id_user,c.subject,c.text,c.id_table, c.id , c.rate, c.rate_minus, c.rate_count, c.rate_count_minus ,COALESCE(c.nick,c.created_by_readonly) as nick,c.IP,c.created_on_readonly, c.id_administrator, c.id_user,u.is_trusted ,count(c2.id_comment) as childs FROM zzz_comment c inner join zzz_edition_article t on t.id_edition_article=c.`id` left join zzz_user_nick u on c.id_user=u.id_user_nick left join zzz_comment c2 on c.id_comment=c2.id_parent and c2.is_visible=1 where 1=1 and c.is_visible=1 and (c.id_parent is null or c.id_parent=0 ) and c.id_table='78' and c.`id`='2086' group by c.id_comment,c.id_user,c.subject,c.text,c.id_table, c.id , c.rate, c.rate_minus, c.rate_count, c.rate_count_minus ,COALESCE(c.nick,c.created_by_readonly),c.IP,c.created_on_readonly, c.id_administrator, c.id_user,u.is_trusted order by c.created_on_readonly desc
Out of resources when opening file './01393027_geo/zzz_comment#P#p2.MYD' (Errcode: 24)