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 | $ | |
---|---|---|
TELESCOPIUM TELESCOPIUM |
12.00 | |
CYPRAEA TIGRIS |
12.00 | |
NEBULARIA CHRYSOSTOMA |
4.00 | |
OLIVA BULBOSA BICINGULATA |
6.00 | |
NATICARIUS CHEMNITZII |
10.00 | |
CONUS VENULATUS |
20.00 | |
EULIMA POLITISSIMA |
12.00 | |
STROMBUS ALATUS |
15.00 | |
PHOS DUMALE |
8.00 | |
CALLIOSTOMA FERNANDESI |
180.00 | |
EROSARIA LABROLINEATA NASHI |
10.00 | |
OLIVA BULBOSA FABAGINA |
6.00 | |
CHICOREUS AXICORNIS |
4.00 | |
CANTHARUS DORBIGNYI |
4.00 | |
CALLIOSTOMA ACULEATUM ALIGUAYENSIS |
25.00 | |
HOMALOCANTHA ANATOMICA PELE |
60.00 | |
MACTRA DISSIMILIS |
6.00 | |
CYCLOPHORUS SIAMENSIS |
6.00 | |
CYPRAEA TIGRIS |
8.00 | |
HOMALOCANTHA ANATOMICA PELE |
35.00 | |
LUNELLA CINEREA |
4.00 | |
MARGOVULA ANULATA |
25.00 | |
SEPTA cf. VESPACEUM |
12.00 | |
CHICOREUS AXICORNIS |
4.00 | |
BARTSCHIA FUSIFORMIS |
35.00 | |
MONETARIA ANNULUS ROSTRATE |
12.00 | |
MONETARIA ANNULUS ROSTRATE |
12.00 | |
ERRONEA ERRONES NIGER |
45.00 | |
BISTOLIDA STOLIDA |
8.00 | |
MUREX BEAUII |
320.00 | |
DOMIPORTA RUFILIRATA |
20.00 | |
LEPOCYPRAEA MAPPA PANERYTHRA |
35.00 | |
MITRA PAPILIO |
4.00 | |
LEPOCYPRAEA MAPPA PANERYTHRA |
60.00 | |
BABELOMUREX NAKAYASUI |
12.00 | |
CONUS VEXILLUM |
4.00 | |
Total: | 1,055.00 |