Hi,

Finally I did a few modifications, in my case I want to add author in the search query (products_name OR products_model OR scrchba.author_name). isbn=model.

The unnecessary LEFT JOINS were deleted and the rest ( product_bookx_authors_to_products and product_bookx_authors) changed to INNER JOIN. it seems to be working fine (still testing)

Cheers