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
Shell | $ | |
---|---|---|
BATISSA VIOLACEA |
5.00 | |
HALIOTIS JACNENSIS KERSHAWI |
40.00 | |
TELESCOPIUM TELESCOPIUM |
8.00 | |
HALIOTIS DOHRNIANA |
6.00 | |
STROMBUS FUSIFORMIS |
12.00 | |
HALIOTIS COCCORADIATA |
12.00 | |
HALIOTIS ASSIMILIS |
15.00 | |
CONUS GLORIOCEANUS |
120.00 | |
CORCULUM CARDISSA KIRAI |
6.00 | |
NERIPTERON TAITENSIS |
8.00 | |
NERITA POLITA |
5.00 | |
HALIOTIS CLATHRATA |
8.00 | |
CYMBIOLA AULICA ALEXISALLARYI |
30.00 | |
CARDITA CRASSICOSTA |
12.00 | |
LAEVICARDIUM ATTENUATUM |
6.00 | |
CYCLOTELLINA cf. REMIES |
6.00 | |
LYROCARDIUM AURANTIACUM |
6.00 | |
CONUS EQUESTRIS |
85.00 | |
OVINOTIS OVINA |
6.00 | |
CORCULUM CARDISSA |
6.00 | |
NERITINA LABIOSA |
6.00 | |
CTENOCARDIA VIRGO |
5.00 | |
NERITINA OWENIANA |
25.00 | |
NERITODRYAS CORNEA |
4.00 | |
FRAGUM ERUGATUM |
3.00 | |
HALIOTIS ASININA |
15.00 | |
STROMBUS SIBBALDI |
6.00 | |
CLAVUS FLAMMULATUS |
8.00 | |
CYCLOTELLINA DISCUS |
12.00 | |
CONUS LISCHKEANUS TROPICENSIS |
35.00 | |
NERITA PLICATA |
3.00 | |
STROMBUS AURISDIANAE |
12.00 | |
Total: | 536.00 |