Is it possible to use these 2 mySQL queries in only one query?

Question

I have two mySQL queries that work without any problems. The first one fetches referers, and the second one calculates the country %'s and numbers. However, I need to include the country %'s and numbers in the first query, in other words, how can I use them together ?

SELECT *, COUNT(*) FROM track 
where referid='".$member."'
GROUP BY referer 
ORDER BY id desc limit 0,15


select id, country, num, num*100/total pct 
from (SELECT id,country, count(*) as num 
FROM track GROUP BY country 
ORDER BY num desc limit 3) x 
join (select count(*) total from track) y

score 2 · Accepted Answer · edited May 23 '17 at 10:25

Join with an inline view:

SELECT *, COUNT(*) FROM track t
where t.referid='".$member."'
GROUP BY t.referer 
ORDER BY t.id desc limit 0,15
JOIN
(
   select id, country, num, num*100/total pct 
   from (SELECT id,country, count(*) as num 
   FROM track GROUP BY country 
   ORDER BY num desc limit 3) x 
   join (select count(*) total from track) y
) tc on t.id = tc.id

See the accepted answer to this question for more info. And you will have to tweak your select lists so that there are no conflicts.

Is it possible to use these 2 mySQL queries in only one query?

1 Answers1