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 | $ | |
---|---|---|
COTONOPSIS PHUKETENSIS |
12.00 | |
CONUS QUERCINUS |
8.00 | |
CYMBIOLISTA HUNTERI |
40.00 | |
OLIVA UNDATELLA ECUADORIANA |
4.00 | |
CHICOREUS DAMICORNIS |
12.00 | |
PHYSELLA GYRINA |
3.00 | |
HOMALOCANTHA ZAMBOI |
4.00 | |
CHLAMYS BULLATA |
6.00 | |
OLIVA IRISANS cf. FORDII |
8.00 | |
CALPURNUS VERRUCOSUS |
3.00 | |
MARGINELLA GLABELLA |
8.00 | |
HARPA MAJOR |
6.00 | |
CALLISTA CHINENSIS |
6.00 | |
LANCEOLARIA LANCEOLATA |
12.00 | |
LIOCONCHA LORENZIANA |
8.00 | |
ACROSTERIGMA VARIEGATUM |
8.00 | |
CALLIOSTOMA SHINAGAWAENSIS |
8.00 | |
CANCELLARIA FOVEOLATA |
4.00 | |
OLIVA IRISANS ORNATA |
6.00 | |
CALLIOSTOMA SPESA |
15.00 | |
CANCELLARIA FOVEOLATA |
4.00 | |
ASTRAEA CAELATA |
25.00 | |
TURRIS NORMANDAVIDSONI |
8.00 | |
SPONDYLUS NUX |
6.00 | |
LAEVICARDIUM ATTENUATUM |
4.00 | |
CYMBIOLACCA PULCHRA WOOLACOTTAE |
30.00 | |
VASTICARDIUM ANGULATUM |
8.00 | |
SEMICASSIS BISULCATA |
5.00 | |
DOSINIA cf. JAPONICA |
8.00 | |
BELLASPIRA ACCLIVICOSTA |
6.00 | |
CALLISTA CHINENSIS |
8.00 | |
ANGARIA POPPEI |
6.00 | |
OLIVA INCRASSATA BURCHORUM |
40.00 | |
OVINOTIS OVINA |
6.00 | |
Total: | 345.00 |