How to create custom sql query on category listing page in Prestashop 1.7

[pankaj_kumar]

In Prestashop 1.7 i want to modify the default SQL query of the listing products on the category page. I cant found which SQL query returning products on category page.

there is custom fields added to product table priority(1,2,3) and state (0,1)

so need to display products above matching columns using custom SQL query.

Inside Class Category.php getProducts() function is not executing on category page if facted search module is enabled.  If i am disabling the facted search module then getProducts() function is executing. 

I need to modify default product listing sql query on Category page, But i cant find the way to modify it. 

[jacob_v_dam]

As i can remember (not tested) the products are loaded in this function:
https://github.com/PrestaShop/PrestaShop/blob/1.7.8.3/classes/controller/ProductListingFrontController.php#L251

This loads a product search provider you can check which provider is loaded and try to extend this. Keep in mind that this could return any search provider which is calculated at:
https://github.com/PrestaShop/PrestaShop/blob/1.7.8.3/classes/controller/ProductListingFrontController.php#L265

Edited February 14, 2022 by jacob_v_dam (see edit history)