So I have two tables.
Table 1 - Records
Table 2 - Earnings
I basically want to retrieve 6 active records from highest to lowest earnings.
Here are the table setups.
Records Table
record_id | record_name | status
1 record_1 1
2 record_2 0
3 record_3 1
4 record_4 1
5 record_5 1
6 record_6 1
7 record_7 1
8 record_8