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 | $ | |
---|---|---|
CYPRAEA TIGRIS |
8.00 | |
CHICOREUS STRIGATUS |
30.00 | |
CONUS MARCHIONATUS |
85.00 | |
UNEDOGEMMULA FRIEDRICHBONHOEFFERI |
12.00 | |
CYPRAEA TIGRIS |
8.00 | |
SIPHOCYPRAEA MUS DONMOOREI |
40.00 | |
SPINIDRUPA SPINOSA |
4.00 | |
TIBIA CANCELLATA |
3.00 | |
CONUS VIDUA CUYOENSIS |
25.00 | |
CONUS TAGAROAE |
12.00 | |
CHICOREUS SAULII |
12.00 | |
TALPARIA TALPA |
8.00 | |
BABELOMUREX PRINCEPS |
20.00 | |
CHICOREUS RAMOSUS |
120.00 | |
NASSARIA THALASSOMELI |
20.00 | |
BABELOMUREX JAPONICUS |
6.00 | |
HALIOTIS DOHRNIANA |
8.00 | |
MONETARIA MONETA ROSTRATE |
35.00 | |
EUCITHARA ARENIVAGA |
6.00 | |
TALPARIA TALPA |
8.00 | |
STROMBUS LENTIGINOSUS |
5.00 | |
NERITA POLITA |
4.00 | |
CYPRAEA TIGRIS |
80.00 | |
CONUS LANI |
90.00 | |
CONUS TEXTILE SCRIPTUS |
20.00 | |
HARPA HARPA |
8.00 | |
BABELOMUREX GEMMATUS |
20.00 | |
DOXOSPIRA HERTLEINI |
8.00 | |
LATIAXIS OLDROYDI |
30.00 | |
HOMALOCANTHA NINAE |
40.00 | |
Total: | 775.00 |