SELECT n.uid, MAX(n.nid) AS latest, COUNT(n.nid), pv.value AS name FROM {node} n
          INNER JOIN {node_primary_term} pt ON n.vid = pt.vid
          LEFT JOIN {profile_values} pv ON n.uid = pv.uid
          WHERE n.type = 'bondblog' AND pt.tid = 3843 AND n.status = 1 AND pv.fid = {$fid}
          GROUP BY n.uid
          ORDER BY name