Search Listings

SELECT default_listingsDB.Title FROM default_listingsDB, default_listingsDBElements WHERE (default_listingsDB.ID = default_listingsDBElements.listing_id) AND (default_listingsDB.active = 'yes') AND (default_listingsDBElements.field_name='type') AND (default_listingsDBElements.field_value = 'Rental')