SELECT a.web_address, a.latitude, a.longitude, a.account, a.date_pom, a.ref, a.web_address, a.search_address, a.bathrooms, a.general_desc, a.description2, a.fk_lookup_protyp_id, a.date_pom, a.description3, a.internet_desc, a.postcode, b.description, a.feature1, a.feature2, a.feature3, a.feature4, a.feature5, a.feature6, a.feature7, a.feature8, a.feature9, a.feature10, a.bedrooms, c.reduced, c.under_offer, c.sold_stc, c.asking_price, d.description, e.description, f.description, g.description, a.special_offer, a.special_offer_text, a.date_pom, c.fk_lookup_tentyp_id, h.description FROM tblproperty a, tbllookup_user b, tblproperty_sale_details c, tbllookup_system d, tbllookup_user e, tbllookup_system f, tbllookup_system g, tbllookup_system h WHERE a.active = 1 AND a.market_property = 1 AND a.fk_lookup_locati_id = b.id AND c.fk_property_ref = a.ref AND c.fk_lookup_prista_id = d.id AND c.fk_lookup_prioff_id = e.id AND a.fk_lookup_protyp_id = f.id AND g.id = a.fk_lookup_prosec_id AND h.id = c.fk_lookup_tentyp_id AND a.fk_lookup_protyp_id = 556 AND a.fk_lookup_protyp_id NOT IN (153, 608, 558, 151, 152, 573) AND a.fk_lookup_prosec_id <> 93 ORDER BY c.asking_price DESC