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 | $ | |
---|---|---|
TEREBRA PERTUSA |
5.00 | |
SPONDYLUS MAESTRATII |
30.00 | |
EROSARIA MILIARIS MILIARIS |
12.00 | |
VASUM CAPITELLUM |
12.00 | |
ANNACHLAMYS REEVEI |
40.00 | |
BISTOLIDA STOLIDA STOLIDA |
8.00 | |
CYPRAEA TIGRIS |
8.00 | |
CYMATIUM FLAVEOLUM |
8.00 | |
SEMIPALLIUM FLAVICANS |
8.00 | |
LATIRUS PEARSONI |
6.00 | |
GELOINA cf. MOERCHIANA |
8.00 | |
VASTICARDIUM KENYANUM |
15.00 | |
CONUS TRISTENSIS |
40.00 | |
DIODORA RUPPELLII |
6.00 | |
TUTUFA OYAMAI |
20.00 | |
CYMBIOLA CATHCARTIAE |
50.00 | |
EROSARIA MILIARIS MILIARIS |
10.00 | |
TALPARIA TALPA |
6.00 | |
CENTROCARDIA SAGAMIENSIS |
12.00 | |
PSEUDOLATIRUS PALLIDUS |
15.00 | |
BABELOMUREX CENTIMANUS |
25.00 | |
STROMBUS MINIMUS |
5.00 | |
PYCNODONTE TANIGUCHII |
30.00 | |
PSEUDOSIMNIA MARGINATA |
15.00 | |
ZONARIA PICTA |
20.00 | |
CALLISTA CHINENSIS |
8.00 | |
CIRSOTREMA VARICOSA |
6.00 | |
HARPA HARPA |
30.00 | |
CYMATIUM FLAVEOLUM |
6.00 | |
Total: | 464.00 |