in order to modify the getQuery function within the ps_facetedsearch/src/Adapter/MySQL.php file, I recommend leveraging the event-driven approach provided by PrestaShop. While there might not be a direct hook available that perfectly aligns with your requirements, you can effectively achieve your objective by utilizing events.
By using PrestaShop's event system, you can intercept and manipulate the necessary data or logic without directly modifying the core files. This approach helps maintain the integrity of your PrestaShop installation and ensures smoother updates in the future.
Although there might not be a predefined hook that directly fits your use case, you can identify relevant events within the application's workflow and then register your custom code to listen for those events. This allows you to execute your modifications at the appropriate point in the execution flow.
Remember to thoroughly understand the available events within PrestaShop, choose the event that closely aligns with the context you're working in, and implement your modifications accordingly. This event-driven approach will help you achieve your goal while adhering to best practices and preserving the flexibility of your PrestaShop installation. For more details, visit..