i need a very small code fix for asp

Hi, good day if you can help me with a very small code fix for asp i can transfer 6 euro now trough freelancer the problem is below

I have 2 exact same tables htmlclient one in pwsmphalls and one i had to add manually in pwsmprooms

both are INT ((0)) value

now what is wrong with the code below please correct it and the 6 euro is yours i will award the project

sql= "select [login to view URL] as roomid, [login to view URL] as hallid, smallblind,bigblind,playerlist,dollarprefix,roundallfloats,lobbyaccess, htmlclient, pokervariant,curplayers, maxplayers,"& _

"lastpot,avgpot,playerlist,avgppf,avghph,cursitting,curwaiting,numseats,lowstakelimit,highstakelimit,bettinglimit,skinname, port, host,stop,name,pointmode,privatemode "& _

"from pwsmprooms,pwsmphalls where pwsmphalls.id=[login to view URL] and trnyenabled=0 and started=1 and multitrnyid=0 and htmlclient=1 order by curplayers DESC,bettinglimit,lowstakelimit,[login to view URL]"

ASP

Nº del proyecto: #14605341

Sobre el proyecto