Unknown column 'product_pin' in 'order clause'
select * from product inner join location on location.location_id = product.location_id inner join store on store.store_id = location.store_id inner join category on category.category_id = product.category_id inner join floor on floor.floor_id = location.location_floor where product_approve = 2 and store_approve = 2 and product_status = 1 and store_status = 1 and location.location_id = '31' order by product_pin desc, product_id desc