Unknown column 'Mshops.shop_id' in 'on clause'SELECT 

Mshops.shop_id, 
Mshops.shop_name, 
sucVotes.vote_love/ sucVotes.vote_hate AS voteStars,
Mshops.shop_url, 
Mshops.shop_desc, 
Mshops.list_type, 
Mrecips.recip_id, 
sucVotes.vote_love, 
sucVotes.vote_hate, 
Mshops2brands.s2b_brand

FROM Mshops, Mshops2brands

LEFT JOIN sucVotes ON sucVotes.shop_id = Mshops.shop_id 
LEFT JOIN Mrecips ON Mrecips.recip_shop = Mshops.shop_id 

AND Mrecips.recip_site =1 
AND Mrecips.recip_ok =1 

WHERE Mshops2brands.s2b_shop = Mshops.shop_id 

AND Mshops2brands.s2b_brand = "dyson" 

ORDER BY voteStars DESC