Specials

Contacts

Our postal address:

BION TERRARIUM CENTER

P.O. Box 43,
01135 Kyiv
Ukraine
Tel.: (+380-44) 486-3331, 486-4781
Fax: (+380-44) 486-3349

Alexandra Antonyuk,
General Export Manager aa@bion.com.ua

Lyudmila Grushanskaya,
Export-Import Manager export@bion.com.ua

For latest information about prices and availability of animals, please, fill in the form below:

Application afterLoad: 0.013 seconds

Application afterInitialise: 0.097 seconds

Application afterRoute: 0.103 seconds

Application afterDispatch: 0.371 seconds

Application afterRender: 0.753 seconds

8228864

SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
  FROM jos_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
SELECT template
  FROM jos_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 85)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT *
FROM jos_bion_data
SELECT id, title, module, position, content, showtitle, control, params
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.published = 1
  AND m.access <= 0
  AND m.client_id = 0
  AND ( mm.menuid = 85 OR mm.menuid = 0 )
  ORDER BY position, ordering
SELECT *
FROM jos_bion_data
SELECT count(s.`id`) AS c
  FROM `jos_stocklist` AS s
  WHERE s.`hotoffers`=1
  AND s.`published`=1
SELECT *
  FROM jos_bionmodules
  WHERE groupid=12
  ORDER BY RAND()
  LIMIT 0,1
SELECT FLOOR(RAND()*COUNT(id))
  FROM jos_stocklist
  WHERE hotoffers=1
  AND published=1
SELECT s.`name` AS cname, s.`sciname` AS sciname, s.`gallery` AS gallery
  FROM `jos_stocklist` AS s
  WHERE s.`hotoffers`=1
  AND s.`published`=1
  LIMIT 1,1
SELECT id, parent_id
FROM jos_mediagallery_categories
SELECT FLOOR(RAND()*COUNT(id))
  FROM jos_mediagallery
  WHERE catid IN(105)
  AND published=1
  AND type=1
SELECT *
  FROM jos_mediagallery
  WHERE catid IN(105)
  AND published=1
  AND type=1
  LIMIT 2,1

None

None