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 | $ | |
---|---|---|
UMBILIA HESITATA BEDDOMEI |
75.00 | |
SPONDYLUS FOLIACEUS CROCEUS |
12.00 | |
CONUS VEXILLUM |
6.00 | |
CONUS VEXILLUM |
6.00 | |
BISTOLIDA STOLIDA STOLIDA |
8.00 | |
HALIOTIS SQUAMATA |
6.00 | |
CERITHIUM SCOBINIFORME |
3.00 | |
FISSURELLA RUBROPICTA |
5.00 | |
GELOINA cf. MOERCHIANA |
12.00 | |
CYMATIUM FLAVEOLUM |
8.00 | |
MARGOVULA ANULATA |
25.00 | |
PSEUDOSIMNIA MARGINATA |
6.00 | |
PALMADUSTA CONTAMINATA |
4.00 | |
LYRIA GRANGEI |
480.00 | |
COLUBRARIA MURICATA |
12.00 | |
DENTIOVULA CLAVA |
12.00 | |
SURREPIFUNGIUM PATAMAKANTHINI |
12.00 | |
PLACAMEN LAMELLATUM |
10.00 | |
MONETARIA MONETA BARTHELEMYI |
12.00 | |
DIODORA SIEBOLDI |
8.00 | |
PSEUDOLATIRUS PALLIDUS |
15.00 | |
FRENULINA SANGUINOLENTA |
3.00 | |
BURSA QUIRIHORAI |
8.00 | |
PYCNODONTE TANIGUCHII |
30.00 | |
CANCILLA BACILLUM |
3.00 | |
AZUMAPECTEN RUSCHENBERGERII |
45.00 | |
CONUS AMMIRALIS |
12.00 | |
BISTOLIDA STOLIDA STOLIDA |
8.00 | |
HARPA HARPA |
8.00 | |
ENGINA MENDICARIA |
3.00 | |
CYPRAEA TIGRIS |
12.00 | |
PLAGIOSTROPHA OPALUS |
6.00 | |
SPONDYLUS GLORIOSUS VISAYENSIS |
45.00 | |
CALLANAITIS DISJECTA |
8.00 | |
Total: | 928.00 |