[DetoNater]

I have 5 clans but they are not displaying

Код:

   			 		case 0:
					{
						new content[950];
						mysql_query(mysql,"SELECT `clan` FROM `clans` ORDER BY `Clanscore` DESC LIMIT 30");//,true,"","");
						if(cache_get_row_count(mysql) > 0)//(cache_num_rows() > 0)
						{
							new Tag[8];
							for(new i = 0; i < cache_get_row_count(); i++)
                            cache_get_field_content(i,"clan",Tag);
                            printf("tagg: %s",Tag);
							{
								format(content,sizeof(content),"%s\t%s\n",content,Tag);
							}
						}
						else
						{
							switch(Sprache[playerid])
							{
								case 0: format(content,sizeof(content),"%sEs gibt keine Clans!",content);
								case 1: format(content,sizeof(content),"%sThere are no Clans!",content);
								case 2: format(content,sizeof(content),"%sNo hay clanes!",content);
							}
						}
						switch(Sprache[playerid])
						{
						    case 0: ShowPlayerDialog(playerid, 1051, DIALOG_STYLE_LIST, "Wдhle ersten clan", content, "Akzeptieren","Abbrechen");
						    case 1: ShowPlayerDialog(playerid, 1051, DIALOG_STYLE_LIST, "Select first clan", content, "Accept", "Cancel");
						    case 2: ShowPlayerDialog(playerid, 1051, DIALOG_STYLE_LIST, "Selecciona el primer clan.", content, "Aceptar", "Cancelar");
						}
					
					}



	    case 1051: //1. clan
	    {
			if(response)
			{
				new query[100],content[950];
				mysql_format(mysql,query,sizeof(query),"SELECT `clan` FROM `clans` LIMIT %d,1",listitem);
				mysql_query(mysql,query);//,true,"","");
				for(new i = 0; i < cache_get_row_count(); i++)
				cache_get_field_content(i,"clan",query);
				format(content,sizeof(content),"%s%s\n",content,query);
				printf("case 1051 test: %s",query);
                             // cache_get_row(0,0,query);
				format(cWar1clan,sizeof(cWar1clan),"%s",query);
  				clanWarOptions[0] = 1;
			    ClanWarCreatorMainMenu(playerid);
			}
			else
			{
			    ClanWarCreatorMainMenu(playerid);
			}
			return 1;
		}

[BigBrainAFK]

whats you mysql table structure?