Unknown column 'lv' in 'where clause'<br>SELECT id,productsname,products.status,products_catalogsid,price,brief,products.description,
lv1,lv2,customid,is_other
FROM products
inner JOIN products_catalogs on products.products_catalogsid=products_catalogs.catalogsid
where lv=9166 
and products.status=1
order by products.ordernum asc,products.productsname asc