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 | $ | |
---|---|---|
BABELOMUREX NAKAYASUI |
40.00 | |
TEREBRA PERTUSA |
6.00 | |
CONUS VIDUA CUYOENSIS |
15.00 | |
SILIQUARIA ANGUINA |
8.00 | |
BABELOMUREX NAKAYASUI |
60.00 | |
STROMBUS VARIABILIS |
4.00 | |
VEXILLUM CITRINUM |
20.00 | |
ERRONEA PALLIDA INSULICOLA |
20.00 | |
STROMBUS URCEUS |
4.00 | |
STROMBUS LUHUANUS |
4.00 | |
CONUS MAGNIFICUS |
40.00 | |
LAMBIS MILLEPEDA |
20.00 | |
STROMBUS URCEUS |
4.00 | |
STROMBUS URCEUS |
6.00 | |
BABELOMUREX NAKAYASUI |
12.00 | |
TUTUFA OYAMAI |
20.00 | |
MUREX TENUIROSTRUM |
30.00 | |
CONUS MAGNIFICUS |
60.00 | |
TELESCOPIUM TELESCOPIUM |
8.00 | |
STROMBUS TEREBELLATUS |
15.00 | |
CONUS VIDUA |
6.00 | |
CALLOCARDIA GUTTATA |
6.00 | |
AMALDA HILGENDORFI VEZZAROI |
45.00 | |
CYMBIOLA AULICA ALEXISALLARYI |
70.00 | |
STROMBUS URCEUS |
4.00 | |
LAEVISTROMBUS TURTURELLA |
8.00 | |
TELESCOPIUM TELESCOPIUM |
30.00 | |
TELESCOPIUM TELESCOPIUM |
12.00 | |
FRAGUM ERUGATUM |
3.00 | |
CONUS MONILE |
6.00 | |
SEMICASSIS BISULCATA JAPONICA |
8.00 | |
VEXILLUM SANGUISUGUM CASTANEOSTICTA |
8.00 | |
Total: | 602.00 |