Emend / Optimize Prestashop Faceted Filter Module Extension

Prestashop 1.7.2 has a filter named Faceted Filter. To add 3 new features an extension was developed but there are some small details to emend and a crucial MySQL queries optimization. The way the MySQL queries were written take too much time to return the results. This extension makes possible the link between a compatibility list and the products so the customer can filter products, using the faceted filter, according to a compatible device (brand and model). All files will be made available. So, this project consists on: 1 - MySQL: correct optimize the queries 2 - FrontOffice->FacetedFilter->Extension->Listbox: present values alphabetically ordered 3 - FrontOffice->FacetedFilter->Extension->KeyWordFilter: correct / normalize the way filter is applied