Unknown column 'published' in 'where clause'<hr>SELECT p.ym_vendor, p.ym_model, p.name_ru, c.name_brand_ru FROM SC_products as p JOIN SC_categories as c ON c.categoryID=p.categoryID  WHERE p.productID = published