Unknown column 'prd.name' in 'order clause'<hr>SELECT productID, `prd`.`name_ru` as name, Price, in_stock, prd.slug, cat.categoryID, product_code, recomb_date from SC_categories as cat JOIN SC_products as prd ON cat.categoryID=prd.categoryID WHERE prd.categoryID&gt;1 AND show_subcategories_products=1 and Price&gt;0 and enabled=1  and in_stock&gt;0  order by prd.name ASC