Sort "myadopts" page

[fadillzzz]

To allow users to sort their adoptables, you can create a page where it lists all their own adoptables and put a textbox next to each adoptable for them to input the sorting number.

The JOIN query would probably look like this
SELECT * FROM adopts_owned_adoptables JOIN adopts_sorting_adoptables ON adoptable_id = aid ORDER BY sorting_number ASC;

I think that should do it (for the query part)