Holiday Rentals in Puerto del Carmen

SELECT distinct(jos_en_listingsdb.listingsdb_id), jos_en_listingsdb.userdb_id, jos_en_listingsdb.listingsdb_title FROM jos_en_listingsdb ,jos_en_listingsdbelements Town ,jos_en_listingsdbelements country ,jos_en_listingsdbelements sort0 WHERE (listingsdb_active = 'yes') AND (jos_en_listingsdb.listingsdb_id = Town.listingsdb_id) AND (jos_en_listingsdb.listingsdb_id = country.listingsdb_id) AND (jos_en_listingsdb.listingsdb_id = sort0.listingsdb_id) AND (Town.listingsdbelements_field_name = 'Town' AND Town.listingsdbelements_field_value = 'Puerto del Carmen') AND (country.listingsdbelements_field_name = 'country' AND country.listingsdbelements_field_value = 'Spain') AND (sort0.listingsdbelements_field_name = 'sequence') ORDER BY sort0.listingsdbelements_field_value DESC
SELECT COUNT(distinct(jos_en_listingsdb.listingsdb_id)) as total_listings FROM jos_en_listingsdb ,jos_en_listingsdbelements Town ,jos_en_listingsdbelements country WHERE (listingsdb_active = 'yes') AND (jos_en_listingsdb.listingsdb_id = Town.listingsdb_id) AND (jos_en_listingsdb.listingsdb_id = country.listingsdb_id) AND (Town.listingsdbelements_field_name = 'Town' AND Town.listingsdbelements_field_value = 'Puerto del Carmen') AND (country.listingsdbelements_field_name = 'country' AND country.listingsdbelements_field_value = 'Spain')