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 | $ | |
---|---|---|
HYOTISSA HYOTIS |
35.00 | |
CONUS QUERCINUS |
25.00 | |
VASUM CAPITELLUM |
8.00 | |
OLIVELLA FLETCHERAE |
6.00 | |
EMPRESSOSTREA PHILIPPINARUM |
10.00 | |
HYOTISSA HYOTIS |
12.00 | |
EMPRESSOSTREA PHILIPPINARUM |
8.00 | |
PARAHYOTISSA cf. INERMIS |
8.00 | |
STROMBUS FRAGILIS |
5.00 | |
TASMEUTHRIA CLARKEI |
12.00 | |
ANADARA OCEANICA |
6.00 | |
HYOTISSA SINENSIS |
10.00 | |
OLIVA VIDUA ALBOFASCIATA |
4.00 | |
NEBULARIA AURANTIA NANUS |
6.00 | |
ANGARIA POPPEI |
6.00 | |
CERITHIUM ATROMARGINATUM |
3.00 | |
ANADARA OCEANICA |
6.00 | |
CHLAMYS ATKINOS |
6.00 | |
CYPHOMA SIGNATUM |
10.00 | |
SEMICASSIS BISULCATA |
6.00 | |
MELAMPUS NUCLEOLUS |
3.00 | |
HYOTISSA HYOTIS |
25.00 | |
LYRIA VICDANI |
20.00 | |
SCABRICOLA VICDANI |
30.00 | |
ALECTRYONELLA PLICATULA |
10.00 | |
SEPTA VESPACEUM |
6.00 | |
Total: | 286.00 |