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 | $ | |
---|---|---|
PTERYNOTUS ACANTHOPTERUS |
20.00 | |
MITRELLA LIGULA |
3.00 | |
CLAVUS ANGULATUS |
8.00 | |
HYOTISSA HYOTIS |
25.00 | |
SCALPTIA CROSSEI |
8.00 | |
COLINA PINGUIS |
3.00 | |
CONUS SANGUINOLENTUS |
20.00 | |
BABELOMUREX JAPONICUS |
12.00 | |
STROMBUS LABIATUS |
8.00 | |
VASUM TURBINELLUM |
8.00 | |
TROCHUS FERREIRAI |
6.00 | |
ERRONEA ADUSTA PERSICA |
30.00 | |
NAQUETIA BARCLAYI ANNANDALEI |
15.00 | |
PECTEN MIRIFICUS |
6.00 | |
SPONDYLUS NICOBARICUS CILIATUS |
8.00 | |
CYMBIOLA AULICA ALEXISALLARYI |
20.00 | |
ANACHIS VEXILLUM |
4.00 | |
ANTIGONA SOMWANGI |
20.00 | |
MITRA BAERORUM |
120.00 | |
SPONDYLUS FOLIACEUS |
12.00 | |
STROMBUS GALLUS |
35.00 | |
NISO HIZENENSIS |
8.00 | |
CYPRAEA TIGRIS |
20.00 | |
PTERYNOTUS BIBBEYI |
30.00 | |
SPONDYLUS NICOBARICUS CILIATUS |
8.00 | |
LIOCONCHA SOWERBYI |
30.00 | |
STROMBUS CANARIUM |
8.00 | |
LAMBIS WHEELWRIGHTI |
45.00 | |
STROMBUS FRAGILIS |
6.00 | |
STROMBUS CANARIUM |
8.00 | |
SPONDYLUS NICOBARICUS CILIATUS |
8.00 | |
TELESCOPIUM TELESCOPIUM |
8.00 | |
COLUMBELLA SCRIPTA |
3.00 | |
CERITHIUM NODULOSUM |
8.00 | |
VASUM TURBINELLUM |
25.00 | |
CLANCULUS FLORIDUS |
4.00 | |
NAQUETIA BARCLAYI ANNANDALEI |
40.00 | |
Total: | 650.00 |