SELECT pr.name_ee, pr.id, pr.parent_id, (SELECT name_ee FROM ng_products WHERE id=pr.parent_id) as parent_name, IF( parent_id=0, (SELECT group_concat(id) FROM ng_products WHERE parent_id= 1115589) , (SELECT group_concat(id) FROM ng_products WHERE parent_id= pr.parent_id) ) as children_ids, IF( parent_id=0, (SELECT group_concat(name_ee) FROM ng_products WHERE parent_id= 1115589) , (SELECT group_concat(name_lv) FROM ng_products WHERE parent_id= pr.parent_id) ) as children_names FROM ng_products pr WHERE id=1115589 GROUP BY id
Ceramic Effect FLUO nr.108 :: Bergo.lv
Shopping cart
Your cart is empty

We recomend

Perspi Guard Antiperspirant Perspi-Guard 50 ml Antiperspirant

Antiperspirant Perspi-Guard lubab unustada higistamise mured. See higistamisvastane vahend kaotab isegi väga tugeva kaenlaaluste (käte, jalgade, torso, rindade jms) higistamise. beprakaito.lt perspi galima naudoti Antiperspirant Perspi-Guard lubab unust

19.99 €

Ceramic Effect FLUO nr.108

Producer: -
Code:
Price: 5.34

Comments

Send
Pirms nopērc, Salidzini.lv - Interneta veikali, Kuponi, OCTA kalkulators, KASKO kalkulators, Ātrie kredītiPirms nopērc, Salidzini.lv - Interneta veikali, Kuponi, OCTA kalkulators, KASKO kalkulators, Ātrie kredīti Visi Internetveikali un cenas