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, ent_australia.category_listing as cl, ent_australia.category c 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 cl.CategoryID=c.CategoryID AND cl.ListingID=l.ListingID AND c.Name LIKE 'Clubs' GROUP BY l.ListingID ORDER BY sl.Feature DESC, l.Name LIMIT 0,20

Clubs

page 1 of 2
page 1 of 2