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 | $ | |
---|---|---|
CLAVUS LAETUS |
8.00 | |
MITRA NUBILA |
12.00 | |
HARPA MAJOR CONOIDALIS |
20.00 | |
LOPHIOTOMA LEUCOTROPIS |
8.00 | |
CANCELLARIA RETICULATA |
8.00 | |
INQUISITOR LORENZI |
8.00 | |
NERITOPSIS RADULA |
3.00 | |
MARGINELLA SEBASTIANI |
6.00 | |
OXYSTELE TABULARIS |
3.00 | |
NEBULARIA COARCTATA |
30.00 | |
PITAR INFLATUS |
12.00 | |
MACTRA DISSIMILIS |
4.00 | |
CERITHIDEA ALBONODOSA |
4.00 | |
ASPERITAS STUARTIAE |
8.00 | |
ANTIGONA LAMELLARIS |
4.00 | |
AGARONIA ACUMINATA |
12.00 | |
CALLOCARDIA GUTTATA |
6.00 | |
SPONDYLUS REESIANUS |
25.00 | |
POLINICES FIBROSA |
6.00 | |
CHITON OLIVACEUS |
6.00 | |
STROMBUS BULLA |
6.00 | |
CANCILLA HERRMANNI |
60.00 | |
CONUS SCABRIUSCULUS |
8.00 | |
NATICA FANEL |
12.00 | |
POLINICES FIBROSA |
6.00 | |
STROMBUS PIPUS |
4.00 | |
OLIVA BULBOSA IMMACULATA |
50.00 | |
LAMBIS LAMBIS |
20.00 | |
BURSA CORRUGATA PUSTULOSA |
30.00 | |
CERITHIUM SCOBINIFORME |
4.00 | |
SEMICASSIS SEMIGRANOSUM |
20.00 | |
SPONDYLUS MAESTRATII |
35.00 | |
STENOPLAX ALATA |
6.00 | |
Total: | 454.00 |