So far I got it working with a subselect, but some research told me it is bad to be using subselects (especially on large tables) as they are less performant.
Now that's what I got:
SELECT COUNT( riddims.riddim ) AS rc,
SELECT COUNT( tunes.tune )
WHERE tunes.tune NOT
) AS tc
WHERE riddims.riddim NOT
riddim | genre | image
riddim | artist | tune
riddims | tunes | artist
100 | 400 | 2
SELECT COUNT(riddims.riddim) AS rc, COUNT(tunes.tune) AS tc FROM riddims LEFT JOIN tunes ON riddims.riddim = tunes.riddim
Are you trying to do this:
select riddims, tunes, artists from (select count(*) as riddims from riddims where . . . ) r cross join (select count(*) as tunes from tunes where tunes not in . . .) t cross join (select count(*) as artists from tunes where artist not in . . .) a
Your tables don't seem to be connected, at least for this query. The possible performance issue is that the subqueries in your select are being called once for each row. By putting them in the FROM clause, you eliminate this possible problem.