When I run the below query, I expect to get one result.

However, I get no results.

```
SELECT listings.*

FROM   `listings` 
       LEFT JOIN users 
              ON listings.user_id = users.user_id 
       LEFT JOIN listing_attributes 
              ON listings.listing_id = listing_attributes.listing_id

WHERE users.account_status = 1

AND ( listing_attributes.name LIKE 'collection_city' AND listing_attributes.content LIKE '%d%' ) 
AND ( listing_attributes.name LIKE 'collection_post_code' AND listing_attributes.content LIKE '%e%' ) 

GROUP BY listings.listing_id

```

I have identified the problem as these two lines

```
AND ( listing_attributes.name LIKE 'collection_city' AND listing_attributes.content LIKE '%d%' ) 
AND ( listing_attributes.name LIKE 'collection_post_code' AND listing_attributes.content LIKE '%e%' ) 

```

If I remove either of the lines, I get the result I expect.

I am thinking something is wrong with the way I am encompassing the results in the ().

In essence I am wishing to check that multiple values exist in listing\_attributes for a result to be as needed.