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 | $ | |
---|---|---|
OLIVA CHRYSOPLECTA |
6.00 | |
NUCULINA CRYSTALLINA |
4.00 | |
MACTRA ACHATINA |
8.00 | |
CASMARIA PONDEROSA |
6.00 | |
CONUS FLOCCATUS |
30.00 | |
PATELLOIDA SACCHARINA LANX |
3.00 | |
SEMICASSIS LABIATA LABIATA |
12.00 | |
SCUTELLASTRA CHAPMANI |
6.00 | |
CALOCOCHLIA PULCHERRIMA |
4.00 | |
LATERNULA SPENGLERI |
8.00 | |
AGATHODONTA NORTONI |
4.00 | |
GLOBULARIA FLUCTUATA |
12.00 | |
STROMBUS LENTIGINOSUS |
6.00 | |
BABELOMUREX CENTIMANUS |
30.00 | |
CASMARIA PONDEROSA |
6.00 | |
HOMALOCANTHA ZAMBOI |
6.00 | |
LATIAXIS MAWAE |
25.00 | |
POLINICES MAMMILLA |
6.00 | |
PATELLA CONCOLOR |
4.00 | |
STROMBUS CAMPBELLI |
8.00 | |
BABELOMUREX ARMATUS |
20.00 | |
OLIVA CAROLIANA |
5.00 | |
TROPIDOPHORA OCCLUSA |
20.00 | |
BABELOMUREX GEMMATUS |
25.00 | |
Total: | 264.00 |