error
SELECT jos_en_listingsdbelements.listingsdb_id
FROM jos_en_listingsdbelements
INNER JOIN jos_en_listingsdb
ON jos_en_listingsdbelements.listingsdb_id = jos_en_listingsdb.listingsdb_id
WHERE jos_en_listingsdbelements.listingsdbelements_field_name = 'subregion' and jos_en_listingsdbelements.listingsdbelements_field_value = 'Costa de Almeria' and jos_en_listingsdb.listingsdb_active = 'yes' ORDER BY RAND() limit 3