$q1 = "SELECT p.aftor, COUNT(*) AS `pcount` FROM `link_pricelist_photos` AS `p` GROUP BY p.aftor;";
    $q2 = "SELECT d.aftor, COUNT(*) AS `dcount` FROM `link_goods_description` AS `d` GROUP BY d.aftor;";
    $q3 = "SELECT s.aftor, COUNT(*) AS `scount` FROM `link_sub_description` AS `s` GROUP BY s.aftor;";

есть такое слово - union all

(1)спс помогло