SELECT brands.* FROM brands INNER JOIN cat ON cat.brand = brands.id INNER JOIN defmenu ON cat.category = defmenu.id WHERE defmenu.link LIKE "/cat/dlia-sobak/igrushki/%" GROUP BY brands.id ORDER BY cat.`order`
  • Sanicat
    Sanicat () , . Sanicat – ...
  • Lolo pets
    HOBBY, , . , . LOLO Pets ...
  • Power vit
    PowerVit , . PowerVit – : - - ...
  • Happy animals
    Happy animals. , , . ...
  • Vitapol
    Vitapol , . Vitapol? . Vitapol ...
  • ZOO
    «» — , Z. , ,...
  • «» , , ...