SELECT * FROM `listing` where listing_id ='deep-industries-ahmedabad' AND publish = 1