# \[ SQL \] Too many entries

**URL:** <https://forum.kirupa.com/t/sql-too-many-entries/251471>\
**Category:** programming\
**Created:** [February 8, 2008, 8:20pm UTC](https://forum.kirupa.com/t/sql-too-many-entries/251471 "2008-02-08T20:20:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bear](https://avatars.discourse-cdn.com/v4/letter/b/ac8455/32.png) [@bear](https://forum.kirupa.com/u/bear)\
**Post date:** [February 8, 2008, 8:20pm UTC](https://forum.kirupa.com/t/sql-too-many-entries/251471/1 "2008-02-08T20:20:16Z")

</div>

Everytime I run this:

> 

select  
drinks.drinks\_id,  
drinkname.drinks\_name\_content,  
drinks.drinks\_new\_old AS dNO

from dbs\_drinks drinks,dbs\_drinks\_name\_content drinkname, (  
select distinct drinks.drinks\_id  
from  
dbs\_drinks drinks,  
dbs\_drinks\_name\_content drinkname,  
dbs\_drinks\_name drinknameref,  
dbs\_drinks\_ings ingsref,  
dbs\_drinks\_ings\_content ingcontent,  
dbs\_drinks\_product productref,  
dbs\_drinks\_product\_content productcontent  
where  
drinknameref.drinks\_name\_content\_id = drinkname.drinks\_name\_content\_id  
and ingsref.drinks\_ings\_content\_id = ingsref.drinks\_ings\_content\_id  
and productcontent.drinks\_product\_content\_id = productref.drinks\_product\_content\_id  
and drinks.drinks\_id = productref.drinks\_id  
and drinks.drinks\_id = ingsref.drinks\_id  
and drinks.drinks\_id = drinknameref.drinks\_id

```
                    AND (
                    ingcontent.drinks_ings_content like '%B%'
                    or productcontent.drinks_product_content like '%B%'
                    or drinkname.drinks_name_content like '%B%'
                    )
                 ) as drinks_returned

```

Where drinks.drinks\_id = drinks\_returned.drinks\_id

I get WAY TOO MANY ENTRIES. And usually, with the same keys too. Not sure why at all, either.