Sql function in npc

[_Darius_]

Had to do some form of these classes were only for ranking first time? I tried doing the following, the sql command would check in ranking_race_level `table` table `class` class now had there in the rankings simply ignore it. But it gave error, someone could correct my sql command?

 

NPC:

L_RANK_CLASS:
	if(BaseLevel == $BaseMax && JobLevel == $JobMax){
		if( Class == Job_Super_Novice && .end_ev_sn == 0){
			set $win_sn$,strcharinfo(0);
			set Zeny,Zeny + $premio_Z;
			getitem 18779,1;
			query_sql"INSERT INTO `ranking_race_level` (`name`,`class`,`date`,`parents`) VALUES ('"+strcharinfo(0)+"','Super Novice','"+@time$+"','0')";
			announce "O Jogador "+ $win_sn$ +" foi o primeiro Super Aprendiz a atingir o Nível MÁXIMO !!",8;
			query_sql("select `class` from `ranking_race_level` ORDER BY fame DESC LIMIT 1", `class`);
			sleep 2000;
			announce "Ele foi recompensado com um Panda Ears[1] e uma quantia considerável de Zenys !!",8;
			sleep 2000;
			announce "Ele é um exemplo para os Aprendizes de toda Rune-Midgard !!",8;
			set .end_ev_sn,1;
			end;
			}
			if( Class == Job_Super_Novice && .end_ev_sn < 10){
				query_sql"INSERT INTO `ranking_race_level` (`name`,`class`,`date`,`parents`) VALUES ('"+strcharinfo(0)+"','Super Novice','"+@time$+"','2')";
				set .end_ev_sn,.end_ev_sn+1;
				end;
			}	

Command SQL:

 

query_sql("select `class` from `ranking_race_level` ORDER BY fame DESC LIMIT 1", `class`);

 

Error:

 

I hope you can help me, thanks

[Patskie]

query_sql "SELECT `class` FROM `ranking_race_level` ORDER BY `fame` DESC LIMIT 1",@class;

[Capuche]

Btw you don't use the variable from this query, why don't remove this line ?