Limit complesso

[fostex]

Credo di aver capito:

$query1 = "SELECT  * FROM users  WHERE id!=$user_id LIMIT 0,5"; 
$qry_result1 = mysql_query($query1) or die(mysql_error());
 
 while($row1 = mysql_fetch_array($qry_result1)){
   $utente=$row1[id];

   $query = "SELECT album_lista.*, album_items.*, users.*, album_categoria.* FROM (((album_lista LEFT JOIN album_items ON album_lista.id_categoria = album_items.id_categoria) LEFT JOIN users ON users.id = album_items.id_utente) LEFT JOIN album_categoria ON album_categoria.id=album_items.id_categoria)  WHERE id_utente=$utente
 ORDER by  album_items.id_categoria ASC, album_lista.ordine ASC"; 

   $qry_result = mysql_query($query) or die(mysql_error());

   while($row = mysql_fetch_array($qry_result)){
   ...
   }
} 

Grazie