I have the following query which executes without an error, however it does not return the correct number of rows. The same query works when selecting from one table, but not two:
SELECT FOUND_ROWS() as `total`
FROM `products` t1
RIGHT JOIN `homepage` t2 ON `t2`.id = `t1`.id;