Hacker News Reader

Am I missing something fundamental like a WHERE clause? I see a join, but no limiting of rows beyond that.

You're right - this query doesnt make sense, because if he's left joining, he should at least do

where tableB.someCol != null

or something. Otherwise, the join is useless (or he should use an inner join)

I think they just wanted all of the data.

Is there an actual schema and does MariaDB do index scans?