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 = '33' order by product_pin desc, product_id desc
