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 | $ | |
---|---|---|
ASPERITAS STUARTIAE |
8.00 | |
CYMATIUM LABIOSUM |
6.00 | |
POLLIA SUBCOSTATA |
8.00 | |
ERGALATAX MARGARITICOLA |
4.00 | |
KIOCONUS cf. EMPRESSAE |
20.00 | |
MITRA PAPALIS |
12.00 | |
EUVOLA CHAZALIEI |
20.00 | |
XESTA BANGGAIENSIS |
8.00 | |
PINCTADA cf. MACULATA |
6.00 | |
LAMBIS LAMBIS |
25.00 | |
PATELLOIDA SACCHARINA LANX |
3.00 | |
TEREBRA FORTUNEI |
6.00 | |
CANCELLARIA LYRATA |
12.00 | |
TURBO FORTISPIRALIS |
5.00 | |
CONUS SCOTTJORDANI |
30.00 | |
HARPA HARPA |
10.00 | |
ZIERLIANA OLEACEA |
6.00 | |
SEMICASSIS CANALICULATA |
8.00 | |
TEGULA FASCIATA |
4.00 | |
CIRCULUS SPECIES |
3.00 | |
JUJUBINUS ESCONDIDUS |
5.00 | |
CONUS AMMIRALIS |
6.00 | |
SPONDYLUS OCCIDENS JAMARCI |
15.00 | |
PARDALINA TYLERAE |
3.00 | |
LATIAXIS MAWAE |
30.00 | |
Total: | 263.00 |