> In order to get the number of results, however, > in order to be able to page the results, ... use SQL_CALC_FOUND_ROWS in the outer query and then follow with SELECT FOUND_ROWS(); by the way you might want to change your joins to INNER JOINs i'm pretty sure they'll produce the same results, and might run faster rudy http://r937.com/