select * from `tbl_artist` join `tbl_gallery` on tbl_gallery.artist_id=tbl_artist.id where tbl_gallery.status='Active' AND tbl_gallery.auction_yr='' AND tbl_gallery.auction_month='' order by cast(tbl_gallery.lot_no as unsigned), tbl_gallery.lot_no asc, tbl_artist.lname asc, tbl_artist.fname asc, tbl_gallery.title asc