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 | $ | |
---|---|---|
LAMBIS MILLEPEDA |
12.00 | |
CABESTANA DOLARIA AFRICANA |
12.00 | |
BURSA LATITUDO FOSTERI |
6.00 | |
ZONARIA ZONARIA |
8.00 | |
MITRA PAPALIS |
25.00 | |
OLIVELLA GRACILIS |
6.00 | |
CYPRAEA TIGRIS |
8.00 | |
NACELLA MAGELLANICA |
8.00 | |
CONUS PULICARIUS |
30.00 | |
CYMBIOLA SOPHIA |
8.00 | |
MERETRIX LUSORIA |
5.00 | |
OLIVA CONCINNA CHRYSOIDES |
12.00 | |
CONUS PURPURASCENS |
8.00 | |
PECTEN MIRIFICUS |
6.00 | |
SIRATUS ARTICULATUS |
30.00 | |
CYMATIUM CARIBBAEUM |
15.00 | |
IBERUS GUALTERIANUS |
8.00 | |
PYCNODONTE TANIGUCHII |
20.00 | |
CHLOTOSTOMA ARGYROSTOMA |
10.00 | |
CYPRAEA TIGRIS |
20.00 | |
BURSA ANGIOYORUM |
6.00 | |
NASSARIUS INCRASSATUS |
3.00 | |
TALPARIA TALPA |
12.00 | |
CONUS FUSCOLINEATUS |
12.00 | |
LOPHIOTOMA INDICA BULOWI |
12.00 | |
PATELLA CAERULEA |
4.00 | |
TEREBRA ELATA |
12.00 | |
CELLANA RADIATA RADIATA |
3.00 | |
CYPRAEA QUADRIMACULATA |
8.00 | |
ZELIPPISTES EXCENTRICUS |
3.00 | |
HARPA ARTICULARIS |
20.00 | |
CYPRAEA TIGRIS |
12.00 | |
PECTEN MIRIFICUS |
6.00 | |
CALLIOSTOMA FERNANDESI |
180.00 | |
Total: | 550.00 |