Searching and filtering to construct adjacency statistics from structured databases

Below egs pertain to the Adverse Event databases for which the columns are as follows:
*dosage*
** *product_type*
** *active_substance*
** *meddra_hlt*
** *country*
** *age*
** *indication*
** *brand_name*
** *raw_name*
** *meddra_hlgt*
** *drug*
** *adverse_event*
** *meddra_pt*

* **EXAMPLE 1**: Search for
** *metformin and canagliflozin* anywhere in the record
* Filter for column: *adverse_event* (so, in particular don't increase diseases from Indication field)
* QUERY in main search bar: *metformin;canagliflozin*
* Filter query in the Adv Search bar (which is the Filter Columns search bar) : *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=metformin%3Bcanagliflozin&corpus=mimic&docToken=adverse

* **EXAMPLE 2**: Search for
** *rosuvastatin and naproxen in drug column*
* QUERY in main search bar: *drug:rosuvastatin;drug:naproxen*
* Filter query in the Adv Search bar: *adverse_event*
* URL:https://preview.nferx.com/signals-lab/results/?query=drug%3Arosuvastatin%3Bdrug%3Anaproxen&corpus=mimic&color=%2300C853&enrichment_group=all

* **EXAMPLE 3**: Search for
** *tiotropium and seretide in drug column*
* QUERY in main search bar: *drug:tiotropium;drug:seretide*
* Filter query in the Adv Search bar: *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=drug%3Atiotropium%3Bdrug%3Aseretide&corpus=mimic&color=%2300C853&enrichment_group=all

* **EXAMPLE 4**: Search for
* adverse event *neutropenia* associated with drug *rituximab*
* QUERY in main search bar: *adverse:neutropenia;raw_name:rituximab*
* Filter query in the Adv Search bar: *raw_name*
* URL: https://preview.nferx.com/signals-lab/results/?query=adverse%3Aneutropenia%3Braw_name%3Arituximab&corpus=mimic&color=%2300C853&enrichment_group=all&docToken=raw_name

* **EXAMPLE 5**: Search for
* QUERY in main search bar: *denosumab;zoledronic acid*
* Filter query in the Adv Search bar: *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=denosumab%3Bzoledronic+acid&corpus=mimic&docToken=adverse

* **EXAMPLE 6**: Search for
* QUERY in main search bar: *ciprofloxacin;levofloxacin*
* Filter query in the Adv Search bar: *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=ciprofloxacin%3Blevofloxacin&corpus=mimic&docToken=adverse

* **EXAMPLE 7**: Search for
* QUERY in main search bar: *apatinib;leucovorin*
* Filter query in the Adv Search bar: *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=apatinib%3Bleucovorin+&corpus=mimic&docToken=adverse

* **EXAMPLE 8**: Search for
* QUERY in main search bar: *etanercept;tocilizumab*
* Filter query in the Adv Search bar: *adverse_event*
* URL: https://preview.nferx.com/signals-lab/results/?query=etanercept%3Btocilizumab&corpus=mimic&docToken=adverse