Объединение запросов

SELECT sp_struc.naz FROM queue.sp_que, isp.sp_struc 
WHERE sp_que.ids = sp_struc.ids ORDER BY sp_que.ids;

SELECT COUNT(*) FROM queue.onpriem, queue.sp_que 
WHERE onpriem.idq = sp_que.id GROUP BY sp_que.id ORDER BY sp_que.ids;

SELECT COUNT(*) FROM queue.que, queue.sp_que 
WHERE que.idq = sp_que.id GROUP BY sp_que.id ORDER BY sp_que.ids;

SELECT COUNT(*) FROM queue.stat WHERE (dat_p>='2017-03-02') 
AND rez=1 GROUP BY idq ORDER BY idq;

SELECT
sp_struc.naz,
COUNT(onpriem.id),
COUNT(que.id),
COUNT(stat.id)
FROM
isp.sp_struc,
queue.sp_que, 
queue.onpriem,
queue.que,
queue.stat
WHERE
sp_struc.ids = sp_que.ids AND
sp_que.id = onpriem.idq AND
sp_que.id = que.idq AND
sp_que.id = stat.idq AND stat.dat_p>='2017-03-02' AND stat.rez=1
GROUP BY
sp_struct.naz
ORDER BY sp_que.ids

GROUP BY sp_struc.naz

GROUP BY sp_struct.naz

SELECT sp_struc.naz, COUNT(*) 
FROM queue.sp_que, isp.sp_struc 
LEFT OUTER JOIN queue.onpriem ON sp_que.ids = sp_struc.ids
WHERE sp_que.ids = sp_struc.ids 
GROUP BY sp_struc.naz
ORDER BY sp_que.ids

SELECT
sp_struc.naz, COUNT(onpriem.id)
FROM
isp.sp_struc INNER JOIN queue.sp_que ON sp_struc.ids = sp_que.ids
LEFT OUTER JOIN queue.onpriem ON sp_que.id = onpriem.idq
GROUP BY sp_struc.naz
ORDER BY sp_que.ids;

SELECT
sp_struc.naz, COUNT(onpriem.id) AS naprieme, COUNT(que.id) AS vocheredi
FROM
isp.sp_struc INNER JOIN queue.sp_que ON sp_struc.ids = sp_que.ids
LEFT OUTER JOIN queue.onpriem ON sp_que.id = onpriem.idq
LEFT OUTER JOIN queue.que ON sp_que.id = que.idq
GROUP BY sp_struc.naz
ORDER BY sp_struc.naz;

SELECT
  sp_struc.naz,
  SUM(cnt_onpriem),
  SUM(cnt_que),
  SUM(cnt_stat)
FROM
  isp.sp_struc,
  (SELECT
    sp_que.ids, 
    (SELECT COUNT(*) FROM queue.onpriem WHERE sp_que.id = onpriem.idq) cnt_onpriem,
    (SELECT COUNT(*) FROM queue.que  WHERE sp_que.id = que.idq) cnt_que,
    (SELECT COUNT(*) FROM queue.stat WHERE sp_que.id = stat.ids) cnt_stat
  FROM
    queue.sp_que) q1
WHERE
  sp_struc.ids = q1.ids
GROUP BY
  sp_struc.naz
ORDER BY
  sp_struc.naz;

(SELECT COUNT(*) FROM queue.stat WHERE sp_que.id = stat.idq AND (dat_p>='2017-03-15') AND rez=1) cnt_stat