Implement search strategy for the website (Pythonanywhere server, Flask, MySQL)

Hi,

I need help with my website (API that displays data from MySQL database on PythonAnywhere server using Flask).

The database has several tables.

I need search to be done using drop-down lists:

1) Dates range (Dates are in "Date" column in format "YYYY-MM"
2) Study design type (column "study_design")
3) Data type (column "data type")
4) Drug category (column "category", where "domain_id" == "Drug")
5) Condition category (column "category", where "domain_id" == "Condition")
6) Country (from region table)
7) City (from region table)
8) Region (from region table)
9) Journal name (from journal table)



ability to sort by:
'journal_ranking' in 'journal' table
'date_pub' from articles table
'author_ranking' from authors