I’ve noticed a very interesting difference between my local development environment and my actual webhosting. In the master post this is the query that displays the artists available (if they have downloads). On my local development environment all the artists keep coming up, while on my webhosting only those with downloads show up (as they should). If I change LEFT JOIN to RIGHT JOIN I reverse the problem. lol.
-
SELECT ar_artist_id, ar_artist, ar_image, COUNT(vi_artist_id) AS ar_numvideo
-
FROM (artist INNER JOIN videos ON artist.ar_artist_id = videos.vi_artist_id) LEFT JOIN videodownloads ON videos.vi_video_id = videodownloads.vd_video_id
-
WHERE artist.ar_pubterm <> ‘Actor’ OR ‘Actress’
-
GROUP BY ar_artist_id
-
ORDER BY ar_artist
It’s the same with this query that shows the downloads per artist on the artist page.
-
SELECT artist.ar_artist_id, videotypes.vt_videotype, videotypes.vt_videotype_id
-
FROM artist INNER JOIN (videotypes INNER JOIN videos ON videotypes.vt_videotype_id = videos.vi_videotype_id) ON artist.ar_artist_id = videos.vi_artist_id LEFT JOIN videodownloads ON videos.vi_video_id = videodownloads.vd_video_id
-
GROUP BY artist.ar_artist_id, videotypes.vt_videotype, videotypes.vt_videotype_id
-
HAVING (((artist.ar_artist_id)=$artistId))
What the hell? I have no explanation. haha.