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 | $ | |
---|---|---|
CYMBIOLA CATHCARTIAE |
50.00 | |
CYMATIUM SPRINGSTEENI |
8.00 | |
MARCHIA MARTINETANUS FENESTRATUS |
45.00 | |
CHICOREUS LACINIATUS |
25.00 | |
MUREX FALSITRIBULUS |
15.00 | |
RANULARIA SARCOSTOMUM |
12.00 | |
ERRONEA ERRONES NIGER |
50.00 | |
DILOMA NIGERRIMA |
4.00 | |
HAINESIA CROCEA |
4.00 | |
EUPROTOMUS IREDALEI |
12.00 | |
MUREX TENUIROSTRUM |
10.00 | |
ACLYVOLVA NICOLAMASSIERAE |
12.00 | |
SASSIA SEMITORTA |
8.00 | |
MONETARIA MONETA |
4.00 | |
STROMBUS TEREBELLATUS |
12.00 | |
CYPRAEA VITELLUS |
12.00 | |
CONUS MUS |
15.00 | |
NEORAPANA TUBERCULATA |
12.00 | |
SASSIA SUBDISTORTA |
45.00 | |
HALIOTIS SEMIPLICATA |
8.00 | |
APORRHAIS PESPELECANI |
6.00 | |
NASSARIUS POLYGONATUS |
3.00 | |
CERITHIDEA ALBONODOSA |
4.00 | |
MIRAPECTEN MOLUCCENSIS |
6.00 | |
CALLIOSTOMA NEPHELOIDE |
20.00 | |
CALLIOSTOMA MONILE |
12.00 | |
DISTORSIO CLATHRATA |
6.00 | |
MARGINELLA PARDALIS |
6.00 | |
CYMATIUM LOTORIUM |
25.00 | |
CYMATIUM FLAVEOLUM |
8.00 | |
OVULA OVUM |
6.00 | |
RANULARIA EXILE |
8.00 | |
CYMBIOLA NOBILIS PARVA |
40.00 | |
CONUS CARACTERISTICUS |
4.00 | |
CORIOCELLA NIGRA |
8.00 | |
NARIA LAMARCKII REDIMITA |
20.00 | |
PECTEN MIRIFICUS |
6.00 | |
MONETARIA ANNULUS |
8.00 | |
Total: | 559.00 |