Welcome to Conchylinet

Best viewed at 1024 x 768
Optimized for Mozilla Firefox
You are running an undetermined browser.

Conchylinet v.2.9 - 2014-04-16
3458671 visits since Jan. 2007.

Species interactive plates

Species Filter
Shape Selector

Choose the query parameters from the lists below to customize the plates.

Choose a class

Choose a order

Choose a family

Choose a province

Plates setup: rows

info box? yes no

MinSize (mm)

MaxSize (mm)

Choose a country

Choose the shape that best match your shellHelp: how to use the shapes?beta version !

Main
shapes

Sub shapes

3 species returned.

query error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,-1' at line 7
try again later
SELECT DISTINCTROW tbl602_conchylinet_taxons.taxonID, tbl602_conchylinet_taxons.taxonName, tbl602_conchylinet_taxons.Specie, tbl602_conchylinet_taxons.MaxSize, tbl602_conchylinet_taxons.Family, tbl602_conchylinet_taxons.taxonOrder, tbl602_conchylinet_taxons.Class, tbl602_conchylinet_taxons.taxonShape2, tbl602_conchylinet_taxons.MaxSize, tbl602_conchylinet_taxons.taxonHasPhoto, min(tbl606_conchylinet_sites.Province) as Province, min(tbl606_conchylinet_sites.str_ProvinceBackColorCode) as str_ProvinceBackColorCode, min(tbl606_conchylinet_sites.str_ProvinceFontColorCode) as str_ProvinceFontColorCode FROM (tbl602_conchylinet_taxons INNER JOIN tbl604_conchylinet_shells ON tbl602_conchylinet_taxons.taxonID = tbl604_conchylinet_shells.TaxonId) INNER JOIN tbl606_conchylinet_sites ON tbl604_conchylinet_shells.SiteId = tbl606_conchylinet_sites.ID_Location WHERE ((tbl602_conchylinet_taxons.Family)="Calyptraeidae" AND (tbl606_conchylinet_sites.Province)="IndoPacific" AND (tbl602_conchylinet_taxons.MaxSize) BETWEEN 0 AND 500 AND ((tbl602_conchylinet_taxons.taxonHasPhoto)=1)) GROUP BY taxonID, taxonName, Specie, MaxSize, Family, taxonOrder, Class, MaxSize, taxonHasPhoto, taxonShape2 ORDER BY Family, Specie LIMIT -1,-1;

Username
Password