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 | |
Total: | 185.00 |