[ SQL ] Too many entries

programming
1

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.