Error in Selection Query
select a.id,a.name,a.price,a.discount_price,a.image,a.slug,mc.slug mcslug, mc.urlcatslug urlcatslug,mc.flag mcflag,a.main_category_id from tbl_products a inner join tbl_main_categories mc on mc.id=a.main_category_id inner join tbl_product_cities b on b.product_id=a.id where a.id!='1650' and a.active=1 and b.active=1 and b.in_stock=1 and b.city='1' and a.main_category_id =8 and mc.active=1 limit 10
Unknown column 'b.city' in 'where clause'