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 | $ | |
---|---|---|
PHENACOVOLVA POPPEI |
12.00 | |
SEMICASSIS BISULCATA JAPONICA |
10.00 | |
PECTEN MIRIFICUS |
6.00 | |
ZONARIA ZONARIA |
8.00 | |
SPONDYLUS ECHINATUS ZONALIS |
8.00 | |
MACOMA RHOMBOIDES |
3.00 | |
HALIOTIS CLATHRATA |
6.00 | |
CONUS NANUS |
4.00 | |
BABELOMUREX CENTIMANUS |
30.00 | |
BABELOMUREX ARMATUS |
25.00 | |
DOSINIA CONTUSA |
8.00 | |
CHICOREUS STRIGATUS |
25.00 | |
SEMIPALLIUM FULVICOSTATUM |
4.00 | |
TELLINA PLICATUS |
12.00 | |
VEXILLUM COCCINEA |
25.00 | |
XENOPHORA CONCHYLIOPHORA |
12.00 | |
TEREBRA ALBOMARGINATA |
6.00 | |
VOLUTA VIRESCENS |
60.00 | |
CYPRAEA SPADICEA |
20.00 | |
PUSTULARIA MARGARITA |
8.00 | |
HASTULA STYLATA |
4.00 | |
PLACOPECTEN MAGELLANICUS |
20.00 | |
PTERYNOTUS TRIFORMIS |
25.00 | |
NASSARIA ACUMINATA BITUBERCULARIS |
8.00 | |
CASMARIA ERINACEUS VIBEX |
4.00 | |
CONUS PERPLEXUS |
8.00 | |
HAUSTELLUM SOBRINUS |
10.00 | |
MONETARIA MONETA |
4.00 | |
EMPRESSOSTREA PHILIPPINARUM |
10.00 | |
CHICOREUS BANKSII CROCATUS |
20.00 | |
HELICOSTYLA GRANDIS DEPRESSA |
8.00 | |
CHICOREUS AXICORNIS |
4.00 | |
CONUS MOLUCCENSIS |
25.00 | |
CYMATIUM FLAVEOLUM |
8.00 | |
Total: | 450.00 |