I have a MySQL (yes, I know) database with two relevant tables, t with 52230 rows and r with 5 rows. r has primary key r_id and t has foreign key r_id -> r.r_id. I have indices on (t.r_id), (t.date), ...
I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results