After a bit of tweaking it's now almost working. I can't tell you how happy I am. The only thing is this returned 20 results but they were all the same product, so do I need to add the GROUP BY back so that it only shows one product rather than the same one twenty times? I did add it back and it showed just one, but I didn't know if that was the correct way of doing it or if using SELECT DISTINCT was better?
ON feeds.product_feed_id = timing.product_id
ON feeds.product_feed_id = flavour.product_id
ON feeds.product_feed_id = sweeteners.product_id
ON feeds.product_feed_id = source.product_id
ON feeds.product_feed_id = dietary.product_id
ON feeds.product_feed_id = ingredients.product_id
ON feeds.product_feed_id = product_categories_map.product_id
WHERE brand_name IN ("Youngs"
, "Birds Eye"
, "Own brand")
and weight_id IN ("3"
and ingredients.ingredients_id IN ("12"
and price >=0
and price <=250
BY best_seller DESC LIMIT 20
I can't thank you enough for helping me with this, you've also helped me to understand MySQL better too so once again thank you!! I couldn't have done it without you're help.