Directory
- floor1
- floor2
- floor3
-
Unknown column 'store_pin' in 'order clause'
select * from store inner join location on store.store_id = location.store_id inner join floor on location.location_floor = floor.floor_id where store_status = 1 and store_approve = 2 and location_status = 1 and floor_status = 1 and location_floor = '1' order by store_pin desc, store.store_id, location_floor, location_room