SELECT foo_count.num
      ,foo.first_col
      ,foo.second_col
  FROM foo
      ,(SELECT description
              ,COUNT(*) as num
          FROM foo
         WHERE description LIKE '%?%'
         GROUP BY description
        ) foo_count
 WHERE foo.description = foo_count.description
 ORDER BY 1,2,3
LIMIT ?, ?