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 SPICATA VIOLACEA |
12.00 | |
MAURITIA EGLANTINA NIGER |
160.00 | |
OLIVA CONCAVOSPIRA |
8.00 | |
SPONDYLUS ASPERRIMUS |
20.00 | |
CONUS ANEMONE NOVAEHOLLANDIAE |
25.00 | |
CASMARIA PONDEROSA |
6.00 | |
CHLAMYS ORNATA |
6.00 | |
GEMMULA CONGENER DIOMEDEA |
20.00 | |
EROSARIA HELVOLA HAWAIENSIS |
8.00 | |
CHICOREUS AXICORNIS |
8.00 | |
LIOCONCHA ORNATA |
3.00 | |
HOMALOCANTHA ANATOMICA PELE |
50.00 | |
OLIVA TODOSINA |
8.00 | |
DENTIMARGO GUIONNETI |
12.00 | |
TEREBRA UNDULATA |
3.00 | |
PROTOTYPHIS ANGASI |
8.00 | |
HYOTISSA HYOTIS |
12.00 | |
PHALIUM AREOLA MAGNITA |
35.00 | |
LEPORICYPRAEA MAPPA |
8.00 | |
STROMBUS TEREBELLATUS |
12.00 | |
VOLVA VOLVA |
4.00 | |
LEPORICYPRAEA MAPPA |
8.00 | |
VOLVA VOLVA |
6.00 | |
LEPORICYPRAEA MAPPA |
8.00 | |
NUTTALINA CALIFORNICA |
4.00 | |
LIOCONCHA ORNATA |
4.00 | |
SPONDYLUS SETIGER |
25.00 | |
SINUM PERSPECTIVUM |
6.00 | |
OLIVA TIGRIDELLA ORIOLA |
5.00 | |
Total: | 494.00 |