first time using AGSQL-need helppp

[redfrog]

hello there
this sql version of sql is fucking confusing me!!!
i been using AGPRO for along time , fianly i decided to move to the sql version , and the reasone i moved is because of the "click tracking" it has , i wanted the main page resort by its prodactivity .

so i installed AGSQL 6.2 , and it so diff from what i used to know with AGPRO.

have some basic question:

1.what shell i add to the template is it the " ORDER click" ? "REORDER click"? other thing maybe? then , how do i update the galleries? with the "build pages"? or with " build pages with new?"
2. i just need it to sort the thumbs with the most clicked at the top , and when i add new galleries the will show at top some time till it drop by it clicked

what methode are good , what u guys doing?

[CamsLord]

i do know that when u want to update and u already did the thumbs for that day, all u have to do is click "BUILD PAGE"

there's a code in the manual in order to sort the way u want to but i just cant remember off the top of my head.. i suggest reading the manual they have online