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 '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
- Home
-
Seashells For Sale
- ===============
- All Sea Shells
- ===============
- ACMAEIDAE
- ACTEONIDAE
- AMPHIBOLIDAE
- ANGARIIDAE
- ANOMIIDAE
- APLUSTRIDAE
- APORRHAIDAE
- ARCHITECTONICIDAE
- ARCIDAE
- ARGONAUTIDAE
- BRACHIOPOD
- BUCCINIDAE
- BULLIDAE
- BULLINIDAE
- BURSIDAE
- CALLIOSTOMATIDAE
- CALYPTRAEIDAE
- CANCELLARIIDAE
- CAPULIDAE
- CARDIIDAE
- CARDITIDAE
- CASSIDAE
- CERITHIIDAE
- CHAMIDAE
- CHELONIBIIDAE
- CHILODONTAIDAE
- CHILODONTIDAE
- CHITONIDAE
- CLATHURELLIDAE
- CLAVAGELLIDAE
- COLUBRARIIDAE
- COLUMBARIIDAE
- COLUMBELLIDAE
- CONIDAE
- CORALLIOPHILIDAE
- CORBICULIDAE
- CORBULIDAE
- CRASSATELLIDAE
- CUCULLAEIDAE
- CULTELLIDAE
- CUSPIDARIIDAE
- CYLICHNIDAE
- CYPRAEIDAE
- CYSTISCIDAE
- DENTALIIDAE
- DONACIDAE
- ELLOBIIDAE
- EPITONIIDAE
- ERATOIDAE
- ERATOIDEA
- EULIMIDAE
- FASCIOLARIIDAE
- FICIDAE
- FISSURELLIDAE
- FOSSARININAE
- FOSSIL
- FOSSIL COWRY
- FRESHWATER
- GLOSSIDAE
- GLYCYMERIDIDAE
- GRYPHAEIDAE
- HALIOTIDAE
- HAMINOEIDAE
- HARPIDAE
- HEMIDONACIDAE
- HIPPONICIDAE
- HORAICLAVIDAE
- ISOGNOMONIDAE
- JANTHINIDAE
- LANDSNAIL
- LATERNULIDAE
- LIMIDAE
- LIMOPSIDAE
- LIOTIIDAE
- LITTORINIDAE
- LOTTIIDAE
- LUCINIDAE
- MACTRIDAE
- MALLEIDAE
- MANGELIIDAE
- MARGINELLIDAE
- MATHILDIDAE
- MELAMPIDAE
- MELONGENIDAE
- MESODESMATIDAE
- MITRIDAE
- MITROMORPHIDAE
- MODULIDAE
- MURICIDAE
- MURICIDAEVERY NICE S
- MYCETOPODIDAE
- MYIDAE
- MYTILIDAE
- NACELLIDAE
- NASSARIIDAE
- NATICIDAE
- NERITIDAE
- NERITOPSIDAE
- NUCULANIDAE
- NUCULIDAE
- OLIVIDAE
- OSTREIDAE
- OVULIDAE
- PACHYCHILIDAE
- PATELLIDAE
- PECTINIDAE
- PERSONIDAE
- PHARIDAE
- PHASIANELLIDAE
- PHASIANELLOIDEA
- PHILINIDAE
- PINNIDAE
- PISANIIDAE
- PLACUNIDAE
- PLANAXIDAE
- PLEUROCERIDAE
- PLEUROTOMARIIDAE
- PLICATULIDAE
- POTAMIDIDAE
- PROPEAMUSSIIDAE
- PSAMMOBIIDAE
- PSEUDOLIVIDAE
- PTERIIDAE
- PTYCHATRACTIDAE
- PYRAMIDELLIDAE
- RANELLIDAE
- RAPHITOMIDAE
- RETUSIDAE
- RISSOIDAE
- SCAPHANDRIDAE
- SEGUENZIIDAE
- SEMELIDAE
- SERAPHSIDAE
- SILIQUARIIDAE
- SIPHONARIIDAE
- SOLARIELLIDAE
- SOLECURTIDAE
- SOLENIDAE
- SOLERCUTIDAE
- SPONDYLIDAE
- STOMATELLIDAE
- STOMATIIDAE
- STROMBIDAE
- STROMBININAE
- STRUTHIOLARIIDAE
- TELLINIDAE
- TEREBRIDAE
- THIARIDAE
- TONNIDAE
- TORNIDAE
- TRAPEZIDAE
- TRAPEZIIDAE
- TRICHOTROPIDAE
- TRIGONIIDAE
- TRIPHORIDAE
- TRIVIIDAE
- TROCHIDAE
- TRUNCATELLIDAE
- TURBINELLIDAE
- TURBINIDAE
- TURITELLIDAE
- TURRIDAE
- UMBRACULIDAE
- UNGULIDAE
- UNIONIDAE
- VANIKORIDAE
- VELUTINIDAE
- VENERIDAE
- VERMETIDAE
- VERTICORDIIDAE
- VITRINELLIDAE
- VOLUTIDAE
- VOLUTOMITRIDAE
- XENOPHORIDAE
- YOLDIIDAE
- __________________
- Freak Sea Shells
- Albino Sea Shells
- Niger Sea Shells
- Rostrate Sea Shells
- Species Sea Shells
- Sinistral Sea Shells
- __________________
- Date Uploaded
- - Today / Latest Shells
- - Yesterday
- - 2 days before
- - 3 days before
- - 1 week before
- - 2 weeks before
- - 3 weeks before
- - 1 month before
-
Landsnails For Sale
- ===============
- All Landsnail Shells
- ===============
- ADMIRALITATIS
- ADONIS
- AEQUATORIUS
- AEQUATORIUS INTERRUPTA
- ALBAIENSIS
- ANTONI
- APEX
- ASPERSA
- ATROPOS
- AURANTIACUS
- BANGGAIENSIS
- BASILANENSIS
- BATHIEI
- BRUMERIENSIS
- BUEHLERI
- BUTOTI
- CALCAREUM
- cf. AGRESTINA
- cf. ALBICOSTATA
- cf. PANTHERA
- CHLORIS
- CHRYSOCHEILA
- CITRINA
- COLORATA KOMODOENSIS
- CONSANGUINEA
- CONTRARIUS
- COTOPAXIENSIS
- CROCEA
- DALLI
- DARAGANICUS
- DARANGANICUS
- DENISI
- DESHAYESIANA
- DINGEONI
- DISCOIDEUS
- DUBIOSA
- DUNKERI
- EXARATA
- FISTULARE
- FLAMMULATA
- FLORIDA
- FULGETRUM
- FULICA
- GEAYI
- GLORIOSA
- GRANDIDIERI
- GRANDIS DEPRESSA
- GRANULOSA
- GUALTERIANUS
- GUESTERIANA
- HARGRAVESI
- HELICOIDES
- HENDERSONI
- HERKLOTSI
- HOVA
- HUNGFORDIANUS
- INCEI
- INCRASSATA
- INQUINATA PENIDAE
- KALGUM
- KIBLERI
- LABIUM
- LEFROYI
- LEUCOSTOMA
- MACULIFERUS
- MADECASSINA
- MAMILLA
- MILTOCHEILUS
- MIXTA
- MOULINSII
- MUMIA CHRYASLIS
- MUMIA MAGISTER
- MUSCARUM
- NILOTICA
- NULLARBORICUM
- OBLONGUS HAEMASTOMUS
- OBLONGUS LORENTZIANUS
- OCCLUSA
- ORNATULA
- OVUM
- PAEZENSE
- PARMULA
- PERVERSUS
- PERVERSUS INTERRUPTUS
- PERVERSUS MELANOMA
- POECILOCHROUS
- POECILOCHROUS CANDIDUS
- POIRIERI
- PORRACEA PARTULOIDES
- PUDICA
- PULCHERRIMA
- QUADRASI
- QUADRASI cf. SOLIDA
- QUADRASI DUBIUS
- QUADRASI SOLIDA
- QUAESITA
- REDFEILDI
- REGINA LAEVIGATA
- RENITENS
- RETICULATA
- ROCHEBRUNI
- ROISSYANA BARTSCHI
- ROSACEUS
- ROTA
- SECTILABRIS
- SELLERSI
- SENKERBERGIANA
- SEPULCHRALIS
- SIAMENSIS
- SIBUYANICA
- SOLIDUS
- SPECIES
- STAINFORTHI
- STRANGEI
- STUARTIAE
- TOBAI
- TRICARINATA MADAGASCARIENSIS
- TWEEDIEI
- VESICALIS
- VEXILLARIS
- VIRGINEUS
- VITREUM
- WAANDERSIANA
- WICHMANNI
- WOODIANA
- XANTHOCHILA
- YPORANGANUS
- ZEBUENSIS
-
Auction
- ===============
- All Sea Shells
- ===============
- BUCCINIDAE
- BURSIDAE
- CASSIDAE
- CONIDAE
- CORALLIOPHILIDAE
- CYPRAEIDAE
- HARPIDAE
- LIMIDAE
- MITRIDAE
- OLIVIDAE
- OVULIDAE
- SPONDYLIDAE
- TEREBRIDAE
- TROCHIDAE
- TURBINIDAE
- TURRIDAE
- VOLUTIDAE
- __________________
- Freak Sea Shells
- Albino Sea Shells
- Niger Sea Shells
- Rostrate Sea Shells
- Species Sea Shells
- Sinistral Sea Shells
- Philippines Shells
-
Identification
- ===============
- All Sea Shells
- ===============
- ARCIDAE
- BRACHIOPOD
- CALLIOSTOMATIDAE
- CARDIIDAE
- CHITONIDAE
- COLUMBELLIDAE
- LANDSNAIL
- LUCINIDAE
- MACTRIDAE
- MITRIDAE
- OVULIDAE
- PTERIIDAE
- PYRAMIDELLIDAE
- RISSOIDAE
- TEREBRIDAE
- TRIPHORIDAE
- TURRIDAE
- VENERIDAE
- VITRINELLIDAE
- __________________
- Freak Sea Shell
- Albino Sea Shell
- Niger Sea Shell
- Rostrate Sea Shell
- Sinistral Sea Shell
Member Log-in
