Sorry I didn't mean to stray from the main subject. I've managed to combine all of the tables into one table that I've called attributes and now have one INNER JOIN and am using
table IN ('1', '12', '30') and to add each set of attributes if they're ticked but I'm still getting zero results.
I've been through the database and the following query should return at least 5 results but as I say I don't get any at all.
product_name, weight, weight_id, serving, price, brand_name, protein_source, protein_100, fat_100, calories_100, carbs_100, aw_deep_link, product_feed_id, image_url, best_seller
attributes ON product_feed_id=product_id
weight_id IN ('0')
timing_id IN ('6', '4', '0')
flavour_id IN ('38', '0')
source_id IN ('1', '2', '0')
ingredient_id IN ('30', '25', '4', '31', '0')
sweetener_id IN ('2', '0')
category_id IN ('4', '1', '0')
DESC LIMIT 20
I really do appreciate you helping and am sorry for veering off the subject before.