sql didn’t get me all the rows

As others have pointed out you need to step through commenting out parts of your logic till you find your issue.

However the problem is likely due to using mediaineration.createtime in your WHERE statement as it is involved in a RIGHT JOIN due to that it makes all of your joins inner joins

Browse More Popular Posts

Leave a Comment