[ic] sql and multipage

[bersa]

I match a big problem using versions 5.x.x:
If I use new sql form as:

    [query
     ml=30
     more=1
     type=list
     sql=|
          SELECT *
          FROM products
          WHERE CAT1='[scratch c1]'
          ORDER by cat4, num_int, numero
         |]
     [list]
.
.
query works but pages separations is not possible

Using old style as:

    [search-region more=1 search="
      st=db
      ml=30
      fi=products
      tf=CAT4
      to=f
      tf=num_int
      to=n
      tf=NUMERO
      to=f
      sf=CAT1
      se=[scratch c1]
      op=rm
      sf=CAT2
      se=[scratch c2]
      op=rm
      sf=CAT3
      se=[scratch c3]
      op=rm
      rf=*
    "]
     [search-list]
     [seti c4][item-field CAT4][/seti]
.
.
.
     [/search-list]
     [more-list 0 0 0 ]
     [first-anchor]Prima[/first-anchor]
     [last-anchor]Ultima[/last-anchor]
     [next-anchor] <span class="titolo"> <br> Vai alla pagina successiva
</span>[/next-anchor]
     [prev-anchor] <span class="titolo"> Vai alla pagina precedente
<br></span>[/prev-anchor]
     [page-anchor]|$PAGE$[/page-anchor]
     [decade-next]<b>( 10 Successive )</b> [/decade-next]
     [decade-prev]<b>( 10 Precedenti )</b> [/decade-prev]
     [more]
[/more-list]
    [/search-region]

Pages separations works but only one level sorting results possible (CAT4)
That form works perfectly in version 4.x.x
I need to present results on different pages sorting on 3 different level
(as above) so, what could I do?
Thanks
Claudio Berselli