select t1.*, t2.*, t3.dyestuffs as p_dyestuffs from products t1 left join product_details t2 on t2.parent_id=t1.id left join products_dyestuffs t3 on t1.id=t3.parent_id where t1.id='117' and t2.lang='tr' and t3.lang='tr'

Rezene

Foeniculum vulgare
Elde Edilen Renkler
Lila, Sarı
İçerdiği Boyarmadde