Accommodation Perth Number One Accommodation Perth Provider
SELECT SQL_CALC_FOUND_ROWS *, l.ListingID as lid, l.Name as name, l.Street as street, s.postcode as postcode, s.Name as suburb, l.SuburbID as sid, r.Name as region, st.Abbr as state, s.subRegionID as srid, sl.Feature FROM ent_australia.listing l, ent_australia.site_listing sl, specdays_locations.suburb s, specdays_locations.region r, specdays_locations.state st WHERE l.SuburbID=s.SuburbID AND l.ListingID = sl.ListingID AND sl.SiteID = 31 AND s.RegionID=r.RegionID AND r.StateID = st.StateID AND l.LStatus = 1 AND s.SuburbID=22694 GROUP BY l.ListingID ORDER BY sl.Feature DESC, l.Name LIMIT 0,20